create an indirect statement of cash flows

Week+4 Assignment+1+Template (2)-Excel joanne tittareli insert Page Layout Fomulas Dats Revies View Hep Tell me what you want to do Cut Copy Format Psinle a .. $-96 , *0 : Conditional Format as Good nsert Delete Forme ort& Find & Fiter Select B 1 u , Merge & Center Fomatting Table -* Cles F13 0 1 Airport Shuttle Service Balance Sheet 20X1 20x2 4 ASSETS 5 Cash 6 Accounts Receivable 7 Prepaid Expenses 8 Land 9 Building 10 Equipment 34,000.00 56,000.00 $ 30,000.00 $ 20,000.00 4.000.00 - $130,000.00 -$160,000.00 10,000.00 $ 27,000.00 -$(14,000.00) 12 13 Total Assets 14 15 LIABILITIES AND EQUITIES 16 Accounts Payable 17 Bouds Payable 18 Common Stock 19 Retained Earings 20 21 Total Liabilities and Equities $74,000.00$ 383,000.00 4,000.00 59,000.00 - $130,000.00 50,000.00 $ 50,000.00 20,000.00 144,000.00 74,000.00 383,000.00 Screenshot saved 23 24 A Eshssded to your ings to activate Windows Sheet1 Ready 10-23 AMM +1+Template 2)- Exce joanne tittarelli Insert Page Layout Formulas Data Review View Help Tel me what you want to Cut Wrap Text ECopy 2 Fill Clear B 1 u ::: . . ! Merge & Center $% , Conditional Format as Good FormattingTable Insert Delete Forma Fommat Painter Sort& Find & ilter Select Alignment Fditing F13 24 5 Airport Shuttle Service Income Statement $507,000 27 Revenues 28 Operating Expense 29 Depreciation Expense 30 Loss on Sale of Equipment 31 Total Expenses 32 Taxable Income 33 Income Taxes 34 Net Income 35 36 37 261,000 15,000.00 3,000.00 279,000 228,000 89,000 $139,000 81. The company declared and paid a S 15.000 cash dividend. 39 2. The company obtained land through the issuance of S 130,000 in long-term bonds. 40 3. A building costin 160,000 was purchased with cash. 1 4. Equipmeut costing S 25,000 was purchased with cash. 42 5. The company sold equipment with a book value of7.000 (cost was $ 8,000 with accumulated depreciation of $ 1,000) for cash of S 4,000 43 45 REQUIRED tivate Window Ready