In: Finance
A company is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an economic life of five years. Depreciation is taken on a straight-line basis, with no expected salvage value. Net working capital required immediately is expected to be $100,000 and will be recovered in full upon the project's completion in five years. In the optimistic-scenario forecast, the annual sales volume is 53,400 units, while the sale price is $138 per unit with a variable cost of $76 per unit. Annual fixed costs are estimated to $1,164,000. If the appropriate discount rate is 12.50% and the tax rate 30%, what is the project's NPV?
Answer: | ||||||
Calculation of NPV | ||||||
Formula will will use here | ||||||
NPV = | Present value of Cash inflows - Initial cost | |||||
Project A | ||||||
Initial cost = | 1100000.00 | |||||
Year | 1 | 2 | 3 | 4 | 5 | |
Sales | 7369200 | 7369200 | 7369200 | 7369200 | 7369200 | |
Less: Cost | 4058400 | 4058400 | 4058400 | 4058400 | 4058400 | |
Gross profit | 3310800 | 3310800 | 3310800 | 3310800 | 3310800 | |
Less: Depreciation | 200000 | 200000 | 200000 | 200000 | 200000 | |
Less: Fixed cost | 1164000 | 1164000 | 1164000 | 1164000 | 1164000 | |
Profit before tax | 1946800 | 1946800 | 1946800 | 1946800 | 1946800 | |
Less: Tax | 681380 | 681380 | 681380 | 681380 | 681380 | |
Proft after tax | 1265420 | 1265420 | 1265420 | 1265420 | 1265420 | |
Add: Depreciation | 200000 | 200000 | 200000 | 200000 | 200000 | |
Add: Working capital | 0 | 0 | 0 | 0 | 100000 | |
Ne operating cash flow | 1465420 | 1465420 | 1465420 | 1465420 | 1565420 | |
PVF | 0.888889 | 0.790123 | 0.702332 | 0.624295 | 0.554929 | |
Present value | 1302595.56 | 1157862.72 | 1029211.30 | 914854.49 | 868696.89 | 5273220.95 |
Total | 14738400 | |||||
NPV of Project | ||||||
Present vallue of cash inflows | 5273220.95 | |||||
Less: Initial cost | 1100000.00 | |||||
NPV of the Project | 4173220.95 | (Answer) |