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