By excel tips and tricks from pryor com november 13 2014 categories advanced excel tags annuity formula excel for anyone working in finance or banking the time value of money is one topic that you should be fluent in knowing exactly what it means to discount something or to get the future value of a particular investment vehicle is necessary to.

Present value calculator in excel present value of annuity when putting deposits to a saving account paying home mortgage and the like you usually make the same payments at regular intervals e g weekly monthly quarterly or yearly such series of payments either inflow or outflow made at equal intervals is called an annuity.

An ordinary annuity is a series of equal payments made at the end of consecutive periods over a fixed length of time an example of an ordinary annuity includes loans such as.