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.
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
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 |
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
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.Recommended textbooks for you
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
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
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
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning