Base case | Best case = base case value*(1+growth rate) | Worst case = base value*(1+growth rate) | |||||
Units sold | 86400 | 86400*1.1 | 95040 | 86400*0.9 | 77760 | ||
selling price | 38.01 | 38.01*1.1 | 41.811 | 38.01*0.9 | 34.209 | ||
variable cost | 23.25 | 23.25*1.1 | 25.575 | 23.25*0.9 | 20.925 | ||
Total fixed cost | 818000 | 818000*1.1 | 899800 | 818000*0.9 | 736200 | ||
Best Case NPV | |||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
Initial Investment | -1710000 | ||||||
sales= units sold*selling price | 3973717.44 | 3973717.44 | 3973717.44 | 3973717.44 | 3973717 | 3973717 | |
variable cost = units sold*variable cost | 2430648 | 2430648 | 2430648 | 2430648 | 2430648 | 2430648 | |
fixed cost | 899800 | 899800 | 899800 | 899800 | 899800 | 899800 | |
annual depreciation | 285000 | 285000 | 285000 | 285000 | 285000 | 285000 | |
operating profit | 358269.44 | 358269.44 | 358269.44 | 358269.44 | 358269.4 | 358269.4 | |
less taxes-21% | 75236.5824 | 75236.5824 | 75236.5824 | 75236.5824 | 75236.58 | 75236.58 | |
after tax profit | 283032.8576 | 283032.8576 | 283032.8576 | 283032.8576 | 283032.9 | 283032.9 | |
add depreciation | 285000 | 285000 | 285000 | 285000 | 285000 | 285000 | |
net operating cash flow | -1710000 | 568032.8576 | 568032.8576 | 568032.8576 | 568032.8576 | 568032.9 | 568032.9 |
present value factor at 9% =1/(1+r)^n | 1 | 0.917431193 | 0.841679993 | 0.77218348 | 0.708425211 | 0.649931 | 0.596267 |
present value of cash flow = net operating cash flow*present value factor | -1710000 | 521131.062 | 478101.8918 | 438625.5888 | 402408.797 | 369182.4 | 338699.4 |
Net present value of best case =sum of present value factor*net operating cash flow | 838149.16 | ||||||
Worst Case NPV | |||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
Initial Investment | -1710000 | ||||||
sales | 2660091.84 | 2660091.84 | 2660091.84 | 2660091.84 | 2660092 | 2660092 | |
variable cost | 1627128 | 1627128 | 1627128 | 1627128 | 1627128 | 1627128 | |
fixed cost | 736200 | 736200 | 736200 | 736200 | 736200 | 736200 | |
annual depreciation | 285000 | 285000 | 285000 | 285000 | 285000 | 285000 | |
operating profit | 11763.84 | 11763.84 | 11763.84 | 11763.84 | 11763.84 | 11763.84 | |
less taxes-21% | 2470.4064 | 2470.4064 | 2470.4064 | 2470.4064 | 2470.406 | 2470.406 | |
after tax profit | 9293.4336 | 9293.4336 | 9293.4336 | 9293.4336 | 9293.434 | 9293.434 | |
add depreciation | 285000 | 285000 | 285000 | 285000 | 285000 | 285000 | |
net operating cash flow | -1710000 | 294293.4336 | 294293.4336 | 294293.4336 | 294293.4336 | 294293.4 | 294293.4 |
present value factor at 9% =1/(1+r)^n | 1 | 0.917431193 | 0.841679993 | 0.77218348 | 0.708425211 | 0.649931 | 0.596267 |
present value of cash flow = net operating cash flow*present value factor | -1710000 | 269993.9758 | 247700.8952 | 227248.5277 | 208484.8878 | 191270.5 | 175477.6 |
Net present value of best case =sum of present value factor*net operating cash flow | -389823.62 |
We are evaluating a project that costs $1,710,000, has a life of 6 years, and has...
We are evaluating a project that costs $1,710,000, has a 6-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 86,400 units per year. Price per unit is $38.01, variable cost per unit is $23.25, and fixed costs are $818,000 per year. The tax rate is 21 percent, and we require a return of 9 percent on this project. points Skipped eBook a. Calculate the base-case...
We are evaluating a project that costs $788,400, has a nine-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 75,000 units per year. Price per unit is $52, variable cost per unit is $36, and fixed costs are $750,000 per year. The tax rate is 21 percent, and we require a return of 12 percent on this project. Suppose the projections given for price, quantity,...
We are evaluating a project that costs $2,070,000, has a 7-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 93,400 units per year. Price per unit is $38.73, variable cost per unit is $23.85, and fixed costs are $854,000 per year. The tax rate is 23 percent and we require a return of 12 percent on this project. Suppose the projections given for price, quantity,...
We are evaluating a project that costs $2,010,000, has a 7-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 89,400 units per year. Price per unit is $38.61, variable cost per unit is $23.75, and fixed costs are $848,000 per year. The tax rate is 21 percent and we require a return of 12 percent on this project. Suppose the projections given for price, quantity,...
We are evaluating a project that costs $2.130,000, has a 8-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,600 units per year. Price per unit is $38.85, variable cost per unit is $23.95, and fixed costs are $860,000 per year. The tax rate is 25 percent and we require a return of 11 percent on this project. Suppose the projections given for price, quantity,...
We are evaluating a project that costs $2,040,000, has a 7-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 89,700 units per year. Price per unit is $38.67, variable cost per unit is $23.80, and fixed costs are $851,000 per year. The tax rate is 22 percent and we require a return of 12 percent on this project. Suppose the projections given for price, quantity,...
We are evaluating a project that costs $744,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 45,000 units per year. Price per unit is $60, variable cost per unit is $20, and fixed costs are $740,000 per year. The tax rate is 35 percent, and we require a return of 18 percent on this project. Suppose the projections given for price, quantity,...
We are evaluating a project that costs $1,160,000, has a ten-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 39,000 units per year. Price per unit is $41, variable cost per unit is $20, and fixed costs are $645,000 per year. The tax rate is 35 percent, and we require a return of 20 percent on this project. Suppose the projections given for price, quantity,...
We are evaluating a project that costs $1,120,000, has a ten-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 64,000 units per year. Price per unit is $50, variable cost per unit is $25, and fixed costs are $620,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,...
We are evaluating a project that costs $832,000, has a life of 8 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 40,000 units per year. Price per unit is $40, variable cost per unit is $17, and fixed costs are $700,000 per year. The tax rate is 23 percent and we require a return of 13 percent on this project. Suppose the projections given for...