annuity_calculate.jpg

How do you calculate a present value of annuity using Excel?

A:

Calculating the present value of an annuity using Microsoft Excel is fairly straightforward. However, you have to know the annuity’s terms: its interest rate, payment amount and duration. Also, the assumption here is that you’re dealing with a fixed annuity.  Variable annuities offer a rate of return that fluctuates, usually in tandem with some stock market or money market index; this makes it difficult to value, as you’d have to guess at future rates.

Pricing a Fixed Annuity in Excel

The price of a fixed annuity is the present value of all future cash flows. In other words, what is the amount we must pay today in order to receive the stated rate of return for the duration of the annuity? For example, if we wanted to receive $1,000 per month for the next 15 years, and the stated annuity rate was 4%, what would this cost us?

Note: this calculation does not account for the income taxes due on the annuity payouts. (If the chart is hard to read, please right-click and choose “view image.”)

This is a paid-for submitted press release. BLOCKCHAINFEEDS DOES NOT ENDORSE, NOR IS RESPONSIBLE FOR ANY MATERIAL INCLUDED BELOW AND ISN’T RESPONSIBLE FOR ANY DAMAGES OR LOSSES CONNECTED WITH ANY PRODUCTS OR SERVICES MENTIONED IN THE PRESS RELEASE. BLOCKCHAINFEEDS URGES READERS TO CONDUCT THEIR OWN RESEARCH WITH DUE DILIGENCE INTO THE COMPANY, PRODUCT OR SERVICE MENTIONED IN THE PRESS RELEASE
Shares 0

Jackson Neo has written on money, investing and risk management for more than a decade. His current interests are cryptocurrencies, fintech, and micro-finance.