At this point you have created a balance sheet and income statement for Diane. She has come to you again for another favor. This time she wants you to create a statement that shows how the cash account changed from June 1 to June 30. She is concerned that her knowledge of the reason why the cash balance is so large but net income is small is still not complete. Can you help her out? Please refer to the balance sheet and income statement to create a statement of cash flows for Diane. Be sure you show income from operations using both the direct and indirect methods.
The spreadsheet above is saved as an Excel spreadsheet that should be accessible by all Excel versions. For those who do not have the Excel program I recommend that you obtain the Excel viewer program listed in the software support section. I have not save the file as any other type because it would require that an individual copy of each sheet be saved . With the Excel viewer you can view and print the spreadsheets you just can't manipulate any of the entries.