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 pessimistic-scenario forecast, the annual sales volume is 24,300 units, while the sale price is $75 per unit with a variable cost of $37 per unit. Annual fixed costs are estimated to $690,000. If the appropriate discount rate is 9.50% and the tax rate 30%, what is the project's NPV?
|
-$178,763 |
|
|
-$183,232 |
|
|
-$187,701 |
|
|
-$192,170 |
|
|
-$196,639 |
Answer : Correct Option is - $178,763
Below is the table showing calculation of NPV
| Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| Initial Investment | 1000000 | |||||
| Annual Sales Revenue (24300*75) | 1822500 | 1822500 | 1822500 | 1822500 | 1822500 | |
| Variable Cost (24300*37) | 899100 | 899100 | 899100 | 899100 | 899100 | |
| Less : Fixed Cost | 690000 | 690000 | 690000 | 690000 | 690000 | |
| Less : Depreciation (1000000/5) | 200000 | 200000 | 200000 | 200000 | 200000 | |
| Earning before taxes | 33400 | 33400 | 33400 | 33400 | 33400 | |
| Taxes @ 30% | -10020 | -10020 | -10020 | -10020 | -10020 | |
| Earnings After Taxes | 23380 | 23380 | 23380 | 23380 | 23380 | |
| Add : Depreciation | 200000 | 200000 | 200000 | 200000 | 200000 | |
| Less : Increase in Working Capial | 100000 | |||||
| Add : Recapture of Working Capital | 100000 | |||||
| Operating Cash Flows | 1100000 | 223380 | 223380 | 223380 | 223380 | 323380 |
| PV Factor @ 9.50% | 1 | 0.913242 | 0.834011 | 0.761654 | 0.695574 | 0.635228 |
| PV of Net Cash flows (Inflow) | 204000 | 186301.4 | 170138.2 | 155377.4 | 205419.9 | |
| PV of Net Cash flows (Outflow) | 1100000 | |||||
| The net present value (NPV) of this project is | = - $ 178763.0847 or - $ 178763 | |||||
| NPV = PV of cash inflow - PV of cash outflow | ||||||
| = 921236.9153- 1100000 | ||||||
| = - $ 178763.0847 or - $ 178763 |