Suppose you are a part of a group of students from a prominent university and were sent out as a team to work with a leading merchandizing company as a part of a work experience program. The team having been introduced to the general manger was told that the Accountant who normally prepares the financial statements has suddenly resigned and there is no one available to prepare the company’s financial statements which are now due. As aspiring university students, you and your group members have expressed an interest in taking on the task. As a group, you are required to collaborate and analyse the problem at hand then apply the accrual basis of accounting in the preparation of the company’s financial statements. The following additional information is available at December 31, 2018:                                                         Insurance of $450,000 was paid on May 1, 2018 for the 10-months to February 2019. The furniture and fixtures have an estimated useful life of 10 years and is being depreciated on the straight-line method down to a residual value of $100,000. The computer equipment was acquired on March 1, 2018 and is being depreciated over 10 years on the double-declining method of depreciation, down to a residue of $60,000. Wages earned by employees NOT yet paid amounted to 15,000 at December 31, 2018. A physical count of inventory at December 31, reveals $180,000 worth of inventory on hand. At December 31, $140,000 of the previously unearned sales revenue had been earned. The aging of the Accounts Receivable schedule at December 31 indicated that the estimated uncollectible on account receivable should be $45,000. REQUIRED: Prepare the necessary adjusting journal entries on December 31. Prepare Columbus Ltd multiple-step income statement for the year ended December 31, 2018. Prepare Columbus Ltd statement of owner’s equity for the year ended December 31, 2018. Prepare Columbus Ltd classified balance sheet at December 31, 2018. Prepare the closing entries Prepare the post-closing trial balance Answer Question 1 and 2.

Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter9: Accounting For Receivables
Section: Chapter Questions
Problem 6PA: Funnel Direct recorded $1,345,780 in credit sales for the year and $695,455 in accounts receivable....
icon
Related questions
Question

Suppose you are a part of a group of students from a prominent university and were sent out as a team to work with a leading merchandizing company as a part of a work experience program. The team having been introduced to the general manger was told that the Accountant who normally prepares the financial statements has suddenly resigned and there is no one available to prepare the company’s financial statements which are now due. As aspiring university students, you and your group members have expressed an interest in taking on the task. As a group, you are required to collaborate and analyse the problem at hand then apply the accrual basis of accounting in the preparation of the company’s financial statements.

The following additional information is available at December 31, 2018:                                                        

  • Insurance of $450,000 was paid on May 1, 2018 for the 10-months to February 2019.
  • The furniture and fixtures have an estimated useful life of 10 years and is being depreciated on the straight-line method down to a residual value of $100,000.
  • The computer equipment was acquired on March 1, 2018 and is being depreciated over 10 years on the double-declining method of depreciation, down to a residue of $60,000.
  • Wages earned by employees NOT yet paid amounted to 15,000 at December 31, 2018.
  • A physical count of inventory at December 31, reveals $180,000 worth of inventory on hand.
  • At December 31, $140,000 of the previously unearned sales revenue had been earned.
  • The aging of the Accounts Receivable schedule at December 31 indicated that the estimated uncollectible on account receivable should be $45,000.

REQUIRED:

  1. Prepare the necessary adjusting journal entries on December 31.
  2. Prepare Columbus Ltd multiple-step income statement for the year ended December 31, 2018.
  3. Prepare Columbus Ltd statement of owner’s equity for the year ended December 31, 2018.
  4. Prepare Columbus Ltd classified balance sheet at December 31, 2018.
  5. Prepare the closing entries
  6. Prepare the post-closing trial balance

Answer Question 1 and 2.

 

Trial Balance as at December 31, 2018
Trial Balance
A/C Name
Cash
Accounts receivable
Allowance for bad debt
Merchandise Inventory
Store Supplies
Prepaid Insurance
Furniture and Fixtures
Accumulated deprecia tion -Furniture and Fixtures
Computer Equipment
Accumulate d deprecia tion Computer Equipment
Accounts payable
Wages payable
Unearned Sales revemue
DR
CR
1,000,000
450,000
15,000
186,000
120,000
450,000
1,000,000
360,000
600,000
320,000
150,000
900,000
Notes Payable, Long Term
John Columbus, Capital
John Columbus, Withdrawals
2,200,000
95,000
Sales revemue
1,761,000
Sales discount
120,000
95,000
650,000
450,000
180,000
Sales returns and allowances
Cost of goods sold
Wages Expense
Insurance Expense
Depreciation Expense - Furniture and Fixtures
Depreciation Expense -Computer Equipment
Store Supplies Expense
Utilities Expense
Bad Debt Expense
Intere st Expense
Total
40,000
180,000
90,000
5,706,000
5,706,000
Transcribed Image Text:Trial Balance as at December 31, 2018 Trial Balance A/C Name Cash Accounts receivable Allowance for bad debt Merchandise Inventory Store Supplies Prepaid Insurance Furniture and Fixtures Accumulated deprecia tion -Furniture and Fixtures Computer Equipment Accumulate d deprecia tion Computer Equipment Accounts payable Wages payable Unearned Sales revemue DR CR 1,000,000 450,000 15,000 186,000 120,000 450,000 1,000,000 360,000 600,000 320,000 150,000 900,000 Notes Payable, Long Term John Columbus, Capital John Columbus, Withdrawals 2,200,000 95,000 Sales revemue 1,761,000 Sales discount 120,000 95,000 650,000 450,000 180,000 Sales returns and allowances Cost of goods sold Wages Expense Insurance Expense Depreciation Expense - Furniture and Fixtures Depreciation Expense -Computer Equipment Store Supplies Expense Utilities Expense Bad Debt Expense Intere st Expense Total 40,000 180,000 90,000 5,706,000 5,706,000
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Accounting profession
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
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
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
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage