In this video, we look into the time value of money – annuities

Get 80% discount on all our courses (see links below) with this voucher

00:50 – Principles of Annuities
02:55 – The Special Case of Perpetuities
03:15 – Simple Annuity and Annuity Due
03:45 – Manual calculation of Annuities – Example
06:15 – Formula for Annuities
09:15 – Integrated formulas for Annuities
10:30 – Calculation Example
13:55 – Annuities applied in Excel
15:00 – Conclusions

An annuity is a special case of FV calculations where a set of identical equidistant (typically yearly) payments are made and the FV is calculated at the end of the period. A simple annuity is paid at the end of the period while an annuity due is paid at the beginning of the period.
Perpetuities are a special case of annuities where the number of periods considered is infinite.
Bases on the definition of the annuities, we can determine its formula or use the in excel integrated formula of FV:


rate = the periodic interest rate
nper = the number of periods considered
pmt = the periodic payments (has to be negative value)
[pv] = present value at the start of the period (if committed = 0)
[type] = 0 or 1, 0 = simple annuity, 1 = annuity due, if committed 0 is used

More about our online courses:

Apply our Voucher for 80% discount of public price:


Project Management Basics
Learn the basics about projects and project management in this 14.5 hour course and get yourself a head start over your colleagues and peers

PMP Preparation
Prepare for your PMP Certification with this preparation course. You will also get access to our set of exam questions once you subscribe.

Subscribe to this channel for more Project Management, Financial and Business content and leave a comment below if you have any questions.


Home Page

Follow me on FB for more Project Management tips and tricks:

#PMP #ProjectManagement #DeCeusterAcademy