needs to be done on excel, and following the required in picture 1.

this and the next picture are together

The unadjusted trial balance of Morgan Manufacturing Corp. at December 31, 2019 is shown on the "Trial Bal" page (see tab below). Refer also to the additional year-end information for the company shown on the "Adjusting Entries" page (see tab below). Required: 1 Prepare year-end adjusting entries. General ledger account numbers are not necessary. Show your calculations below each adjusting entry. 2 Post the adjusting entries to the trial balance and prepare an adjusted trial balance. Using the amounts from the adjusted trial balance, complete the financial statements for the year ended December 31, 2019. Morgan Manufacturing Corp. Adjusting Entries For the Year Ended December 31, 2019 The following additional information is available at the corporation's year-end. GST of 5% only applies when indicated. a. S5.000 A sale on account has not been recorded in the amount of Applicable sales tax is: b. Warranty ex 20 c. Unpaid gros $10,000 Deductions Employee Portion 126 Company Portion Employee incor FICA Social Se FICA Medicare Company health these are not the actual required percentages 26 d. The estimati 590.000 e. Rent revenue consists of 13 equal monthly payments, including one paid in advance for January 2020. f. A trade account payable was converted to a note payable during the year. No entry has been made to record this. The note payable is due at the end of 2020 540.000 The amount of the note payable is: The annual interest rate on the note payable is: The note payable was created at the end of this month: (January - 1: December - 12) $30,000 A lawsuit was commenced against the company in 2019. Damages claimed are: Lawyers for the company consider the likelihood of success to be: Possible S163.200 h. The interest rate on the mortgage is: Annual payments (blended principal and interest) are made on Dec. 31 and total: The 2019 payment has been recorded as Interest on Long-term Debt expense. i. The corporate income tax rate as a percentage of income before income taxes is: Corporate income tax installments during the year have been recorded as Income Tax expense in the records. Assume any 2019 loss before income taxes will result in the refund of income taxes at the current year's income tax rate. GENERAL JOURNAL Dec. 2019 Adjusting entries Debit Credit Adj. # Adjusted 7B Debit Credit Trial Balance At December 31, 2019 Account Unadjusted TB Adjustments Debit Credit Adj. # Debit Credit Cash in bank 74,000 Accounts receivable 760,000 Parts inventory 210,000 Corp. income tax receivable Land 10.000.000 Building 7,900,000 Accumulated dep'n - bldg. 1.580.000 Trade accounts payable 140,000 Interest payable 11 Estimated current liabilities 136,000 Estimated warranty liability Salaries payable Employee inc. taxes pay. FICA Soc. Sec. pay. TI IT T FICA Medicare payable Co. health insurance payable 1,000 1,632.000 9.000.000 2,963,800 520,000 13,600,000 Corp. income tax payable Sales tax payable Note payable Uncarned rent revenue Mortgage payable Common stock, S1 per sh. Retained earnings Rent revenue Sales, net Cost of goods sold Bad debts expense Co. health ins. expense Delivery expense Dep'n, expense -building FICA Soc. Sec. exp. FICA Medicare exp. Interest and bank charges Interest on long-term debt Lawsuit damages expense Office supplies expense Professional fees Salaries expense Warranty expense Corp, income tax exp. 1 || 8,704,000 3.000 18.400 300,000 1.000 18,400 9.200 50.000 163,200 99,000 40.000 460,000 1.000 489,600 29,436,800 29,436,800 Morgan Manufacturing Corp. Income Statement For the Year Ended December 31, 2019 2019 2018 $12,756,800 9,017,344 3,739,456 532.510 282,510 99,000 247,520 1,161,030 Sales, net Less: Cost of goods sold Gross profit Operating expenses Selling Salaries and benefits Delivery Office supplies Warranty Total selling General and administrative Bad debts Depreciation Lawsuit damages Professional fees Total general and adminstrative Total operating expenses Income from operations Other income Rent revenue Income before interest and income taxes Interest expense Income before income taxes Income taxes Net income 2,790 940 143,000 146,730 1,307,760 2,431,696 499,200 2,930,896 177,243 2,753,653 275,365 $2,478,288 Morgan Manufacturing Corp. Statement of Changes in Equity For the Year Ended December 31, 2019 2019 Retained Common stock earnings Total equity $9,000,000 $ $2,963,800 $11,963,800 2018 Balance at Jan. 1 Net income Balance at Dec. 31 Total equity $9,485,512 2,478,288 $11,963,800 $9,000,000 Morgan Manufacturing Corp. Balance Sheet At December 31, 2019 Morgan Manufacturing Corp. Balance Sheet At December 31, 2019 Assets 2019 Current Cash Accounts receivable, net Corporate income taxes receivable Inventories 2018 $41,970 640,000 168,012 849,982 Non-current Land Building, net 23,166,245 6,321,000 29,487,245 $30,337,227 $108,150 84,600 126,900 Liabilities Current Trade accounts payable Estimated current liabilities Estimated warranty liabilities Note payable Interest payable Salaries and benefits payable Sales tax payable Unearned rent Current portion of mortgage payable Corporate income taxes payable 297 10,340 1,540 41,600 180,000 553,427 Non-current Mortgage payable Less: Current portion 18,000,000 (180,000) 17,820,000 18,373,427 Total liabilities Stockholders' Equity Common stock Retained earnings 9,000,000 2,963,800 11,963,800 $30,337,227 Total liabilities and S/H equity The unadjusted trial balance of Morgan Manufacturing Corp. at December 31, 2019 is shown on the "Trial Bal" page (see tab below). Refer also to the additional year-end information for the company shown on the "Adjusting Entries" page (see tab below). Required: 1 Prepare year-end adjusting entries. General ledger account numbers are not necessary. Show your calculations below each adjusting entry. 2 Post the adjusting entries to the trial balance and prepare an adjusted trial balance. Using the amounts from the adjusted trial balance, complete the financial statements for the year ended December 31, 2019. Morgan Manufacturing Corp. Adjusting Entries For the Year Ended December 31, 2019 The following additional information is available at the corporation's year-end. GST of 5% only applies when indicated. a. S5.000 A sale on account has not been recorded in the amount of Applicable sales tax is: b. Warranty ex 20 c. Unpaid gros $10,000 Deductions Employee Portion 126 Company Portion Employee incor FICA Social Se FICA Medicare Company health these are not the actual required percentages 26 d. The estimati 590.000 e. Rent revenue consists of 13 equal monthly payments, including one paid in advance for January 2020. f. A trade account payable was converted to a note payable during the year. No entry has been made to record this. The note payable is due at the end of 2020 540.000 The amount of the note payable is: The annual interest rate on the note payable is: The note payable was created at the end of this month: (January - 1: December - 12) $30,000 A lawsuit was commenced against the company in 2019. Damages claimed are: Lawyers for the company consider the likelihood of success to be: Possible S163.200 h. The interest rate on the mortgage is: Annual payments (blended principal and interest) are made on Dec. 31 and total: The 2019 payment has been recorded as Interest on Long-term Debt expense. i. The corporate income tax rate as a percentage of income before income taxes is: Corporate income tax installments during the year have been recorded as Income Tax expense in the records. Assume any 2019 loss before income taxes will result in the refund of income taxes at the current year's income tax rate. GENERAL JOURNAL Dec. 2019 Adjusting entries Debit Credit Adj. # Adjusted 7B Debit Credit Trial Balance At December 31, 2019 Account Unadjusted TB Adjustments Debit Credit Adj. # Debit Credit Cash in bank 74,000 Accounts receivable 760,000 Parts inventory 210,000 Corp. income tax receivable Land 10.000.000 Building 7,900,000 Accumulated dep'n - bldg. 1.580.000 Trade accounts payable 140,000 Interest payable 11 Estimated current liabilities 136,000 Estimated warranty liability Salaries payable Employee inc. taxes pay. FICA Soc. Sec. pay. TI IT T FICA Medicare payable Co. health insurance payable 1,000 1,632.000 9.000.000 2,963,800 520,000 13,600,000 Corp. income tax payable Sales tax payable Note payable Uncarned rent revenue Mortgage payable Common stock, S1 per sh. Retained earnings Rent revenue Sales, net Cost of goods sold Bad debts expense Co. health ins. expense Delivery expense Dep'n, expense -building FICA Soc. Sec. exp. FICA Medicare exp. Interest and bank charges Interest on long-term debt Lawsuit damages expense Office supplies expense Professional fees Salaries expense Warranty expense Corp, income tax exp. 1 || 8,704,000 3.000 18.400 300,000 1.000 18,400 9.200 50.000 163,200 99,000 40.000 460,000 1.000 489,600 29,436,800 29,436,800 Morgan Manufacturing Corp. Income Statement For the Year Ended December 31, 2019 2019 2018 $12,756,800 9,017,344 3,739,456 532.510 282,510 99,000 247,520 1,161,030 Sales, net Less: Cost of goods sold Gross profit Operating expenses Selling Salaries and benefits Delivery Office supplies Warranty Total selling General and administrative Bad debts Depreciation Lawsuit damages Professional fees Total general and adminstrative Total operating expenses Income from operations Other income Rent revenue Income before interest and income taxes Interest expense Income before income taxes Income taxes Net income 2,790 940 143,000 146,730 1,307,760 2,431,696 499,200 2,930,896 177,243 2,753,653 275,365 $2,478,288 Morgan Manufacturing Corp. Statement of Changes in Equity For the Year Ended December 31, 2019 2019 Retained Common stock earnings Total equity $9,000,000 $ $2,963,800 $11,963,800 2018 Balance at Jan. 1 Net income Balance at Dec. 31 Total equity $9,485,512 2,478,288 $11,963,800 $9,000,000 Morgan Manufacturing Corp. Balance Sheet At December 31, 2019 Morgan Manufacturing Corp. Balance Sheet At December 31, 2019 Assets 2019 Current Cash Accounts receivable, net Corporate income taxes receivable Inventories 2018 $41,970 640,000 168,012 849,982 Non-current Land Building, net 23,166,245 6,321,000 29,487,245 $30,337,227 $108,150 84,600 126,900 Liabilities Current Trade accounts payable Estimated current liabilities Estimated warranty liabilities Note payable Interest payable Salaries and benefits payable Sales tax payable Unearned rent Current portion of mortgage payable Corporate income taxes payable 297 10,340 1,540 41,600 180,000 553,427 Non-current Mortgage payable Less: Current portion 18,000,000 (180,000) 17,820,000 18,373,427 Total liabilities Stockholders' Equity Common stock Retained earnings 9,000,000 2,963,800 11,963,800 $30,337,227 Total liabilities and S/H equity