Comparing two projects of different life spans

Inleiding tot financiële concepten in Python

Dakota Wixom

Quantitative Finance Analyst

Different NPVs and IRRs

Year Project 1 Project 2
1 -$100 -$125
2 $200 $100
3 $300 $100
4 N / A $100
5 N / A $100
6 N / A $100
7 N / A $100
8 N / A $100

Assume a 5% discount rate for both projects

Project comparison

NPV IRR Length
#1 362.58 200% 3
#2 453.64 78.62% 8

Notice how you could undertake multiple Project 1's over 8 years? Are the NPVs fair to compare?

Inleiding tot financiële concepten in Python

Equivalent Annual Annuity (EAA) can be used to compare two projects of different lifespans in present value terms.

Apply the EAA method to the previous two projects using the computed NPVs * -1:

import numpy as np
npv_project1 = 362.58
npv_project2 = 453.64
np.pmt(rate=0.05, nper=3, pv=-1*npv_project1, fv=0)

133.14

np.pmt(rate=0.05, nper=8, pv=-1*npv_project2, fv=0)

70.18

Project 1 has the highest EAA

Inleiding tot financiële concepten in Python

Let's practice!

Inleiding tot financiële concepten in Python

Preparing Video For Download...