On another worksheet, create a statement of cash flows for 2016. Do not enter any numbers directly on this worksheet. All formulas should be linked directly to the source on previous worksheets. (The previous worksheets were just the income statement and balance sheet as shown but with formulas included)

P.S. In our example problem, the Statement of Cash Flows included three main components: Cash Flows from Operations, Cash Flows from Investing, and Cash Flows from Financing.

Problems 1. Using the data presenta data presented below Rack Cadeat Mining Ca Income Statements For the lears 2015 and 2016 369 00 285.400 83,900 $354.000 281.800 72.200 26.360 21.820 1.050 22.940 Games Pro 1.080 32,660 Oberbering Eyese Net Operating Income 14.975 9.990 7.505 15,435 6.174 59.261 Earnings Before Taxes $14.985 Net Income Notes: 40.000 52,100 $0.18 Tax Rate 40.00 52.100 Earnings per Share S0.29 Big Rock Candy Mountain Mining Co. Balance Sheet For the Year Ended December 31, 2016 2015 $10,300 $550 Marketable Securities Accounts Receivable Total Current Assets Gross Fixed Assets Accumulated Depreciation Ner Plant & Equipment Total Assets $14,714 $1,841 $41,090 $46,910 $104 555 5388,000 $78,020 $309,980 $414.535 $42.100 $48.490 S101,440 $352.600 $51,200 $301.400 $402,840 Liabilities & Orner's Equity Accounts Payable Accrued Expenses Total Current Liabilities Long-term Debt Total Liabilities Common Stock ($1.00 par) Additional Paid-in-Capital Retained Earnings $35.200 $2,850 $38,050 $152,700 S190,750 $52,100 5121,500 $50,185 $32,700 $2,740 $35,440 S158,600 $194,040 $52.100 $121,500 $35,200 $208.800 S402,840 Total Owner's Equity Total Liab. & Ovener's Equity $223,785 $414,535