Golden Corporation's current year income statement, comparative balance sheets, and additional information follow. For the year,

$(1)$ all sales are credit sales,

$(2)$ all credits to Accounts Receivable reflect cash receipts from customers,

$(3)$ all purchases of inventory are on credit,

$(4)$ all debits to Accounts Payable reflect cash payments for inventory, and

$(5)$ any change in Income Taxes Payable reflects the accrual and cash payment of taxes.

$\backslash$table$[[\backslash$table$[[$GOLDEN CORPORATION$],[$Comparative Balance Sheets$],[$December $31]],$Current Year,Prior Year$],[\backslash$table$[[$Assets$],[$Cash$],[$Accounts receivable$],[$Inventory$],[$Total current assets$],[$Equipment$],[$Accumulated depreciation$-$Equipment$]],\backslash$table$[[\backslash$table$[[$$$181,000],[108,500],[626,500],[916,000],[380,800],[(166,500)]]]],\backslash$table$[[\backslash$table$[[$$$125,700],[88,000],[543,000],[756,700],[316,000],[(112,500)]]]]],[$Total assets,$$1,130,300,$$$960,200],[\backslash$table$[[$LiabilitiesandEquity$],[$Accountspayable$],[$Incom$\backslash$eta xespayable$],[$Totalcurrentliabilities$],[$Equity$],[$Commonstock$,$$$2$parvalue$],[$Paid$-$inca$\backslash$pi talinexcessofparvalue,commonstock$],[$R$\backslash$eta inedearnings$]],\backslash$table$[[\backslash$table$[[$$$121,000],[45,000],[166,000],[],[612,400],[226,600],[125,300]]]],\backslash$table$[[\backslash$table$[[$$$88,000],[33,600],[121,600],[],[585,000],[185,500],[68,100]]]]],[$Total liabilities and equity,$$1,130,300,$$$960,200]]$ Additional Information on Current Year Transactions

a$.$ Purchased equipment for $$64,800$ cash.

b$.$ Issued $13,700$ shares of common stock for $$5$ cash per share.

c$.$ Declared and paid $$106,000$ in cash dividends.

Problem $12-7$AA $($Algo$)$ Indirect: Cash flows spreadsheet LO P$4$

Required:

Prepare a complete statement of cash flows using a spreadsheet under the indirect method.

Note: Enter all amounts as positive values. $\backslash$table$[[$GOLDEN CORPORATION$],[$Spreadsheet for Statement of Cash Flows$],[$For Current Year Ended December $31],[,\{$

$\backslash$table$[[$December $31,$ Prior$],[$Year$]]\},$Analysis of Changes,$\{$

$\backslash$table$[[$December $31,],[$Current Year$]]\}],[,$Debit,Credit$],[$Balance sheet$$debit balance accounts$],[$Cash$,$$$,125,700,,,$$$,181,000],[$Accounts receivable,,$88,000,20,000,,,108,000],[$Inventory$,,543,000,83,500,,,626,500],[$Equipment$,,316,000,,,,],[$$$,1,072,700,,,$$$,915,500],[$Balance sheet$$credit balance accounts$],[$Accumulated depreciation$-$Equipment,$$,112,500,,,,],[$Accounts payable,,$88,000,,,,],[$Income taxes payable,,$33,600,,,,],[$Common stock, $$2$ par value,,$585,000,,,,],[$Paid$-$in capital in excess of par value, common stock,,$185,500,,,,],[$Retained earnings,,$68,100,,,,],[$$$,1,072,700,,,$$$,\backslash$bar $(0)]]\backslash$table$[[,,,,],[$Statement of cash flows$],[$Operating activities$],[$Net income,,$163,200,,],[$Depreciation expense,,$54,000,,],[$Increase in accounts receivable$],[$Decrease in inventory$],[$Decrease in accounts payable$],[,,,,],[,,,,],[$Investing activities$],[$Payment for equipment$],[,,,,],[$Financing activities$],[$Paid cash dividends$],[,,,,],[,,,,],[,,320,700,$$$,]]$