In: Finance
The only current answer available to this question is wrong.
We are evaluating a project that costs $768,000, has a six-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 52,000 units per year. Price per unit is $60, variable cost per unit is $35, and fixed costs are $770,000 per year. The tax rate is 35 percent, and we require a return of 15 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. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) NPV Best-case $ Worst-case $
Project cost | 768,000 |
Depreciation (straight line 6 years) | 128,000 |
Sales unit | 52,000 |
Price per unit | 60 |
Variable cost per unit | -35 |
Income after variable cost | =52000*(60-35) |
Income after variable cost | 1,300,000 |
Fixed costs | -770,000 |
Depreciation | -128,000 |
Operating profit before tax | 402,000 |
Tax (@35%) | -140,700 |
Net operating profit after tax | 261,300 |
Net operating profit after tax | 261,300 |
Depreciation | 128,000 |
Annual Cash flow (base case) | 389,300 |
Annual Cash flow (Best case) | 428,230 |
Annual Cash flow (Worst case) | 350,370 |
NPV - Best case | |||
Year | Cash flow | Discount factor @15% | Present value |
0 | -768,000 | 1.000 | -768,000 |
1 | 428,230 | 0.870 | 372,374 |
2 | 428,230 | 0.756 | 323,803 |
3 | 428,230 | 0.658 | 281,568 |
4 | 428,230 | 0.572 | 244,842 |
5 | 428,230 | 0.497 | 212,906 |
6 | 428,230 | 0.432 | 185,136 |
NPV -Best case | 852,629.02 | ||
NPV - Worst case | |||
Year | Cash flow | Discount factor @15% | Present value |
0 | -768,000 | 1.000 | -768,000 |
1 | 350,370 | 0.870 | 304,670 |
2 | 350,370 | 0.756 | 264,930 |
3 | 350,370 | 0.658 | 230,374 |
4 | 350,370 | 0.572 | 200,325 |
5 | 350,370 | 0.497 | 174,196 |
6 | 350,370 | 0.432 | 151,475 |
NPV -Worst case | 557,969.20 |