Fund flow statement

I am a student, i need help on the following problem for fund flow statement.  If someone can please provide solution on excel, i will be highly obliged.  Attaching the working till Working Capital.

From the foll Balance sheet of Mr.X, prepare a funds flow statement

Liabilities  31.3.2012   31.3.2013  Asset      31.3.2012   31.3.2013
Capital      77,000       78,000       Cash             5,000         2,300
Bank loan    15,000    19,500        Debtors       17,500       19,200
Creditors    18,000      20,500      Stock           12,500       11,000
                                                  Land           10,000       15,000
                                                  Building       25,000       27,500
                                                  Machinery   40,000       43,000
Drawing of Mr.X during the year was 20,000 depreciation charge of machinery was 4,000.
 
Thanks and Kind Regards

Attached File : 1442692 20150515122652 ff question.xlsx downloaded: 220 times
Replies (1)

I have put the Fund Flow Statement in Excel but I am not good at that.  I run online classes of Accounts for Class XI and XII details of which you can get in the following video:

https://youtu.be/tTNUFQPFSAc

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
15 September 2026
Client-site CA associate

Aditya Muley and Co

Mumbai

CA

View Details
Company
ARTICLESHIP 07 October 2026
Article Assistant

Malhotra Rajesh & Associates

New Delhi

B.Com

View Details
Company
08 October 2026
SALES TELECALLER

HIRE NOVA

Lucknow

Graduate (Any)

View Details
Company
30 September 2026
Senior Accounts Executive

Codeboard Technology

Chennai

MBA

View Details
Company
20 September 2026
Semi Qualified CA

Navin & Associates

Mumbai

CA Inter

View Details
Company
Featured 21 September 2026
Consultant - Reporting

Finrep Advisors LLP

Mumbai

CA

View Details
Company
18 September 2026
Accounts & Finance Specialist

ULTRA CHEMICAL WORKS

Thane

CA Final

View Details
Company
ARTICLESHIP 30 September 2026
CA Article Assistant

CA Suraj Garg & Associates

New Delhi

CA Final

View Details