Chesapeake Bay Kayak Rentals (CBKR) is located near the mouth of the Lynnhaven River on the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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, 2021, 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, 2021. 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, 2021. Chesapeake Bay Kayak Rentals Trial Balance December 31, 2021 Unadjusted Debit Credit Cash 43,640 Accounts Receivable 4,500 9,600 Prepaid Insurance Supplies Land Building Accumulated Depreciation - Building Computer Equipment Accumulated Depreciation - Computer Equipment Kayaks, paddleboards, and life vests (equipment) Accumulated Depreciation- Equipment Accounts Payable Wages Payable Interest Payable Note Payable Unearned Revenue Common stock, $ 5 par (4,000 shared issued and outstanding) Paid In Capital In Excess of Par Retained Earnings Rental Revenue Advertising Expense Depreciation Expense - Building Depreciation Expense - Equipment Depreciation Expense - Computer equipment Insurance Expense Interest Expense Supplies Expense Utilities Expense 600 330,000 2,800 17,300 6,850 318,144 1,500 20,000 12,000 124,435 6,832 8,532 Telephone and Internet Expense Wages Expense Income Summary 1,485 57,640 ТOTALS 482,929 482,929 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, 2021. Record appropriate insurance expense for the period ending December 31. b. Katie, the only employee, worked 16 hours on December 30 and 31 for which she has not been paid. She earns $15/hour. c. A physical count shows $165 of supplies on hand at December 31. d. CBKR purchased land/building on April 1, 2021, 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 $270,000 and the building at $90,000. Properly allocated the purchase price between the land and the building with an adjusting entry. e. Building purchased on April 1, 2021, 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 $1,482, and an interest rate of 3.5%. His first payment was made May 1, 2021. Matt tells you he posted the entire amount of each payment (8) against the note payable account. You will need to prepare an AJE to reclassify interest portion of payments to Interest expense. (Note: Prepare an amortization schedule using an excel template. Loan amount: $330,000, annual interest rate:3.5%, loan period in years: 30, number of payments per year: 12, start date of loan: 5/1/21, optional extra payments: $0; scheduled payment should equal $1,481.85. Matt rounded up and is paying $1,482/month.) Save amortization schedule as part of workbook (file). g. December interest on the note payable is due on January 1, 2022, with the January 1 payment. Accrue December interest expense h. Kayaks, paddle boards, and life vests (equipment) were purchased on April2, 2021, at a cost of $17,300. This equipment is expected to have a service life of five years and a salvage value of $2,300. The straight-line depreciation method is used. i. Computer equipment with a value of $2,800 was acquired April 1, 2021 and is expected to have a seven year life with no salvage value. Straight-line method of depreciation is used. b. File should include four worksheets: trial balance, adjusting entries, amortization schedule, and financial statements. c. Using the trial balance worksheet prepare the unadjusted trial balance and include columns for the adjusting entries and adjusted trial balance. АССТ 307 CB Kayak Rental Excel Assignment 2. Use the information provided to prepare adjusting journal entries in the Adjusting entries worksheet and then post these to the trial balance worksheet. a. Column totals should be calculated using SUM formula b. Calculate adjusted balances using IF formulas. Net income should equal $29,367. 3. Copy the amortization schedule you created above to the Amortization worksheet or move to your assignment file and rename tab. 4. Prepare the following statements: a. Single step income statement - use formula to calculate total expenses and net income b. Statement of retained earnings - use formula to create ending retained earning balance, use cell reference for net income c. Classified balance sheet – use formulas for all subtotals and totals. Note: determine current portion of note payable from amortization schedule and include in current liability section. Remember to subtract this from NP balance for non-current portion. 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, 2021, 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, 2021. 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, 2021. Chesapeake Bay Kayak Rentals Trial Balance December 31, 2021 Unadjusted Debit Credit Cash 43,640 Accounts Receivable 4,500 9,600 Prepaid Insurance Supplies Land Building Accumulated Depreciation - Building Computer Equipment Accumulated Depreciation - Computer Equipment Kayaks, paddleboards, and life vests (equipment) Accumulated Depreciation- Equipment Accounts Payable Wages Payable Interest Payable Note Payable Unearned Revenue Common stock, $ 5 par (4,000 shared issued and outstanding) Paid In Capital In Excess of Par Retained Earnings Rental Revenue Advertising Expense Depreciation Expense - Building Depreciation Expense - Equipment Depreciation Expense - Computer equipment Insurance Expense Interest Expense Supplies Expense Utilities Expense 600 330,000 2,800 17,300 6,850 318,144 1,500 20,000 12,000 124,435 6,832 8,532 Telephone and Internet Expense Wages Expense Income Summary 1,485 57,640 ТOTALS 482,929 482,929 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, 2021. Record appropriate insurance expense for the period ending December 31. b. Katie, the only employee, worked 16 hours on December 30 and 31 for which she has not been paid. She earns $15/hour. c. A physical count shows $165 of supplies on hand at December 31. d. CBKR purchased land/building on April 1, 2021, 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 $270,000 and the building at $90,000. Properly allocated the purchase price between the land and the building with an adjusting entry. e. Building purchased on April 1, 2021, 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 $1,482, and an interest rate of 3.5%. His first payment was made May 1, 2021. Matt tells you he posted the entire amount of each payment (8) against the note payable account. You will need to prepare an AJE to reclassify interest portion of payments to Interest expense. (Note: Prepare an amortization schedule using an excel template. Loan amount: $330,000, annual interest rate:3.5%, loan period in years: 30, number of payments per year: 12, start date of loan: 5/1/21, optional extra payments: $0; scheduled payment should equal $1,481.85. Matt rounded up and is paying $1,482/month.) Save amortization schedule as part of workbook (file). g. December interest on the note payable is due on January 1, 2022, with the January 1 payment. Accrue December interest expense h. Kayaks, paddle boards, and life vests (equipment) were purchased on April2, 2021, at a cost of $17,300. This equipment is expected to have a service life of five years and a salvage value of $2,300. The straight-line depreciation method is used. i. Computer equipment with a value of $2,800 was acquired April 1, 2021 and is expected to have a seven year life with no salvage value. Straight-line method of depreciation is used. b. File should include four worksheets: trial balance, adjusting entries, amortization schedule, and financial statements. c. Using the trial balance worksheet prepare the unadjusted trial balance and include columns for the adjusting entries and adjusted trial balance. АССТ 307 CB Kayak Rental Excel Assignment 2. Use the information provided to prepare adjusting journal entries in the Adjusting entries worksheet and then post these to the trial balance worksheet. a. Column totals should be calculated using SUM formula b. Calculate adjusted balances using IF formulas. Net income should equal $29,367. 3. Copy the amortization schedule you created above to the Amortization worksheet or move to your assignment file and rename tab. 4. Prepare the following statements: a. Single step income statement - use formula to calculate total expenses and net income b. Statement of retained earnings - use formula to create ending retained earning balance, use cell reference for net income c. Classified balance sheet – use formulas for all subtotals and totals. Note: determine current portion of note payable from amortization schedule and include in current liability section. Remember to subtract this from NP balance for non-current portion.
Expert Answer:
Answer rating: 100% (QA)
Answer Solution Adjusting Entries Date Account Title and Explanation Debit Credit De... View the full answer
Related Book For
Accounting Principles
ISBN: 978-0470534793
10th Edition
Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso
Posted Date:
Students also viewed these accounting questions
-
A wholesale business with a December 31 year end purchased new equipment on November 25, 20X0, for $10,000. Before 20X0, the business owned no other equipment. Required: 1. What are the tax...
-
Bisor Company has a December 31 year end and uses straight-line depreciation for all property, plant, and equipment. On July 1, 2010, the company purchased equipment for $500,000. The equipment had...
-
Tropical North Company, which has a December 31 year end and uses a periodic inventory system, completed the following transactions during 2016 and 2017: 2016 Oct. 14 Sold merchandise to OFTR Racing,...
-
Write inequalities to describe the set. The slab bounded by the planes z = 0 and z = 1
-
The table below shows the length of 10 recent broad-band service interruptions as reported by Broad Cast Cable Services, the largest service provider in the country, and JST Broadband, a smaller...
-
For your graduation present from college, your parents are offering you your choice of two alternatives. The first alternative is to give you a money gift of $19,000. The second alternative is to...
-
A neurosurgery resident wants to double her money in the time it takes her to complete a residency program (7 years) so she can buy a new car with cash upon graduation. What interest rate is needed...
-
This paper is written by B.B Zhou, X. Qu and R.P Brent working in Computer Sciences laboratory. The title of this journal is Effective scheduling in a Mixed Parallel and Sequential Computing...
-
You are expected to propose a campaign that will recommend specific content to appear on the candobristol.co.uk website in order to encourage website visitors to register, then explain how you will...
-
Tony and Suzie see the need for a rugged all-terrain vehicle to transport participants and supplies. They decide to purchase a used Suburban on July 1, 2022, for $12,000. They expect to use the...
-
How is net cash burn calculated? Explain with Example.
-
Alan and Catherine Murray filed a voluntary petition under Chapter 13 in September 2014. The Murrays had student loans totaling \($77,524\) in principal and more than \($200,000\) in accrued interest...
-
Blue Bell is one of the countrys largest ice cream manufacturers. In 2015, the company suffered a listeria outbreak, causing it to shut down, recall all of its products, and lay off a third of its...
-
Thomas and Jack Canna are brothers and attorneys who started their own law firm, Canna & Canna Ltd. (C&C), in 1990. Thomas and Jack each owned 50 percent of C&C and served in positions on the board....
-
Lake Point Phase I, LLC, and Lake Point Phase II, LLC (collectively, Lake Point), the District, and Martin County entered into a partnership for an environmental project. After contract disputes...
-
Miller filed for Chapter 7 bankruptcy protection on April 26, 2013. Based upon the filing date, the period for determining Millers current monthly income was October 1, 2012, through March 31, 2013....
-
Brady Inc. ordered a new trophy case on December 25, 2020. Payment for the case will be made upon delivery on January 10, 2021. How will this impact the financial statements of Brady Inc. for the...
-
Assume that a trial balance is prepared with an account balance of $21,360 listed as $21,630 and an account balance of $1,500 listed as $15,000. Identify the transposition and the slide.
-
In alphabetical order below are balance sheet items for George Company at December 31, 2012. Kayla George is the owner of George Company. Prepare a balance sheet, following the format of Illustration...
-
Castellitto Company sells automatic can openers under a 75-day warranty for defective merchandise. Based on past experience, Castellitto estimates that 3% of the units sold will become defective...
-
Break-even analysis is of limited use to management because a company cannot survive by just breaking even. Do you agree? Explain.
-
The preferred stock of the Luxemburg Mining Corporation pays a $3.25 dividend. What is the value of the stock if your required rate of return is 8 percent?
-
What is the value of Brunei Petroleum Companys preferred stock when the dividend rate is 18 percent on a $100 par value? The appropriate discount rate for a stock of this risk level is 14 percent.
-
What is the value of Queens Park PLCs preferred stock when the dividend rate is 10 percent on a $100 par value? The appropriate discount rate for a stock of this risk level is 16 percent.
Study smarter with the SolutionInn App