Best case
Time line | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |||
Cost of new machine | -2070000 | ||||||||||
=Initial Investment outlay | -2070000 | ||||||||||
100.00% | |||||||||||
Unit sales | 102740 | 102740 | 102740 | 102740 | 102740 | 102740 | 102740 | ||||
Profits | =no. of units sold * (sales price - variable cost) | 2171718.12 | 2171718.12 | 2171718.12 | 2171718.1 | 2171718.1 | 2171718.1 | 2171718.12 | |||
Fixed cost | -768600 | -768600 | -768600 | -768600 | -768600 | -768600 | -768600 | ||||
-Depreciation | Cost of equipment/no. of years | -295714.286 | -295714.286 | -295714.286 | -295714.3 | -295714.3 | -295714.3 | -295714.286 | 0 | =Salvage Value | |
=Pretax cash flows | 1107403.834 | 1107403.834 | 1107403.834 | 1107403.8 | 1107403.8 | 1107403.8 | 1107403.834 | ||||
-taxes | =(Pretax cash flows)*(1-tax) | 852700.9524 | 852700.9524 | 852700.9524 | 852700.95 | 852700.95 | 852700.95 | 852700.9524 | |||
+Depreciation | 295714.2857 | 295714.2857 | 295714.2857 | 295714.29 | 295714.29 | 295714.29 | 295714.2857 | ||||
=after tax operating cash flow | 1148415.238 | 1148415.238 | 1148415.238 | 1148415.2 | 1148415.2 | 1148415.2 | 1148415.238 | ||||
+Tax shield on salvage book value | =Salvage value * tax rate | 0 | |||||||||
=Terminal year after tax cash flows | 0 | ||||||||||
Total Cash flow for the period | -2070000 | 1148415.238 | 1148415.238 | 1148415.238 | 1148415.2 | 1148415.2 | 1148415.2 | 1148415.238 | |||
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.12 | 1.2544 | 1.404928 | 1.5735194 | 1.7623417 | 1.9738227 | 2.210681407 | ||
Discounted CF= | Cashflow/discount factor | -2070000 | 1025370.748 | 915509.5967 | 817419.2828 | 729838.65 | 651641.65 | 581822.9 | 519484.7318 | ||
NPV= | Sum of discounted CF= | 3171087.55 |
Worst case
Time line | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |||
Cost of new machine | -2070000 | ||||||||||
=Initial Investment outlay | -2070000 | ||||||||||
100.00% | |||||||||||
Unit sales | 84060 | 84060 | 84060 | 84060 | 84060 | 84060 | 84060 | ||||
Profits | =no. of units sold * (sales price - variable cost) | 724765.32 | 724765.32 | 724765.32 | 724765.32 | 724765.32 | 724765.32 | 724765.32 | |||
Fixed cost | -939400 | -939400 | -939400 | -939400 | -939400 | -939400 | -939400 | ||||
-Depreciation | Cost of equipment/no. of years | -295714.286 | -295714.286 | -295714.286 | -295714.3 | -295714.3 | -295714.3 | -295714.286 | 0 | =Salvage Value | |
=Pretax cash flows | -510348.966 | -510348.966 | -510348.966 | -510349 | -510349 | -510349 | -510348.966 | ||||
-taxes | =(Pretax cash flows)*(1-tax) | -392968.704 | -392968.704 | -392968.704 | -392968.7 | -392968.7 | -392968.7 | -392968.704 | |||
+Depreciation | 295714.2857 | 295714.2857 | 295714.2857 | 295714.29 | 295714.29 | 295714.29 | 295714.2857 | ||||
=after tax operating cash flow | -97254.4179 | -97254.4179 | -97254.4179 | -97254.42 | -97254.42 | -97254.42 | -97254.4179 | ||||
+Tax shield on salvage book value | =Salvage value * tax rate | 0 | |||||||||
=Terminal year after tax cash flows | 0 | ||||||||||
Total Cash flow for the period | -2070000 | -97254.4179 | -97254.4179 | -97254.4179 | -97254.42 | -97254.42 | -97254.42 | -97254.4179 | |||
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.12 | 1.2544 | 1.404928 | 1.5735194 | 1.7623417 | 1.9738227 | 2.210681407 | ||
Discounted CF= | Cashflow/discount factor | -2070000 | -86834.3017 | -77530.6265 | -69223.7737 | -61806.94 | -55184.77 | -49272.11 | -43992.9596 | ||
NPV= | Sum of discounted CF= | -2513845.49 |
We are evaluating a project that costs $2,070,000, has a 7-year life, and has no salvage...
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,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 10 percent on this project. a. Calculate the base-case operating cash flow...
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,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 $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.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 $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 $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,...