NPV and IRR calculations
Cost of Capital1.00%
Time/yr012345
Cash flow Input here
Discounted CF000000
NPV0=cf1/((1+n)^1)=cf2/((1+n)^2)=cf3/((1+n)^3)=cf4/((1+n)^4)=cf5/((1+n)^5)
PV factor0.990099010.9802960490.9705901480.9609803440.951465688
IRR#NUM!