donde estate Income Setement de Salud Tamice Sheet for Island Deem, Inc. for the fiscal year ending December 1.200 XCII. You The flow to Create Form des to the tale we to be reste de thee Backentru SMITH EXCEL P222 D F E G B 132 133 134 Island Dream, Inc. Adjusted Trial Balance December 31, 2020 135 136 137 Credit $ Debit 33,500 60,000 $ 6.100 18,600 2,500 2,000 100,000 800.000 440,000 400,000 138 Cash 139 Accounts Receivable 140 Allowance for Doubtful Accounts 141 Merchandise Inventory 142 Supplies 143 Prepaid Insurance 144 Land 145 Building 146 Accumulated Depreciation - Building 147 Equipment 148 Accumulated Depreciation - Equipment 149 Accounts Payable 150 Uneamed Revenue 151 Salaries Payable 152 Notes Payable, due May 31, 2020 153 Mortgage Payable due Dec. 31, 2025 154 Common Stock 155 Retained Earnings 156 Dividends 157 Sales 158 Sales Returns & Allowances 159 Sales Discounts 160 Costs of Goods Sold 161 Salaries Expense 155,000 42,400 20.500 1.200 25,000 230,000 275,000 222.000 45,000 225.000 4,400 1,600 110,000 30,000 LE Case Part 11 Income Statement Retained Earnings Statement Balance Sheet Read P222 E G 62 Depreciation Expense 63 Freight Out 64 Advertising Expense 6. Utilities Expense 766 Supplies Expense 167 Bad Debt Expense 168 Interest Revenue 160 Gain on sale of Equipment 170 Loss on sale of Building Interest Expense 172 Total F 15.000 500 3.300 12,700 1,500 2.000 3.700 2.000 3,500 1.800 ? 173 IN teleet tabte Retained Ishte theme tab to anche Can the countrieb of the statements and format or the Add Trual son ch shet, type the propriate labels for the financial state For a miple step income strumples from chapter 5 of the book. For the retained maps, we cumplir chapter of For the defied hals, pero che of the testbook Be sure that your sind balance sheet TOTAL ASSETS TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY 6. leder to copy then from the date one of the financial statements, click on the cells wich you want the samer to appear, the press Then dick the Adjusted Trial Balance sheet tab and dick the the that you want to transfer to the final de Enter This will transfer the member to the financial statement. This should be done for each number on the financial state, sot the totale! That way, it Cattomila why to complete the financial ONT Fachland nach obtotal should have a forma) Tocomplete the instalents, you will need to property format the worksheets. In some cas you tined to face with the common format. In other cities to format the cells with the eyfonal Benuto indicate wedle with the correct andering or double. These can be found and the Font tab Fully, you have your work and print the final statements Rome your filene should be Your NameSection Beure to set the print option to print to maging the page layout a 10. Upload you feinated by your starting Moodlit Ahostach your printed copy to the appropriate paper in this case Be want to write your name and action on your printed copy donde estate Income Setement de Salud Tamice Sheet for Island Deem, Inc. for the fiscal year ending December 1.200 XCII. You The flow to Create Form des to the tale we to be reste de thee Backentru SMITH EXCEL P222 D F E G B 132 133 134 Island Dream, Inc. Adjusted Trial Balance December 31, 2020 135 136 137 Credit $ Debit 33,500 60,000 $ 6.100 18,600 2,500 2,000 100,000 800.000 440,000 400,000 138 Cash 139 Accounts Receivable 140 Allowance for Doubtful Accounts 141 Merchandise Inventory 142 Supplies 143 Prepaid Insurance 144 Land 145 Building 146 Accumulated Depreciation - Building 147 Equipment 148 Accumulated Depreciation - Equipment 149 Accounts Payable 150 Uneamed Revenue 151 Salaries Payable 152 Notes Payable, due May 31, 2020 153 Mortgage Payable due Dec. 31, 2025 154 Common Stock 155 Retained Earnings 156 Dividends 157 Sales 158 Sales Returns & Allowances 159 Sales Discounts 160 Costs of Goods Sold 161 Salaries Expense 155,000 42,400 20.500 1.200 25,000 230,000 275,000 222.000 45,000 225.000 4,400 1,600 110,000 30,000 LE Case Part 11 Income Statement Retained Earnings Statement Balance Sheet Read P222 E G 62 Depreciation Expense 63 Freight Out 64 Advertising Expense 6. Utilities Expense 766 Supplies Expense 167 Bad Debt Expense 168 Interest Revenue 160 Gain on sale of Equipment 170 Loss on sale of Building Interest Expense 172 Total F 15.000 500 3.300 12,700 1,500 2.000 3.700 2.000 3,500 1.800 ? 173 IN teleet tabte Retained Ishte theme tab to anche Can the countrieb of the statements and format or the Add Trual son ch shet, type the propriate labels for the financial state For a miple step income strumples from chapter 5 of the book. For the retained maps, we cumplir chapter of For the defied hals, pero che of the testbook Be sure that your sind balance sheet TOTAL ASSETS TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY 6. leder to copy then from the date one of the financial statements, click on the cells wich you want the samer to appear, the press Then dick the Adjusted Trial Balance sheet tab and dick the the that you want to transfer to the final de Enter This will transfer the member to the financial statement. This should be done for each number on the financial state, sot the totale! That way, it Cattomila why to complete the financial ONT Fachland nach obtotal should have a forma) Tocomplete the instalents, you will need to property format the worksheets. In some cas you tined to face with the common format. In other cities to format the cells with the eyfonal Benuto indicate wedle with the correct andering or double. These can be found and the Font tab Fully, you have your work and print the final statements Rome your filene should be Your NameSection Beure to set the print option to print to maging the page layout a 10. Upload you feinated by your starting Moodlit Ahostach your printed copy to the appropriate paper in this case Be want to write your name and action on your printed copy