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 an income statement in the Excel template in the 'Income Statement' tab on the LMS, upload your worksheet. Ignore GST and taxes.

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter15: Financial Statement Analysis
Section: Chapter Questions
Problem 60P
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 an income statement in the Excel template in the 'Income Statement' tab on the LMS, upload your worksheet. Ignore GST and taxes.

Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Receivables Management
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
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage