Create the Statement of Cash Flows using the Indirect Method from the information provided. Include the required supplemental information regarding interest and taxes, and include any significant non-cash transactions in EXCEL.

Havaii Boarding, Inc. Balance Sheet December 31, 2020 and 2019 2020 2019 $ Assets Current Assets Cash Accounts Receivable Merchandise Inventory Prepaid Insurance Total Current Assets $ 569,809 164,450 810,810 590 1,545,659 413,900 126,500 772,200 680 1,313,280 Property and Equipment Land Buildings Accumulated Depreciation-Buildings Equipment Accumulated Depreciation Equipment Net Property and Equipment 144,000 1,534,000 (268,450) 685,000 (479,500) 1,615,050 1,774,000 (266,100) 685,000 (411,000) 1,781,900 Right-of-Use Asset ROU--Warehouse Net Right-of-Use Assets 399,000 399,000 195,000 Other Assets Investment in Marketable Securities Assets Held for Sale Total Other Assets 195,000 18,600 18,600 Total Assets $3,754,709 $ 3,113,780 $ Liabilities and Stookholders' Equity Current Liabilities Accounts Payable Salaries and Wages Payable Interest Payable Taxes Payable Unearned Revenue Total Current Liabilities 141,570 19,791 5,411 19,396 20,900 207,067 128,700 21,990 2,664 16,841 19,000 189, 195 Long-term Liabilities Finance Lease Liability Note Payable Total Long-term Liabilities 380,000 431,600 811,600 456,600 456,600 Total Liabilities 1,018,667 645,795 Stockholders' Equity Common Stook Retained Earnings Total Stookholders' Equity 680,000 2,056,042 2,736,042 680,000 1,787,985 2,467,985 Total Liabilities and Stockholders' Ex $3,754,709 $ 3,113,780 1 The company paid dividends to its shareholders at the end of 2020. You need to calculate the amount. The company sold a building (warehouse) in 2020. The building had a historical cost of $240,000 and was sold for $250,000 in cash. See the journal entry for this transaction below. The company purchased land for expansion The company invested in marketable securities with the intent of holding them long-term. They paid $195,000 for this investment. The company sold an asset they were holding for sale for $18,600 The company obtained a new warehouse valued at $420,000 through a 20-year finance lease agreement. They made a $40,000 cash principal payment on the first day of the lease term. The The company made a payment on their long term note. Check Figures: Cash Provided by Operating Activities is $315,109. Cash Used for Investing Hawaii Boarding, Inc. Income Statement For the Years Ending December 31, 2020 and 2019 Sales Revenue Cost of Goods Sold Gross Profit 2020 $ 2,119,803 (1,271,882) 847,921 2019 $ 2,018,860 (1,211,316) 807,544 Operating (Income) Expenses: Salaries and Wages Expense Insurance Expense Supplies Expense Depreciation Expense Gain on Sale of Building Total Operating Expenses 357,853 3,540 7,650 127,850 (46,000) 450,893 344,090 4,080 9,771 112,850 470,791 Income from Operations 397,028 336,753 Other Income and (Expenses): Dividend Income Interest Expense Total Other Income and Expenses 4.875 (32,464) (27,589) (15,981) (15,981) Income Before Income Taxes 369,439 320,772 Tax Expense (77,582) (67,362) Net Income 291,857 $ 253,410 Journal Entry for Sale of Building referred to in Item #2 above: Cash 250,000 Accumulated Depreciation 36,000 Building 240,000 Gain on Sale of Building 46,000 To record sale of building, removing Building and related Accumulated Depreciation from the Balance Sheet and recording the Gain on the Income Statement