In: Finance
A project has an initial requirement of $191013 for new equipment and $13286 for net working capital. The installation costs to get the new equipment in working condition are 3728. The fixed assets will be depreciated to a zero book value over the 5-year life of the project and have an estimated salvage value of $72103. All of the net working capital will be recouped at the end of the project. The annual operating cash flow is $94903 and the cost of capital is 7% What is the project's NPV if the tax rate is 25%? Enter your answer rounded off to two decimal points. Do not enter $ or comma in the answer box. For example, if your answer is $12.345 then enter as 12.35 in the answer box.
Year |
Cash outflows |
Cash inflows |
Depreciation = D = 194741/5 = 125,914.29 |
Net Working capital = NWC |
Net Cash flows = Cash outflow + NWC |
Discount factor = Df = 1/(1+Rate)^Year |
Present Values |
0 |
-194741.00 |
0.00 |
0.00 |
-13,286.00 |
-208,027.00 |
1.000000 |
-208,027.00 |
Co |
Ci |
D |
NWC |
Net Cash flow = (Co+Ci-D)x(1-25%)+D+NWC |
Df = 1/(1+7%)^Year |
Df x Net Cash flows |
|
1 |
94,903.00 |
38,948.20 |
80,914.30 |
0.934579 |
75,620.8056 |
||
2 |
94,903.00 |
38,948.20 |
80,914.30 |
0.873439 |
70,673.7053 |
||
3 |
94,903.00 |
38,948.20 |
80,914.30 |
0.816298 |
66,050.1813 |
||
4 |
94,903.00 |
38,948.20 |
80,914.30 |
0.762895 |
61,729.1149 |
||
5 |
167,006.00 |
38,948.20 |
13,286.00 |
148,277.55 |
0.712986 |
105,719.8173 |
|
Total = NPV = |
171,766.62 |
NPV = $171,766.62
Note:
Installation cost is included in Cash outflows for machine purchase and same is used for depreciation purposes.
Year 5: Cash inflows = Cash flow from operations + Sale proceeds of machine.