We are evaluating a project that costs $660,000, has a five-year life, and has n
ID: 2790469 • Letter: W
Question
We are evaluating a project that costs $660,000, has a five-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 69,000 units per year. Price per unit is $58, variable cost per unit is $38, and fixed costs are $660,000 per year. The tax rate is 35 percent, and we require a return of 12 percent on this project. Suppose the projections given for price, quantity, variable costs, and fixed costs are all accurate to within ±10 percent. Calculate the best-case and worst-case NPV figures. (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations and round your final answers to 2 decimal places, e.g., 32.16.)
Just worst case needed
price, quantity, variable costs, and fixed costs need to be adjusted 10% for best and worst quality from the base
Explanation / Answer
We first need to find the depreciation for each year. The depreciation is:
Depreciation = $660,000/5
Depreciation = $132,000 per year
We will use the tax shield approach to calculate the OCF for the best- and worst-case scenarios. For the best-case scenario, the price and quantity increase by 10 percent, so we will multiply the base case numbers by 1.1, a 10 percent increase. The variable and fixed costs both decrease by 10 percent, so we will multiply the base case numbers by 0.9, a 10 percent decrease. Doing so, we get:
OCFbest = ((((58 * 1.1 - 38 * 0.9)) * 69,000 * 1.1) - 660,000 * 0.9) * 0.65 - 0.35 * 132,000
OCFbest = 1,028,016
Best Case NPV:
NPV = -660,000 + 1,028,016/ 1.12 + 1,028,016/ 1.122 + 1,028,016/ 1.123 + 1,028,016/ 1.124 + 1,028,016/ 1.125
NPV = 3,045,767.61
OCFWorst = ((((58 * 0.9 - 38 * 1.1)) * 69,000 * 0.9) - 660,000 * 1.1) * 0.65 - 0.35 * 132,000
OCFWorst = -98,304
Worst Case NPV:
NPV = -660,000 - 98,304/ 1.12 - 98,304/ 1.122 - 98,304/ 1.123 - 98,304/ 1.124 - 98,304/ 1.125
NPV = -1,014,363.92
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.