How to Calculate Future Value and Present Value Interest Factors

The concept of future value and present value interest factors is an important one to understand when you begin to calculate future and present values which take into account more complex forms of taxation.

For instance, to determine the future value of an account that taxes interest or dividends on an annual basis at some specified rate would require you to calculate the future value interest factor using a formula that solves for such method of taxation.

Before the age of calculators and computers, solving future value and present value equations required the use of interest factor tables. Fortunately, solving for the factors is easier than in sounds.

The future value interest factor (FVIF) is simply the quantity that the present value is compounded by:

future value interest factor formula

Let’s construct a future value interest factor table using an assumed annual rate of 7%:

Rate
2.00%3.00%4.00%5.00%6.00%7.00%
Year
11.02001.03001.04001.05001.06001.0700
21.04041.06091.08161.10251.12361.1449
31.06121.09271.12491.15761.19101.2250
41.08241.12551.16991.21551.26251.3108
51.10411.15931.21671.27631.33821.4026
61.12621.19411.26531.34011.41851.5007
71.14871.22991.31591.40711.50361.6058
81.17171.26681.36861.47751.59381.7182
91.19511.30481.42331.55131.68951.8385
101.21901.34391.48021.62891.79081.9672
future value interest factor table

Let’s assume you wanted to calculate the future value interest factor for an investment that will grow at 7% for ten years, plugging those values into the future value interest factor equation will yield the following:

where; r = 0.07, n = 10

Using the table above and finding the area where n = 10 and r = 7% intersect indicates that the FVIF is 1.9672. Any dollar amount multiplied by the FVIF of 1.9672 will yield the future value of an investment that grew at 7% for ten years.

Present value interest factors (PVIF) are simply the inverse of FVIFs:

present value interest factor formula

We can construct a PVIF table in the same manner:

Rate
2%3%4%5%6%7%
Year
10.98040.97090.96150.95240.94340.9346
20.96120.94260.92460.90700.89000.8734
30.94230.91510.88900.86380.83960.8163
40.92380.88850.85480.82270.79210.7629
50.90570.86260.82190.78350.74730.7130
60.88800.83750.79030.74620.70500.6663
70.87060.81310.75990.71070.66510.6227
80.85350.78940.73070.67680.62740.5820
90.83680.76640.70260.64460.59190.5439
100.82030.74410.67560.61390.55840.5083
present value interest factor table

Notice, if you multiply any FVIF by its corresponding PVIF the product of the two numbers will equal one:

FVIF * PVIF

Using an HP12C calculator, we can solve for the FVIF in the example above using the following keystrokes:

hp12c

[1][.][0][7][ENTER]
[10][y^x]

The Excel model for FVIF and PVIF table construction can be found here.

How to Calculate the Future Value of a Tax-Deferred Account

Recall, that the formula utilized to calculate the future value of a lump sum is as follows:

future value formula

Where:
FV = Future Value
PV = Present Value
r = rate
n = periods

Calculating the future value of a tax-deferred account incorporates the tax paid on the money when it is withdrawn during the final period. We can account for the taxes paid by adjusting the present value after it has been compounded by the specified rate and number of periods:

future value of a tax-deferred account

The addition of the quantity (1 – t) adjusts the future value in the final period by the tax that is owed.

Assume you have a present value of $1,000, the will grow at a rate of 7% for ten years, with an assumed tax rate of 30%. Plugging those values into the formula will yield the following:

where; PV = $1,000, rate = 0.07, n = 10, t = 30%

Using Excel, we can model what happens during each of the ten periods:

Year PV rate FV Tax (30%)
1 $ 1,000.007% $ 1,070.00
2 $ 1,070.007% $ 1,144.90
3 $ 1,144.907% $ 1,225.04
4 $ 1,225.047% $ 1,310.80
5 $ 1,310.807% $ 1,402.55
6 $ 1,402.557% $ 1,500.73
7 $ 1,500.737% $ 1,605.78
8 $ 1,605.787% $ 1,718.19
9 $ 1,718.197% $ 1,838.46
10 $ 1,838.467% $ 1,967.15
Tax $ 590.15
Net ATFV $ 1,377.01
future value of a tax-deferred account table

Notice how the tax is paid during the final period. In the United States, this is how the future value of a Traditional IRA would be calculated. We can represent the table above visually with the following chart:

future value of a tax-deferred account chart

Using an HP12C calculator, we can calculate the future value of a tax-deferred account with the following keystrokes:

hp12c

[1000][PV]
[7][i]
[10][n][FV]
[.][7][*]

The formula can be rearranged as follows to find the present value of a tax-deferred account:

present value of a tax-deferred account formula

The present value of a tax-deferred account formula is usually only seen on tests which require you to calculate the present value of a tax-deferred account based on an initial investment an investor made in the past, given some current value in the future.

A copy of the Excel model can be found here.

How to Calculate the Future Value of a Tax-Free Account

Recall, that the formula utilized to calculate the future value of a lump sum is as follows:

future value formula

Where:
FV = Future Value
PV = Present Value
r = rate
n = periods

Calculating the future value of a tax-free account incorporates the tax paid on the money prior to investing it in the tax-free account. We can account for the taxes paid by adjusting the present value for taxes:

future value of a tax-free account

In essence, the present value is reduced by the tax owed today and becomes the net amount invested. This net amount is then grown tax-free through all periods and no tax liability is owed when the money is withdrawn.

Assume you have a present value of $1,000, that will grow at a 7% rate for 10 years, and the initial tax owed is 30%. We can calculate the future value of the tax-free account by plugging those variables into the formula as follows:

where; PV = $1,000, rate = 0.07, n = 10, t = 30%

Using Excel, we can model what occurs during each of the ten periods:

Year PV rate FV 
1 $    700.007.00% $    749.00
2 $    749.007.00% $    801.43
3 $    801.437.00% $    857.53
4 $    857.537.00% $    917.56
5 $    917.567.00% $    981.79
6 $    981.797.00% $ 1,050.51
7 $ 1,050.517.00% $ 1,124.05
8 $ 1,124.057.00% $ 1,202.73
9 $ 1,202.737.00% $ 1,286.92
10 $ 1,286.927.00% $ 1,377.01
future value of a tax-free account table

Notice how the initial present value is reduced by the current tax rate. In the United States, this is how the future value of a Roth IRA would be calculated. We can illustrate the table above visually with the following chart:

future value of a tax-free account chart

Using an HP12C calculator, you can calculate the future value of a tax-free account using the following keystrokes:

hp12c

[1000][ENTER]
[.][7][*][PV]
[7][i]
[10][n]
[FV]

The formula can be rearranged as follows to find the present value of a tax-free account:

present value of a tax-free account

The present value version of the tax-free account formula is usually only seen on tests which require you to calculate the initial investment an investor made in the past, given some current value in the future.

A copy of the Excel model can be found here.

Traditional IRAs vs Roth IRAs

Many people are familiar with the different tax treatment between Traditional IRAs and Roth IRAs; unfortunately, often times most individuals are not sure which contribution type is right for them.

Typically, advocates for either type of IRA tend to elect 100% of their annual contribution limits towards their IRA flavor of choice.

Ultimately, if taxes never changed then mathematically it makes zero difference if you elected Traditional IRA or Roth IRA contributions, the ending balances would be the same.

Recall, that the future value of a present value today can be solved for with the following formula:

future value formula

Where:
FV = Future Value
PV = Present Value
r = rate
n = period

In order to determine the after-tax value of a Traditional IRA or a Roth IRA, a new quantity for taxes is added. The key difference is the order that the taxes are taken out, which becomes clearer when comparing the two formulas. Here is the formula for the after-tax value of a Traditional IRA:

after-tax value of traditional IRA

Where:
t = taxes

Comparatively, here is the formula for the after-tax value of a Roth IRA (which can also be referred to as the future value of a tax-free account):

after-tax value of roth IRA

Notice how the quantity (1 – t) is moved to the front of the equation, which makes sense given that Roth IRA contributions are taxed up front, and the remaining amount is invested. Since multiplication is cumulative, then the ending balances after paying taxes should be identical between both accounts.

Let’s assume that you invest $1,000 in a Traditional IRA growing at a rate of 7.00% for 10 years, when you retire your marginal tax bracket is 30%. Plugging those values into the formula for a Traditional IRA would yield the following:

where; PV = $1,000, rate = 0.07, n = 10, t = 30%

Your initial $1,000 contribution grew tax free for 10 years, and after paying a 30% tax in the tenth year you are left with $1,377.01. The table below illustrates the tax free growth for 10 years, the tax paid, and the net after-tax future value:

Traditional IRA
Year PV RateFVTax (30%)
1 $  1,000.007.00% $            1,070.00
2 $  1,070.007.00% $            1,144.90
3 $  1,144.907.00% $            1,225.04
4 $  1,225.047.00% $            1,310.80
5 $  1,310.807.00% $            1,402.55
6 $  1,402.557.00% $            1,500.73
7 $  1,500.737.00% $            1,605.78
8 $  1,605.787.00% $            1,718.19
9 $  1,718.197.00% $            1,838.46
10 $  1,838.467.00% $            1,967.15
TAX $  590.15
Net ATFV $            1,377.01
traditional IRA table

We can represent the data above in the following chart:

traditional IRA ATFV

Let’s plug the same values into the Roth IRA formula to prove that they are identical:

where; PV = $1,000, rate = 0.07, n = 10, t = 30%

Despite starting with a lower initial investment since the tax with Roth IRA contributions are paid up front, the ending value is still identical to the Traditional IRA account:

Roth IRA
Year PV RateFVTax (30%)
1 $     700.007.00% $     749.00
2 $     749.007.00% $     801.43
3 $     801.437.00% $     857.53
4 $     857.537.00% $     917.56
5 $     917.567.00% $     981.79
6 $     981.797.00% $  1,050.51
7 $  1,050.517.00% $  1,124.05
8 $  1,124.057.00% $  1,202.73
9 $  1,202.737.00% $  1,286.92
10 $  1,286.927.00% $  1,377.01
TAX $           –  
Net ATFV $  1,377.01
roth IRA table
roth IRA ATFV

To reiterate, if your marginal tax bracket in the future is identical to your marginal tax bracket today, there is zero difference between a Traditional IRA and a Roth IRA (there may be a perceived difference due to emotional or cognitive biases).

Obviously, the future state of taxation is a huge assumption to make and the world is not that simple. There are a multitude of additional variables and factors that need to be taken into account in order to determine what blend between Traditional IRA or Roth IRA contributions makes the most financial sense for you.

Since there are exactly zero people on the planet who can accurately predict what the marginal tax brackets will look like when you retire (I’d be skeptical of anyone claiming that they can), having money in both account types will provide you with the maximum flexibility in determining your actual tax bracket when you retire.

Remember that the next time anyone says, “Roth IRAs are better than Traditional IRAs so I put 100% of my annual contribution limits into my Roth IRA”, or vice versa. Generalized advice, generally has good intentions, but produces generally bad outcomes, generally speaking.

Taxes aren’t the only variable that should be taken into account when determining the optimal Traditional IRA and Roth IRA blend. One should also consider the following:

  • what will your burn rate be when you retire
  • what will your projected federal tax bracket be
  • do you pay state income taxes
  • will you move to a state that has no income taxes
  • will you move to a state that does have an income tax
  • what is your current blend of qualified vs non-qualified assets
  • what proportion of your employer matching contributions into any qualified plans is made on your behalf

The list above, while somewhat lengthy, is nowhere near exhaustive despite the potential to get exhausted while thinking about it.

All of the concepts above are also applicable to the world of 401(k)s. From a taxation standpoint, Traditional IRAs (which are a type of qualified accounts) are taxed identically to Traditional 401(k) contributions. Similarly, Roth IRAs are taxed identically to Roth 401(k) contributions.

Other important subtleties that you should be aware of for Roth IRAs and Roth 401(k)s are the lack of required minimum distributions. RMDs do not apply to Roth IRAs or Roth 401(k)s which make them an extremely potent estate planning wealth transfer tool.

In my opinion, the best kept secret about Roth 401(k) contributions are the fact that the income limitations that apply to Roth IRAs, do not apply to Roth 401(k) contributions. You could make $1mm dollars a year and still contribute the IRS maximum into a Roth 401(k).

If you don’t have a Traditional IRA or a Roth IRA you can open one at Charles Schwab for commission free trading with an initial funding bonus of up to $500 by clicking here.

How to Calculate Present Value

The formula used to discount a future value to a present value today is as follows:

present value formula

Where:

PV = Present Value
FV = Future Value
r = rate
t = time

Assume you would like to have a future lump sum of $10,000. How much would you have to invest today, if the initial contribution grew at required rate of 7.00% for five years? Plugging those values into the formula would yield the following:

FV = $10,000; r = 0.07; t = 5

The amount that is required today, in order to have $10,000 in the future will decrease as a function of either a longer time-frame, or a higher discount rate. Using Excel, we can model the amounts required given a specific time-frame or rate:

Year FV rate PV 
5 $ 10,000.007.00% $ 7,129.86
10 $ 10,000.007.00% $ 5,083.49
15 $ 10,000.007.00% $ 3,624.46
20 $ 10,000.007.00% $ 2,584.19
25 $ 10,000.007.00% $ 1,842.49
30 $ 10,000.007.00% $ 1,313.67
present value table

The data can be represented visually as well:

present value chart

Viewing the chart above, you can see that the initial investment required today, decreases exponentially as a function of time.

Using an HP12C calculator, the present value can be calculated using the following keystrokes:

HP12C

[10,000][FV]
[7][i]
[5][n]
[PV]

A copy of the Excel model can be found here

How to Calculate Future Value

The formula used to calculate the future value of a present amount today, is as follows:

future value formula
future value formula

Where:
FV = Future Value
PV = Present Value
r = interest rate
t = time

Assume you have a present value (PV) of $1,000, growing at a rate (r) of 7.00% for ten years (t), the future value would be calculated as follows:

PV = $1,000; r = 7.00%; t = 10

Using Excel, we can model the amount of interest that is credited at the end of each year:

Year Present Value rateinterestFuture Value
1 $         1,000.007.00% $   70.00 $    1,070.00
2 $         1,070.007.00% $   74.90 $    1,144.90
3 $         1,144.907.00% $   80.14 $    1,225.04
4 $         1,225.047.00% $   85.75 $    1,310.80
5 $         1,310.807.00% $   91.76 $    1,402.55
6 $         1,402.557.00% $   98.18 $    1,500.73
7 $         1,500.737.00% $ 105.05 $    1,605.78
8 $         1,605.787.00% $ 112.40 $    1,718.19
9 $         1,718.197.00% $ 120.27 $    1,838.46
10 $         1,838.467.00% $ 128.69 $    1,967.15
FV table

The data can be represented visually as well:

future value chart
future value chart

As you can see, the amount of interest credited at the end of each year grows on an exponential basis.

Using an HP12C, the future value can be calculated using the following keystrokes:

hp12c

[1000][PV]
[10][n]
[7][i]
[FV]

A copy of the Excel model used to calculate future value can be found here.