Present Value Annuity
Use this template to calculate the present value of an annuity, interest earned on an annuity, and the number of periods. You can specify if you are working with an Ordinary Annuity (payments made at the end of the year) or an Annuity Due (payments at the beginning of the year). To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.
Copyright © KMT Software, Inc. All Rights Reserved.
Present Value of an Annuity
Enter 1 if Ordinary Annuity, Enter 2 if Annuuty Due Payment Per Period Number of Periods Interest Rate Per Period (per n periods) The present value of the annuity is:
Calculating an Interest Rate
Payment Per Period Present Value Number of Periods (n) The interest rate per period is:
Calculating the Number of Periods
Payment Per Period Present Value Interest Rate Per Period (per n periods) The number of periods is: