A period certain annuity is a series of periodic payments for a given term, independent of any life contingency. This type of annuity can be calculated using Excel’s native PV function. More information is available here.
Excel Functions
|
Type
of Annuity |
Category |
Description |
|
Period certain |
Present value of a period certain annuity |
|
|
Period certain |
Present value of a period certain annuity -- simplified parameters with PPA
interest and mortality |
Related Topics
Excel Functions in EAC Tools
Complete list of functions
Single life functions
Joint life functions
Actuarial equivalence functions
Age, date, more functions
Defined contribution plan functions
Commutation functions
Interest rate functions
Life expectancy and survival functions
Life insurance functions
More PV functions
PVCO
PVCOPPA
Regulatory limits and other functions