1. Using the Goal Seek Tool find the Net Income breakeven point for both years changing the units sold while price remains fixed at $25.00 2. Using the Goal Seek Tool find the price each year that creates an income 1200 in 2018 and 2019 holding sales at 3500 units 2018 2019 Total Revenue 61436 63644 Cost of Goods Sold 46077 47733 Gross Profit 15359 15911 General & Admin 12,884 13,411 Depreciation 1250 1,250 Rent 650 650 Operating Expenses 14,784 15,311 EBIT 575 600 Interest Expense 575 600 Earnings Before Taxes 0 0 Income Tax Expense 0 0 Net Income 0 0 Units Sold 2,457 2,546 Price 25.00 25.00 Tax Rate 40.0% 40.0% Cost of Good Sold 75.0% 75.0%
1. Using the Goal Seek Tool find the Net Income breakeven point for both years changing the units sold while price remains fixed at $25.00 2. Using the Goal Seek Tool find the price each year that creates an income 1200 in 2018 and 2019 holding sales at 3500 units 2018 2019 Total Revenue 61436 63644 Cost of Goods Sold 46077 47733 Gross Profit 15359 15911 General & Admin 12,884 13,411 Depreciation 1250 1,250 Rent 650 650 Operating Expenses 14,784 15,311 EBIT 575 600 Interest Expense 575 600 Earnings Before Taxes 0 0 Income Tax Expense 0 0 Net Income 0 0 Units Sold 2,457 2,546 Price 25.00 25.00 Tax Rate 40.0% 40.0% Cost of Good Sold 75.0% 75.0%
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
1. Using the Goal Seek Tool find the Net Income breakeven point
for both years changing the units sold while price remains fixed at $25.00
2. Using the Goal Seek Tool find the price each year that creates an income
1200 in 2018 and 2019 holding sales at 3500 units
2018 | 2019 | |
Total Revenue | 61436 | 63644 |
Cost of Goods Sold | 46077 | 47733 |
Gross Profit | 15359 | 15911 |
General & Admin | 12,884 | 13,411 |
1250 | 1,250 | |
Rent | 650 | 650 |
Operating Expenses | 14,784 | 15,311 |
EBIT | 575 | 600 |
Interest Expense | 575 | 600 |
Earnings Before Taxes | 0 | 0 |
Income Tax Expense | 0 | 0 |
Net Income | 0 | 0 |
Units Sold | 2,457 | 2,546 |
Price | 25.00 | 25.00 |
Tax Rate | 40.0% | 40.0% |
Cost of Good Sold | 75.0% | 75.0% |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
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
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education