question of cash flow statement

pls find the excel sheet solution attached.............

pls find .xls format file attached.

 Thanks ashish.. i got the answer but i took investments in investment activity.. can you please explain the depreciation fund calculation..

regards

senthil

SINCE THESE ARE TEMPORARY INVESTMENTS, IT SHOULD COME UNDER CURRENT ASSETS. YOU CAN ALTERNATIVELY TAKE IT UNDER INVESTMENT ACTIVITY, THE RESULT WOULD BE SAME. BUT UNDER INVESTMENT ACTIVITY, LONG TERM INVESTMENTS COME.......

IN DEPRECIATION FUND A/C, THE AMOUNT OF Rs. 8000 is transferred to the machinery account as an accumulated amount of depreciaion on the machinery sold. The opening and closing bal. is given, the balance amount is depreciation for the current yr. consequently the loss of Rs.2000 is tranf. to P & L A/c. The balance of Rs. 7000 is assumed to be that of machinery sold.