The following trial balance was extracted from the books of Columbus Ltd at December 31, the end of the company’s financial year. The company is owned by John Columbus and is in the business of buying and farming supplies. Trial Balance as at December 31, 2018 Trial balance A/C Name Dr Cr Cash 1,000,000   Accounts receivable 450,000   Allowance for bad debt   15,000 Merchandise inventory 186,000   Store supplies 120,000   Prepaid insurance 450,000   Furniture and fixtures 1,000,000   Accumulated depreciation - furniture and fixtures   360,000 Computer equipment 600,000   Accumulated depreciation computer equipment     Accounts payable   320,000 Wages payable     Unearned sales revenue   150,000 Notes payable, long term   900,000 John Columbus, capital   2,200,000 John Columbus, withdrawals 95,000   Sales revenue   1,761,000 Sales discount 120,000   Sales returns and allowances 95,000   Cost of goods sold 650,000   Wages expense 450,000   Insurance expense 180,000   Depreciation expense - furniture and fixtures     Depreciation expense - computer equipment      Store supplies 40,000   Utilities expense 180,000   Bad debt expense     Interest expense 90,000   Total 5,706,000 5,706,000 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 Columbus Ltd classified balance sheet at December 31, 2018. Prepare the closing entries Prepare the post-closing trial balance

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

he problem to be resolved:

The following trial balance was extracted from the books of Columbus Ltd at December 31, the end of the company’s financial year. The company is owned by John Columbus and is in the business of buying and farming supplies.

Trial Balance as at December 31, 2018

Trial balance

A/C Name Dr Cr
Cash

1,000,000

 
Accounts receivable 450,000  
Allowance for bad debt   15,000
Merchandise inventory 186,000  
Store supplies 120,000  
Prepaid insurance 450,000  
Furniture and fixtures 1,000,000  
Accumulated depreciation - furniture and fixtures   360,000
Computer equipment 600,000  
Accumulated depreciation computer equipment    
Accounts payable   320,000
Wages payable    
Unearned sales revenue   150,000
Notes payable, long term   900,000
John Columbus, capital   2,200,000
John Columbus, withdrawals 95,000  
Sales revenue   1,761,000
Sales discount 120,000  
Sales returns and allowances 95,000  
Cost of goods sold 650,000  
Wages expense 450,000  
Insurance expense 180,000  
Depreciation expense - furniture and fixtures    
Depreciation expense - computer equipment     
Store supplies 40,000  
Utilities expense 180,000  
Bad debt expense    
Interest expense 90,000  
Total 5,706,000 5,706,000

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 Columbus Ltd classified balance sheet at December 31, 2018.
  2. Prepare the closing entries
  3. Prepare the post-closing trial balance
Expert Solution
steps

Step by step

Solved in 3 steps with 9 images

Blurred answer
Knowledge Booster
Accounting for Liquidation of Companies
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education