Chapter 5 Homework - Excel Search Bobby Simoni e Insert Formulas Data Review View Help Share Cabb Draw Page Layout -11 - AA E- OA- - General 2 Wrap Text Merge Center Insert Delete Format A7 O 4 BTU- $ -% Ideas Sensitiv Conditional Format as Cell Formatting Table Styles Styles Sort & Find a Filter Select Editing Font Alignment Number Cels Idees Sen. fo O P Q R S 8 D H M N You will also be required to use formulas for any totals and subtotals in your trial balance. The lack of formulas will result in a lower grade. The Rohrback Company has the following trial balance at the end of Year Four, before adjusting entries are preapred. During the year, all cash transactions were recorded, but no other journal entries were made. The Rohrbach Company Trial Balance December 31, Year Four Other Information: 1 Utilities were not paid for or recorded for the months of November and December at a total of $2,000. Debit Credit 33,400 2 On July 1, Year Four, insurance for the next eighteen months was obtained for $5,400 in cash. 79,000 90,000 3 On May 1 Year Four, the company paid $8,000 to rent the building for the next 12 months. 4 Employees are paid $8,000 for each month with payments seven days after the end of the month. Accounts Payable Accounts Receivable Capital stock Cash Cost of Goods Sold Dividends Paid Insurance Expense Interest Expense Interest Payable Inventory Land Notes Payable Dennis Problem Worksheet 41,000 180,000 20,000 3,800 5 The company collected $20,000 from a customer during the early part of November. The amount was recorded and was to be earned by Rohrbach over the following 5 months. 6 Interest on the note payable has accrued for the full year at 5% interest 98,000 320,000 130,000 7 On December 31st, Rohrbach Company counted the supplies and found that $800 remain on the shelves. O ? Type here to search 12:12 AM 9/24/2012 E Chapter 5 Homework - Excel Bobby Simmons o Insert Draw Page Layout Formulas Data Review View Help Commer Caliber General S - % Insert - Dekte AM 27 11-AA 25 Wrap Test OA-EEE Merge a Center - Alignment ru - Su Find Ideas Sensitivity Conditional Formats Cell Formatting - Table Styles Styles Font Number Cells tuting dat G H L M N o P R 20,000 3,800 5 The company collected $20,000 from a customer during the early part of November. The amount was recorded and was to be earned by Rohrbach over the following 5 months. 98,000 320,000 6 Interest on the note payable has accrued for the full year at 5% interest. 130,000 7 On December 31st, Rohrbach Company counted the supplies and found that $800 remain on the shelves. C Dividends Paid Insurance Expense Interest Expense Interest Payable Inventory Land Notes Payable Prepaid Insurance Prepaid Rent Rent Expense Retained Earnings, Jan. 1 Salary Expense Salary Payable Sales Revenue Supplies Supplies Expense Unearned Revenue Utilities Expense Utilities Payable Loss on sale of Truck 5,400 8.000 6,000 8 The company did work for a customer throughout December and finished on December 30. Because it was so late in the year, no journal entry was recorded, and no part of the $15,000 payment has been received 228,000 96,000 Required: 8.000 400,000 a. Prepare the needed adjusting entries. 2,200 b. Prepare an updated trial balance. 20,000 12.000 2,000 891.400 891.400 Problem Worksheet o 12:12 AM 9/24/2020 E Type here to search