Chesapeake Bay Kayak Rentals (CBKR) is located near the mouth of the Lynnhaven River on the Chesapeake Bay in Virginia Beach, VA, and rents kayaks and paddle boards to be used on the bay and the Lynnhaven River in addition to providing tours. Matt Redfern decided to start the business because of his love for the water and outdoors. Matt decided to incorporate the business to limit his legal liability. The business began operations April 1, 2022, and has a December 31 year end.
Matt has asked you to prepare Chesapeake Bay Kayak Rentals’ financial statements for the nine months ended December 31, 2022. He has been doing his own accounting but isn’t sure if he’s done everything correctly since he only took principles of financial accounting in college. He has provided you with an
unadjusted trial balance at December 31, 2022.
| Chesapeake Bay Kayak Rentals | ||
| Trial Balance | ||
| December 31, 2022 | ||
| Unadjusted | ||
| Debit | Credit | |
| Cash | 30,625 | |
| Accounts Receivable | 8,360 | |
| Allowance for uncollectible accounts | 945 | |
| Prepaid Insurance | 9,600 | |
| Supplies | 1,935 | |
| Land | ||
| Building | 330,000 | |
| Accumulated Depreciation – Building | ||
| Computer Equipment | 3,745 | |
| Accumulated Depreciation – Computer Equipment | ||
| Kayaks, paddleboards, and life vests (equipment) | 17,300 | |
| Accumulated Depreciation – Equipment | ||
| Accounts Payable | 6,850 | |
| Wages Payable | ||
| Interest Payable | ||
| Note Payable | 313,312 | |
| Unearned Revenue | ||
| Common stock, $ 5 par (4,000 shared issued and outstanding) | 20,000 | |
| Paid In Capital In Excess of Par | 12,000 | |
| Retained Earnings | ||
| Rental Revenue | 141,615 | |
| Advertising Expense | 6,400 | |
| Bad Debt Expense | ||
| Depreciation Expense – Building | ||
| Depreciation Expense – Equipment | ||
| Depreciation Expense – Computer equipment | ||
| Insurance Expense | ||
| Interest Expense | ||
| Supplies Expense | ||
| Utilities Expense | 8,432 | |
| Telephone and Internet Expense | 2,790 | |
| Wages Expense | 73,645 | |
| Income Summary | ||
| TOTALS | 493,777 | 493,777 |
In addition to the trial balance, he has provided you with the following information (Round all items to nearest whole dollar.):
a. Annual liability insurance premium of $9,600 was paid April 2, 2022. Record appropriate insurance expense for the period ending December 31.
b. Katie and Matt each worked 16 hours (December 30 and 31) for which they have not been paid. Katie earns $15/hour and Matt earns $25/hour.
c. A physical count shows $286 of supplies on hand at December 31.
d. CBKR purchased land/building on April 1, 2022, for $330,000. He has not separated the value of the land from the building. The appraisal performed at the time of purchased assessed the land at $266,000 and the building at $114,000. Properly allocated the purchase price between the land and the building with an adjusting entry.
e. Building purchased on April 1, 2022, is expected to have a useful life of 40 years with no salvage value. Matt has chosen to use the straight-line method of depreciation based on number of months in service. Round expense to nearest whole dollar.
f. CBKR financed 100% of the cost of the land/building with a 30 year note payable with monthly payments of $2,086, and an interest rate of 6.50%. His first payment was made May 1, 2022. Matt tells you he posted the entire amount of each payment (8) against the note payable account. You will need an AJE to reclassify interest portion of payments to Interest expense. (Note: need an amortization schedule using an excel template. Loan amount: $330,000, annual interest rate: 6. 5%, loan period in years: 30,
number of payments per year: 12, start date of loan: 5/1/22, optional extra payments: $0; scheduled payment should equal $2,085.82. Matt rounded up and is paying $2,086/month.) Save amortization schedule as part of workbook (file).
g. December interest on the note payable is due on January 1, 2023, with the January 1 payment. Accrue December interest expense
h. Kayaks, paddle boards, and life vests (equipment) were purchased on April 2, 2022, at a cost of $17,300. This equipment is expected to have a service life of five years and no salvage value. The straight-line depreciation method is used.
i. Computer equipment with a value of $3,745 was acquired April 1, 2022, and is expected to have a seven year life with a $385 salvage value. Straight-line method of depreciation is used.
j. Matt is estimates that 5% of account receivable balance at December 31 is uncollectible. Matt wrote off a $945 account in November.
k. CBKR received a check of $1,800 in December 2022 for a kayak tour scheduled for April 2023. Receipt was recorded as rental revenue
Need help with H through K
To calculate the depreciation expense for the kayaks, paddleboards, and life vests (equipment), we will use the straight-line depreciation method. The cost of the equipment is $17,300, and it is expected to have a service life of five years with no salvage value.
First, we need to determine the annual depreciation expense: \text{Annual Depreciation Expense} = \frac{\text{Cost of Equipment}}{\text{Useful Life}} = \frac{17,300}{5} = $3,460 \text{ per year}
Since the business started on April 1, 2022, we need to calculate the depreciation expense for nine months (April to December).
\text{Depreciation Expense for Equipment} = \text{Annual Depreciation Expense} \times \left(\frac{9}{12}\right) = $3,460 \times 0.75 = $2,595
So, the depreciation expense for equipment for the nine months ending December 31, 2022, is $2,595.
I. Depreciation Expense for Computer Equipment
The computer equipment has a value of $3,745 and is expected to have a seven-year life with a salvage value of $385. We will also use the straight-line depreciation method to calculate the depreciation expense.
First, we determine the annual depreciation expense: \text{Annual Depreciation Expense} = \frac{\text{Cost of Equipment} – \text{Salvage Value}}{\text{Useful Life}} = \frac{3,745 – 385}{7} = $520 \text{ per year}
Since the business started on April 1, 2022, we need to calculate the depreciation expense for nine months.
\text{Depreciation Expense for Computer Equipment} = \text{Annual Depreciation Expense} \times \left(\frac{9}{12}\right) = $520 \times 0.75 = $390
The depreciation expense for computer equipment for the nine months ending December 31, 2022, is $390.
J. Uncollectible Accounts and Bad Debt Expense
Matt estimates that 5% of the accounts receivable balance at December 31 is uncollectible. Additionally, Matt wrote off a $945 account in November. To account for these uncollectible accounts and calculate bad debt expense:
This $1,363 represents the total uncollectible accounts. To calculate bad debt expense, we recognize this expense in the income statement.
\text{Bad Debt Expense} = $1,363
K. Unearned Revenue Adjustment
CBKR received a check of $1,800 in December 2022 for a kayak tour scheduled for April 2023. Since the service has not been provided by December 31, 2022, this payment should not be recognized as revenue in the current year. Instead, it should be recorded as unearned revenue, representing a liability until the service is provided.
So, we need to make the following journal entry to adjust for unearned revenue: \text{Unearned Revenue} (Liability) \: $1,800 \text{Rental Revenue} (Reduce Revenue) \: $1,800
This entry ensures that the revenue is recognized when the service is provided in the following year, aligning with the accrual accounting principle.
In summary, these adjustments help ensure that Chesapeake Bay Kayak Rentals’ financial statements accurately reflect its financial position and performance for the nine months ending December 31, 2022, in accordance with generally accepted accounting principles (GAAP). It covers depreciation expenses for equipment and computer equipment, the recognition of bad debt expense, and the appropriate treatment of unearned revenue. These adjustments are crucial for providing a true and fair view of the business’s financial health.
As a renowned provider of the best writing services, we have selected unique features which we offer to our customers as their guarantees that will make your user experience stress-free.
Unlike other companies, our money-back guarantee ensures the safety of our customers' money. For whatever reason, the customer may request a refund; our support team assesses the ground on which the refund is requested and processes it instantly. However, our customers are lucky as they have the least chances to experience this as we are always prepared to serve you with the best.
Plagiarism is the worst academic offense that is highly punishable by all educational institutions. It's for this reason that Peachy Tutors does not condone any plagiarism. We use advanced plagiarism detection software that ensures there are no chances of similarity on your papers.
Sometimes your professor may be a little bit stubborn and needs some changes made on your paper, or you might need some customization done. All at your service, we will work on your revision till you are satisfied with the quality of work. All for Free!
We take our client's confidentiality as our highest priority; thus, we never share our client's information with third parties. Our company uses the standard encryption technology to store data and only uses trusted payment gateways.
Anytime you order your paper with us, be assured of the paper quality. Our tutors are highly skilled in researching and writing quality content that is relevant to the paper instructions and presented professionally. This makes us the best in the industry as our tutors can handle any type of paper despite its complexity.
Recent Comments