Future Value of an Annuity Due: Definition and How to Calculate It

Future value (FV) of an annuity due measures the amount of money that you will receive in the future at a given interest rate and timeframe with a certain level of the invested money.

In this article, we cover the definition of the future value of an annuity due as well as how to calculate it using both the future value of an annuity due table and an Excel spreadsheet.

What is Future Value of an Annuity Due?

Before we understand the future value of an annuity due, first, we want to go through the basic definition of an annuity.

Annuity refers to the level of an equal periodic stream of cash flows over a specified period of time both cash inflows and cash outflows. The annuity of cash inflows is the periodic equal return on investment at a given interest rate and timeframe. While the annuity of cash outflows refers to the periodic equal cash outflows of funds invested in order to earn future returns.

Now, you know the basic understanding of annuity. So, next, we will go into detail about the FV of an annuity due with the example calculation.

There are two types of annuities that you should be aware of. These are ordinary annuity and annuity due. An ordinary annuity refers to the annuity with the cash flows occur at the end of each period.

However, for an annuity due, the cash flows occur at the beginning of each period. Thus, the future value of an annuity due refers to the periodic equal future value of cash flows occur at the beginning of each period.

How to Compute the Future Value of An Annuity Due?

In order to calculate the future value of an annuity due, we can simply use the future value interest factors of an ordinary annuity with an annuity due to converting into future value interest factors for an annuity due. Below is the formula to convert this interest factor for an ordinary annuity to future value interest factors of an annuity due:

FVIFA i , n (annuity due) = FVIFA i, n × (1+i)

Then, we can calculate the FV of an annuity due as follows

FVA n = PMT × FVIFA i, n (annuity due)

Where:

READ:  Bond Immunization - How Does It Work?

FVIFA = Future value interest factors

FVA = Future value of an annuity due

PMT = Periodic or annual cash flows

The basic reason for converting the future value interest factors of an ordinary annuity is that each cash flow of an annuity due earns interest one year more than an ordinary annuity. This is because the annuity due takes into account the interest at the beginning of the period.

Therefore, by multiplying the future value interest factors of an ordinary due by (1+i), that means we add one more year of interest to each annuity cash flow.

Example

Peter is considering two annuities; ordinary annuity and annuity due. Both annuity A and B have five years with yearly cash flows of $1,000 (annuity). The annual interest for these two annuities is 8%. Below table is the summary of the two annuities:

End of yearAnnuity A (Annuity Due
US$
Annuity B (Ordinary Annuity)
US$
1,000
11,0001,000
21,0001,000
31,0001,000
41,0001,000
51,000
Total5,0005,000

Calculate the FV of an annuity due and ordinary due. Which one provides higher returns at the end of year 5?

Solution:

First, let’s calculate the future value of an annuity due A as follows:

Before we can calculate the FV of an annuity due (A), we need to calculate the future value interest factors of an annuity due by using the below formula:

FVIFA i , n (annuity due) = FVIFA i, n × (1+i)

Where:

FVIFA = 5.867 (From the future value of an ordinary annuity table).

i = 8%

n = 5

Therefore, FVIFA 8%,5 yrs = 5.867 × (1+0.08) = 6.336

READ:  Plain Vanilla Bond: Definition and How It Works

So, we can substitute FVIFA of 6.336 into the below formula:

FVA (A) = PMT × FVIFA i, n (annuity due)

Hence, FVA (A) = 1,000 × 6.336 = $6,336.36

Therefore, the FVA (A) = $6,336.36.

We can also calculate the future value of an annuity due (A) by using the spreadsheet Excel as per the screenshot below:

Future Value of an Annuity Due

You can follow the illustration as per the calculation above to develop your own Excel spreadsheet calculation.

The small difference is due to the rounding.

Now, we can calculate the FV of an ordinary annuity B by using the formula below:

FVA (B) = PMT × FVIFA i, n

Where:

FVIFA 8%, 5 yrs = 5.867

Therefore, FVA (B) = 1,000 × 5.867 = $5,867

Hence, the FVA (A) is greater than the ordinary annuity B.

Future Value of an Annuity Due Vs Future Value of an Ordinary Annuity

The FV of an annuity due is always higher than an ordinary annuity. This is because an annuity due gets one year more interest than an ordinary annuity.

As you can see from the calculation above, FVA (A) is $6,336.36 while FVA (B) is only $5,867. FVA (A) is $469 greater than FVA (B).

This is because the cash flow of the annuity due occurs at the start of each period while the ordinary annuity occurs at the end of each period.

How to Get Future Value of an Annuity Due Table?

As you are aware, to get the future value interest factors of an annuity due, we need to multiply the future value interest factors of an ordinary annuity by (1+i). Thus, we need to know the FVIFA of an ordinary first.

READ:  Capitalization-Weighted Index: What Is It and How to Calculate?

Using Future Value of an Ordinary Annuity Table to Convert:

The FVIFA of an ordinary annuity can be taken from the future value of an ordinary annuity table.

We can generate the future value interest of an ordinary annuity table by using the formula below: FVIFA = ((1+i)n -1)/i

By using the formula above, we can generate the future value of an ordinary due table as below:

You can also see the formula in Excel in order to produce the future value of an ordinary annuity table as follows:

Screenshot Formula of FVIFA - Ordinary Annuity
Period1%2%3%4%5%6%7%8%9%10%
11.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
22.0102.0202.0302.0402.0502.0602.0702.0802.0902.100
33.0303.0603.0913.1223.1533.1843.2153.2463.2783.310
44.0604.1224.1844.2464.3104.3754.4404.5064.5734.641
55.1015.2045.3095.4165.5265.6375.7515.8675.9856.105
66.1526.3086.4686.6336.8026.9757.1537.3367.5237.716
77.2147.4347.6627.8988.1428.3948.6548.9239.2009.487
88.2868.5838.8929.2149.5499.89710.26010.63711.02811.436
99.3699.75510.15910.58311.02711.49111.97812.48813.02113.579
1010.46210.95011.46412.00612.57813.18113.81614.48715.19315.937
1111.56712.16912.80813.48614.20714.97215.78416.64517.56018.531
1212.68313.41214.19215.02615.91716.87017.88818.97720.14121.384
1313.80914.68015.61816.62717.71318.88220.14121.49522.95324.523
1414.94715.97417.08618.29219.59921.01522.55024.21526.01927.975
1516.09717.29318.59920.02421.57923.27625.12927.15229.36131.772

Then, to get the future value interest factors of an annuity due, we just simply convert the data in the table above by multiplying with (1+i).

Generate the Future Value of an Annuity Due Table Directly:

We can also generate the future value of an annuity due table directly as well by using the formula below:

FVIFA of an annuity due = [((1+i)n -1))/i] × (1+i)

Therefore, by using the formula above, we can produce the future value of an annuity due table as below:

Screenshot of FVIFA - Annuity Due
Period1%2%3%4%5%6%7%8%9%10%
11.0101.0201.0301.0401.0501.0601.0701.0801.0901.100
22.0302.0602.0912.1222.1532.1842.2152.2462.2782.310
33.0603.1223.1843.2463.3103.3753.4403.5063.5733.641
44.1014.2044.3094.4164.5264.6374.7514.8674.9855.105
55.1525.3085.4685.6335.8025.9756.1536.3366.5236.716
66.2146.4346.6626.8987.1427.3947.6547.9238.2008.487
77.2867.5837.8928.2148.5498.8979.2609.63710.02810.436
88.3698.7559.1599.58310.02710.49110.97811.48812.02112.579
99.4629.95010.46411.00611.57812.18112.81613.48714.19314.937
1010.56711.16911.80812.48613.20713.97214.78415.64516.56017.531
1111.68312.41213.19214.02614.91715.87016.88817.97719.14120.384
1212.80913.68014.61815.62716.71317.88219.14120.49521.95323.523
1313.94714.97416.08617.29218.59920.01521.55023.21525.01926.975
1415.09716.29317.59919.02420.57922.27624.12926.15228.36130.772
1516.25817.63919.15720.82522.65724.67326.88829.32432.00334.950

Conclusion

To sum up, the future value of an annuity due is a future stream of equal periodic cash flows occurs at the beginning of each period. It provides a higher future return as compare to the future value of an ordinary annuity.

Scroll to Top