## How To Calculate Annuity Present Value In Excel?

For example, if you wanted to calculate the present value of a future annuity with a 5% interest rate for 12 years and a $1000 yearly payment, you would use the following formula: =PV (.05,12,1000). You’d end up with a present value of $8,863.25. It’s vital to remember that the “NPER” figure in this calculation …

How To Calculate Annuity Present Value In Excel? Read More »