Please be sure to also provide a handwritten copy of your Worksheet for preparing the Statement of Cash Flows as well as a handwritten copy of the Statement of Cash Flows

Use Excel and the information below to prepare an Excel Spreadsheet for the following:

1. The Worksheet for the Statement of Cash Flows
2. The Statement of Cash Flows
3. Provide a printout of the Excel formulas that you used for the above items

Please be sure to also provide a handwritten copy of your Worksheet for preparing the Statement of Cash Flows as well as a handwritten copy of the Statement of Cash Flows

Comparative Balance Sheet December 31

Assets	1996	1995
Cash	$ 97,800	$ 38,400
Accounts Receivable	90,800	33,000
Inventories	112,500	102,850
Prepaid expenses	18,400	16,000
Investments	108,000	94,000
Plant Assets	270,000	242,500
Accumulated Depreciation	(50,000)	(52,000)
	$647,500	$474,750
Liabilities & Stockholders Equity Accounts Payable	$ 92,000	$ 67,300
Accrued Expenses payable	16,500	17,000
Bonds Payable	85,000	110,000
Common Stock	220,000	175,000
Retained Earnings	234,000	105,450
	$647,500	$474,750

Income Statement

For the Year Ended December 31, 1996

Sales Less: Cost of Goods Sold	$ 115,460	$342,780
Operating Expenses(Excluding depreciation)	12,410
Depreciation expense	46,500
Income Tax Expense	7,280
Interest Expense	2,730
Loss on Sale of Plant Assets	7,500	191,880
Net Income		$150,900

Additional Information:

1. New plant assets were purchased for cash during the year.
2. Old plant assets having an original cost of $57,500 were sold for $1,500 cash.
3. Bonds matured and were paid off at face value for cash.
4. A cash dividend was declared and paid during the year.

5. Instruction

   Prepare a statement of cash flows using the indirect method