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: 213 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
Featured 16 July 2026
Semi Qualified Company Secretary

Vakilsearch.com

Chennai

CS

View Details
Company
ARTICLESHIP 11 July 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 15 July 2026
CA Articles

Kinjal H Shah & Co.

Mumbai

CA Foundation

View Details
Company
11 July 2026
CA semi qualified

Vakilsearch.com

Chennai

CA Inter

View Details
Company
16 July 2026
CA Inter, CA Intermediate, CA IPCC, CA CPT , CA SemiQualifie

Vakilsearch.com

Chennai

CA Inter

View Details
Company
20 July 2026
Senior GST Executive

Chandak Agarwal & Co

Mumbai

Graduate (Any)

View Details
Company
28 July 2026
Senior accountant

RJ Public School

Bengaluru

B.Com

View Details
Company
06 July 2026
Accountant

Agarwal Anoop and Associates

Noida

CA Final

View Details
Follow