In: Finance
Problem 11-5 Sensitivity Analysis and Break-Even [LO1, 3]
We are evaluating a project that costs $630,700, has a seven-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 90,000 units per year. Price per unit is $46, variable cost per unit is $33, and fixed costs are $720,000 per year. The tax rate is 25 percent, and we require a return of 10 percent on this project. |
a-1. |
Calculate the accounting break-even point. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) |
a-2. | What is the degree of operating leverage at the accounting break-even point? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.) |
b-1. | Calculate the base-case cash flow and NPV. (Do not round intermediate calculations. Round your cash flow answer to the nearest whole number, e.g., 32. Round your NPV answer to 2 decimal places, e.g., 32.16.) |
b-2. | What is the sensitivity of NPV to changes in the quantity sold? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) |
c. | What is the sensitivity of OCF to changes in the variable cost figure? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. ) |
I have answered the question below using excel and have attached the image below.
Please up vote for the same and thanks!!!
Do reach out in the comments for any queries
Answer:
a-2)
DOL = 1 + FC/OCF = 1 + 720000/90100 = 8.991