Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help me fill the rest of the yellow boxes. need to use excel formulas. thank you!! We are evaluating a project that costs $845,000,

please help me fill the rest of the yellow boxes. need to use excel formulas. thank you!!
image text in transcribed
image text in transcribed
image text in transcribed
We are evaluating a project that costs $845,000, has an eight-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 51,000 units per year. Price per unit is $53, variable cost per unit is $27, and fixed costs are $950,000 per year. The tax rate is 22 percent, and we require a return of 10 percent on this project. a. Calculate the accounting break-even point. What is the degree of operating leverage at the accounting break-even point? b. Calculate the base-case cash flow and NPV. What is the sensitivity of NPV to changes in the quantity sold? Explain what your answer tells you about a 500-unit decrease in the quantity sold. c. What is the sensitivity of OCF to changes in the variable cost figure? Explain what your answer tells you about a $1 decrease in estimated variable costs. \begin{tabular}{l|||r|r|} \hline Initial cost & $845,000.00 \\ Project life & 8 \\ Units sales & 51,000 \\ Price/unit & $53.00 \\ Variable cost/unit & $27.00 \\ Fixed costs & $950,000.00 \\ Tax rate & 22% \\ Required return & 10% \\ b. New quantity for calculation & 52,000 \\ Projected sales change & (500) \\ c. New VC for calculation & $28.00 \\ Projected VC change & $1.00) \\ \hline \end{tabular} Output area: a. Depreciation per year Accounting break-even DOL b. Base OCF Base NPV OCF at new quantity NPV at new quantity DNPV/DQ Change in NPV for given quantity change c. OCF DOCF/DVC Change in NPV for given VC change

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Introduction To Socio-Finance

Authors: Jørgen Vitting Andersen, Andrzej Nowak

2013th Edition

3642419437, 978-3642419430

More Books

Students also viewed these Finance questions

Question

16-17: What is the rationale for preventive mental health programs?

Answered: 1 week ago