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

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

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 and Stockholders' Equity
Accounts payable	$ 92,000	$ 67,300
Accrued expense 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 Data

For the Year Ended December 3 I

Sales $342,780

Less

Cost of goods sold	$115,460
Operating expenses (exclucling
depreciation)	12,410
Depreciation expense	46,500
Income taxes	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 costing $85,000 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 of $22,350 was declared and paid during the year

Instruction

Prepare a statement of cash flows using the indirect method