Write a program to generate a Statement of Cash Flows yourself. It isn't as hard as you might think. First set up the Income Statement and two Balance Sheets on the spreadsheet just as they appear in Problem 27. Let the amounts in individual accounts such as cash, A/R, revenue, COGS, interest, and tax be input items, and let the program calculate all the totals and subtotals such as current assets, total assets, gross margin and net income.

In Problem 27

At the close of 20X3, the financial statements of Northern Manufacturing were as follows.

In addition, Northern paid dividends of $1.2M and sold new stock valued at $1.0M during 20X3. Use the CASHFLO program to produce Northern's statement of cash flows for 20X3.

Transcribed Image Text:

Northern Manufacturing Balance Sheet For the year ended 12/31/X3 12/31 X2 12/31 X3 ASSETS 500 200 Northern Manufacturing as Income Statement For the year ending 12/31X3 6,250 $11,930 $7,500 $5,100 Accounts Receivable Inventory CURRENT ASSETS 7,300 Sales 6.470 COGS 13.970 Gross Mar $5,332 700 $5,022 Fixed Assets Gross Accum. Deprec. Net 9,000Expense .100) Depreciation 5,900 EBIT Interest 1.180 TOTAL ASSETS $17,030$19,870 EBT Tax Net Income 1.537 2,305 LIABILITIES Accounts Payable Accruals CURRENT LIABILITIES Long-term Debt Equity TOTAL CAPITAL TOTAL LIABILITIES AND EOUITY $1,860 850 $2,710 $2,210 220 $2,430 $11,32012,335 $14,320 $17,440 $17,030 $19,870