I need help with finding the accounting breakeven and cash break even and OCF at financial breakeven with taxes. Also, what excel function to use for NPV calculation in the NPV profile D11 XVfx C TOSK T lapet area: Initial cost Unit sales Price/unit Variable cost/unit B TOYT E Fixed costs Project life 1,000,000 Required return 11% 5,000 Tax rate 21% 7,000 Unit sales uncertainty 8% 6,400 Variable cost uncertainty 270,000 Fixed cost uncertainty 8% 5 Question 1 Base Case Best Case Worst Case Unit sales 5,000 Variable cost/unit 6,400 5,400 1 5,888 4,600 6,912 Fixed costs 270,000 Sales 35,000,000 Variable cost 32,000,000 Fixed cost 270,000 Depreciation 200,000 248,400 37,800,000 31,795,200 248,400 ! 200,000 32,200,000 31,795,200 291,600 291,600 200,000 EBIT 2,530,000 5,556,400 (86,800) Taxes (21%) Net income OCF 531,300 1,166,844 (18,228) 1,998,700 4,389,556 (68,572) 2,138,700 4,589,556 131,428 NPV $7.126.168.77 $15,962,526.33 ($514,255.65) Question 2 fignoring Taxes with Taxes) x Accounting break-even 783.33 783.33 Question 3 fignoring Taxes) with Taxes) x Cach break-even 450.00 Question 4 fignoring Taxes) (with Taxes) x OCF at financial-break even 7x Financial break-even 5,483,333 Question 5 2.350 2.242 2.458 x Degree of operating leverage Greation 6 Draw graph of "Sensitivity of NPV to changes in unit price" Unit Price 5,500 5,750 6,000 6,250 6,500 6,750 7,000 7,250 $5 7,500 $6 7.750 57 8,000 NPV
I need help with finding the accounting breakeven and cash break even and OCF at financial breakeven with taxes. Also, what excel function to use for NPV calculation in the NPV profile D11 XVfx C TOSK T lapet area: Initial cost Unit sales Price/unit Variable cost/unit B TOYT E Fixed costs Project life 1,000,000 Required return 11% 5,000 Tax rate 21% 7,000 Unit sales uncertainty 8% 6,400 Variable cost uncertainty 270,000 Fixed cost uncertainty 8% 5 Question 1 Base Case Best Case Worst Case Unit sales 5,000 Variable cost/unit 6,400 5,400 1 5,888 4,600 6,912 Fixed costs 270,000 Sales 35,000,000 Variable cost 32,000,000 Fixed cost 270,000 Depreciation 200,000 248,400 37,800,000 31,795,200 248,400 ! 200,000 32,200,000 31,795,200 291,600 291,600 200,000 EBIT 2,530,000 5,556,400 (86,800) Taxes (21%) Net income OCF 531,300 1,166,844 (18,228) 1,998,700 4,389,556 (68,572) 2,138,700 4,589,556 131,428 NPV $7.126.168.77 $15,962,526.33 ($514,255.65) Question 2 fignoring Taxes with Taxes) x Accounting break-even 783.33 783.33 Question 3 fignoring Taxes) with Taxes) x Cach break-even 450.00 Question 4 fignoring Taxes) (with Taxes) x OCF at financial-break even 7x Financial break-even 5,483,333 Question 5 2.350 2.242 2.458 x Degree of operating leverage Greation 6 Draw graph of "Sensitivity of NPV to changes in unit price" Unit Price 5,500 5,750 6,000 6,250 6,500 6,750 7,000 7,250 $5 7,500 $6 7.750 57 8,000 NPV
Survey of Accounting (Accounting I)
8th Edition
ISBN:9781305961883
Author:Carl Warren
Publisher:Carl Warren
Chapter11: Cost-volume-profit Analysis
Section: Chapter Questions
Problem 11.16E
Question

Transcribed Image Text:I need help with finding the accounting breakeven and cash break even and OCF at financial breakeven with taxes. Also,
what excel function to use for NPV calculation in the NPV profile
D11
XVfx
C
TOSK T
lapet area:
Initial cost
Unit sales
Price/unit
Variable cost/unit
B
TOYT
E
Fixed costs
Project life
1,000,000 Required return
11%
5,000 Tax rate
21%
7,000 Unit sales uncertainty
8%
6,400 Variable cost uncertainty
270,000
Fixed cost uncertainty
8%
5
Question 1
Base Case
Best Case
Worst Case
Unit sales
5,000
Variable cost/unit
6,400
5,400 1
5,888
4,600
6,912
Fixed costs
270,000
Sales
35,000,000
Variable cost
32,000,000
Fixed cost
270,000
Depreciation
200,000
248,400
37,800,000
31,795,200
248,400 !
200,000
32,200,000
31,795,200
291,600
291,600
200,000
EBIT
2,530,000
5,556,400
(86,800)
Taxes (21%)
Net income
OCF
531,300
1,166,844
(18,228)
1,998,700
4,389,556
(68,572)
2,138,700
4,589,556
131,428
NPV
$7.126.168.77
$15,962,526.33
($514,255.65)
Question 2
fignoring Taxes
with Taxes)
x Accounting break-even
783.33
783.33
Question 3
fignoring Taxes)
with Taxes)
x Cach break-even
450.00
Question 4
fignoring Taxes)
(with Taxes)
x OCF at financial-break even
7x Financial break-even
5,483,333
Question 5
2.350
2.242
2.458
x Degree of operating leverage
Greation 6
Draw graph of "Sensitivity of NPV to changes in unit price"
Unit Price
5,500
5,750
6,000
6,250
6,500
6,750
7,000
7,250
$5
7,500
$6
7.750
57
8,000
NPV
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

Recommended textbooks for you

Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning

Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning