Construct the Statement of Cash Flow for 2017 in a different worksheet. The numbers in the Statement of Cash Flows should be linked to the related numbers either in the Balance Sheet or in the Income Statement. All three worksheets (balance sheet, income statement, statement of cash flows) should be in the same workbook. Compare the net Change in Cash Balance from the statement of cash flows with the cash holdings in 2017 and 2016 balance sheet. What is their relationship?

Construct the 2017 and 2016 common-size balance sheets and income statements.

SL High Tech
Balance Sheet
For the Year Ended December 31, 2017
	2017	2016
Assets
Cash	56300	41000
Marketable Securities	85000	21000
Accounts Receivable	438000	372000
Inventory	520000	420000
Total Current Assets	1099300	854000
Gross Fixed Assets	2680000	2170000
Accumulated Depreciation	548800	485000
Net Plant & Equipment	2131200	1685000
Total Assets	3230500	2539000
Liabilities & Owner's Equity
Accounts Payable	505000	310000
Accrued Expenses	49370	32000
Total Current Liabilities	554370	342000
Long-term Debt	1168100	1061000
Total Liabilities	1722470	1403000
Common Stock ($20 par)	760000	600000
Retained Earnings	748030	536000
Total Owner's Equity	1508030	1136000
Total Liab. & Owner's Equity	3230500	2539000

Construct the 2017 common-size statement of cash flows using both sales and the beginning cash balance as the denominator. You are expected to use the CHOOSE () function in Excel to switch the denominators.

Use Excels Outliner tool to create appropriate outlines for three financial statements.

Discuss the results and your findings.