Please use the Adjusted Trial Balance for Rockford Corporation included as a separate Excel file to complete this assignment. Note that the Excel file contains tabs for the individual worksheets designated for each of the required statements or assignments. Please name the workbook you submit as specified below. In addition to the content, you will be assessed on your mastery of the following skills: (1) correct data entry, (2) correct and accessible formulas, (3) formatting of column headings and labels, (4) merger and centering of titles, and (5) overall spreadsheet formatting and printing. You are asked to prepare the following statements: Income Stat ent for the year ending December 31, 2019 Statement of Retained Earnings for the year ending December 31, 2019 Statement of Stockholders Equity for the year ending December 31, 2019 Balance Sheet at December 31, 2019 In addition to the above statements, you are to prepare the journal entries necessary to close the books for Rockford Corporation on December 31, 2019 . Note: The following relates to Common Stock Authorized - 1,000,000 shares Issued 100,000 shares Outstanding - 65,000 shares . Rockford Corporation Adjusted Trial Balance December 31, 2019 2019 Debil 250.17 2500 Credit 0 0 14.014 0 Account Cach Accounts Receivable Allowance for Doubl Accounts Notes Receivable Interest Receivable Inry Supplies Prepaid Insurance Prepaid Rom Investments - Trading Securities Land Buildings Accumulated lepreciation Buildings 0 0 0 104.300 1251 499.00 R30 100 3.500 16550 99.650 306.000 0 0 0 0 70 0 47.540 0 19.133 3800 0 40.000 0 0 0 15,000 181.549 4,406 9.00 0 15.315 0 0 0 0 0 0 46 .... 2.400 10.955 8.740 113 275.000 0 100 0 100,000 10,000 292.400 Accumulated Depreciation Trucks Equipes Acculated Depreciation liquipment Investments Available for Sale Securities Notes Payable Accounts Payable Salaries and Wages Payable FICAT Payable Federal Income Taxes Payable Federal Wading Tanes Payable FUTA Payable SUTA Payable Interest Payable Dividends Payable Notes Payable Long Term Bonds Payable - 51.000 par, 6. Convertible Discount on Bands Payable Preferred Socks S10 Pa (10,000 authorized 1,000 issued & outstanding) Commen Stock-S1 Par (1,000,000 autorired. 100.000 issued 65.000 outstanding Paid in Capital in Excess of Par-Preferred Paid-in Capital in Excess of Par-Common Retained Earning Treasury Stack Accumulated Other Comprehensive Income Non-Controlling Interest Dividends Sales Revenue Sales Disents Sales Returns All Cost of Goods Sold Advertising Expense Bad Dhe Expense Supplies Expense Freight- Office Expense Depreciation Expense Insurance Esp Salaries and Wages pense Rent Expense Payroll Tax Expense Us Expense Interest Revenue Net Income Tax on cd Operations Interest Expense Loss on Disposal of Plant Assets Loss en Disposal - Discontinued Operations (Net of Tax) Income Tax Expense Total 0 0 0 125.610 0 6,850 5,660,052 0 0 0 0 0 8.740 0 77.251 14.00 3.955.362 7673 13.134 4456 19.90 1.455 37.745 45 995.752 21.950 0 0 0 0 0 0 0 0 0 17.47% 0 0 37.051 500 24250 72.000 15.750 0 0 7 7.385,905 "Each hond is convertible into twenty(20) shares of common stock at the discretion of the band holder
