Need help with Accural Adjustments - and I have two Excel Files: One performing Debits and Credits (Already completed) and the other with a Balance Sheet and Income Statement which I need the most help on. Problem 1: Adjusting the Books Using Adjusting Entries

Huntington Company's annual accounting year ends on December 31. It is December 31, 2012, and all of the 2012 entries except the following adjusting entries have been made:

1. On September 1, 2012, Huntington collected six months of rent worth $9,000 on storage space. At that date, Zimmerman debited Cash and credited Unearned rent Revenue for $9,000.
2. On October 1, 2012, the company borrowed $30,000 from a local bank and signed a 12 percent note for that amount. The principal and interest are payable on the maturity date, September 30, 2012.
3. Depreciation of $5,000 must be recognized on a service truck purchased on July 1, 2012, at a cost of $30,000.
4. Cash of $4,800 was collected on November 1, 2012, for services to be rendered evenly over the next year beginning on November 1. Unearned Service Revenue was credited when the cash was received.
5. On November 1, 2012, Huntington paid a one-year premium for fire insurance of a total of $12,000 for one year of coverage starting on that date. Cash was credited and Prepaid Insurance was debited for this amount.
6. The company earned service revenue of $6,000 on a special job that was completed December 24, 2012. Collection will be made during January 2012. No entry has been recorded.
7. At December 31, 2012, wages earned by employees totaled $17,500. The employees will be paid on the next payroll date, January 15, 2012.
8. On December 31, 2012, the company estimated it owed $16,000 for 2012 property taxes on land. The tax will be paid when the bill is received in January 2012.

Using the information above, prepare the adjusting entry required for each transaction at December 31, 2012. To complete this problem, you may wish to use the Assessment 3, Problem 1 Template, which is linked in the Resources under the Capella Resources heading.

Problem 2: Analyzing the Effects of Adjusting Entries on the Accounting Model

For this problem, fill in the Assessment 3, Problem 2 Template linked in the Resources (under the Capella Resources heading) and submit the Excel document for grading. You will also need to refer to Problem 1. Using + for increase, ? for decrease, and NE for no effect, indicate in the table provided the effect of each adjusting entry in Problem 1 (a through h) and the amount of the effect. Reminder: Assets = Liabilities + Stockholders' Equity; Revenues ? Expenses = Net Income; and Net Income accounts are closed to Retained Earnings, a part of Shareholders' Equity.

Learner: Rhonda Manns Huntington Company Adjusting Entries 31-Dec-11 a. b. c. d. e. f. g. h. Unearned rent revenue Rent revenue (4 months Of 6 months Of $9,000) $ Interest Expense Interest payable ($30,000 X .12 X 3/12) $ Depreciation expense Accumulated Depreciation - Truck (amount of $5,000 is given) $ Unearned service revenue Service revenue ($4,800/12 times 2 months) $ Insurance expense Prepaid Insurance ($12,000/12 times 2 months) $ Accrued Service Revenue Service revenues (Amount of $6,000 is given) $ Wages expense Accrued Wages Payable (Amount of $17,500 is given) $ Property tax expense Accrued Taxes Payable (amount of $16,000 is given) $ DR 9,000.00 CR $ 9,000.00 $ 900.00 $ 5,000.00 $ 800.00 $ 2,000.00 $ 6,000.00 $ 17,500.00 $ 16,000.00 900.00 30,000.00 4,800.00 12,000.00 6,000.00 17,500.00 16,000.00