Arrowsmlft.gif (338 bytes)Previous Table of Contents NextArrowsmrt.gif (337 bytes)

COMPOUND INTEREST FUNCTIONS

Life insurance calculations use compound interest. Premium and reserve computations assume that companies keep funds continuously invested until those funds are paid out in settlement of claims. The company�s computations further assume that interest earnings are added to the original principal and reinvested. To understand the relationships, it will be helpful to examine four basic compound interest series.

 

FIGURE 14-2
Compound Interest

Future Values

The first series shows the amount to which a principal sum of $10,000 invested for a number of years (or other units of time) will increase over time. This applies compound interest to accumulate interest earnings. Figure 14-2 illustrates this concept. If you invest $10,000 at 5.5 percent for one year, the combined amount of principal and interest at the end of the year, according to the simple formula previously stated, will be $10,000 x 1.055, or $10,550. If the $10,550 is then invested for another year at 5.5 percent, the combined amount of principal and interest at the end of the second year will be $10,550 x 1.055, or $11,130. This is equivalent to multiplying $10,000 by 1.0552 where the exponent�indicated in this example by the superscript "2"�denotes the number of times the base�in this case 1.055�is multiplied by itself. If the sum of $11,130 is again invested for another year at 5.5 percent, the principal and interest at the end of the third year will be $11,130 x 1.055, or $11,742, which is the equivalent of multiplying $10,000 by 1.0553. If this process continues, the accumulated principal and interest will always equal the sum obtained by multiplying $10,000 by 1.055 raised to an exponent equal to the number of years of compound interest earned.

The future value of any principal sum invested for any period of time at any rate of interest can be computed by the same process. If S represents the future value, or sum, at the end of the period, i the rate of interest, P the principal invested, and n the number of years, the general formula becomes S = P (1 + i)n. If the principal is $1, as is shown in most compound interest tables, the formula is S = (1 + i)n. Table 14-1 shows the accumulated amount of 1 at the end of each of 30 years at various rates of compound interest. A student who wants to compute the future value of $500, for example, at the end of 23 years with interest at 5.5 percent compounded annually looks up the factor (the number in the table opposite 23 years in the column headed 5.5 percent), 3.4262, and multiplies that factor by 500. This produces the answer of $1,713.10.

Instead of reading 3.4262 from a compound interest table, the yx function of a calculator could be used. To solve the same problem, a calculator that uses so-called algebraic notation, such as the TI BA-II Plus, would require the following set of key strokes:

Pressing the �=� key then produces the answer, the factor 3.4262. For calculators like the HP 12-C, using so-called �reverse Polish� notation, the future value factor is found with the following series of key strokes:

Those with ready access to a computer spreadsheet, such as Lotus 1-2-3, would enter the formula (1.055)^23 into a spreadsheet cell and press ENTER to obtain the needed solution.

Likewise, future value problems can be solved using a financial calculator. For most calculators with financial function keys, the future value of an initial $500 principal at the end of 23 years with interest at 5.5 percent compounded annually requires the following key strokes to produce the $1,713.10 answer:

TABLE 14-1
Future Value of 1 at Various Rates of Compound Interest

(1+i)n

Year

3.5%

4.0%

4.5%

5.0%

5.5%

1

2

3

4

5

1.0350

1.0712

1.1087

1.1475

1.1877

1.0400

1.0816

1.1249

1.1699

1.2167

1.0450

1.0920

1.1412

1.1925

1.2462

1.0500

1.1025

1.1576

1.2155

1.2763

1.0550

1.1130

1.1742

1.2388

1.3070

6

7

8

9

10

1.2293

1.2723

1.3168

1.3629

1.4106

1.2653

1.3159

1.3686

1.4233

1.4802

1.3023

1.3609

1.4221

1.4861

1.5530

1.3401

1.4071

1.4775

1.5513

1.6289

1.3788

1.4547

1.5347

1.6191

1.7081

11

12

13

14

15

1.4600

1.5111

1.5640

1.6187

1.6753

1.5395

1.6010

1.6651

1.7317

1.8009

1.6229

1.6959

1.7722

1.8519

1.9353

1.7103

1.7959

1.8856

1.9799

2.0789

1.8021

1.9012

2.0058

2.1161

2.2325

16

17

18

19

20

1.7340

1.7947

1.8575

1.9225

1.9898

1.8730

1.9479

2.0258

2.1068

2.1911

2.0224

2.1134

2.2085

2.3079

2.4117

2.1829

2.2920

2.4066

2.5270

2.6533

2.3553

2.4848

2.6215

2.7656

2.9178

21

22

23

24

25

2.0594

2.1315

2.2061

2.2833

2.3632

2.2788

2.3699

2.4647

2.5633

2.6658

2.5202

2.6337

2.7522

2.8760

3.0054

2.7860

2.9253

3.0715

3.2251

3.3864

3.0782

3.2475

3.4262

3.6146

3.8134

26

27

28

29

30

2.4460

2.5316

2.6202

2.7119

2.8068

2.7725

2.8834

2.9987

3.1187

3.2434

3.1407

3.2820

3.4297

3.5840

3.7453

3.5557

3.7335

3.9201

4.1161

4.3219

4.0231

4.2444

4.4778

4.7241

4.9840

Despite the fact that different strokes are needed to solve mathematical formulas, the key strokes for financial functions are similar for algebraic notation and reverse Polish calculators (although the former may require that a CPT [computer] key be pressed before the FV key). If you do not obtain the correct answer, check your calculator to be certain it is set for beginning-of-year computations.

The spreadsheet solution with an initial $500 principal amount is a simple extension of the formula (1.055)^23. Enter the formula (1.055)^23*500 to verify the $1,713.10 answer.

Relationship Between Interest Rate and Accumulation Period
to Future Values

If a higher rate of interest is used in the compounding process, or if a longer period of accumulation is used, a higher future value results. (While this is a somewhat obvious statement in the context of future value, it is important to make this explicit statement here because similar relationships that the student will encounter later in this chapter are less obvious.)

Present Values or Discounted Values

The second series, called present values, calculates the value today that is equivalent to a given sum due at a designated time in the future. This process is called discounting. The process of discounting is particularly vital to life insurance company operations since the companies deal heavily in future promises. Their contracts provide for benefits to be paid in the future. Companies finance these benefits through premium income and future interest earnings. Their very solvency depends on establishing an equivalence between future benefit payments and receipts from premiums and investments. This equivalence is established through the discounting process whereby all values are reduced to a common basis. That common basis is present value.

The discounting process implicitly recognizes that a dollar due one year from now is worth less than a dollar due now. And a dollar due 5 years from now is worth less than a dollar due in one year. Money in hand can be invested to produce more money or capital. The difference in value between money in hand and money due in the future depends on the rate of return that can be obtained from invested capital. Also the longer the period before the future money will be received, the greater the expected interest earnings and the greater the difference between the value of the present and future capital.

The present value of an amount due at a specified date in the future is that principal sum that, if invested now at an assumed rate of interest, would accumulate to the required amount by the due date. For example, $1 invested at 5.5 percent compound interest will accumulate in 10 years to $1.71. This is the meaning of the statement that $1 is the present value at 5.5 percent compound interest of $1.71 due in 10 years. This suggests how easily the present value of a sum due in the future can be obtained by reversing the accumulation process described above. The higher the rate of return available on invested capital, the greater the difference between the value of present and future money, and vice versa.

Derivation of Present Values

As explained earlier, the amount to which a given sum will accumulate is found by multiplying the principal by 1 plus the rate of interest raised to an exponent equal to the number of interest-compounding time units in the period (years in our example). If, instead, the amount at the end of the period is given, the beginning principal may be found by dividing the future amount by 1 plus the rate of interest raised to the proper exponent. For example, $1 invested for one year at 5.5 percent interest will accumulate to $1.055 by the end of the year. If the process is to be reversed, the principal is found by dividing $1 by 1.055. If the amount due 2 years from now is $11,130, the present value of the amount at 5.5 percent compounded annually is $11,130 ÷ (1.055)2 = $11,130 ÷ 1.1130 = $10,000. Similarly, if $10,000 is due one year from now, it is worth only $10,000 ÷ 1.055, or $9,479, today, based on an interest rate of 5.5 percent.

If $10,000 is to be paid 2 years from now, its value now is only $10,000 ÷ (1.055)2 = $10,000 ÷ 1.1130 = $8,985. Figure 14-3 illustrates this derivation. Conversely, $8,985 invested at 5.5 percent compound interest will, at the end of 2 years, amount to $10,000.

 

 

FIGURE 14-3
Present Value

The present value of 1 at 5.5 percent compound interest can be derived for any number of years and arranged in tabular form for convenient use by use of this general formula,

 

 

In standard actuarial notation the present value of 1 due n years from now is represented by the symbol vn where v = 1/(1+i) and n = number of years:

 

 

These values are shown for 30 years in table 14-2 or can be computed easily using a financial calculator or computer spreadsheet.

Once you have a table of values for vn, the present value of any amount due at the end of any number of years is determined by multiplying the future amount by the appropriate value of vn. Thus the present value of $1,000 due 15 years from now is, at 5.5 percent compound interest, $1,000 x 0.4479, or $447.90.

Once again, the financial calculator can produce the same answer. For the present value of $1,000 to be received at the end of 15 years with interest at 5.5 percent compounded annually requires the following key strokes:

Pressing the PV key, or the CPT and PV keys, yields an answer of $447.93 (the 3 cents difference between table value and the calculation value is due to the rounding in the table values). The spreadsheet user would enter the formula (1/1.055)^15*1000 to obtain this solution.

One final note about present values is important for anyone working or investing in the financial marketplace. Sometimes banks and other commercial organizations use approximation methods that produce results slightly different from those obtained by the precise determination of present values described here. For example, interest may be deducted in advance. For small amounts and short terms the differences produced by the alternate methods of discounting are inconsequential.

Relationship between Interest Rate and Discounting Period to Present Values

The relationship between interest rates and discounting period to present value is an inverse one. The magnitude of the difference between present and

TABLE 14-2
Present Value of 1 at Various Rates of Compound Interest

Year

3.5%

4.0%

4.5%

5.0%

5.5%

1

2

3

4

5

0.9662

0.9335

0.9019

0.8714

0.8420

0.9615

0.9246

0.8890

0.8548

0.8219

0.9569

0.9157

0.8763

0.8386

0.8025

0.9524

0.9070

0.8638

0.8227

0.7835

0.9479

0.8985

0.8516

0.8072

0.7651

6

7

8

9

10

0.8135

0.7860

0.7594

0.7337

0.7089

0.7903

0.7599

0.7307

0.7026

0.6756

0.7679

0.7348

0.7032

0.6729

0.6439

0.7462

0.7107

0.6768

0.6446

0.6139

0.7252

0.6874

0.6516

0.6176

0.5854

11

12

13

14

15

0.6849

0.6618

0.6394

0.6178

0.5969

0.6496

0.6246

0.6006

0.5775

0.5553

0.6162

0.5897

0.5643

0.5400

0.5167

0.5847

0.5568

0.5303

0.5051

0.4810

0.5549

0.5260

0.4986

0.4726

0.4479

16

17

18

19

20

0.5767

0.5572

0.5384

0.5202

0.5026

0.5339

0.5134

0.4936

0.4746

0.4564

0.4945

0.4732

0.4528

0.4333

0.4146

0.4581

0.4363

0.4155

0.3957

0.3769

0.4246

0.4024

0.3815

0.3616

0.3427

21

22

23

24

25

0.4856

0.4692

0.4533

0.4380

0.4231

0.4388

0.4220

0.4057

0.3901

0.3751

0.3968

0.3797

0.3634

0.3477

0.3327

0.3589

0.3418

0.3256

0.3101

0.2953

0.3249

0.3079

0.2919

0.2767

0.2622

26

27

28

29

30

0.4088

0.3950

0.3817

0.3687

0.3563

0.3607

0.3468

0.3335

0.3207

0.3083

0.3184

0.3047

0.2916

0.2790

0.2670

0.2812

0.2678

0.2551

0.2429

0.2314

0.2486

0.2356

0.2233

0.2117

0.2006

 

 

future values depends on the interest rate that is used for discounting. Assuming a higher rate of interest means that more interest is made or lost over time. That means the present values of future amounts are smaller for higher interest rates.

For example, the present value of $100 to be paid 20 years from now based on 3 percent interest is $100 x .5537, or $55.37. The present value assuming 5.5 percent interest is $100 x .3427, or $34.27. A higher rate of interest means a lower present value of a specific future value. Similarly, the longer the discounting period, the lower the present value. For example, the present value of $100 to be paid 30 years from now based on 3 percent interest is $100 x .4120, or $41.20, compared to $55.37 for a 20-year discounting period.

Future Value of Annual Payments

The third compound interest series deals with the future value of periodic equal annual payments. This stream of annual payments is called an annuity.

Beginning-of-Year Future Values

An annuity with payments at the beginning of the period is called an annuity due. Premium payments on most life insurance policies, although they include a mortality factor as well as interest, are one common example of beginning-of-period payments. Figure 14-4 shows the future values based on a 5.5 percent interest rate of four $1 payments made at the beginning of the year. Adding together the future values of the four payments�$1.055 + $1.113 + $1.1742 + $1.2388 gives us the $4.5810 future value of all four payments.

 

FIGURE 14-4
Future Value of an Annuity with Beginning-of-Year Payments

 

 

This process can be continued for any number of years to produce a table of annuity values. The elements of table 14-3 are created by simply adding the elements of table 14-1. To illustrate, the first five figures in the 5.5 percent column of table 14-1 are reproduced in table 14-1 extract.

 

TABLE 14-1 EXTRACT

Year

5.5%

(1.055)n

1

2

3

4

5

1.0550

1.1130

1.1742

1.2388

1.3070

(1.055)1

(1.055)2

(1.055)3

(1.055)4

(1.055)5

TABLE 14-3
Future Value of 1 per Year at Various Rates of Compound Interest
Annuity Due�Payments Made at the Beginning of Year

Year

3.5%

4.0%

4.5%

5.0%

5.5%

1

2

3

4

5

1.0350

2.1062

3.2149

4.3625

5.5502

1.0400

2.1216

3.2465

4.4163

5.6330

1.0450

2.1370

3.2782

4.4707

5.7169

1.0500

2.1525

3.3101

4.5256

5.8019

1.0550

2.1680

3.3423

4.5811

5.8881

6

7

8

9

10

6.7794

8.0517

9.3685

10.7314

12.1420

6.8983

8.2142

9.5828

11.0061

12.4864

7.0192

8.3800

9.8021

11.2882

12.8412

7.1420

8.5491

10.0266

11.5779

13.2068

7.2669

8.7216

10.2563

11.8754

13.5835

11

12

13

14

15

13.6020

15.1130

16.6770

18.2957

19.9710

14.0258

15.6268

17.2919

19.0236

20.8245

14.4640

16.1599

17.9321

19.7841

21.7193

14.9171

16.7130

18.5986

20.5786

22.6575

15.3856

17.2868

19.2926

21.4087

23.6411

16

17

18

19

20

21.7050

23.4997

25.3572

27.2797

29.2695

22.6975

24.6454

26.6712

28.7781

30.9692

23.7417

25.8551

28.0636

30.3714

32.7831

24.8404

27.1324

29.5390

32.0660

34.7193

25.9964

28.4812

31.1027

33.8683

36.7861

21

22

23

24

25

31.3289

33.4604

35.6665

37.9499

40.3131

33.2480

35.6179

38.0826

40.6459

43.3117

35.3034

37.9370

40.6892

43.5652

46.5706

37.5052

40.4305

43.5020

46.7271

50.1135

39.8643

43.1118

46.5380

50.1526

53.9660

26

27

28

29

30

42.7591

45.2906

47.9108

50.6227

53.4295

46.0842

48.9676

51.9663

55.0849

58.3283

49.7113

52.9933

56.4230

60.0071

63.7524

53.6691

57.4026

61.3227

65.4388

69.7608

57.9891

62.2335

66.7114

71.4355

76.4194

The first number in the table 14-1 extract is the same as the first figure in the 5.5 percent column of table 14-3. To obtain the second number in table 14-3�2.168 �add the first two numbers above. The third number in the table 14-1 extract, 1.1742, is added to 2.1680 to produce 3.3423, the third number in table 14-3 in the 5.5 percent column except for a difference due to rounding. Add 1.2388 to this to yield 4.5811, the fourth number in the 5.5 percent column in table 14-3, and so on. To repeat, the values in table 14-3 assume payments of $1 occur at the beginning of each year.

End-of-Year Future Values

An annuity with payments at the end of each period is called an ordinary annuity. A homeowner�s mortgage with its payment due at the end of the first month is a common example of an ordinary annuity. Figure 14-5 illustrates a
4-year ordinary annuity. Figure 14-5 can be compared with figure 14-4 to better understand the difference between this and a 4-year annuity due. Three of the four payments align perfectly, with a payment of $1 at the end of year 0 in table 14-5 corresponding exactly to a payment of $1 at the beginning of year 1 in table 14-4 and so on.

 

FIGURE 14-5
Future Value of an Annuity with End-of-Year Payments

 

 

The correspondence between most of the payments, illustrated in figure 14-6, eliminates the need for a separate table. Table 14-3 with its beginning-of-year values can also be used to find the future value of a series of annual payments made at the end of each year. An adjustment is made to reflect the difference in timing of the first and last payments. An example follows to clarify the method.

To derive ordinary-annuity future values from annuity due values, use the factor from the annuity due table for one period less than the actual number of payments and add 1.0000 to that factor. The result will be the present value factor for an ordinary annuity. For example, to find the factor for a 5-year ordinary annuity, add 1.0000 to the future value factor for a 4-year annuity due of $1 per year.

 

 

FIGURE 14-6
Comparing Future Values

 

 

 

Suppose you need to find the amount to which $1,000 per year, payable for 5 years at the end of each year, will accumulate by the end of the last period at 5.5 percent interest. Since the first payment is not due until one year from now, interest will be earned for only 4 years. From table 14-3, the amount of $1 per annum in advance at 5.5 percent interest for 4 years is $4.5811. The last of the five payments, however, will be made at the end of the period and will not earn any interest. This last payment of $1 added to $4.5811 yields $5.5811, the amount of $1 per annum payable at the end of each year over a 5-year period at 5.5 percent interest. Since $1 payments made in this manner will amount to $5.5811, then $1,000 payments made in the same manner will, obviously, amount to $1,000 x 5.5811, or $5,581.10.

Calculator and Spreadsheet Functions

Most financial calculators can be set directly to do either beginning-of-year or end-of-year calculations of the future value of an annuity. The end-of-year calculator solution to finding the future value of $1 per year for 5 years and annual compounding of interest entails the following keystrokes:

When the user presses the FV (or CPT and FV) button, the calculator produces the answer of 5.5811, which is 1 plus the 4th-year value from table 14-3.

Computer spreadsheet functions usually assume end-of-year payments. The typical spreadsheet function to obtain the same answer is formatted @FV(payment, interest rate, term of years). This problem is solved with the formula @FV(1,0.055,5). Spreadsheet users enter the interest rate as a decimal rather than as a percent.

Test your spreadsheet or calculator�s financial functions to be certain that you understand whether it is performing computations that assume payment at the beginning of a year or the end of a year. Enter the three factors specified above for 5 years of payments at 5.5 percent interest. If the answer is 5.5811, then the computation assumes end-of-year payments. If the answer is 5.8881, then the computation assumes beginning-of-year payments. The HP-12C calculator is easily set for beginning or end-of-period payments through the function and the BEG or END key. The BA-II Plus calculator is set by using the 2nd, BGN, and SET keys.

Another way to check your calculator or spreadsheet assumption about timing of payments is to solve for the future value of a single payment of $1 at an interest rate greater than zero. If the payments are assumed to be at the end of the period, the calculated FV will be $1. If the payment is assumed to be made at the beginning of the period, the calculated FV will be greater than $1 because of the interest earned during the period.

Also be certain you understand how interest is being compounded. Many manual calculations assume annual compounding. Some calculators, including the HP-12C and the BA-II Plus, can be set for monthly, weekly, or other compounding intervals. The interest rate must be appropriately adjusted to coincide with the length of the compounding period.

Present Value of Annual Payments

The fourth and final compound interest series determines the present value of a number of equal annual payments at various rates of interest. This series is used by life insurance companies to find amounts payable under the settlement options that liquidate insurance proceeds over several years. An understanding of this series is particularly important here so that we can extend it in the next chapter to include computations that combine these values with life contingencies.

Derivation of Present Values

Table 14-4 showing the present value of annuity payments is derived from the values presented in table 14-2 in the same manner that table 14-3 was derived from the values in table 14-1. As in table 14-2, the values in this series are for annual payments of $1 due at the end of each year (ordinary annuity).

 

FIGURE 14-7
Present Value of a 3-Year Annuity with End-of-Year $1 Payments

 

(Adjustments similar to those described in the previous section can be made to derive the present value of payments due at the beginning of each year.) Remember that in table 14-2 at 5.5 percent interest, the present value of $1 payable one year from now is $0.9479. The present value of the second payment of $1 due 2 years from now is $0.8985; the payment due in 3 years is worth $0.8516 now. The present value of all three payments is, of course, the sum of the present values of each taken separately, or $2.6980, as depicted in figure 14-7.

The present value factors in table 14-4 are based on the assumption that each $1 payment is made at the end of the period. Many life insurance calculations involve payment streams that are made at the beginning of the period, such as premium payments. When the number of payments, the interest rate, and amount of each payment are all the same, the present value of an annuity due is higher than the present value of a corresponding immediate annuity. This is purely a result of the earlier timing of the payments.

In order to convert ordinary-annuity present values factors into annuity due present value factors, first, find the ordinary-annuity factor for the appropriate interest rate and for one payment period less than the total number of payments to be made. Then add 1.000 to that factor to represent the $1 payment at the beginning of the stream. The result is a present value factor representing the specific annuity due payments of $1 per period.

Figure 14-8 depicts a 3-year annuity due of $1 per year. The first payment is not discounted because it is made now and worth the full $1 amount. The second payment is one year away and is worth $0.9479 now when discounted at 5.5 percent interest. The third payment is worth $0.8985 now. All three $1 payments have a present value equal to the sum of their individual present values ($2.8464 in this example). The difference between the present value of the 3-year annuity due and the corresponding ordinary annuity does not seem important. However, consider the amount involved if each annual payment is for $10 million instead of $1. The difference in timing amounts to $1,484 million, which is one year of additional interest earned when each payment is made one year earlier.

By the process of cumulative addition, the present value of a series of annual payments of $1 for any number of years can be found. Table 14-4 shows these values at various rates of interest for durations up to 30 years. The value for 2 years in table 14-4 is the sum of the first two values in table 14-2. The value for 3 years is the sum of the first three values in table 14-2 (2.6979, which is the same present value depicted in figure 14-7), and so on.

Application of the Values

Annuity values, typically based on a present value of $1, are used in several different ways by life insurance companies. For example, determining what payment amount each $1 of death benefit can buy if paid to the beneficiary in 20 annual end-of-year installments under the fixed-period settlement option earning 5.5 percent interest requires the present value of $1 per annum for 20 years, which is $11.9504. This number is then divided into $1 to yield $0.08368. Stated differently, at 5.5 percent compound interest, $1 will provide 8.4 cents at the end of each year for 20 years. Therefore, each $1,000 of death benefit would provide $1,000 x 0.08368, or $83.68 per year for 20 years.

 

FIGURE 14-8
Present Value of a 3-Year Annuity with Beginning-of-Year $1 Payments

 

 

From a different perspective, $11.95 of savings invested at 5.5 percent will provide $1 per year for 20 years. The first payment will occur one year from now; payments will continue for 19 years. At the end of 20 years none of the money will remain. Similarly $14.53 will provide $1 annual payments for 30 years.

Annuity values also can be used to determine the amount available from larger investments. If $11.95 will provide $1 per year for 20 years, then $1,000 will provide an annual payment of $1,000 ÷ 11.95 = $83.68. The rule is as follows: To find the amount of annual payments due at the end of each year that a given principal sum will provide, divide the sum by the present value of $1 per year at the applicable rate of interest for the period.

Amounts payable under life insurance settlement options are payable at the beginning of the year. Likewise, annual premiums are due at the beginning of the year. Therefore life insurance companies must modify the values shown in

TABLE 14-4
Present Value of 1 per Year at Various Rates of Compound Interest
Immediate Annuity�Payment at End of Year

Year

3.5%

4.0%

4.5%

5.0%

5.5%

1

2

3

4

5

0.9662

1.8997

2.8016

3.6731

4.5151

0.9615

1.8861

2.7751

3.6299

4.4518

0.9569

1.8727

2.7490

3.5875

4.3900

0.9524

1.8594

2.7232

3.5460

4.3295

0.9479

1.8463

2.6979

3.5052

4.2703

6

7

8

9

10

5.3286

6.1145

6.8740

7.6077

8.3166

5.2421

6.0021

6.7327

7.4353

8.1109

5.1579

5.8927

6.5959

7.2688

7.9127

5.0757

5.7864

6.4632

7.1078

7.7217

4.9955

5.6830

6.3346

6.9522

7.5376

11

12

13

14

15

9.0016

9.6633

10.3027

10.9205

11.5174

8.7605

9.3851

9.9856

10.5631

11.1184

8.5289

9.1186

9.6829

10.2228

10.7395

8.3064

8.8633

9.3936

9.8986

10.3797

8.0925

8.6185

9.1171

9.5896

10.0376

16

17

18

19

20

12.0941

12.6513

13.1897

13.7098

14.2124

11.6523

12.1657

12.6593

13.1339

13.5903

11.2340

11.7072

12.1600

12.5933

13.0079

10.8378

11.2741

11.6896

12.0853

12.4622

10.4622

10.8646

11.2461

11.6077

11.9504

21

22

23

24

25

14.6980

15.1671

15.6204

16.0584

16.4815

14.0292

14.4511

14.8568

15.2470

15.6221

13.4047

13.7844

14.1478

14.4955

14.8282

12.8212

13.1630

13.4886

13.7986

14.0939

12.2752

12.5832

12.8750

13.1517

13.4139

26

27

28

29

30

16.8904

17.2854

17.6670

18.0358

18.3920

15.9828

16.3296

16.6631

16.9837

17.2920

15.1466

15.4513

15.7429

16.0219

16.2889

14.3752

14.6430

14.8981

15.1411

15.3725

13.6625

13.8981

14.1214

14.3331

14.5337

 

 

table 14-4 to reflect the present value of a series of periodic payments due at the beginning of the year. The adjustment involved is simple and very similar to the adjustment made for future values.

Consider, for example, a series of annual payments of $1 due at the beginning of each year for 25 years. The first payment is due immediately and is worth $1. Twenty-four additional payments remain, the first of which is due one year from now. The present value of the entire series is obtained by adding $1 to the present value of $1 per annum (end of year from table 14-4) for one year less, in this case, 24 years. The result at an interest rate of 5.5 percent is $13.1517 + $1, or $14.1517.

Calculator and Spreadsheet Functions

Financial calculators and spreadsheets are also used to perform present value computations. The financial calculator solution to valuing a temporary annuity that pays $1 per year at the end of each of 20 years at 5.5 percent interest requires input similar to that used for future value computations:

Then press the PV (or CPT and PV) button. The present value of $1 per annum for 20 years is $11.9504 as before. If this is divided into 1, the annual payment for 20 years purchased by $1 is $0.08368. The typical computer spreadsheet function to obtain the same answer is formatted @PV(payment, interest rate, term of years). This problem is solved with the formula @PV(1,0.055,20).

Arrowsmlft.gif (338 bytes)Previous TopArrowsm.gif (337 bytes) NextArrowsmrt.gif (337 bytes)