Create a statement of cash flows using the indirect method. Figures for additional notes:
Depreciation expense for building = $87,500
Depreciation expense for equipment = $6,000
Depreciation expense for office furniture= $11,750
Acct. No. Account Title 100 Cash 102 Accounts Receivable, nel 104 Merchandise Inventory, net 108 Office Supplies 107 Prepaid Expenses 120 Equity Investments - Trading 122 Investments Held to Malurity 140 Land 145 Building 146 Accumulated Depreciation Building 151 Equipment 152 Accumulated Depreciation Equipment 163 Office Furniture Accumulated Depreciation Office Furniture 201 Accounts Pavable 202 Wages Payable 203 Interest Payable 204 Dividends Payable 205 Unearned Rent 206 250 251 252 253 252 300 301 330 331 340 500 600 700 701 702 703 704 Customer Refunds Payable Notes Payable - Long Term Bonds Payable - Long Term Premium on Bonds Payable Discount on Bonds Payable Mortgage (Warehouse) Payable Comman Sack $1 Par, 100,000 Authorised 61.000 bad/Outstanding Paid In Capital - Excess of Par Common Stock Retained Earnings Cash Dividends Treasury Stock Seles Cost of Goods Sold Wage Expense (hourly workers) Salaries Expense (Exempt Staff) Marketing Expense Travel and Entertainment Expense Bad Debt Expense July 31, 2019 Adjusted Trial Balance Dr. 583,730.00 445,000.00 497,430.00 1,250.00 12.500.00 59,850.00 23,860.00 1,000,000.00 2.500.000.00 170,000.00 32,500.00 38,000.00 1,750,199.00 794,515.00 89,000.00 | 65,000.00 525.00 6,500.00 Cr. 312,500.00 85,000.00 16,250.00 356,000.00 6,000.00 35,600.00 12,000.00 200,000.00 248,000.00 65,600.00 1,177,250.00 2,351,400.00 3,457,984.00 CHANGES COLUMNS Used ONLY for Statement of cash flows Debit Credit 21,470.00 (19.500.00) 100.170.00 5,250.00 (2.000.00) 26.800.00 32,100.00 500,000.00 1.000.000 or 35.000.00 10,000.00 200,000.00 50,000.00 37.420.00 (2.000.00) (6.800.00) 200,000.00 200,000.00 550,000.00 15,500.00 July 31, 2020 Adjusted Trial Balance Dr. 805,200.00 425,500.00 597,600.00 6,500.00 10.500,00 86,450.00 65.960.00 1,500,000.00 3.500.000.00 205,000.00 42,500.00 200,000.00 88,000.00 1,509,195.00 799,500.00 229,000.00 75,000.00 85,600.00 9,900.00 Cr Additional Notes for Statement of Cash Flows Change in cash not required in operating activites, but should match net increase or decrease in cash 400,000.00 Use depreciation expense from income statement 95,000.00 Use depreciation expense from Income statement 18,250.00 Use depreciation expense from income statement 393,420.00 4,000.00 29,000.00 212,000.00 400,000.00 798,000.00 81,000.00 1,177,250.00 2,849,810.00 3,975,725.00 704 Bad Debt Expense 705 Property Tax Expense 706 Office Maintenance & Repair Expense 707 Legal Expenses 708 Insurance Expense 709 Miscellaneous Expense 710 Office Supplies Expense 711 Telecommunications Expense 712 Depreciation Expense - Building 713 Depreciation Expense - Equipment 714 Depreciation Expense - Office Furniture 800 Rent Income 802 Gain on Sale of Equity Investment Securities - Trading 900 Interest Expense 902 Loss on sale of Held to Maturity Investments Total Net Income (Loss) 6,500.00 111,200.00 1,500.00 48,985.00 400.00 62,500.00 17,000.00 3,250.00 5,000.00 4,000.00 8,323,484.000 2,959,574.00 8,323,484.000 3,457,984.00 498,410.00 9,900.00 150,000.00 30,000.00 5,400.00 3,500.00 53,925.00 735.00 10,000.00 87,500.00 6,000.00 11,750.00 61,000.00 30,250.00 10,481,455.000 12,000.00 35,000.00 10,481,455.000
