XYZ Holdings is a company that purchases widgets from Company ABC. This is their first year of operations. The accounts for the financial year ending 30 June 2021 are as follows:   Sales 100,000 Accounts receivable 80,000 Drawings 20,000 Building 20,000 Bank loan, due 30 June 2030 100,000 Cost of sales 50,000 Accumulated depreciation - Building 10,000 Cash 60,000 Wages 15,000 Opening retained profit 0 Electricity 500 Capital 50,000 Property, plant and equipment 20,000 Depreciation 12,000 Accounts payable 30,000 Accumulated depreciation - Property, plant and equipment 2,000 Accrued expenses 500 Interest expense 5,000 Insurance expense 10,000 Closing retained profit          ???   Required: Prepare a balance sheet in the Excel template in the 'Balance Sheet' tab on the LMS, upload your worksheet. Ignore GST and taxes.

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

XYZ Holdings is a company that purchases widgets from Company ABC. This is their first year of operations.

The accounts for the financial year ending 30 June 2021 are as follows:

 

Sales 100,000
Accounts receivable 80,000
Drawings 20,000
Building 20,000
Bank loan, due 30 June 2030 100,000
Cost of sales 50,000
Accumulated depreciation - Building 10,000
Cash 60,000
Wages 15,000
Opening retained profit 0
Electricity 500
Capital 50,000
Property, plant and equipment 20,000
Depreciation 12,000
Accounts payable 30,000
Accumulated depreciation - Property, plant and equipment 2,000
Accrued expenses 500
Interest expense 5,000
Insurance expense 10,000
Closing retained profit          ???

 

Required:

Prepare a balance sheet in the Excel template in the 'Balance Sheet' tab on the LMS, upload your worksheet. Ignore GST and taxes.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Ratio Analysis
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