Question

In: Finance

The current available answer to this question is wrong. We are evaluating a project that costs...

The current available answer 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 $

Solutions

Expert Solution

Best case

Time line 0 1 2 3 4 5 6
Cost of new machine -768000
=Initial Investment outlay -768000
Unit sales 57200 57200 57200 57200 57200 57200
Profits =no. of units sold * (sales price - variable cost) 1973400 1973400 1973400 1973400 1973400 1973400
Fixed cost -693000 -693000 -693000 -693000 -693000 -693000
-Depreciation Cost of equipment/no. of years -128000 -128000 -128000 -128000 -128000 -128000
=Pretax cash flows 1152400 1152400 1152400 1152400 1152400 1152400
-taxes =(Pretax cash flows)*(1-tax) 749060 749060 749060 749060 749060 749060
+Depreciation 128000 128000 128000 128000 128000 128000
=after tax operating cash flow 877060 877060 877060 877060 877060 877060
+Tax shield on salvage book value =Salvage value * tax rate 0
=Terminal year after tax cash flows 0
Total Cash flow for the period -768000 877060 877060 877060 877060 877060 877060
Discount factor= (1+discount rate)^corresponding period 1 1.15 1.3225 1.520875 1.7490063 2.0113572 2.3130608
Discounted CF= Cashflow/discount factor -768000 762660.9 663183.4 576681.19 501461.9 436053.83 379177.24
NPV= Sum of discounted CF= 2551218.39

Worst case

Time line 0 1 2 3 4 5 6
Cost of new machine -768000
=Initial Investment outlay -768000
Unit sales 46800 46800 46800 46800 46800 46800
Profits =no. of units sold * (sales price - variable cost) 725400 725400 725400 725400 725400 725400
Fixed cost -847000 -847000 -847000 -847000 -847000 -847000
-Depreciation Cost of equipment/no. of years -128000 -128000 -128000 -128000 -128000 -128000
=Pretax cash flows -249600 -249600 -249600 -249600 -249600 -249600
-taxes =(Pretax cash flows)*(1-tax) -162240 -162240 -162240 -162240 -162240 -162240
+Depreciation 128000 128000 128000 128000 128000 128000
=after tax operating cash flow -34240 -34240 -34240 -34240 -34240 -34240
+Tax shield on salvage book value =Salvage value * tax rate 0
=Terminal year after tax cash flows 0
Total Cash flow for the period -768000 -34240 -34240 -34240 -34240 -34240 -34240
Discount factor= (1+discount rate)^corresponding period 1 1.15 1.3225 1.520875 1.7490063 2.0113572 2.3130608
Discounted CF= Cashflow/discount factor -768000 -29773.9 -25890.4 -22513.36 -19576.83 -17023.33 -14802.9
NPV= Sum of discounted CF= -897580.69

Related Solutions

The only current answer available to this question is wrong. We are evaluating a project that...
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...
We are evaluating a project that costs $1,675,000, has a six year life, and has no...
We are evaluating a project that costs $1,675,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 as 91,000 units per year, price is $35.95 per unit, variable cost is $21.4 per unit, fixed costs are $775,000 per year. Tax rate is 35% and discount rate is 11%. 1) calculate base-case profit, profit with a 100-unit increase or 100-unit decrease, and break-even...
We are evaluating a project that costs $681,103, has a five-yearlife, and has no salvage...
We are evaluating a project that costs $681,103, 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 43,456 units per year. Price per unit is $46, variable cost per unit is $28, and fixed costs are $521,866 per year. The tax rate is 30%, and we require a return of 20% on this project. Suppose the projections given for price, quantity, variable costs,...
We are evaluating a project that costs $972,000, has a life of twelve years, and has...
We are evaluating a project that costs $972,000, has a life of twelve years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 117,000 units per year. Price per unit is $35, variable cost per unit is $25, and fixed costs are $989,496 per year. The tax rate is 22 percent, and we require a return of 21 percent on this project. The projections given for price,...
We are evaluating a project that costs $604,000, has an 8 year life, and has no...
We are evaluating a project that costs $604,000, has an 8 year life, and has no salvage value. Assume that depreciation is straight-line to zero of the life of the project. Sales are projected at 55,000 units per year. Price per unit is $36, variable cost per unit is $17, and fixed cost are 685,000 per year. The tax rate is 21 percent and we require a return of 15 percent on this project. a. Calculate the accounting break-even point....
We are evaluating a project that costs $743,000, has a life of eight years, and has...
We are evaluating a project that costs $743,000, has a life of eight years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 124,000 units per year. Price per unit is $37, variable cost per unit is $20, and fixed costs are $749,687 per year. The tax rate is 22 percent, and we require a return of 21 percent on this project. The projections given for price,...
We are evaluating a project that costs $1,100,000, has a life of 10 years, and has...
We are evaluating a project that costs $1,100,000, has a life of 10 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 47,000 units per year. Price per unit is $50, variable cost per unit is $25, and fixed costs are $820,000 per year. The tax rate is 21 percent and we require a return of 16 percent on this project. Suppose the projections given for...
We are evaluating a project that costs $1,080,000, has a life of 10 years, and has...
We are evaluating a project that costs $1,080,000, has a life of 10 years, 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 $50, variable cost per unit is $30, and fixed costs are $730,000 per year. The tax rate is 25 percent and we require a return of 15 percent on this project. Suppose the projections given for...
We are evaluating a project that costs $1,920,000, has a 6 year life, and no salvage...
We are evaluating a project that costs $1,920,000, has a 6 year life, and no salvage value. Assume that depreciation is staright-line to zero over the life of the project. Sales are projected at 94,000 units per year. Price per unit is $38.43, variable cost per unit is $23.60 and fixed costs are $839,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 the price,...
We are evaluating a project that costs $972,000, has a 4 year life, and no salvage...
We are evaluating a project that costs $972,000, has a 4 year life, and no salvage value. Assume that depreciation is staright-line to zero over the life of the project. Sales are projected at 88,000 units per year. Price per unit is $35.15, variable cost per unit is $21.40 and fixed costs are $768,000 per year. The tax rate is 35 percent and we require a return of 13 percent on this project. A) Calculate the best case operating cash...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT