Present Value of Annuity – Excel Template

Ivan Kitov
Ivan Kitov

Annuities are common financial instruments that offer a level stream of regular payments lasting for a fixed number of periods. Common examples of annuities include retirement pensions, leases, and mortgages. The present value of an annuity refers to the value of these financial products discounted to the present day. You can use the template to calculate the present value of your investment, deposit, and obligation.

This open-access Excel template is a useful tool for bankers, investment professionals, corporate finance practitioners, and portfolio managers.

Present Value of Annuity is among the topics included in the Quantitative Methods module of the CFA Level 1 Curriculum. Gain valuable insights into the subject with our Math for Finance course.

You can also explore other related templates such as—Future Value of Annuity and NPV.