Fund flow statement

sunil (quality) (24 Points)

15 May 2015  

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