Xyz company is confronted with two mutually-exclusive investment opportunities
You can calculate the NPV of each investment using this formula.
NPV = CF0 + (CF1/(1+r)) + (CF2/(1+r)^2) + … + (CFn/(1+r)^n).
Where r is cost of Capital and CF represents Cash Flows in a specific year. We have the following for Project A:
(60k/ 1+0.12) + 60k/ 1+0.122 + 60k/ 1+0.123 + 30k/ 1+0.124 + $30k/ 1+0.124 + $30k/ 1+ 0.125 + $30,000/ 1+ 0.126
Therefore, the NPV is -$24 553.
Project B has:
The NPV is -$100,000+$30 000/( 1+.012 $ 30 000/( 1+.012 $300 000/( 1+.012 $50 000/( 1+.012 $60 000/( 1+.012 )2 )+$30 000/( 1+.012 $ 30000/( HTML0 ) + HTML0 )+.0)
The NPV of Project B is therefore -$50 872