npv calculation
Post on 01-Oct-2015
218 Views
Preview:
DESCRIPTION
TRANSCRIPT
Sheet1
PVi=10%PV Variablei=10%NPV Cash Outflowi=10%NPV Cash Outflowi=25%YearsFVCFYearsFVCFYearsFVCFYearsFVCF1200181.8181818182110090.90909090910-250-2500-50-502200165.28925619832300247.93388429751200181.818181818213002403200150.26296018033600450.78888054092200165.289256198323001924200136.6026910734900614.71210982863200150.26296018033300153.65200124.184264611851200745.1055876714200136.6026910734300122.885200124.1842646118530098.304PV By Sum758.1573538817PV By Sum2149.4495532471By Sum508.1573538817By Sum756.784NPV Formula$758.16NPV Function$2,149.45NPV Function$508.16NPV Function$756.78PV Formula$758.16
PV of AnnunityPV of Infinite annuityAnnunity2000Annunity2000Periodic payment7Periodic payment7Discount rate18%Discount rate18%By Function-7,623.06 by Formula7623.0551866445
Sheet2
Sheet3
top related