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%
Chapter4A: Nopat Breakeven: Revenues Needed To Cover Total Operating Costs
Section: Chapter Questions
Problem 1EP
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 |
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% |
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