How do I calculate Cumulative PV in ExcelSolutionyou can use

How do I calculate Cumulative PV in Excel?

Solution

you can use NPV function in excel to calculate cumulative PV.

NPV Excel formula= NPV(discount rate, value1, value 2...)

Here discount rate is the rate which future cash flow is to be discounted. Value are the cash flow antcipated in future years.