Vandelay Industries is evaluating a project that costs $1,350,000 and has a 20 y
ID: 2715415 • Letter: V
Question
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%. a. (15 points) What is the project’s NPV? b. (5 points) What is the project’s payback period? c. (5 points) What is the project’s profitability index? d. (5 points) What is the project’s IRR? e. (5 points) Why might this company decide to pursue this project?
Explanation / Answer
50452.87
ear BTCF Tax ATCF ROR Present Value NPV Profitability Index 0 -1500000 35% -1500000 11% -1500000 -233941 -0.84 1 575600 35% 374140 11% 337063.06 Payback Period 2 955600 35% 621140 11% 504131.16 9.72 3 100600 35% 65390 11% 47812.60 4 100600 35% 65390 11% 43074.42 5 100600 35% 65390 11% 38805.78 6 100600 35% 65390 11% 34960.16 7 100600 35% 65390 11% 31495.64 8 100600 35% 65390 11% 28374.45 9 100600 35% 65390 11% 25562.57 10 100600 35% 65390 11% 23029.34 11 100600 35% 65390 11% 20747.16 12 100600 35% 65390 11% 18691.13 13 100600 35% 65390 11% 16838.86 14 100600 35% 65390 11% 15170.14 15 100600 35% 65390 11% 13666.79 16 100600 35% 65390 11% 12312.43 17 100600 35% 65390 11% 11092.28 18 100600 35% 65390 11% 9993.04 19 100600 35% 65390 11% 9002.74 20 300600 35% 195390 11% 24234.99 Year BTCF Tax ATCF IRR Present Value NPV 0 -1500000 35% -1500000 7.0042% -1500000 0.166259 1 575600 35% 374140 7.0042% 349649.83 2 955600 35% 621140 7.0042% 542485.14 3 100600 35% 65390 7.0042% 53371.43 4 100600 35% 65390 7.0042% 49877.89 5 100600 35% 65390 7.0042% 46613.02 6 100600 35% 65390 7.0042% 43561.86 7 100600 35% 65390 7.0042% 40710.42 8 100600 35% 65390 7.0042% 38045.63 9 100600 35% 65390 7.0042% 35555.26 10 100600 35% 65390 7.0042% 33227.92 11 100600 35% 65390 7.0042% 31052.91 12 100600 35% 65390 7.0042% 29020.27 13 100600 35% 65390 7.0042% 27120.68 14 100600 35% 65390 7.0042% 25345.44 15 100600 35% 65390 7.0042% 23686.40 16 100600 35% 65390 7.0042% 22135.95 17 100600 35% 65390 7.0042% 20686.99 18 100600 35% 65390 7.0042% 19332.88 19 100600 35% 65390 7.0042% 18067.40 20 300600 35% 195390 7.0042%50452.87
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.