12 pus For this question, you will need to do the following Download the attached document Question 20 Statement of Cash Flow Template.xlsx and save to your computer. Complete the problem on your computer. Once completed you will need to upload the document back to Canvas. Prepare a statement of cash flows using the information provided below and amounts indicated on the attached template. CD Corporation has the following for 2020: Net Income $145,000 Depreciation was $4,250 Sold Equipment with a Cost of $32,000. Accumulated Depreciation $15,000 for $22,500 Cash. Sold Common Stock of $250,000 Paid a Dividend of $6,500 Balance Sheet Balances 2020 2019 o Balance Sheet Balances 2020 2019 Cash 882,500 425,000 Accounts Receivable 575,500 275,500 Merchandise Inventory 445,000 900,000 Prepaid Expenses 67,500 82,500 Equipment 68,000 100,000 Accumulated Depreciation Building (29.250) (40,000) Accounts Payable 590,100 737,350 Wages Payable 65,000 40,000 Retained Earnings 254,150 115,650 Common Stock 1,100,000 850,000 CHART OF ACCOUNTS CASH ACCOUNTS RECEIVABLE INTEREST RECEIVABLE EQUIPMENT ACCUMULATED DEPRECIATION - EQUIPMENT TRUCK ACCUMULATED DEPRECIATION - TRUCK LAND INVESTMENT IN BONDS INVESTMENTS - (NAME) VALUATION ALLOWANCE FOR TRADING INVESTMETNTS ACCOUNTS PAYABLE BONDS PAYABLE INTEREST PAYABLE CASH DIVIDENDS PAYABLE DISCOUNT ON BONDS PAYABLE PREMIUM ON BONDS PAYABLE COMMON STOCK PREFERRED STOCK PAID IN CAPITAL IN EXCESS OF PAR - COMMON STOCK PAID IN CAPITAL IN EXCESS OF PAR - PREFERRED STOCK TREASURY STOCK PAID IN CAPITAL FROM SALE OF TREASURY STOCK CASH DIVIDENDS STOCK DIVIDEND RETAINED EARNINGS SALES INTEREST REVENUE DIVIDEND REVENUE GAIN ON REDEMPTION OF BONDS GAIN ON SALE OF INVESTMENTS INCOME OF (NAME OF CORPORATION) UNREALIZED GAIN (LOSS) ON AVAILABLE FOR SALE INVESTMENTS UNREALIZED GAIN (LOSS) ON TRADING INVESTMENTS ORGANIZATIONAL EXPENSES INTEREST EXPENSE AMORTIZATION EXPENSE COST OF MERCHANDISE SOLD LOSS ON REDEMPTION OF BONDS LOSS ON SALE OF INVESTMENTS RENT EXPENSE SALARIES EXPENSE SUPPLIES EXPENSES