Question

In: Accounting

I'm working on the worksheet aspect of this practice set and my adjustments are not lining...

I'm working on the worksheet aspect of this practice set and my adjustments are not lining up with the adjusted trial balance. Could someone please help me with the adjusting entries? I'll post them and the original entries for reference, thank you.

ORIGINAL ENTRIES:

DECEMBER TRANSACTION DATA

Dec 1        Homer’s pays $1,200 for a one year insurance policy. The term of the policy is from 12/1/19 through 11/30/20.

Dec 1        Homer’s purchases Equipment (a forklift) for $10,000, paying $5,000 in cash and signing a 5 year, $5,000, Long Term Note Payable for the remaining amount. Don’t record any interest yet!

Dec 1        Homer’s purchases additional Equipment for $2,000, paying cash. Don’t combine this purchase with the previous purchase. Make a separate entry

Dec 4        Homer’s purchases inventory for $27,000 from AMPAS. As you recall from November, HH established a $10,000 credit limit with AMPAS, so HH puts $10,000 on account and pays cash for the remaining amount.

Dec 5        Homer’s pays this month’s $200 rent.

Dec 15      Homer’s pays $300 in advance for three months of advertising. The ads will run from 12/15/19 thru 3/15/20.

Dec 15      Homer’s pays off (with Cash) the $537.18 account payable amount owed to the attorneys from November.

Dec 15      After losing the Best Actress Oscar to Olivia Colman, Glenn Close decides to try to avoid the spotlight for awhile and return to her first love of painting. She rents some of HH’s property to use as an outdoor studio. Homer’s receives $600 Cash in advance from Close for 4 month’s rent. The rental agreement starts on 12/15/19. Hint: Use a liability account for the credit.

Dec 16      Homer’s sells Green Book Company three acres of Land. HH receives $5,000 Cash and a $10,000 Note Receivable in exchange for the 3 acres.

STEP 1: DIVIDE the TOTAL AMOUNT Homer’s originally recorded as their COST ($70,000) on November 15th by the TOTAL number of ACRES HH purchased (20 acres). This represents Homer’s “COST per ACRE.”

STEP 2: MULTIPLY HH’s “Cost per Acre” from Step 1 times the # of acres they sold (3 acres).This amount represents HH’s COST of the 3 acres sold.

STEP 3: COMPARE HH’s COST of the 3 ACRES sold to the TOTAL dollar AMOUNT HH RECEIVES from the sale (the Cash amount PLUS the amount of the Note Receivable). The difference will represent either a GAIN or LOSS.

You will need to allow four lines to journalize this transaction. There will be two Debit accounts (representing what Homer’s receives) and two Credit accounts (based on the cost of what HH gives up). Review the Chart of Accounts. Hint: This is not to be recorded like a “sale of merchandise on account.” Land is NOT considered part of HH’s “Inventory!”

Dec 17      Homer’s purchases $250 worth of office supplies, paying cash. Hint: The office supplies should provide a benefit to HH for several months.

Dec 18      Homer’s set a fire to burn some trash that had accumulated near the back of the store. The fire gets out of control and destroys $1,800 worth of inventory. Unfortunately, the insurance company does not honor HH’s claim. Homer’s must record the decrease in inventory and the other appropriate account. Hint: Inventory is gone but since it was not “sold” we can’t use the COGS account. Look at the Chart of Accounts to find an appropriate account title that seems to match these circumstances.

Dec 28      Homer’s pays cash of $5,248 in Salary and Wages Expense for salaries earned by employees up to and including 12/28.

Dec 31      During the month of December, Homer’s sells a combined total of $45,600 of inventory on account. Homer’s cost of the inventory was $25,650. Record this just like you did for the individual sales HH made on account in November.

Dec 31      The HH Board of Directors declares a dividend of $.05 / share. A total of 40,000 shares of Common Stock were issued from November 1 through December 31st and are eligible to participate in the dividend. Remember, this is just the declaration of the dividend. The payment will not be made until January. Be sure to use the appropriate dividend accounts to record this transaction. Review the Chart of Accounts.

Dec 31            Homer’s collected $36,700 in cash from its customers on account.

&& THE ADJUSTING ENTRIES

December adjustment data:

(a)        MAKE THE SALARY ACCRUAL ADJUSTMENT. December 28th was the last payday for the month of December. On that date, employees were paid for work through the 28th. The two staff employees and the manager all worked Dec. 29, 30 and 31. The two staff employees are paid $12.00 per hour each and the manager receives $17.00 per hour. All employees work an eight-hour day.

(b)        MAKE THE ADJUSTMENT FOR OFFICE SUPPLIES. A count of the office supplies shows that $180 worth of office supplies remain on hand.  

(c)        MAKE THE PREPAID INSURANCE ADJUSTMENT for the amount of insurance that has expired as of 12/31.

(d)        MAKE THE DEPRECIATION ADJUSTMENT FOR BOTH THE FORKLIFT AND THE OTHER EQUIPMENT ACQUIRED ON 12/1. Use the straight-line method. The $10,000 forklift (equipment) has an estimated useful life of 10 years and no salvage value. The other ($2,000) equipment has a 5 year estimated useful life and no salvage value. These are two different types of Equipment, so calculate the amount of depreciation for each asset separately, then COMBINE the two separate amounts into ONE total and make ONE adjusting entry for the combined amount. HINT: Since HH has only had these assets for one month, you will need to pro-rate the annual amount of depreciation for just the month of December - 1/12 of a year. Do NOT ROUND the amount to the nearest $.

(e)        MAKE THE PREPAID ADVERTISING ADJUSTMENT. As always, pay careful attention to the date of the original transaction. HINT: You don’t have to count out the exact number of days -- you may just use ½ of the monthly amount.

(f)         MAKE THE ADJUSTMENT FOR THE UNEARNED RENTAL REVENUE that has now been earned from Glenn Close. As always, pay careful attention to the date of the original transaction. HINT: You don’t have to count out the exact number of days -- you may just use ½ of the monthly amount.

(g)        MAKE THE ADJUSTMENT FOR THE INTEREST ACCRUED ON THE $10,000, 10% APR NOTE RECEIVABLE that HH received on 12/16 from the sale of land. REMEMBER: HH is using a 360 day year for all interest calculations, so use 15/360 OR ½ of 1/12 as the “T” in the (P x I x T) formula.

(h)        MAKE THE ADJUSTMENT FOR THE INTEREST ACCRUED in DECEMBER on both (A) the $55,000, 10% APR LONG-TERM NOTE PAYABLE from NOVEMBER and (B) the $5,000, 12% APR L-T NOTE PAYABLE from the 12/1 FORKLIFT PURCHASE. Calculate interest on each note separately using 30/360 (or 1/12) as the time factor. Then, add the amounts together and enter that amount as one adjusting entry.

Solutions

Expert Solution


Related Solutions

Hi guys, I'm working on an assignment for my Java II class and the narrative for...
Hi guys, I'm working on an assignment for my Java II class and the narrative for this week's program has me a bit lost. I've put the narrative of the assignment in the quotation marks below. " Included with this assignment is an encrypted text file. A simple Caesar cipher was used to encrypt the data. You are to create a program which will look at the frequency analysis of the letters (upper and lowercase) to help “crack” the code...
Complete a worksheet from a trial balance and adjustment data. Enter the adjustments in the adjustments...
Complete a worksheet from a trial balance and adjustment data. Enter the adjustments in the adjustments columns of the worksheet. Key adjusting entries by letter. Total the debit and credit columns. Then calculate the adjusted​balances, enter them in the adjusted trial balance columns on the​ worksheet, and​ again, total the debit and credit columns. J. Trent Worksheet Month Ended July 31, 201X Trial Balance Adjustments Account Titles Debit Credit Debit Credit Cash 32 Accounts Receivable 7 Prepaid Insurance 4 Store...
only two adjustments appear in the adjustments column of a worksheet for Winona Mfg: one to...
only two adjustments appear in the adjustments column of a worksheet for Winona Mfg: one to record 8,000 depreciation of factory equipment, and the other to record the use of 1,500 of prepaid insurance. If the trial balance column totals are 145,380, what are the totals od the adjusted trial balance columns?
Why is it necessary to make consolidation adjustments for intragroup transactions? In making consolidation worksheet adjustments,...
Why is it necessary to make consolidation adjustments for intragroup transactions? In making consolidation worksheet adjustments, sometimes tax-effect entries are made, why? Give an example about the tax-effect of intragroup transactions in catering services for airline industries.
Inventory Costing Worksheet Practice                                     &
Inventory Costing Worksheet Practice                                                    Units             Cost per unit Beginning inventory                 30                      $10   Puirchase    3/31                       20                      $11 Purchase    4/30                        20                      $12 Purchase    5/31                        30                      $13      There is a total of 100 units.   65 units were sold, therefore 35 units were in ending inventory. Calculate the following under the periodic method for costing inventory Compute cost of goods sold under FIFO. Compute ending inventory under FIFO. Compute cost of goods sold under LIFO. Compute ending inventory under LIFO. Compute cost of...
transcription and translation practice worksheet
transcription and translation practice worksheet
Happy Saturday. I'm working on my accounting homework ch. 11 and would liek to know if...
Happy Saturday. I'm working on my accounting homework ch. 11 and would liek to know if nayone coould possibly help out with this question... Novak Company acquired a plant asset at the beginning of Year 1. The asset has an estimated service life of 5 years. An employee has prepared depreciation schedules for this asset using three different methods to compare the results of using one method with the results of using other methods. You are to assume that the...
Hi, I am struggling to understand this worksheet my professor gave us for practice. Could someone...
Hi, I am struggling to understand this worksheet my professor gave us for practice. Could someone make any sense of this? The scenario: Sodium is found largely in the extracellular compartment with concentrations between 130-145 mM with intracellular sodium concentrations between 3.5-5mM. This chemical difference gives sodium a large concentration gradient, which when permitted (by opening of a channel or through facilitated transport) will move down its concentration gradient to enter the cell. Sodium also has a favorable electrical gradient;...
Hey everyone I'm working through my homework which involves creating a ER diagram based of certain...
Hey everyone I'm working through my homework which involves creating a ER diagram based of certain business rules and I am stuck on this part: Updated info • Customers have a name, phone number, a credit card no, and a unique customer number. • Customers can attend many performances, and each performance can have many customers attending. • Each performance of a show is on at a specific date and time, at a venue. • Each performance has many actors...
It is now 30 June and our business is preparing adjustments via a worksheet. Complete the...
It is now 30 June and our business is preparing adjustments via a worksheet. Complete the following adjustments in the worksheet using the number next to each adjustment as the ref (if no adjustment is necessary enter "0" in the relevant box). All answers are numbers which consist only of the digits 0 to 9. Symbols or punctuation marks should NOT be incorporated in answers. Then determine whether owners equity will increase or decrease. 1 Prepaid 12,000 for annual insurance...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT