Question

In: Finance

Vandelay Industries is evaluating a project that costs $1,350,000 and has a 20 year life. Depreciation...

Vandelay Industries is evaluating a project that costs $1,350,000 and has a 20 year life. Depreciation will be straight-line to zero over the life of the project. Management believes they will be able to sell the equipment at the end of the project for $50,000. Sales are projected to be 50,000 units in the first year, 70,000 units in the second year, and 25,000 units for all additional years. Price per unit is $34.50, variable cost per unit is $15.50 and fixed costs are $300,000 per year. The project also requires an initial investment in net working capital of $150,000 and for the project to maintain a net working capital balance equal to $150,000 plus 15% of sales while the project is ongoing. All net working capital will be recouped at the end of the project. This project will have an additional spillover effect that will impact existing sales negatively. The net pre-tax impact of the spillover effect will be -$75,000 per year. This project will also have a positive spillover effect. Specifically, the project will generate additional sales of 100 units of an existing product at a price of $15 each. The existing product has variable costs of $9 and fixed costs of $5,000 per year. The company’s marginal tax rate is 35%. The required return on similar projects is 11%.

1) What is the project’s NPV?

2) What is the project’s payback period?

3) What is the project’s profitability index?

4) Why might this company decide to pursue this project?

Please show all steps clearly. Thank you.

Solutions

Expert Solution

Year Sales Voume Sales Value@(34.5-15.5)=19 Less F.C Negative Spill over Positive Spill over @100(15-9)+5000 p.yr Less: Annual Depreciation Taxable Income Tax @ 35% After tax income Add: Tax shield due to depn. Cash flow Add:NWC@ 15% *Sales Net Annual Cash flow PV F @ 11% PV @ 11% COC
0-Initial Cost -1350000 -1350000 -1350000 -1350000 1 -1350000
0- NWC Introd -150000 -150000 -150000 -150000 1 -150000
1 50000 950000 300000 75000 5600 65000 515600 180460 335140 22750 357890 -142500 215390 0.9009 194044.851
2 70000 1330000 300000 75000 5600 65000 895600 313460 582140 22750 604890 -199500 405390 0.81162 329022.632
3 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.73119 -16166.611
4 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.65873 -14564.52
5 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.59345 -13121.18
6 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.53464 -11820.89
7 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.48166 -10649.503
8 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.43393 -9594.1923
9 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.39092 -8643.2412
10 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.35218 -7786.6998
11 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.31728 -7015.0608
12 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.28584 -6319.9224
13 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.25751 -5693.5461
14 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.23199 -5129.2989
15 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.209 -4620.99
16 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.18829 -4163.0919
17 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.16963 -3750.5193
18 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.15282 -3378.8502
19 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.13768 -3044.1048
20 25000 475000 300000 75000 5600 65000 40600 14210 26390 22750 49140 -71250 -22110 0.12403 -2742.3033
20 sale of Equipment 50000 50000 17500 32500 32500 32500 0.12403 4030.975
Recovery of all WC 150000+1624500(NO TAX) 1774500 1774500 1774500 1774500 1774500 0.12403 220091.235
Net Cash flows &NPV of the project 529800 -891014.83
-1624500
Annual Deprciation
(1350000-50000)/20   =0000000000000000
Alternate Method
Initial investment @ year 0                               -1350000
Initial NWC @ year 0                                                  150000 -150000
PV of year 1 Net cash flow- 215390*0.9009 194044.85 Detaiils as per table
PV of year 2 Net cash flow- 405390*0.81162 329022.63 Detaiils as per table
PV of years (3 to 20) Net cash flow 22110*6.25077 -138204.52 Detaiils as per table
PV of sale value 50000*0.65*0.12403 4030.98
PV of release of NWC 1774500 * 0.12403 220091.24
Net Present Value0 -891014.83
0

NPV OF THE PROJECT IS NEGATIVE


Related Solutions

Vandelay Industries is evaluating a project that costs $1,350,000 and has a 20 year life. Depreciation...
Vandelay Industries is evaluating a project that costs $1,350,000 and has a 20 year life. Depreciation will be straight-line to zero over the life of the project. Management believes they will be able to sell the equipment at the end of the project for $50,000. Sales are projected to be 50,000 units in the first year, 70,000 units in the second year, and 25,000 units for all additional years. Price per unit is $34.50, variable cost per unit is $15.50...
Vandelay Industries is evaluating a project that costs $1,350,000 and has a 20 year life.  Depreciation will...
Vandelay Industries is evaluating a project that costs $1,350,000 and has a 20 year life.  Depreciation will be straight-line to zero over the life of the project. Management believes they will be able to sell the equipment at the end of the project for $50,000.  Sales are projected to be 50,000 units in the first year, 70,000 units in the second year, and 25,000 units for all additional years.  Price per unit is $34.50, variable cost per unit is $15.50 and fixed costs...
Tank Co. is evaluating a project that costs $120000, has a 5-year life. Assume that depreciation...
Tank Co. is evaluating a project that costs $120000, has a 5-year life. Assume that depreciation is prime-cost to zero salvage value over the 5-years, and the equipment can be sold for $6,000 at the end of year 5. The average discount rate for such project is 10 per cent on such projects. The individual tax rate is 15 per cent and corporate tax rate is 30 per cent. It is projected that they will sell 12000 units per year....
We are evaluating a project that costs $800,000, has an eight-year life, and has 20% salvage...
We are evaluating a project that costs $800,000, has an eight-year life, and has 20% salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 70,000 units per year. Price per unit is $40, variable cost per unit is $30, and fixed costs are $725,000 per year. The tax rate is 40 percent, and we require a 15 percent return on this project. a) Calculate the accounting break-even point. b) Calculate...
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 $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....
A firm is evaluating a project that costs RM450m, has a five-year life and has a...
A firm is evaluating a project that costs RM450m, has a five-year life and has a salvage value of RM3m. Assume that depreciation is straight line with zero residual value over the life of the project. Working capital of RM35m is needed initially and the same will be released in the final year. Sales are projected at 555,000 units per year with a selling price of RM505 per unit, variable cost RM315 per unit, and fixed costs are RM1,325,000 per...
A) We are evaluating a project that costs $111518, has a seven-year life, and has no...
A) We are evaluating a project that costs $111518, has a seven-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 4266 units per year. Price per unit is $51, variable cost per unit is $24, and fixed costs are $83124 per year. The tax rate is 39 percent, and we require a 13 percent return on this project. Suppose the projections given for price, quantity,...
A) We are evaluating a project that costs $115571, has a seven-year life, and has no...
A) We are evaluating a project that costs $115571, has a seven-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 4293 units per year. Price per unit is $45, variable cost per unit is $25, and fixed costs are $81427 per year. The tax rate is 35 percent, and we require a 8 percent return on this project. Suppose the projections given for price, quantity,...
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,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT