please include all formulas and linking information between the sheets

Required Tasks: 1. Using the information in the Worksheet (1) tab, Aging Analysis (2) tab, and Adjustments (3) tab, prepare the adjusting journal entries for the period. Record the entries in the Adjusting Journal Entries (4) tab. (Use letters a-j instead of a date for the date column and round all numbers to the nearest dollar.) SHOW YOUR WORK FOR THE ADJUSTMENT IN THE CELL OR YOU WILL NOT RECEIVE CREDIT FOR THE ENTRY. Use formulas and link the values to the adjustment. 2. After the above adjusting entries are entered on the Adjusting Journal Entries (4) tab, the amounts should be linked to the Adjustments column of the Worksheet (1). Your adjustment amounts should be a formula so if you change the debit/credit amount on the Adjusting Journal Entries (4), the column amount will automatically change. 3. Complete the Adjusting Trial Balance columns of the by the Worksheet (1) using formulas. Think about the best way to do this. Your last three sets of columns should never contain constant numbers but will include formulas only. 4. Prepare a multiple-step income statement on the Income Statement (5) tab. Your Income Statement should be in good form (proper titles, etc., see text page 230) and well formatted. The accounts of the financial statements should follow the order of accounts on the trial balance. You should use formulas in all cells, not constant numbers. (That means, your income statement should be linked to the adjusted numbers on your worksheet.) 5. Prepare a Statement of Retained Earnings (6) on the proper worksheet. Your Statement should be formatted. You should use formulas in all cells, not constant numbers. 6. Prepare a Classified Balance Sheet (7) on the proper worksheet as of 12/31/19. Your Statement should be formatted as shown on page 175. You should use formulas in all cells, not constant numbers. 7. On the Closing Entries (8) worksheet tab, prepare in journal entry form the appropriate closing entries and the end of 12/31/19. Link entries to the Worksheet (1) and/or financial statement tabs. Formatting as Table Styles X fx 489956 For the Year Faded December 31, 2019 Ladded Trial Balance DR CREDR 231.400 Income Statem CRDR ( DR DRT Allowance for Decal Accounts es Reche 11 Note Receivable 12 Merchandise Inventory 13 Prepaid Issance 14 Prepaid Rent 41 Equipment IF Accumulated Depreciation - Equip 18 Accounts Payable Salaries & Wigs Payable 20 Une neden LLLL TELEE BETELUL 23 Note Payable (final payment due 2023) 34 Common Stock 2 Retained Barsing Dwidends Nein ADJE G H Prepare the Aging Schedule to determine the adjustment required for the allowance method for bad debt: Balance December 31, 2019 Estimated % Uncollectible Estimated Amount Uncollectible Age of Accounts Current 2% 287,616 125,705 5 1-30 days past due 5% 6 31-90 days past due 7 Over 90 days past due 8 Total Accounts Receivable 65,345 11,290 489,956 12% 30% 11 Times New Roman 14 AA I . A EEE I Bule W Teat rge & Carte er % 9 w XOM Confort Although entries have been recorded all year, adjusting entries have not been recorded since December 31, 2018 when the financial statements were last prepared. Refer to the Worksheet (1) tab for adjusted account balance information as of December 31, 2019. 4 Use the following information to help in preparing adjusting entries for Rochester Enterprise . On November 1, 2019. Rochester Enterprise had signed a 8% bank loan (refer to the worksheet) due in 4 years. This is the only outstanding note payable. b. Prepaid insurance represents a 6-month insurance policy purchased on October 1, 2019. 10 . On September 1, 2019, Rochester Enterprise paid $25,000 for a 5-month lease for office space. 4. Uneamed revenue represents a 12-month contract for consulting services that will be performed monthly. The payment from the customer was received on December 1, 2019. A physical count revealed that supplies on hand at the end of the month total $23,230. 16 Equipment is depreciated on a straight line basis, residual value is estimated to be $25.000 with an estimated service life of 7 years. The assets were held the entire year. On December 1, Rochester Enterprise accepted from Greene Supplies a 7 month not receivable at a 5.5% annual interest rate. The company uses the percentage-of-receivables basis for estimating uncollectible accounts. The aging schedule of accounts receivable must be completed to determine management's desired balance for 2019 Accrued wages totaling 552,789 were unpaid and unrecorded at December 31, 2019. j: Utility costs incurred but unrecorded for the month of December were estimated to be 56,941 An Andy Ann Erstcode S weet General Journal Account Titles Debit Credit HO A EI322 Merge & Center v $*%93-% Formatting as N O P Q R Income Statement statement of REM Balance sheet Close Aging Analysis (2) Adjustments (1) income statement Adluating Journal Entriesil Formatting as Table Statement of Retained Earnings NOOIT Statement of R a ce Care TU S %9 L 9 2 Conditional Format Formatting as Table Coll Styles Balance Sheet NO PO RS Ready Balance Sheet E3 Merge Center $ %9 9 Conditional Format All Forming as Table Styles Hum Required Tasks: 1. Using the information in the Worksheet (1) tab, Aging Analysis (2) tab, and Adjustments (3) tab, prepare the adjusting journal entries for the period. Record the entries in the Adjusting Journal Entries (4) tab. (Use letters a-j instead of a date for the date column and round all numbers to the nearest dollar.) SHOW YOUR WORK FOR THE ADJUSTMENT IN THE CELL OR YOU WILL NOT RECEIVE CREDIT FOR THE ENTRY. Use formulas and link the values to the adjustment. 2. After the above adjusting entries are entered on the Adjusting Journal Entries (4) tab, the amounts should be linked to the Adjustments column of the Worksheet (1). Your adjustment amounts should be a formula so if you change the debit/credit amount on the Adjusting Journal Entries (4), the column amount will automatically change. 3. Complete the Adjusting Trial Balance columns of the by the Worksheet (1) using formulas. Think about the best way to do this. Your last three sets of columns should never contain constant numbers but will include formulas only. 4. Prepare a multiple-step income statement on the Income Statement (5) tab. Your Income Statement should be in good form (proper titles, etc., see text page 230) and well formatted. The accounts of the financial statements should follow the order of accounts on the trial balance. You should use formulas in all cells, not constant numbers. (That means, your income statement should be linked to the adjusted numbers on your worksheet.) 5. Prepare a Statement of Retained Earnings (6) on the proper worksheet. Your Statement should be formatted. You should use formulas in all cells, not constant numbers. 6. Prepare a Classified Balance Sheet (7) on the proper worksheet as of 12/31/19. Your Statement should be formatted as shown on page 175. You should use formulas in all cells, not constant numbers. 7. On the Closing Entries (8) worksheet tab, prepare in journal entry form the appropriate closing entries and the end of 12/31/19. Link entries to the Worksheet (1) and/or financial statement tabs. Formatting as Table Styles X fx 489956 For the Year Faded December 31, 2019 Ladded Trial Balance DR CREDR 231.400 Income Statem CRDR ( DR DRT Allowance for Decal Accounts es Reche 11 Note Receivable 12 Merchandise Inventory 13 Prepaid Issance 14 Prepaid Rent 41 Equipment IF Accumulated Depreciation - Equip 18 Accounts Payable Salaries & Wigs Payable 20 Une neden LLLL TELEE BETELUL 23 Note Payable (final payment due 2023) 34 Common Stock 2 Retained Barsing Dwidends Nein ADJE G H Prepare the Aging Schedule to determine the adjustment required for the allowance method for bad debt: Balance December 31, 2019 Estimated % Uncollectible Estimated Amount Uncollectible Age of Accounts Current 2% 287,616 125,705 5 1-30 days past due 5% 6 31-90 days past due 7 Over 90 days past due 8 Total Accounts Receivable 65,345 11,290 489,956 12% 30% 11 Times New Roman 14 AA I . A EEE I Bule W Teat rge & Carte er % 9 w XOM Confort Although entries have been recorded all year, adjusting entries have not been recorded since December 31, 2018 when the financial statements were last prepared. Refer to the Worksheet (1) tab for adjusted account balance information as of December 31, 2019. 4 Use the following information to help in preparing adjusting entries for Rochester Enterprise . On November 1, 2019. Rochester Enterprise had signed a 8% bank loan (refer to the worksheet) due in 4 years. This is the only outstanding note payable. b. Prepaid insurance represents a 6-month insurance policy purchased on October 1, 2019. 10 . On September 1, 2019, Rochester Enterprise paid $25,000 for a 5-month lease for office space. 4. Uneamed revenue represents a 12-month contract for consulting services that will be performed monthly. The payment from the customer was received on December 1, 2019. A physical count revealed that supplies on hand at the end of the month total $23,230. 16 Equipment is depreciated on a straight line basis, residual value is estimated to be $25.000 with an estimated service life of 7 years. The assets were held the entire year. On December 1, Rochester Enterprise accepted from Greene Supplies a 7 month not receivable at a 5.5% annual interest rate. The company uses the percentage-of-receivables basis for estimating uncollectible accounts. The aging schedule of accounts receivable must be completed to determine management's desired balance for 2019 Accrued wages totaling 552,789 were unpaid and unrecorded at December 31, 2019. j: Utility costs incurred but unrecorded for the month of December were estimated to be 56,941 An Andy Ann Erstcode S weet General Journal Account Titles Debit Credit HO A EI322 Merge & Center v $*%93-% Formatting as N O P Q R Income Statement statement of REM Balance sheet Close Aging Analysis (2) Adjustments (1) income statement Adluating Journal Entriesil Formatting as Table Statement of Retained Earnings NOOIT Statement of R a ce Care TU S %9 L 9 2 Conditional Format Formatting as Table Coll Styles Balance Sheet NO PO RS Ready Balance Sheet E3 Merge Center $ %9 9 Conditional Format All Forming as Table Styles Hum