In: Finance
Last month, Lloyd's Systems analyzed the project whose cash flows are shown below. However, before the decision to accept or reject the project, the Federal Reserve took actions that changed interest rates and therefore the firm's WACC. The Fed's action did not affect the forecasted cash flows. By how much did the change in the WACC affect the project's forecasted NPV? Note that a project's projected NPV can be negative, in which case it should be rejected.
Old
WACC: 10.00% New
WACC: 11.25%
Year | 0 | 1 | 2 | 3 |
Cash flows | -$2,000 | $800 | $900 | $1,100 |
-$48.33 |
||
-$49.91 |
||
-$50.28 |
||
-$51.37 |
||
-$52.34 |
NPV as per WACC= 10% | |||
Year | Cash Flow | PV Factor | PV Of Cash Flow |
a | b | c=1/1.10^a | d=b*c |
0 | $ -2,000 | 1.000000 | $ -2,000.00 |
1 | $ 800 | 0.909091 | $ 727.27 |
2 | $ 900 | 0.826446 | $ 743.80 |
3 | $ 1,100 | 0.751315 | $ 826.45 |
NPV | $ 297.52 | ||
NPV as per WACC=11.25% | |||
Year | Cash Flow | PV Factor | PV Of Cash Flow |
a | b | c=1/1.11.25^a | d=b*c |
0 | $ -2,000 | 1.000000 | $ -2,000.00 |
1 | $ 800 | 0.898876 | $ 719.10 |
2 | $ 900 | 0.807979 | $ 727.18 |
3 | $ 1,100 | 0.726273 | $ 798.90 |
NPV | $ 245.18 | ||
Reduction in NPV =245.18-297.52 | |||
=-$52.34 | |||