In: Finance
Emperor’s Clothes Fashions can invest $5 million in a new plant for producing invisible makeup. The plant has an expected life of 5 years, and expected sales are 6 million jars of makeup a year. Fixed costs are $2.8 million a year, and variable costs are $1.40 per jar. The product will be priced at $3.00 per jar. The plant will be depreciated straight-line over 5 years to a salvage value of zero. The opportunity cost of capital is 14%, and the tax rate is 30%.
A. what is project NPV under these base-case assumptions
B. What is NPV if variable costs turn out to be $2.10 per jar
c.What is NPV if fixed costs turn out to be $2.6 million per
year?
d. At what price per jar would project NPV equal zero?
A. what is project NPV under these base-case assumptions
Sales Revenue | 18000000 |
Variable Cost | 8400000 |
Contribution | 9600000 |
Less Fixed Cost | 2800000 |
Net Income | 6800000 |
Less Tax 30% | 2040000 |
Add Tax Saving in Depreciation 5000000/5*.30 | 300000 |
Operating Cash flow | 5060000 |
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Initial Investment | -5000000 | |||||
Operating Cash flow | 5060000 | 5060000 | 5060000 | 5060000 | 5060000 | |
PV factor | 0.8772 | 0.7695 | 0.6750 | 0.5921 | 0.5194 | |
PV | -5000000 | 4,438,596.49 | 3,893,505.69 | 3,415,355.87 | 2,995,926.20 | 2,628,005.44 |
NPV | 12,371,389.70 |
B. What is NPV if variable costs turn out to be $2.10 per jar
Sales Revenue | 18000000 |
Variable Cost | 12600000 |
Contribution | 5400000 |
Less Fixed Cost | 2800000 |
Net Income | 2600000 |
Less Tax 30% | 780000 |
Add Tax Saving in Depreciation 5000000/5*.30 | 300000 |
Operating Cash flow | 2120000 |
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Initial Investment | -5000000 | |||||
Operating Cash flow | 2120000 | 2120000 | 2120000 | 2120000 | 2120000 | |
PV factor | 0.8772 | 0.7695 | 0.6750 | 0.5921 | 0.5194 | |
PV | -5000000 | 1,859,649.12 | 1,631,271.16 | 1,430,939.61 | 1,255,210.19 | 1,101,061.57 |
NPV | 2,278,131.65 |
c.What is NPV if fixed costs turn out to be $2.6 million per year?
Sales Revenue | 18000000 |
Variable Cost | 8400000 |
Contribution | 9600000 |
Less Fixed Cost | 2600000 |
Net Income | 7000000 |
Less Tax 30% | 2100000 |
Add Tax Saving in Depreciation 5000000/5*.30 | 300000 |
Operating Cash flow | 5200000 |
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Initial Investment | -5000000 | |||||
Operating Cash flow | 5200000 | 5200000 | 5200000 | 5200000 | 5200000 | |
PV factor | 0.8772 | 0.7695 | 0.6750 | 0.5921 | 0.5194 | |
PV | -5000000 | 4,561,403.51 | 4,001,231.15 | 3,509,851.88 | 3,078,817.44 | 2,700,717.05 |
NPV | 12,852,021.04 |
d. At what price per jar would project NPV equal zero?
Let = X Operating Cash Flow
0=-5000000+X*PVIFA 14% 5
=5,000,000/3.43308
Operating Cash Flow=1456417.73
Operating Cash Flow =(6000000*(Sales price-1.4)-2800000)*(1-.30)+5000000/5*0.3
1456417.73=(6000000*(Sales price-1.4)-2800000)*(1-.30)+5000000/5*0.3
Sales Price Per unit =2.142004