Quest Cruise is a travel agency that offers international and local travel packages. The company is...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Quest Cruise is a travel agency that offers international and local travel packages. The company is owned and operated by Gray Pelletier. The closing balances at the end of October 2023 and the chart of accounts are shown below. Assets Cash Accounts Receivable Prepaid Insurance Equipment Accumulated Depreciation Total Assets Quest Cruise Balance Sheet As at October 31, 2023 Liabilities $29,920 Accounts Payable $11,800 Unearned Revenue $11,500 $9,000 $0 Bank Loan $27,000 $41,000 Note Payable $0 -$12,500 Total Liabilities $47,500 Pelletier, Capital $22,720 $70,220 Total Liabilities & Owners' Equity $70,220 Account Description Account # Account Description Account # ASSETS REVENUE Cash 101 Service Revenue 400 Accounts Receivable 105 EXPENSES Prepaid Insurance 110 Advertising Expense 500 Equipment 120 Depreciation Expense 510 Accumulated Depreciation 125 Insurance Expense 515 LIABILITIES Interest Expense 520 Accounts Payable 200 Salaries Expense 545 Interest Payable 205 Telephone Expense 550 Salary Payable 210 Travel Expense 555 Unearned Revenue 215 Rent Expense 560 Bank Loan 220 Note Payable 225 OWNER'S EQUITY Pelletier, Capital 300 Pelletier, Withdrawals 310 Income Summary 315 Activate Window For the month of November 2023, Quest Cruise had the following transactions: Nov 1 Nov 1 Nov 1 Nov 2 Nov 2 Nov 5 Nov 15 Nov 18 Nov 20 Nov 23 Nov 26 Nov 28 Gray invested $14,600 cash and equipment valued at $15,000 into the business. Prepaid $15,000 for insurance for one year. Paid $5,200 cash for November's rent. Provided travel services to group of travellers; they paid $32,500 now and will pay $6,500 later. Purchase equipment by signing a Note Payable for $21,000, due in 3 years plus accrued interest at 12%. Recorded travel expenses for $12,450 to be paid next month. Paid $9,200 cash to reduce the balance of accounts payable. Received $5,900 cash from customers for the travel services provided last month. Received a telephone bill for $995 which will be paid next month. Paid $9,110 cash for employee's salaries. Received $31,450 cash in advance from travellers for travel services to be provided next month. Paid $7,540 advertising expense for the promotion of the travel and tours in the month of November. Nov 28 month of November. Nov 29 The owner withdrew $8,000 cash for personal use. Nov 30 Paid $578 cash for the bank loan which included $375 principle and $203 interest. The loan is due in 6 years with monthly repayments of $375 principle plus interest at 9% on outstanding balance. At the end of November, the following adjustment had to be journalized to properly report the balances of the company's accounts: Nov 30 Nov 30 Nov 30 Nov 30 Nov 30 $34,150 of the balance of unearned revenue, still remains unearned. One month of prepaid insurance worth $1,250 has been used. Monthly depreciation on the equipment was $1,440. Accrued salary expense of $4,555 for an employee. Accrued interest on the Note Payable amounts to $210. Required: a) Enter the opening balances from the October 2023 balance sheet into the general ledger accounts. b) Prepare the journal entries for the month of November and post them to the appropriate general ledger accounts. c) Create the trial balance in the worksheet, and then complete the remaining section of the worksheet taking into account the information for adjustments shown above. d) Create the income statement, statement of owner's equity and the classified balance sheet. e) Prepare the journal entries for the adjustments and post them to the appropriate general ledger accounts. f) Prepare the journal entries to close the books for the month of November 2023 (use the income summary account), and post the journal entries to the appropriate general ledger accounts. g) Create the post-closing trial balance. Quest Cruise is a travel agency that offers international and local travel packages. The company is owned and operated by Gray Pelletier. The closing balances at the end of October 2023 and the chart of accounts are shown below. Assets Cash Accounts Receivable Prepaid Insurance Equipment Accumulated Depreciation Total Assets Quest Cruise Balance Sheet As at October 31, 2023 Liabilities $29,920 Accounts Payable $11,800 Unearned Revenue $11,500 $9,000 $0 Bank Loan $27,000 $41,000 Note Payable $0 -$12,500 Total Liabilities $47,500 Pelletier, Capital $22,720 $70,220 Total Liabilities & Owners' Equity $70,220 Account Description Account # Account Description Account # ASSETS REVENUE Cash 101 Service Revenue 400 Accounts Receivable 105 EXPENSES Prepaid Insurance 110 Advertising Expense 500 Equipment 120 Depreciation Expense 510 Accumulated Depreciation 125 Insurance Expense 515 LIABILITIES Interest Expense 520 Accounts Payable 200 Salaries Expense 545 Interest Payable 205 Telephone Expense 550 Salary Payable 210 Travel Expense 555 Unearned Revenue 215 Rent Expense 560 Bank Loan 220 Note Payable 225 OWNER'S EQUITY Pelletier, Capital 300 Pelletier, Withdrawals 310 Income Summary 315 Activate Window For the month of November 2023, Quest Cruise had the following transactions: Nov 1 Nov 1 Nov 1 Nov 2 Nov 2 Nov 5 Nov 15 Nov 18 Nov 20 Nov 23 Nov 26 Nov 28 Gray invested $14,600 cash and equipment valued at $15,000 into the business. Prepaid $15,000 for insurance for one year. Paid $5,200 cash for November's rent. Provided travel services to group of travellers; they paid $32,500 now and will pay $6,500 later. Purchase equipment by signing a Note Payable for $21,000, due in 3 years plus accrued interest at 12%. Recorded travel expenses for $12,450 to be paid next month. Paid $9,200 cash to reduce the balance of accounts payable. Received $5,900 cash from customers for the travel services provided last month. Received a telephone bill for $995 which will be paid next month. Paid $9,110 cash for employee's salaries. Received $31,450 cash in advance from travellers for travel services to be provided next month. Paid $7,540 advertising expense for the promotion of the travel and tours in the month of November. Nov 28 month of November. Nov 29 The owner withdrew $8,000 cash for personal use. Nov 30 Paid $578 cash for the bank loan which included $375 principle and $203 interest. The loan is due in 6 years with monthly repayments of $375 principle plus interest at 9% on outstanding balance. At the end of November, the following adjustment had to be journalized to properly report the balances of the company's accounts: Nov 30 Nov 30 Nov 30 Nov 30 Nov 30 $34,150 of the balance of unearned revenue, still remains unearned. One month of prepaid insurance worth $1,250 has been used. Monthly depreciation on the equipment was $1,440. Accrued salary expense of $4,555 for an employee. Accrued interest on the Note Payable amounts to $210. Required: a) Enter the opening balances from the October 2023 balance sheet into the general ledger accounts. b) Prepare the journal entries for the month of November and post them to the appropriate general ledger accounts. c) Create the trial balance in the worksheet, and then complete the remaining section of the worksheet taking into account the information for adjustments shown above. d) Create the income statement, statement of owner's equity and the classified balance sheet. e) Prepare the journal entries for the adjustments and post them to the appropriate general ledger accounts. f) Prepare the journal entries to close the books for the month of November 2023 (use the income summary account), and post the journal entries to the appropriate general ledger accounts. g) Create the post-closing trial balance.
Expert Answer:
Related Book For
Federal Taxation 2021 Corporations, Partnerships, Estates & Trusts
ISBN: 9780135919460
34th Edition
Authors: Timothy J. Rupert, Kenneth E. Anderson, David S. Hulse
Posted Date:
Students also viewed these finance questions
-
Cheers Beverages Limited paid a $ 3 dividend last year. The dividend is expected to grow at a constant rate of 5 percent forever. The required rate of return is 1 4 percent ( this will also serve as...
-
Over/Under: Beta failed to record the issue (sale) of common stock to new stockholders for $10,000 cash and a normal AJE for $12,000 of unearned sales revenue that had been earned. This has what...
-
Below is the algorithm of quicksort partition, PARTITION (4, p, q) A[p..q] x A[p] iep pivot = A[p] for j
-
On January 1, 20x1, Allan Co. purchased 400,000 bonds for 392,000. The bonds mature on January 1, 20x5 and pay 12% annual interest beginning January 1, 20x2. Transaction costs are negligible. The...
-
A manager can invoke the "employment-at-will" doctrine and fire a non-union worker who complains about too much overtime.
-
How does revenue destruction effect affect the ability of firms to coordinate on a pricing equilibrium?
-
In a computer system, how are accounting records posted? a. master file is updated to a transaction file b. master file is updated to an index file c. transaction file is updated to a master file d....
-
A large St. Louis feed mill, Robert Orwig Processing, prepares its 6- month aggregate plan by forecasting demand for 50- pound bags of cattle feed as follows: January, 1,000 bags; February, 1,200;...
-
1. Question 1 This month, a company receives $5,000 from a regular customer, of which $3,000 is for products delivered last month and $2,000 is for products that will be delivered next month. How...
-
1. The Corporate Responsibility Report 2010 of Coca-Cola Amatil Company is at http://ecamatil.com/InvestorRelations/AnnualReports/2009/2010%20 Sustainability%20Report. pdf. It mentions four global...
-
Relocating to the chicago area and need assistance in searching for my new home. i would like to know what are 2 or 3 of the best cities, towns, or suburbs (sometimes referred to as community areas)...
-
if the function f ( x ) = x ^ 4 + x ^ 3 + px ^ 2 - 5 2 x - 4 0 = 0 has 3 equal roots then the value of - p / 9 is?
-
Crystal Glassware Company has the following standards and flexible-budget data. Standard variable-overhead rate Standard quantity of direct labor Budgeted fixed overhead Budgeted output Actual...
-
Distinguish and explain the difference between a commercial annuity and a private annuity
-
Panamint Systems Corporation is estimating activity costs associated with producing disk drives, tape drives, and wire drives. The indirect labor can be traced to five separate activity pools. The...
-
One of the most impressive, innovative advances in online fundraising over the past decade is the rise of crowd-funding websites. While features differ from site to site, crowd-funding sites are...
-
Why is it important to understand the macro-environment when making decisions about an international retail venture?
-
How many months does it take to save $200,000.00 based on the information provided in this problem?---
-
What is the amount oi the credit to employee city income tax payable?
-
Milat is the total yearly gross pay for all employees?
Study smarter with the SolutionInn App