Scan House, a large campground in southern Florida, adjusts its accounts monthly. Most guests of the campground pay at the time they check out, and the amounts collected are credited to Camper Revenue. The following information is available as a source for preparing the adjusting entries at December 31: 1. Scan House invests some of its excess cash in certificates of deposit (CDs) with its local bank. Accrued interest revenue on its CDs at December 31 is $1,400. None of the interest has yet been received. 2. A six-month bank loan in the amount of $120,000 had been obtained on September 1. Interest is to be computed at an annual rate of 8 percent and is payable when the loan becomes due. 3. Depreciation on buildings owned by the campground is based on a 20-year life. The original cost of the buildings was $800,000. The Accumulated Depreciation: Buildings account has a credit balance of $300,000 at December 31, prior to the adjusting entry process. The straight-line method of depreciation is used. 4. Management signed an agreement to let 4H Troop 840 of Traverse City, Michigan, use the campground in June of next year. The agreement specifies that the 4H Troop will pay a daily rate of $50 per campsite, with a clause providing a minimum total charge of $3,500. 5. Salaries earned by campground employees that have not yet been paid amount to $2,800. 6. As of December 31, Scan House has earned $4,000 of revenue from current campers who will not be billed until they check out. 7. Several lakefront campsites are currently being leased on a long-term basis by a group of senior citizens. Nine months' rent of $54,000 was collected in advance and credited to Unearned Camper Revenue on October 1 of the current year. 8. A bus to carry campers to and from town and the airport had been rented the first week of December at a daily rate of $300. At December 31, no rental payment has been made, although the campground has had use of the bus for 25 days. 9. Unrecorded Income Taxes Expense accrued in December amounts to $15,000. This amount will not be paid until January 15. Required: (prepare using an excel spreadsheet, include proper heading with your name, course name and number, and problem number – Chapter 2 Excel HW (1 of 2) a. For each of the above numbered paragraphs, prepare the necessary adjusting entry (including an explanation). If no adjusting entry is required, explain why. b. Indicate the effects that each of the adjustments in part a will have on the following six total amounts in the campground's financial statements for the month of December. Organize your answer in tabular form, using the column headings shown below. Use the letters I for increase, D for decrease, and NE for no effect. Adjusting entry 1 is provided as an example. c. What is the amount of interest expense recognized for the entire current year on the $120,000 bank loan obtained September 1? d. Compute the book value of the campground's buildings to be reported in the current year's December 31 balance sheet. (Refer to paragraph 3.)
Scan House, a large campground in southern Florida, adjusts its accounts monthly. Most guests of the campground pay at the time they check out, and the amounts collected are credited to Camper Revenue. The following information is available as a source for preparing the
1. Scan House invests some of its excess cash in certificates of deposit (CDs) with its local
bank. Accrued interest revenue on its CDs at December 31 is $1,400. None of the
interest has yet been received.
2. A six-month bank loan in the amount of $120,000 had been obtained on September 1.
Interest is to be computed at an annual rate of 8 percent and is payable when the loan
becomes due.
3.
original cost of the buildings was $800,000. The
account has a credit balance of $300,000 at December 31, prior to the adjusting entry
process. The straight-line method of depreciation is used.
4. Management signed an agreement to let 4H Troop 840 of Traverse City, Michigan, use
the campground in June of next year. The agreement specifies that the 4H Troop will
pay a daily rate of $50 per campsite, with a clause providing a minimum total charge of
$3,500.
5. Salaries earned by campground employees that have not yet been paid amount to
$2,800.
6. As of December 31, Scan House has earned $4,000 of revenue from current campers
who will not be billed until they check out.
7. Several lakefront campsites are currently being leased on a long-term basis by a group
of senior citizens. Nine months' rent of $54,000 was collected in advance and credited
to Unearned Camper Revenue on October 1 of the current year.
8. A bus to carry campers to and from town and the airport had been rented the first week
of December at a daily rate of $300. At December 31, no rental payment has been
made, although the campground has had use of the bus for 25 days.
9. Unrecorded Income Taxes Expense accrued in December amounts to $15,000. This
amount will not be paid until January 15.
Required: (prepare using an excel spreadsheet, include proper heading with your name,
course name and number, and problem number – Chapter 2 Excel HW (1 of 2)
a. For each of the above numbered paragraphs, prepare the necessary adjusting entry
(including an explanation). If no adjusting entry is required, explain why.
b. Indicate the effects that each of the adjustments in part a will have on the following six
total amounts in the campground's financial statements for the month of December.
Organize your answer in tabular form, using the column headings shown below. Use the
letters I for increase, D for decrease, and NE for no effect. Adjusting entry 1 is provided
as an example.
c. What is the amount of interest expense recognized for the entire current year on the
$120,000 bank loan obtained September 1?
d. Compute the book value of the campground's buildings to be reported in the current
year's December 31
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 2 images
