**Table of Contents**

## What is Time Value of Money Formula?

The formula for the time value of money either discounts the future value of money to present value or compounds the present value of money to future value.

Mathematically, the time value of money formula it is represented as below,

**FV = PV * (1 + i/n )**

^{n*t}or PV = FV / (1 + i/n )^{n*t}where,

- FV = Future value of money,
- PV = Present value of money,
- i = Rate of interest or current yield on similar investment,
- t = Number of years and
- n = Number of compounding periods of interest per year

### Steps to Calculate Time Value of Money

The formula for the time value of money can be calculated by using the following steps:

**Step 1:** Firstly, try to figure out the rate of interest or the rate of return expected from a similar kind of investment based on the market situation. Please note that the rate of interest mentioned here is not the effective rate of interest but the annualized rate of interest. It is denoted by *‘ i*’.

**Step 2:** Now, the tenure of the investment in terms of number years has to be determined i.e. for how long the money is going to remain invested. The number of years is denoted by *‘ t*’.

**Step 3:** Now, the number of compounding periods of interest per year has to be determined i.e. how many times in a year the interest will be charged. The interest compounding can be quarterly, half-yearly, annually etc. The number of compounding periods of interest per year is denoted by *‘ n*’.

**Step 4:** Finally, if the present value of money (PV) is available, then the future value of money (FV) after ‘t’ number of year can be calculated using the following formula as,

**FV = PV * (1 + i/n ) ^{n*t} **

On the other hand, if the future value of money (FV) after ‘t’ number of the year is available, then the present value of money (PV) today can be calculated using the following formula as,

**PV = FV / (1 + i/n ) ^{n*t}**

**Example of Time Value of Money Formula (with Excel Template)**

Let’s see some simple to advanced examples for the calculation of the Time Value of Money Equation to understand it better.

#### Time Value of Money Formula – Example #1

Let us take an example of a sum of $100,000 today invested for two years at 12% rate of interest. Now let us calculate the future value of money if the compounding is done:

- Monthly
- Quarterly
- Half Yearly
- Annually

Given, Present value of money (PV) = $100,000 , i = 12% , t = 2 years

4.9 (927 ratings)

**#1 – Monthly Compounding**

Since monthly ,therefore n = 12

The calculation of time value of the money for Future value is done using the above formula as,

Future value of money (FV)= $100,000 * (1 + )^{12*2}

- FV = $126,973.46 ~
**$126,973**

**#2 – Quarterly Compounding**

Since quarterly, therefore n = 4

The calculation of time value of money for future value is done using the above formula as,

Future value of money (FV) = $100,000 * (1 + )^{4*2}

- FV= $126,677.01 ~ $
**126,677**

**#3 – Half Yearly Compounding**

Since half yearly, therefore n = 2

The calculation of time value of money for future value is done using the above formula as,

Future value of money (FV) = $100,000 * (1 + )^{2*2}

- FV = $126,247.70 ~
**$126,248**

**#4 – Annual Compounding**

Since annually, therefore n = 1

The calculation of time value of money for future value is done using the above formula as,

Future value of money ( FV ) = $100,000 * (1 + )^{1*2}

- FV = $125,440.00 ~
**$125,440**

Therefore, the future value of money for various compounding periods will be –

The above example shows the calculation of time value of money that depends not only on the rate of interest and the tenure of the investment but also on how many times the interest compounding happens in a year.

#### Time Value of Money Formula – Example #2

Let us take the example of a sum of $100,000 to be received after two years and the discounting rate is 10%. Now let us calculate the present value today if the compounding is done.

- Monthly
- Quarterly
- Half yearly
- Annually

Given, FV = $100,000 , i = 10% , t = 2 years

**#1 – Monthly Compounding**

Since monthly, therefore n = 12

The calculation of a time value of the money for Present Value is done using the above formula as,

Present value of money (PV) = $100,000 / (1 + )^{12*2}

- PV = $81,940.95 ~
**$81,941**

**#2 – ****Quarterly ****Compounding**

Since quarterly, therefore n = 4

The calculation of a time value of the money for Present Value is done using the above formula as,

Present value of money (PV) = $100,000 / (1 + )^{4*2}

- PV = $82,074.66 ~
**$82,075**

**#3 – ****Half Yearly ****Compounding**

Since half yearly, therefore n = 2

The calculation of a time value of the money for Present Value is done using the above formula as,

Present value of money (PV) = $100,000 / (1 + )^{2*2}

- PV = $82,270.25 ~
**$82,270**

**#4 – ****Annual ****Compounding**

Since annually, therefore n = 1

The calculation of a time value of the money for Present Value is done using the above formula as,

Present value of money (PV)= $100,000 / (1 + )^{1*2}

- PV = $82,644.63 ~
**$82,645**

Therefore, the present value of money for various compounding periods will be –

### Relevance and Use of Time Value of Money Formula

The understanding of time value of money formula is very important because it deals with the concept that the money available at the present time is worth more than an equal amount in the future for its potential of earning interest. The basic idea behind the concept is that money can be invested to earn interest and as such the same amount of money is worth more today than it is later.

The concept of time value of money formula can also be seen in the parlance of inflation and purchasing power. Since inflation continuously erodes the value of money which eventually impacts the purchasing power negatively. Both inflation and purchasing power should be considered when money is invested today in order to calculate the real return on investment. In case the rate of inflation is higher than the rate of interest expected on the investment, then despite nominal growth, the money is worthless in the future which means loss of money in terms of purchasing power.

**Recommended Articles**

This has been a guide to Time Value of Money Formula. Here we discuss how to calculate Time Value of Money using PV and FV Equation using practical examples and downloadable excel templates. You may learn more about Financial Analysis from the following articles –

- Examples of NPV Profile
- Examples of Return on Investment Formula
- What is Purchasing Power Parity Formula?
- Use PV Function in Excel
- Use NPV in Excel
- NPV vs IRR – Compare and Contrast
- DCF Valuation Analysis

- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion

- Basic Microsoft Excel Training
- MS Excel 2010 Training Course: Advanced
- Microsoft Excel Basic Training
- Microsoft Excel 2013 – Advanced
- Microsoft Excel 2016 – Beginners
- Microsoft Excel 2016 – Advanced

## Leave a Reply