Present Value of Annuity Due – Excel Template

Ivan Kitov
Ivan Kitov

Annuities due offer a level stream of regular payments lasting for a fixed number of periods, such as rent, car payments and insurance expenses. With annuity due, cash flows occur at the beginning of each compounding period. Use this template to calculate the present value of a series of expected annuity payments, paid at the beginning of the period.

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

Present Value of Annuity Due 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—Present Value of Annuity, Future Value of Annuity, and Present Value of Perpetuity.

Top