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: 216 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
27 August 2026
ACCOUNTANT

CHARUPREETI & CO

Noida

Graduate (Any)

View Details
Company
09 September 2026
Semi Qualified CA / CA Inter - 2 Groups Cleared

Getmyca Consultant Pvt Ltd

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 01 September 2026
Article Assistant

SGNG & Associates

New Delhi

CA Inter

View Details
Company
15 September 2026
Client-site CA associate

Aditya Muley and Co

Mumbai

CA

View Details
Company
25 August 2026
Senior Accountant

MG Associates

New Delhi

CA Inter

View Details
Company
Featured 11 September 2026
Audit Executive

RBSM Corporate Advisors Private Limited

Pune

CA

View Details
Company
09 September 2026
Chartered Accountant

Aviv Global Private Limited

Ahmedabad

CA

View Details
Company
28 August 2026
Assistant Manager

NRS AND ASSOCIATES

Kozhikode

CA Inter

View Details