The following trial balance was extracted from the books of Movies To The Max Ltd at July 31, the end of the company’s financial year. The company is owned by Samuel Maximo and is in the business of buying and selling movies on tapes. The following additional information is available at July 31, 2021: Insurance of $510,000 was paid on April 1, 2021, for six (6) -months to February 2022. The computer and equipment were purchased on December 1, 2020 and have an estimated useful life of 10 years. This asset is depreciated on the double-declining depreciation method down to a residual value of $100,000. The company has two deliver trucks and uses the units of production method to compute the depreciation charges. One of the trucks was purchased for $800,000 on August 1, 2018, and is recognized as truck A. The other which is recognized as truck B was purchased for $1,100,000 on October 1, 2020. The expected useful life of both truck is ten (10) years or 120,000 miles. And the residual value on both trucks is $200,000. In the 2018/2019 financial year truck A drove 12,000 miles, 18,000 miles in 2019/2020, and 21,000 miles in 2020/2021. Truck B drove 8,000 miles in 2020/2021. Wages earned by employees NOT yet paid amounted to 23,050 at July 31, 2021. A physical count of inventory at July 31, 2021 reveals $165,070 worth of inventory on hand. At July 31, 2021 $105,000 of the previously unearned sales revenue had been earned. The aging of the Accounts Receivable schedule at July 31, 2021 indicated that the estimated uncollectible on account receivable should be $29,050. REQUIRED: (A-F) Prepare the necessary adjusting journal entries on July 31, 2021. [Narrations are not required] Prepare Columbus Ltd multiple-step income statement for the year ended July 31, 2021. Prepare Columbus Ltd statement of owner’s equity for the year ended July 31, 2021.

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter9: Long-term Liabilities
Section: Chapter Questions
Problem 91PSA: Problem Reporting Long-Term Debt Fridley Manufacturings accounting records reveal the following...
icon
Related questions
icon
Concept explainers
Question

The following trial balance was extracted from the books of Movies To The Max Ltd at July 31, the end of the company’s financial year. The company is owned by Samuel Maximo and is in the business of buying and selling movies on tapes.

The following additional information is available at July 31, 2021:

  • Insurance of $510,000 was paid on April 1, 2021, for six (6) -months to February 2022.
  • The computer and equipment were purchased on December 1, 2020 and have an estimated useful life of 10 years. This asset is depreciated on the double-declining depreciation method down to a residual value of $100,000.
  • The company has two deliver trucks and uses the units of production method to compute the depreciation charges. One of the trucks was purchased for $800,000 on August 1, 2018, and is recognized as truck A. The other which is recognized as truck B was purchased for $1,100,000 on October 1, 2020. The expected useful life of both truck is ten (10) years or 120,000 miles. And the residual value on both trucks is $200,000. In the 2018/2019 financial year truck A drove 12,000 miles, 18,000 miles in 2019/2020, and 21,000 miles in 2020/2021. Truck B drove 8,000 miles in 2020/2021.
  • Wages earned by employees NOT yet paid amounted to 23,050 at July 31, 2021.
  • A physical count of inventory at July 31, 2021 reveals $165,070 worth of inventory on hand.
  • At July 31, 2021 $105,000 of the previously unearned sales revenue had been earned.
  • The aging of the Accounts Receivable schedule at July 31, 2021 indicated that the estimated uncollectible on account receivable should be $29,050.

REQUIRED: (A-F)

  1. Prepare the necessary adjusting journal entries on July 31, 2021. [Narrations are not required]
  2. Prepare Columbus Ltd multiple-step income statement for the year ended July 31, 2021.
  3. Prepare Columbus Ltd statement of owner’s equity for the year ended July 31, 2021.
  4. Prepare Columbus Ltd classified balance sheet at July 31, 2021.
  5. Prepare the closing entries
  6. Prepare the post-closing trial balance
Trial Balance as at July 31, 2021
Trial Balance
DR
A/CName
CR
Cash
Accounts recevable
Alowance for bad debt
Merehandise nventory
Store Supplies
Prepaid Rent
Computer and Equpment
Accumibted deprecation-Computer and Equipment
Delivery Truck
Accumbted đeprecaion De livery Truck
Accounts payable
Wages payable
Unearned Sales reveme
750,000
290,500
25,000
167,050
120,000
510,000
1,200,000
1,900,000
150,000
400,000
Notes Payable, Long Term
SamelMaximo, Capital
SamelMaximo, Withdrawals
150,000
1,000,000
2,500,000
105,000
iSales revemme
2,833,580
Sales discount
Sales returns and allowances
Cost of goods sold
Wages Expense
Rent Expense
Depreciation Expense=
Deprecation Expense-Delivery Tnck
Store Supples Expense
Unhtes Expense
Bad Debt ExpeIES
Interest Expense
Total
73,250
52,100
495,000
325,125
680 000
Computerand Equipment
65,000
220,000
105 555
7,058,580
7,058,580
Transcribed Image Text:Trial Balance as at July 31, 2021 Trial Balance DR A/CName CR Cash Accounts recevable Alowance for bad debt Merehandise nventory Store Supplies Prepaid Rent Computer and Equpment Accumibted deprecation-Computer and Equipment Delivery Truck Accumbted đeprecaion De livery Truck Accounts payable Wages payable Unearned Sales reveme 750,000 290,500 25,000 167,050 120,000 510,000 1,200,000 1,900,000 150,000 400,000 Notes Payable, Long Term SamelMaximo, Capital SamelMaximo, Withdrawals 150,000 1,000,000 2,500,000 105,000 iSales revemme 2,833,580 Sales discount Sales returns and allowances Cost of goods sold Wages Expense Rent Expense Depreciation Expense= Deprecation Expense-Delivery Tnck Store Supples Expense Unhtes Expense Bad Debt ExpeIES Interest Expense Total 73,250 52,100 495,000 325,125 680 000 Computerand Equipment 65,000 220,000 105 555 7,058,580 7,058,580
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 3 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning