Time Value of Money Fundamentals

Investments represent the expenditure of money today for an anticipated return sometime in the future. The first step in understanding how to evaluate an investment is to understand the time value of money. In this section, you will learn about the present and future value of money.

Explain the Time Value of Money and Calculate Present and Future Values of Lump Sums and Annuities

Future Value

There are benefits to investing money now in hopes of a larger return in the future. These future earnings are possible because of interest payments received as an incentive for tying up money long-term. Knowing what these future earnings will be can help a business decide if the current investment is worth the long-term potential. Recall the future value (FV) as the value of an investment after a certain period of time. Future value considers the initial amount invested, the time period of earnings, and the earnings interest rate in the calculation. For example, a bank would consider the future value of a loan based on whether a long-time client meets a certain interest rate return when determining whether to approve the loan.

To determine future value, the bank would need some means to determine the future value of the loan. The bank could use formulas, future value tables, a financial calculator, or a spreadsheet application. The same is true for present value calculations. Due to the variety of calculators and spreadsheet applications, we will present the determination of both present and future values using tables. In many college courses today, these tables are used primarily because they are relatively simple to understand while demonstrating the material. For those who prefer formulas, the different formulas used to create each table are printed at the top of the corresponding table. In many finance classes, you will learn how to utilize the formulas. Regarding the use of a financial calculator, while all are similar, the user manual or a quick internet search will provide specific directions for each financial calculator. As for a spreadsheet application such as Microsoft Excel, there are some common formulas, shown in Table 11.2. In addition, Appendix C provides links to videos and tutorials on using specific aspects of Excel, such as future and present value techniques.

Excel Formulas

Time Value Component Excel Formula Shorthand Excel Formula Detailed
Present Value Single Sum =PV =PV(Rate, N, Payment, FV)
Future Value Single Sum +FV =FV(Rate, N, Payment, PV)
Present Value Annuity =PV =PV(Rate, N, Payment, FV, Type)
Future Value Annuity =FV =FV(Rate, N, Payment, PV, Type)
Net Present Value =NPV =NPV(Rate, CF2, CF3, CF4) + CF1
Internal Rate of Return =IRR =IRR(Invest, CF1, CF2, CF3)
Rate = annual interest rate
N = number of periods
Payment = annual payment amount, entered as a negative number, use 0 when calculating both present value of a single sum and future value of a single sum
FV = future value
PV = current or present value
Type = 0 for regular annuity, 1 for annuity due
CF = cash flow for a period, thus CF1 – cash flow period 1, CF2 – cash flow period 2, etc.
Invest = initial investment entered as a negative number

Table11.2

Since we will be using the tables in the examples in the body of the chapter, it is important to know there are four possible tables, each used under specific conditions (Table 11.3.)

Time Value of Money Tables


Situation Table Heading
Future Value – Lump Sum Future Value of $1
Future Value – Annuity (even payment stream) Future Value of an Annuity
Present Value – Lump Sum Present Value of $1
Present Value – Annuity (even payment stream) Present Value of an Annuity

Table11.3

In the prior situation, the bank would use either the Future Value of $1 table or Future Value of an Ordinary Annuity table, samples of which are provided in Appendix B. To use the correct table, the bank needs to determine whether the customer will pay them back at the end of the loan term or periodically throughout the term of the loan. The Future Value of $1 table is used if the customer will pay back at the end of the period; if the payments will be made periodically throughout the term of the loan, they will use the Future Value of an Annuity table. Choosing the correct table to use is critical for accurate determination of the future value. The application in other business matters is the same: a business needs to also consider if they are making an investment with a repayment in one lump sum or in an annuity structure before choosing a table and making the calculation. In the tables, the columns show interest rates (i) and the rows show periods (n). The interest columns represent the anticipated interest rate payout for that investment. Interest rates can be based on experience, industry standards, federal fiscal policy expectations, and risk investment. Periods represent the number of years until payment is received. The intersection of the expected payout years and the interest rate is a number called a future value factor. The future value factor is multiplied by the initial investment cost to produce the future value of the expected cash flows (or investment return).

Future Value of $1

A lump sum payment is the present value of an investment when the return will occur at the end of the period in one installment. To determine this return, the Future Value of $1 table is used.

For example, you are saving for a vacation you plan to take in 6 years and want to know how much your initial savings will yield in the future. You decide to place $4,500 in an investment account now that yields an anticipated annual return of 8%. Looking at the FV table, n = 6 years, and i = 8%, which return a future value factor of 1.587. Multiplying this factor by the initial investment amount of $4,500 produces $7,141.50. This means your initial savings of $4,500 will be worth approximately $7,141.50 in 6 years.

Future Value of $1 Table Factor = 1 (1+ i)^n
Period (n) Rate(i)
1% 2% 3% 5% 8%
1 1.010 1.020 1.030 1.050 1.080
2 1.020 1.040 1.061 1.103 1.166
3 1.030 1.061 1.093 1.158 1.260
4 1.041 1.082 1.126 1.216 1.360
5 1.051 1.104 1.159 1.276 1.469
6 1.062 1.126 1.194 1.340 1.587

Future Value of an Ordinary Annuity

An ordinary annuity is one in which the payments are made at the end of each period in equal installments. A future value ordinary annuity looks at the value of the current investment in the future, if periodic payments were made throughout the life of the series.

For example, you are saving for retirement and expect to contribute $10,000 per year for the next 15 years to a 401(k) retirement plan. The plan anticipates a periodic interest yield of 12%. How much would your investment be worth in the future meeting these criteria? In this case, you would use the Future Value of an Ordinary Annuity table. The relevant factor where n = 15 and i = 12% is 37.280. Multiplying the factor by the amount of the cash flow yields a future value of these installment savings of (37.280 × $10,000) $372,800. Therefore, you could expect your investment to be worth $372,800 at the end of 15 years, given the parameters.

Future Value of an Ordinary annuity Table Factor = \frac{[(1 + o)^n - 1]}{i}
Period (n) Rate(i)
1% 2% 3% 5% 8% 10% 12%
1 1.000 1.000 1.000 1.000 1.000 1.000 1.000
2 2.010 2.020 2.030 2.050 2.080 2.100 2.120
3 3.030 3.060 3.091 3.153 3.246 3.310 3.374
4 4.060 4.122 4.184 4.310 4.506 4.641 4.779
5 5.101 5.204 5.309 5.526 5.867 6.105 6.353
6 6.152 6.308 6.468 6.802 7.336 7.716 8.115
7 7.214 7.434 7.662 8.142 8.923 9.487 10.089
8 8.286 8.583 8.892 9.549 10.637 11.436 12.300
9 9.369 9.755 10.159 11.027 12.488 13.579 14.776
10 10.462 10.950 11.464 12.578 14.487 15.937 17.549
11 11.567 12.169 12.808 14.207 16.645 18.531 20.655
12 12.683 13.412 14.192 15.917 18.977 21.384 24.133
13 13.809 14.680 15.618 17.713 21.495 24.523 28.029
14 14.947 15.974 17.086 19.599 24.215 27.975 32.393
15 16.097 17.293 18.599 21.579 27.152 31.772 37.280

Let's now examine how present value differs from future value in use and computation.

YOUR TURN


Determining Future Value

Determine the future value for each of the following situations. Use the future value tables provided in Appendix B when needed, and round answers to the nearest cent where required.

A. You are saving for a car and you put away $5,000 in a savings account. You want to know how much your initial savings will be worth in 7 years if you have an anticipated annual interest rate of 5%.

B. You are saving for retirement and make contributions of $11,500 per year for the next 14 years to your 403(b) retirement plan. The interest rate yield is 8%.

Solution

A. Use FV of $1 table. Future value factor where n = 7 and i = 5 is 1.407. 1.407 × 5,000 = $7,035. B. Use FV of an ordinary annuity table. Future value factor where n = 14 and i = 8 is 24.215. 24.215 × 11,500 = $278,472.50.