2. Create statement of retained earnings using July 31, 2020 adjusted balances AND formatting information from stmnt of RE tab.
Create statement of cash flows using the income statement, the "changes" columns from below, and the additional notes to the right of July 31, 2020 adjusted trial balance columns. To complete the "changes" columns and the statement of cash flows:
Please help with making a statement of retained earnings and Statement of Cash flow!
1. Create multi-step Income Statement using the July 31, 2020 adjusted balances AND formatting information from IS tab. 2. Create statement of retained earnings using July 31, 2020 adjusted balances AND formatting information from stmnt of RE tab. 3. Create classified balance sheet using July 31, 2020 adjusted balances AND formatting information from BS tab. 4. Create statement of cash flows using the income statement, the "changes" columns from below, and the additional notes to the right of July 31, 2020 adjusted trial balance columns. To complete the "changes" columns and the statement of cash flows: a. Input a formula in either the debit column OR the credit column to find the change in account balance from July 2019 to July 2020. b. Only complete the "changes" cells that are outlined and have 2019 beginning balances and 2020 ending balances. Do not find changes in cells that are grayed out. c. Use the "changes" amounts to create the statement of cash flows. Amounts from the income statement will also be needed. d. Pay attention to statement of cash flows additional information columns below. These give hints. July 31, 2019 July 31, 2020 Adjusted Adjusted CHANGES COLUMNS Used ONLY for Statement of cash flows Trial Balance Trial Balance Acct. No. Account Title Dr. Cr. Debit Credit Dr. Cr 100 Cash 583,730.00 21,470.00 605,200.00 102 Accounts Receivable, net 445,000.00 425,500.00 104 Merchandise Inventory, net 497,430.00 597,600.00 106 Office Supplies 1,250.00 6,500.00 107 Prepaid Expenses 12,500.00 10,500.00 120 Equity Investments - Trading 59,650.00 86,450.00 122 Investments - Held to Maturity 23,850.00 55,950.00 1,000,000.0 1,500,000.0 0 140 Land 2,500,000.0 3,500,000.0 0 145 Building 146 Accumulated Depreciation - Building 312,500.00 400,000.00 151 Equipment 170,000.00 205,000.00 152 85,000.00 96,000.00 153 Accumulated Depreciation - Equipment Office Furniture Accumulated Depreciation - Office Furniture 32,500.00 42,500.00 154 16,250.00 18,250.00 201 Accounts Payable 356,000.00 393,420.00 202 203 Wages Payable Interest Payable Dividends Payable 204 205 Unearned Rent 6,000.00 4,000.00 206 Customer Refunds Payable 35,600.00 29,000.00 250 Notes Payable - Long Term 12,000.00 212,000.00 251 Bonds Payable - Long Term 200,000.00 400,000.00 252 Premium on Bonds Payable Discount on Bonds Payable 253 252 Mortgage (Warehouse) Payable 248,000.00 798,000.00 300 Common Stock, $1 Par, 100,000 Authorized: 81,000 shares Issued/Outstanding 65,500.00 81,000.00 Paid In Capital - Excess of Par Common Stock 1,177,250. 00 1,177,250. 00 301 2,351,400. 00 Retained Earnings 2,849,810. 00 330 331 Cash Dividends 200,000.00 340 Treasury Stock 38,000.00 88,000.00 500 3,457,984. 00 3,975,725. 00 Sales 1,750,199.0 0 1,509,195.0 0 600 Cost of Goods Sold 794,515.00 799,500.00 701 89,000.00 229,000.00 65,000.00 75,000.00 700 Wage Expense (hourly workers) Salaries Expense (Exempt Staff) 702 Marketing Expense 703 Travel and Entertainment Expense Bad Debt Expense Property Tax Expense 525.00 85,600.00 704 6,500.00 9,900.00 705 111,200.00 150,000.00 706 Office Maintenance & Repair Expense 30,000.00 707 Legal Expenses 5,400.00 708 Insurance Expense 1,500.00 3,500.00 709 48,985.00 53,925.00 710 400.00 735.00 711 10,000.00 Miscellaneous Expense Office Supplies Expense Telecommunications Expense Depreciation Expense - Building Depreciation Expense - Equipment Depreciation Expense - Office Furniture 712 62,500.00 87,500.00 713 17,000.00 6,000.00 714 3,250.00 11,750.00 800 12,000.00 802 35,000.00 Rent Income Gain on Sale of Equity Investment Securities - Trading Interest Expense Loss on sale of Held to Maturity Investments 900 5,000.00 61,000.00 902 4,000.00 30,250.00 8,323,484.0 8,323,484. 00 000 10,481,455. 10,481,455 000 .000 Total 2,959,574.03,457,984. 0 00 Net Income (Loss) 498,410.00 Instructions: Using the August 31, 2020 adjusted trial balance information AND the statement of retained earnings complete a classified balance sheet. Round all amounts to the nearest cent. Follow the below format notes, the rest is up to the student. Note that grades are also based on organization, formula use, and clarity of financial statement. The other requirements are: a. ONLY use accounts that have adjusted balances for July 31, 2020 b. Include proper report title c. Not all rows or columns need to be used. Formulas MUST be used when necessary. Use the following format (in order): 1. Input and list asset accounts in 3 categories: Current Assets; Property, Plant, and Equipment(PPE); Other Assets 2. Each category from #1 requires a subtotal EXCEPT for Other Assets 3. Calculate Total Assets 4. Input and list liability accounts in 2 categories: Current Liabilities and Long-term Liabilities 5. Each category from #4 requires a subtotal 6. Calculate Total Liabilities 7. Input and list Stockholder's Equity Accounts including ending balance of retained earnings from statement of retained earnings. 8. Calculate Total Stockholder's Equity 9. Calculate Total Liabilities and Stockholder's Equity. This amount should equal Total Assets 1. Create multi-step Income Statement using the July 31, 2020 adjusted balances AND formatting information from IS tab. 2. Create statement of retained earnings using July 31, 2020 adjusted balances AND formatting information from stmnt of RE tab. 3. Create classified balance sheet using July 31, 2020 adjusted balances AND formatting information from BS tab. 4. Create statement of cash flows using the income statement, the "changes" columns from below, and the additional notes to the right of July 31, 2020 adjusted trial balance columns. To complete the "changes" columns and the statement of cash flows: a. Input a formula in either the debit column OR the credit column to find the change in account balance from July 2019 to July 2020. b. Only complete the "changes" cells that are outlined and have 2019 beginning balances and 2020 ending balances. Do not find changes in cells that are grayed out. c. Use the "changes" amounts to create the statement of cash flows. Amounts from the income statement will also be needed. d. Pay attention to statement of cash flows additional information columns below. These give hints. July 31, 2019 July 31, 2020 Adjusted Adjusted CHANGES COLUMNS Used ONLY for Statement of cash flows Trial Balance Trial Balance Acct. No. Account Title Dr. Cr. Debit Credit Dr. Cr 100 Cash 583,730.00 21,470.00 605,200.00 102 Accounts Receivable, net 445,000.00 425,500.00 104 Merchandise Inventory, net 497,430.00 597,600.00 106 Office Supplies 1,250.00 6,500.00 107 Prepaid Expenses 12,500.00 10,500.00 120 Equity Investments - Trading 59,650.00 86,450.00 122 Investments - Held to Maturity 23,850.00 55,950.00 1,000,000.0 1,500,000.0 0 140 Land 2,500,000.0 3,500,000.0 0 145 Building 146 Accumulated Depreciation - Building 312,500.00 400,000.00 151 Equipment 170,000.00 205,000.00 152 85,000.00 96,000.00 153 Accumulated Depreciation - Equipment Office Furniture Accumulated Depreciation - Office Furniture 32,500.00 42,500.00 154 16,250.00 18,250.00 201 Accounts Payable 356,000.00 393,420.00 202 203 Wages Payable Interest Payable Dividends Payable 204 205 Unearned Rent 6,000.00 4,000.00 206 Customer Refunds Payable 35,600.00 29,000.00 250 Notes Payable - Long Term 12,000.00 212,000.00 251 Bonds Payable - Long Term 200,000.00 400,000.00 252 Premium on Bonds Payable Discount on Bonds Payable 253 252 Mortgage (Warehouse) Payable 248,000.00 798,000.00 300 Common Stock, $1 Par, 100,000 Authorized: 81,000 shares Issued/Outstanding 65,500.00 81,000.00 Paid In Capital - Excess of Par Common Stock 1,177,250. 00 1,177,250. 00 301 2,351,400. 00 Retained Earnings 2,849,810. 00 330 331 Cash Dividends 200,000.00 340 Treasury Stock 38,000.00 88,000.00 500 3,457,984. 00 3,975,725. 00 Sales 1,750,199.0 0 1,509,195.0 0 600 Cost of Goods Sold 794,515.00 799,500.00 701 89,000.00 229,000.00 65,000.00 75,000.00 700 Wage Expense (hourly workers) Salaries Expense (Exempt Staff) 702 Marketing Expense 703 Travel and Entertainment Expense Bad Debt Expense Property Tax Expense 525.00 85,600.00 704 6,500.00 9,900.00 705 111,200.00 150,000.00 706 Office Maintenance & Repair Expense 30,000.00 707 Legal Expenses 5,400.00 708 Insurance Expense 1,500.00 3,500.00 709 48,985.00 53,925.00 710 400.00 735.00 711 10,000.00 Miscellaneous Expense Office Supplies Expense Telecommunications Expense Depreciation Expense - Building Depreciation Expense - Equipment Depreciation Expense - Office Furniture 712 62,500.00 87,500.00 713 17,000.00 6,000.00 714 3,250.00 11,750.00 800 12,000.00 802 35,000.00 Rent Income Gain on Sale of Equity Investment Securities - Trading Interest Expense Loss on sale of Held to Maturity Investments 900 5,000.00 61,000.00 902 4,000.00 30,250.00 8,323,484.0 8,323,484. 00 000 10,481,455. 10,481,455 000 .000 Total 2,959,574.03,457,984. 0 00 Net Income (Loss) 498,410.00 Instructions: Using the August 31, 2020 adjusted trial balance information AND the statement of retained earnings complete a classified balance sheet. Round all amounts to the nearest cent. Follow the below format notes, the rest is up to the student. Note that grades are also based on organization, formula use, and clarity of financial statement. The other requirements are: a. ONLY use accounts that have adjusted balances for July 31, 2020 b. Include proper report title c. Not all rows or columns need to be used. Formulas MUST be used when necessary. Use the following format (in order): 1. Input and list asset accounts in 3 categories: Current Assets; Property, Plant, and Equipment(PPE); Other Assets 2. Each category from #1 requires a subtotal EXCEPT for Other Assets 3. Calculate Total Assets 4. Input and list liability accounts in 2 categories: Current Liabilities and Long-term Liabilities 5. Each category from #4 requires a subtotal 6. Calculate Total Liabilities 7. Input and list Stockholder's Equity Accounts including ending balance of retained earnings from statement of retained earnings. 8. Calculate Total Stockholder's Equity 9. Calculate Total Liabilities and Stockholder's Equity. This amount should equal Total Assets
