Chapter 2
Time Value of Money
ANSWERS TO END-OF-CHAPTER QUESTIONS




2-1 a. PV (present value) is the value today of a future payment, or stream of payments, discounted at the appropriate rate of interest. PV is also the beginning amount that will grow to some future value. The parameter i is the periodic interest rate that an account pays. The parameter INT is the dollars of interest earned each period. FVn (future value) is the ending amount in an account, where n is the number of periods the money is left in the account. PVAn is the value today of a future stream of equal payments (an annuity) and FVAn is the ending value of a stream of equal payments, where n is the number of payments of the annuity. PMT is equal to the dollar amount of an equal, or constant cash flow (an annuity). In the EAR equation, m is used to denote the number of compounding periods per year, while iNom is the nominal, or quoted, interest rate.

b. FVIFi,n is the future value interest factor for a lump sum left in an account for n periods paying i percent interest per period. PVIFi,n is the present value interest factor for a lump sum received n periods in the future discounted at i percent per period. FVIFAi,n is the future value interest factor for an ordinary annuity of n periodic payments paying i percent interest per period. PVIFAi,n is the present value interest factor for an ordinary annuity of n periodic payments discounted at i percent interest per period. All the above factors represent the appropriate PV or FVn when the lump sum or ordinary annuity payment is $1. Note that the above factors can also be defined using formulas.

c. The opportunity cost rate (i) of an investment is the rate of return available on the best alternative investment of similar risk.

d. An annuity is a series of payments of a fixed amount for a specified number of periods. A single sum, or lump sum payment, as opposed to an annuity, consists of one payment occurring now or at some future time. A cash flow can be an inflow (a receipt) or an outflow (a deposit, a cost, or an amount paid). We distinguish between the terms cash flow and PMT. We use the term cash flow for uneven streams, while we use the term PMT for annuities, or constant payment amounts. An uneven cash flow stream is a series of cash flows in which the amount varies from one period to the next. The PV (or FVn) of an uneven payment stream is merely the sum of the present values (or future values) of each individual payment.

e. An ordinary annuity has payments occurring at the end of each period. A deferred annuity is just another name for an ordinary annuity. An annuity due has payments occurring at the beginning of each period. Most financial calculators will accommodate either type of annuity. The payment period must be equal to the compounding period.

f. A perpetuity is a series of payments of a fixed amount that last indefinitely. In other words, a perpetuity is an annuity where n equals infinity. Consol is another term for perpetuity. Consols were originally bonds issued by England in 1815 to consolidate past debt.

g. An outflow is a deposit, a cost, or an amount paid, while an inflow is a receipt. A time line is an important tool used in time value of money analysis; it is a graphical representation which is used to show the timing of cash flows. The terminal value is the future value of an uneven cash flow stream.

h. Compounding is the process of finding the future value of a single payment or series of payments. Discounting is the process of finding the present value of a single payment or series of payments; it is the reverse of compounding.

i. Annual compounding means that interest is paid once a year. In semiannual, quarterly, monthly, and daily compounding, interest is paid 2, 4, 12, and 365 times per year respectively. When compounding occurs more frequently than once a year, you earn interest on interest more often, thus increasing the future value. The more frequent the compounding, the higher the future value.

j. The effective annual rate is the rate that, under annual compounding, would have produced the same future value at the end of 1 year as was produced by more frequent compounding, say quarterly. The nominal (quoted) interest rate, iNom, is the rate of interest stated in a contract. If the compounding occurs annually, the effective annual rate and the nominal rate are the same. If compounding occurs more frequently, the effective annual rate is greater than the nominal rate. The nominal annual interest rate is also called the annual percentage rate, or APR. The periodic rate, iPER, is the rate charged by a lender or paid by a borrower each period. It can be a rate per year, per 6-month period, per quarter, per month, per day, or per any other time interval (usually one year or less).

k. An amortization schedule is a table that breaks down the periodic fixed payment of an installment loan into its principal and interest components. The principal component of each payment reduces the remaining principal balance. The interest component is the interest payment on the beginning-of-period principal balance. An amortized loan is one that is repaid in equal periodic amounts (or "killed off" over time).


2-2 The opportunity cost rate is the rate of interest one could earn on an alternative investment with a risk equal to the risk of the investment in question. This is the value of i in the TVM equations, and it is shown on the top of a time line, between the first and second tick marks. It is not a single rate--the opportunity cost rate varies depending on the riskiness and maturity of an investment, and it also varies from year to year depending on inflationary expectations.

2-3 True. The second series is an uneven payment stream, but it contains an annuity of $400 for 8 years. The series could also be thought of as a $100 annuity for 10 years plus an additional payment of $100 in Year 2, plus additional payments of $300 in Years 3 through 10.

2-4 True, because of compounding effects--growth on growth. The following example demonstrates the point. The annual growth rate is i in the following equation:

$1(1 + i)10 = $2.

The term (1 + i)10 is the FVIF for i percent, 10 years. We can find i in one of two ways:

1. Using a financial calculator input N = 10, PV = -1, PMT = 0, FV = 2, and I = ?. Solving for I you obtain 7.18%.

2. Using a financial calculator, input N = 10, I = 10, PV = -1, PMT = 0, and FV = ?. Solving for FV you obtain $2.59. This formulation recognizes the "interest on interest" phenomenon.

2-5 For the same stated rate, daily compounding is best. You would earn more "interest on interest."



SOLUTIONS TO END-OF-CHAPTER PROBLEMS


2-1 a. 0 1
| | $500(1.06) = $530.00.
-500 FV = ?

b. 0 1 2
| | | $500(1.06)2 = $561.80.
-500 FV = ?

c. 0 1
| | $500(1/1.06) = $471.70.
PV = ? 500

d. 0 1 2
| | | $500(1/1.06)2 = $445.00.
PV = ? 500


2-2 a. 0 1 2 3 4 5 6 7 8 9 10
| | | | | | | | | | |
-500 FV = ?

b. 0 1 2 3 4 5 6 7 8 9 10
| | | | | | | | | | |
-500 FV = ?

c. 0 1 2 3 4 5 6 7 8 9 10
| | | | | | | | | | |
PV = ? 500

d. 0 1 2 3 4 5 6 7 8 9 10
| | | | | | | | | | |
PV = ? 1,552.90

$1,552.90(PVIF12%,10) = $1,552.90(PVIF6%,10) =
$1,552.90(0.3220) = $500.03; i = 6%: $1,552.90(0.5584) = $867.14.

The present value is the value today of a sum of money to be received in the future. For example, the value today of $1,552.90 to be received 10 years in the future is about $500 at an interest rate of 12 percent, but it is approximately $867 if the interest rate is 6 percent. Therefore, if you had $500 today and invested it at 12 percent, you would end up with $1,552.90 in 10 years. The present value depends on the interest rate because the interest rate determines the amount of interest you forgo by not having the money today.


2-3 a. ?
| | $400 = $200(FVIF7%,n)
-200 400 2 = FVIF7%,n
n » 10 years.

With a financial calculator, enter I = 7, PV = -200, PMT = 0, and FV = 400. Then press the N key to find N = 10.24. Override I with the other values to find N = 7.27, 4.19, and 1.00.

b. ?
| | 2 = FVIF10%,n
-200 400 n » 7 years.

c. ?
| | 2 = FVIF18%,n
-200 400 n » 4 years.

d. ?
| | 2 = FVIF100%,n
-200 400 n = 1 year.


2-4 The general formula is FVAn = PMT(FVIFAi,n).

a. 0 1 2 3 4 5 6 7 8 9 10
| | | | | | | | | | |
400 400 400 400 400 400 400 400 400 400
FV = ?

FVA10 = ($400)15.9374 = $6,374.96.

With a financial calculator, enter N = 10, I = 10, PV = 0, and PMT = -400. Then press the FV key to find FV = $6,374.97.

b. 0 1 2 3 4 5
| | | | | | ($200)5.5256 = $1,105.12.
200 200 200 200 200
FV = ?

With a financial calculator, enter N = 5, I = 5, PV = 0, and PMT =
-200. Then press the FV key to find FV = $1,105.13.





c. 0 1 2 3 4 5
| | | | | | ($400)5 = $2,000.00.
400 400 400 400 400
FV = ?

With a financial calculator, enter N = 5, I = 0, PV = 0, and PMT =
-400. Then press the FV key to find FV = $2,000.

d. To solve Part d using a financial calculator, repeat the procedures discussed in Parts a, b, and c, but first switch the calculator to "BEG" mode. Make sure you switch the calculator back to "END" mode after working the problem.

(1) 0 1 2 3 4 5 6 7 8 9 10
| | | | | | | | | | |
400 400 400 400 400 400 400 400 400 400 FV = ?
FVAn(Annuity due) = PMT(FVIFAi,n)(1 + i). Therefore,
FVA10 = $400(15.9374)(1.10) = $7,012.46.

(2) 0 1 2 3 4 5
| | | | | |
200 200 200 200 200 FV = ?
FVA5 = $200(5.5256)(1.05) = $1,160.38.

(3) 0 1 2 3 4 5
| | | | | |
400 400 400 400 400 FV = ?
FVA5 = $400(5)(1.00) = $2,000.00.






















2-5 The general formula is PVAn = PMT(PVIFAi,n).

a. 0 1 2 3 4 5 6 7 8 9 10
| | | | | | | | | | |
PV = ? 400 400 400 400 400 400 400 400 400 400

PV = $400 (6.1446) = $2,457.83.
With a financial calculator, simply enter the known values and then press the key for the unknowns. Except for rounding errors, the answers are as given below.

b. 0 1 2 3 4 5
| | | | | | $200(4.3295) = $865.90.
PV = ? 200 200 200 200 200

c. 0 1 2 3 4 5
| | | | | | $400(5) = $2,000.00.
PV = ? 400 400 400 400 400

d. (1) 0 1 2 3 4 5 6 7 8 9 10
| | | | | | | | | | |
400 400 400 400 400 400 400 400 400 400 PV = ?

PVAn (Annuity due) = PMT(PVIFAi,n)(1 + i). Therefore,
$400(6.1446)(1.10) = $2,703.62.

(2) 0 1 2 3 4 5
| | | | | |
200 200 200 200 200 200

PVAn (Annuity due) = $200(4.3295)(1.05) = $909.20.

(3) 0 1 2 3 4 5
| | | | | |
400 400 400 400 400

PV = ?
PVAn (Annuity due)= $400(5)(1.00) = $2,000.00.




2-6 a. Cash Stream A Cash Stream B
0 1 2 3 4 5 0 1 2 3 4 5
| | | | | | | | | | | |
PV = ? 100 400 400 400 300 PV = ? 300 400 400 400 100

With a financial calculator, simply enter the cash flows (be sure to enter CF0 = 0), enter I = 8, and press the NPV key to find NPV = PV = $1,251.25 for the first problem. Override I = 8 with I = 0 to find the next PV for Cash Stream A. Repeat for Cash Stream B to get NPV = PV = $1,300.32.

b. PVA = $100 + $400 + $400 + $400 + $300 = $1,600.
PVB = $300 + $400 + $400 + $400 + $100 = $1,600


2-7 These problems can all be solved using a financial calculator by entering the known values shown on the time lines and then pressing the I button.

a. 0 1
| |
+700 -749

7 percent: $700 = $749(PVIFi,1); PVIFi,1 = 0.9346.

b. 0 1
| | 7 percent.
-700 +749

c. 0 10
| |
+85,000 -201,229

$201,229/$85,000 = 2.3674 = FVIFi,10; i = 9%.


d. 0 1 2 3 4 5
| | | | | |
+9,000 -2,684.80 -2,684.80 -2,684.80 -2,684.80 -2,684.80

$9,000/$2,684.80 = 3.3522 = PVIFAi,5; i = 15%.


2-8 a. 0 12% 1 2 3 4 5
| | | | | |
-500 FV = ?

With a financial calculator, enter N = 5, I = 12, PV = -500, and PMT = 0, and then press FV to obtain FV = $881.17. With a regular calculator, proceed as follows:

Fvn = PV(1 + i)n = $500(1.12)5 = $500(1.7623) = $881.15.

b. 0 1 2 3 4 5 6 7 8 9 10
| | | | | | | | | | |
-500 FV = ?

Enter the time line values into a financial calculator to obtain FV = $895.42, or

PVn= PV
= $500 = $500(1.06)10
= $500(FVIF6%, 10) = $500(1.7908) = $895.40.

c. 0 4 8 12 16 20
| | | | | |
-500 FV = ?

Enter the time line values into a financial calculator to obtain FV = $903.06, or

FVn = $500 = $500(1.03)20 = $500(1.8061) = $903.05.

d. 0 12 24 36 48 60
| | | | | |
-500 ?

Enter the time line values into a financial calculator to obtain FV = $908.35, or

FVn = $500 = $500(1.01)60 = $500(1.8167) = $908.35.

2-9 a. 0 2 4 6 8 10
| | | | | |
PV = ? 500

Enter the time line values into a financial calculator to obtain PV = $279.20, or

PV = FVn = $500
= $500 = $500(PVIF6%, 10) = $500(0.5584) = $279.20.

b. 0 4 8 12 16 20
| | | | | |
PV = ? 500

Enter the time line values into a financial calculator to obtain PV = $276.84, or

PV = $500 = $500 = $500(0.5537) = $276.85.

c. 0 1 2 12
| | | · · · |
PV = ? 500

Enter the time line values into a financial calculator to obtain PV = $443.72, or

PV = $500
= $500 = $500(1.01)-12 = $500(0.8874) = $443.70.


2-10 a. 0 1 2 3 9 10
| | | | · · · | |
400 400 400 400 400
FV = ?

Enter N = 5 ? 2 = 10, I = 12/2 = 6, PV = 0, PMT = -400, and then press FV to get FV = $5,272.32.


b. Now the number of periods is calculated as N = 5 x 4 = 20, I = 12/4 = 3, PV = 0, and PMT = -200. The calculator solution is $5,374.07.

Note that the solution assumes that the nominal interest rate is compounded at the annuity period.

c. The annuity in Part b earns more because some of the money is on deposit for a longer period of time and thus earns more interest. Also, because compounding is more frequent, more interest is earned on interest.


2-11 a. Universal Bank: Effective rate = 7%.

Regional Bank:

Effective rate = - 1.0 = (1.015)4 – 1.0
= 1.0614 – 1.0 = 0.0614 = 6.14%.

With a financial calculator, you can use the interest rate conversion feature to obtain the same answer. You would choose the Universal Bank.

b. If funds must be left on deposit until the end of the compounding period (1 year for Universal and 1 quarter for Regional), and you think there is a high probability that you will make a withdrawal during the year, the Regional account might be preferable. For example, if the withdrawal is made after 10 months, you would earn nothing on the Universal account but (1.015)3 - 1.0 = 4.57% on the Regional account.
Ten or more years ago, most banks and S&Ls were set up as described above, but now virtually all are computerized and pay interest from the day of deposit to the day of withdrawal, provided at least $1 is in the account at the end of the period.


2-12 a. With a financial calculator, enter N = 5, I = 10, PV = -25000, and FV = 0, and then press the PMT key to get PMT = $6,594.94. Then go through the amortization procedure as described in your calculator manual to get the entries for the amortization table.

Repayment Remaining
Year Payment Interest of Principal Balance
1 $ 6,594.94 $2,500.00 $ 4,094.94 $20,905.06
2 6,594.94 2,090.51 4,504.43 16,400.63
3 6,594.94 1,640.06 4,954.88 11,445.75
4 6,594.94 1,144.58 5,450.36 5,995.39
5 6,594.93* 599.54 5,995.39 0
$32,974.69 $7,974.69 $25,000.00

*The last payment must be smaller to force the ending balance to zero.

Here the loan size is doubled, so the payments also double in size to $13,189.87.

c. The annual payment on a $50,000, 10-year loan at 10 percent interest would be $8,137.27. Because the payments are spread out over a longer time period, more interest must be paid on the loan, which raises the amount of each payment. The total interest paid on the 10-year loan is $31,372.70 versus interest of $15,949.37 on the 5-year loan.



2-13 a. 1997 1998 1999 2000 2001 2002
| | | | | |
-6 12 (in millions)



With a calculator, enter N = 5, PV = -6, PMT = 0, FV = 12, and then solve for I = 14.87%.

b. The calculation described in the quotation fails to take account of the compounding effect. It can be demonstrated to be incorrect as follows:

$6,000,000(1.20)5 = $6,000,000(2.4883) = $14,929,800,

which is greater than $12 million. Thus, the annual growth rate is less than 20 percent; in fact, it is about 15 percent, as shown in Part a.


2-14 0 1 2 3 4 5 6 7 8 9 10
| | | | | | | | | | |
-4 8 (in millions)

$4,000,000/$8,000,000 = 0.50, which is slightly less than the PVIFi,n for 7 percent in 10 years. Thus, the expected rate of return is just over 7 percent. With a calculator, enter N = 10, PV = -4, PMT = 0, FV = 8, and then solve for I = 7.18%.


2-15 0 1 2 3 4 30
| | | | | · · · |
85,000 -8,273.59 -8,273.59 -8,273.59 -8,273.59 -8,273.59

$85,000/$8,273.59 = 10.2737 = PVIFAi,n for a 30-year annuity.

With a calculator, enter N = 30, PV = 85000, PMT = -8273.59, FV = 0, and then solve for I = 9%.


2-16 a. 0 1 2 3 4
| | | | |
PV = ? -10,000 -10,000 -10,000 -10,000

With a calculator, enter N = 4, I = 7, PMT = -10000, and FV = 0. Then press PV to get PV = $33,872.11.

b. (1) At this point, we have a 3-year, 7% annuity whose value is $26,243.16. You can also think of the problem as follows:

$33,872(1.07) - $10,000 = $26,243.04.

(2) Zero after the last withdrawal.


2-17 0 1 2 ?
| | | · · · |
12,000 -1,500 -1,500 -1,500



With a calculator, enter I = 9, PV = 12000, PMT = -1500, and FV = 0. Press N to get N = 14.77 » 15 years. Therefore, it will take approximately 15 years to pay back the loan.

2-18 0 1 2 3 4 5 6
| | | | | | |
1,250 1,250 1,250 1,250 1,250 ?
FV = 10,000

With a financial calculator, get a "ballpark" estimate of the years by entering I = 12, PV = 0, PMT = -1250, and FV = 10000, and then pressing the N key to find N = 5.94 years. This answer assumes that a payment of $1,250 will be made 94/100th of the way through Year 5.
Now find the FV of $1,250 for 5 years at 12%; it is $7,941.06. Compound this value for 1 year at 12% to obtain the value in the account after 6 years and before the last payment is made; it is $7,941.06(1.12) = $8,893.99. Thus, you will have to make a payment of $10,000 - $8,893.99 = $1,106.01 at Year 6, so the answer is: it will take 6 years, and $1,106.01 is the amount of the last payment.



2-19 PV = $100/0.07 = $1,428.57. PV = $100/0.14 = $714.29.

When the interest rate is doubled, the PV of the perpetuity is halved.


2-20 0 1 2 3 4
| | | | |
PV = ? 50 50 50 1,050

Discount rate: Effective rate on bank deposit:

EAR = (1 + 0.08/4)4 - 1 = 8.24%.

Find PV of above stream at 8.24%:

PV = $893.26 using the cash flow register.

Also get PV = $893.26 using the TVM register, inputting N = 4, I = 8.24, PMT = 50, and FV = 1000.


2-21 This can be done with a calculator by specifying an interest rate of 5% per period for 20 periods with 1 payment per period, or 10% interest, 20 periods, 2 payments per year. Either way, we get the payment each 6 months:

N = 10 ? 2 = 20.
I = 10%/2 = 5.
PV = -10000.
FV = 0.

Solve for PMT = $802.43. Set up amortization table:


Pmt of
Period Beg Bal Payment Interest Principal End Bal
1 $10,000.00 $802.43 $500.00 $302.43 $9,697.57
2 9,697.57 802.43 484.88
$984.88

You can also work the problem with a calculator having an amortization function. Find the interest in each 6-month period, sum them, and you have the answer. Even simpler, with some calculators such as the HP-17B, just input 2 for periods and press INT to get the interest during the first year, $984.88. The HP-10B does the same thing.


2-22 First, find PMT by using a financial calculator: N = 5, I/YR = 15, PV = -1000000, and FV = 0. Solve for PMT = $298,315.55. Then set up the amortization table:

Beginning Ending
Year Balance Payment Interest Principal Balance
1 $1,000,000.00 $298,315.55 $150,000.00 $148,315.55 $851,684.45
2 851,684.45 298,315.55 127,752.67 170,562.88 681,121.57

Fraction that is principal = $170,562.88/$298,315.55 = 0.5718 = 57.18%.


2-23 a. Begin with a time line:

6-mos. 0 1 2 3 4 5 6 8 10 12 14 16 18 20
Years 0 6% 1 2 3 4 5 6 7 8 9 10
| | | | | | | | | | | | | | | | | | | | |
100 100 100 100 100 FVA

Since the first payment is made today, we have a 5-period annuity due. The applicable interest rate is I = 12/2 = 6 per period, N = 5, PV = 0, and PMT = -100. Setting the calculator on "BEG," we find FVA (Annuity due) = $597.53. That will be the value at the 5th 6-month period, which is t = 2.5. Now we must compound out to t = 10, or for 7.5 years at an EAR of 12.36%, or 15 semiannual periods at 6%.

$597.53 ® 20 - 5 = 15 periods @ 6% ® $1,432.02,

or $597.53 ® 10 - 2.5 = 7.5 years @ 12.36% ® $1,432.02.


b. 1 10 years
0 1 2 3 4 5 40 quarters
| | | | | | · · · |
PMT PMT PMT PMT PMT FV = 1,432.02

The time line depicting the problem is shown above. Because the payments only occur for 5 periods throughout the 40 quarters, this problem cannot be immediately solved as an annuity problem. The problem can be solved in two steps:

(1) Discount the $1,432.02 back to the end of Quarter 5 to obtain the PV of that future amount at Quarter 5.

(2) Then solve for PMT using the value solved in Step 1 as the FV of the five-period annuity due.

Step 1: Input the following into your calculator: N = 35, I = 3, PMT = 0, FV = 1432.02, and solve for PV at Quarter 5. PV = $508.92.

Step 2: The PV found in Step 1 is now the FV for the calculations in this step. Change your calculator to the BEGIN mode. Input the following into your calculator: N = 5, I = 3, PV = 0, FV = 508.92, and solve for PMT = $93.07.


2-24 Here we want to have the same effective annual rate on the credit extended as on the bank loan that will be used to finance the credit extension.
First, we must find the EAR = EFF% on the bank loan. Enter NOM% = 15, N = P/YR = 12, and press EFF% to get EAR = 16.08%.
Now recognize that giving 3 months of credit is equivalent to quarterly compounding--interest is earned at the end of the quarter, so it is available to earn interest during the next quarter. Therefore, enter P/YR = 4, EFF% = EAR = 16.08%, and press NOM% to find the nominal rate of 15.19 percent.
Therefore, if a 15.19 percent nominal rate is charged and credit is given for 3 months, the cost of the bank loan will be covered.
Alternative solution: We need to find the effective annual rate (EAR) the bank is charging first. Then, we can use this EAR to calculate the nominal rate that should be quoted to the customers.

Bank EAR: EAR = (1 + iNom/m)m - 1 = (1 + 0.15/12)12 - 1 = 16.08%.

Nominal rate that should be quoted to customers:

16.08% = (1 + iNom/4)4 - 1
1.1608 = (1 + iNom/4)4
1.0380 = 1 + iNom/4
iNom = 0.0380(4) = 15.19%.

2-25 Information given:

1. Will save for 10 years, then receive payments for 25 years.

2. Wants payments of $40,000 per year in today's dollars for first payment only. Real income will decline. Inflation will be 5 percent. Therefore, to find the inflated fixed payments, we have this time line:

0 5 10
| | | | | | | | | | |
40,000 FV = ?

Enter N = 10, I = 5, PV = -40000, PMT = 0, and press FV to get FV = $65,155.79.

3. He now has $100,000 in an account which pays 8 percent, annual compounding. We need to find the FV of the $100,000 after 10 years. Enter N = 10, I = 8, PV = -100000, PMT = 0, and press FV to get FV = $215,892.50.

4. He wants to withdraw, or have payments of, $65,155.79 per year for 25 years, with the first payment made at the beginning of the first retirement year. So, we have a 25-year annuity due with PMT = 65,155.79, at an interest rate of 8 percent. (The interest rate is 8 percent annually, so no adjustment is required.) Set the calculator to "BEG" mode, then enter N = 25, I = 8, PMT = 65155.79, FV = 0, and press PV to get PV = $751,165.35. This amount must be on hand to make the 25 payments.

5. Since the original $100,000, which grows to $215,892.50, will be available, we must save enough to accumulate $751,165.35 - $215,892.50 = $535,272.85.

6. The $535,272.85 is the FV of a 10-year ordinary annuity. The payments will be deposited in the bank and earn 8 percent interest. Therefore, set the calculator to "END" mode and enter N = 10, I = 8, PV = 0, FV = 535272.85, and press PMT to find PMT = $36,949.61.



SOLUTION TO SPREADSHEET PROBLEM




2-26 The detailed solution for the spreadsheet problem is available both on the instructor’s resource CD-ROM (in the file Solution for Ch 02 P26 Build a Model.xls) and on the instructor’s side of the textbook’s web site, brigham.swcollege.com.



MINI CASE




Assume that you are nearing graduation and that you have applied for a job with a local bank. As part of the bank's evaluation process, you have been asked to take an examination which covers several financial analysis techniques. The first section of the test addresses discounted cash flow analysis. See how you would do by answering the following questions.

a. Draw time lines for (a) a $100 lump sum cash flow at the end of year 2, (b) an ordinary annuity of $100 per year for 3 years, and (c) an uneven cash flow stream of -$50, $100, $75, and $50 at the end of years 0 through 3.

Answer: (Begin by discussing basic discounted cash flow concepts, terminology, and solution methods.) A time line is a graphical representation which is used to show the timing of cash flows. The tick marks represent end of periods (often years), so time 0 is today; time 1 is the end of the first year, or 1 year from today; and so on.

0 1 2 year
| | | lump sum
100 cash flow

0 1 2 3
| | | | annuity
100 100 100

0 1 2 3
| | | | uneven cash flow stream
-50 100 75 50

A lump sum is a single flow; for example, a $100 inflow in year 2, as shown in the top time line. An annuity is a series of equal cash flows occurring over equal intervals, as illustrated in the middle time line. An uneven cash flow stream is an irregular series of cash flows which do not constitute an annuity, as in the lower time line. -50 represents a cash outflow rather than a receipt or inflow.


b. 1. What is the future value of an initial $100 after 3 years if it is invested in an account paying 10 percent annual interest?

Answer: Show dollars corresponding to question mark, calculated as follows:

0 1 2 3
| | | |
100 FV = ?

After 1 year:

FV1 = PV + i1 = PV + PV(i) = PV(1 + i) = $100(1.10) = $110.00.

Similarly:

FV2 = FV1 + i2 = FV1 + FV1(i) = FV1(1 + i)
= $110(1.10) = $121.00 = PV(1 + i)(1 + i) = PV(1 + i)2.

FV3 = FV2 + i3 = FV2 + FV2(i) = FV2(1 + i)
= $121(1.10)=$133.10=PV(1 + i)2(1 + i)=PV(1 + i)3.

In general, we see that:

FVn = PV(1 + i)n,
SO FV3 = $100(1.10)3 = $100(1.3310) = $133.10.

Note that this equation has 4 variables: FVn, PV, i, and n. Here we know all except FVn, so we solve for FVn. We will, however, often solve for one of the other three variables. By far, the easiest way to work all time value problems is with a financial calculator. Just plug in any 3 of the four values and find the 4th.

Finding future values (moving to the right along the time line) is called compounding. Note that there are 3 ways of finding FV3: using a regular calculator, financial calculator, or spreadsheets. For simple problems, we show only the regular calculator and financial calculator methods.

(1) regular calculator:

1. $100(1.10)(1.10)(1.10) = $133.10.

2. $100(1.10)3 = $133.10.





(2) financial calculator:

This is especially efficient for more complex problems, including exam problems. Input the following values: N = 3, I = 10, PV = -100, pmt = 0, and solve for FV = $133.10.


b. 2. What is the present value of $100 to be received in 3 years if the appropriate interest rate is 10 percent?

Answer: Finding present values, or discounting (moving to the left along the time line), is the reverse of compounding, and the basic present value equation is the reciprocal of the compounding equation:

0 1 2 3
| | | |
PV = ? 100

FVn = PV(1 + i)n transforms to:

PV = = FVn = FVn(1 + i)-n

thus:

PV = $100 = $100(PVIFi,n) = (0.7513) = $75.13.

The same methods used for finding future values are also used to find present values.
Using a financial calculator input N = 3, I = 10, pmt = 0, FV = 100, and then solve for PV = $75.13.


c. We sometimes need to find how long it will take a sum of money (or anything else) to grow to some specified amount. For example, if a company's sales are growing at a rate of 20 percent per year, how long will it take sales to double?

Answer: We have this situation in time line format:

0 1 2 3 3.8 4
| | | | | |
-12 2

Say we want to find out how long it will take us to double our money at an interest rate of 20%. We can use any numbers, say $1 and $2, with this equation:

FVn = $2 = $1(1 + i)n = $1(1.20)n.

(1.2)n = $2/$1 = 2
n LN(1.2) = LN(2)
n = LN(2)/LN(1.2)
n = 0.693/0.182 = 3.8.

Alternatively, we could use a financial calculator. We would plug I = 20, PV = -1, PMT = 0, and FV = 2 into our calculator, and then press the N button to find the number of years it would take 1 (or any other beginning amount) to double when growth occurs at a 20% rate. The answer is 3.8 years, but some calculators will round this value up to the next highest whole number. The graph also shows what is happening.



d. If you want an investment to double in three years, what interest rate must it earn?


Answer: 0 1 2 3
| | | |
-1 2
1(1 + i) 1(1 + i)2 1(1 + i)3

FV = $1(1 + i)3 = $2.

$1(1 + i)3 = $2.
(1 + i)3 = $2/$1 = 2.
1 + i = (2)1/3
1 + i = 1.2599
i = 25.99%.

Use a financial calculator to solve: enter N = 3, PV = -1, PMT = 0, FV = 2, then press the I button to find I = 25.99%.
Calculators can find interest rates quite easily, even when periods and/or interest rates are not even numbers, and when uneven cash flow streams are involved. (With uneven cash flows, we must use the "CFLO" function, and the interest rate is called the IRR, or "internal rate of return;" we will use this feature in capital budgeting.)



e. What is the difference between an ordinary annuity and an annuity due? What type of annuity is shown below? How would you change it to the other type of annuity?

0 1 2 3
| | | |
100 100 100

Answer: This is an ordinary annuity--it has its payments at the end of each period; that is, the first payment is made 1 period from today. Conversely, an annuity due has its first payment today. In other words, an ordinary annuity has end-of-period payments, while an annuity due has beginning-of-period payments.
The annuity shown above is an ordinary annuity. To convert it to an annuity due, shift each payment to the left, so you end up with a payment under the 0 but none under the 3.


f. 1. What is the future value of a 3-year ordinary annuity of $100 if the appropriate interest rate is 10 percent?

Answer: 0 1 2 3
| | | |
100 100 100
110
121
$331

Go through the following discussion. One approach would be to treat each annuity flow as a lump sum. Here we have

FVAn = $100(1) + $100(1.10) + $100(1.10)2
= $100[1 + (1.10) + (1.10)2] = $100(3.3100) = $331.00.

Using a financial calculator, N = 3, I = 10, PV = 0, PMT = -100. This gives FV = $331.00.

f. 2. What is the present value of the annuity?

Answer: 0 1 2 3
| | | |
100 100 100
90.91
82.64
75.13
$248.68

The present value of the annuity is $248.68. Using a financial calculator, input N = 3, I = 10, PMT = 100, FV = 0, and press the PV button.
Spreadsheets are useful for time lines with multiple cash flows.
The following spreadsheet shows this problem:


A
B
C
D
1
0
1
2
3
2

100
100
100
3
248.69




The excel formula in cell A3 is = NPV(10%,B2:D2). This gives a result of 248.69. Note that the interest rate can be either 10% or 0.10, not just 10. Also, note that the range does not include any cash flow at time zero.
Excel also has special functions for annuities. For ordinary annuities, the excel formula is = PV(interest rate, number of periods, payment). In this problem, = PV(10%,3,-100), gives a result of 248.96. For the future value, it would be = FV(10%,3,-100), with a result of 331.


f. 3. What would the future and present values be if the annuity were an annuity due?

Answer: If the annuity were an annuity due, each payment would be shifted to the left, so each payment is compounded over an additional period or discounted back over one less period.
To find the future value of an annuity due use the following formula:

FVAn(Annuity Due) = FVAn(1 + i).

In our situation, the future value of the annuity due is $364.10:

FVA3(Annuity Due) = $331.00(1.10)1 = $364.10.

This same result could be obtained by using the time line: $133.10 + $121.00 + $110.00 = $364.10.
The best way to work annuity due problems is to switch your calculator to "beg" or beginning or "due" mode, and go through the normal process. Note that it's critical to remember to change back to "end" mode after working an annuity due problem with your calculator.
This formula could be used to find the present value of an annuity due:

PVAn(Annuity Due) = PVAn(1 + i) = PMT(PVIFAi,n)(1 + i).

In our situation, the present value of the annuity due is $273.56:

PVA3(Annuity Due) = $248.69(1.10)1 = $273.56.

The Excel function is = PV(10%,3,-100,0,1). The fourth term, 0, tells Excel there are no additional cash flows. The fifth term, 1, tells Excel it is an annuity due. The result is $273.56.
A similar modification gives the future value: = FV(10%,3,-100,0,1), with a result of 364.10.


g. What is the present value of the following uneven cash flow stream? The appropriate interest rate is 10 percent, compounded annually.

0 1 2 3 4 years
| | | | |
0 100 300 300 -50

Answer: Here we have an uneven cash flow stream. The most straightforward approach is to find the PVs of each cash flow and then sum them as shown below:

0 1 2 3 4 years
| | | | |
100 300 300 -50
90.91
247.93
225.39
(34.15)
530.08

Note (1) that the $50 year 4 outflow remains an outflow even when discounted. There are numerous ways of finding the present value of an uneven cash flow stream. But by far the easiest way to deal with uneven cash flow streams is with a financial calculator or a spreadsheet. Calculators have a function which on the HP 17B is called "CFLO," for "cash flow." other calculators could use other designations such as cf0 and CFi, but they explain how to use them in the manual. You would input the cash flows, so they are in the calculator's memory, then input the interest rate, I, and then press the NPV or PV button to find the present value.
Spreadsheets are especially useful for uneven cash flows. The following spreadsheet shows this problem:


A
B
C
D
E
1
0
1
2
3
4
2

100
300
300
-50
3
530.09




The Excel formula in cell A3 is = NPV(10%,B2:E2), with a result of 530.09.


h. 1. Define (a) the stated, or quoted, or nominal rate, (iNom), and (b) the periodic rate (iPer).

ANSWER: The quoted, or nominal, rate is merely the quoted percentage rate of return. The periodic rate is the rate charged by a lender or paid by a borrower each period (periodic rate = inom/m).



h. 2. Will the future value be larger or smaller if we compound an initial amount more often than annually, for example, every 6 months, or semiannually, holding the stated interest rate constant? Why?

Answer: Accounts that pay interest more frequently than once a year, for example, semiannually, quarterly, or daily, have future values that are higher because interest is earned on interest more often. Virtually all banks now pay interest daily on passbook and money fund accounts, so they use daily compounding.


h. 3. What is the future value of $100 after 5 years under 12 percent annual compounding? Semiannual compounding? Quarterly compounding? Monthly compounding? Daily compounding

Answer: Under annual compounding, the $100 is compounded over 5 annual periods at a 12.0 percent periodic rate:

iNom = 12%.
FVn = = $100 = $100(1.12)5 = $176.23.
Under semiannual compounding, the $100 is compounded over 10 semiannual periods at a 6.0 percent periodic rate:

iNom = 12%.
FVn = = $100 = $100(1.06)10 = $179.08.

quarterly: FVn = $100(1.03)20 = $180.61.

monthly: FVn = $100(1.01)60 = $181.67.

daily: FVn = $100(1+ 0.12/365)365*5 = $182.19.


h. 4. What is the effective annual rate (EAR)? What is the ear for a nominal rate of 12 percent, compounded semiannually? Compounded quarterly? Compounded monthly? Compounded daily?

Answer: The effective annual rate is the annual rate that causes the PV to grow to the same FV as under multi-period compounding. For 12 percent semiannual compounding, the ear is 12.36 percent:

EAR = Effective Annual Rate =

IF iNom = 12% and interest is compounded semiannually, then:

EAR = = (1.06)2 – 1.0 = 1.1236 – 1.0 = 0.1236 = 12,36%.

For quarterly compounding, the effective annual rate is:

(1.03)4 - 1.0 = 12.55%.

For monthly compounding, the effective annual rate is:

(1.01)12 - 1.0 = 12.55%.

For daily compounding, the effective annual rate is:

(1 + 0.12/365)365 - 1.0 = 12.75%.


i. Will the effective annual rate ever be equal to the nominal (quoted) rate?

Answer: If annual compounding is used, then the nominal rate will be equal to the effective annual rate. If more frequent compounding is used, the effective annual rate will be above the nominal rate.



j. 1. Construct an amortization schedule for a $1,000, 10 percent annual rate loan with 3 equal installments.

2. What is the annual interest expense for the borrower, and the annual interest income for the lender, during year 2?

Answer: To begin, note that the face amount of the loan, $1,000, is the present value of a 3-year annuity at a 10 percent rate:

0 1 2 3
| | | |
-1,000 PMT PMT PMT

PVA3 = PMT + PMT + PMT
$1,000 = PMT(1 + i)-1 + PMT(1 + i)-2 + PMT(1 + i)-3
= PMT(1.10)-1 + PMT(1.10)-2 + PMT(1.10)-3.

We have an equation with only one unknown, so we can solve it to find PMT. The easy way is with a financial calculator. Input n = 3, i = 10, PV = -1,000, FV = 0, and then press the PMT button to get PMT = 402.1148036, rounded to $402.11.
Now make the following points regarding the amortization schedule:

The $402.11 annual payment includes both interest and principal. Interest in the first year is calculated as follows:

1st year interest = i ? beginning balance = 0.1 ? $1,000 = $100.

The repayment of principal is the difference between the $402.11 annual payment and the interest payment:

1st year principal repayment = $402.11 - $100 = $302.11.

The loan balance at the end of the first year is:

1st year ending balance = beginning balance – principal repayment
= $1,000 - $302.11 = $697.89.

We would continue these steps in the following years.

Notice that the interest each year declines because the beginning loan balance is declining. Since the payment is constant, but the interest component is declining, the principal repayment portion is increasing each year.

The interest component is an expense which is deductible to a business or a homeowner, and it is taxable income to the lender. If you buy a house, you will get a schedule constructed like ours, but longer, with 30 ? 12 = 360 monthly payments if you get a 30-year, fixed rate mortgage.

The payment may have to be increased by a few cents in the final year to take care of rounding errors and make the final payment produce a zero ending balance.

The lender received a 10% rate of interest on the average amount of money that was invested each year, and the $1,000 loan was paid off. This is what amortization schedules are designed to do.

Most financial calculators have amortization functions built in.


k. Suppose on January 1 you deposit $100 in an account that pays a nominal, or quoted, interest rate of 11.33463 percent, with interest added (compounded) daily. How much will you have in your account on October 1, or after 9 months?

Answer: The daily periodic interest rate is rPer = 11.3346%/365 = 0.031054%. There are 273 days between January 1 and October 1. Calculate FV as follows:

FV273 = $100(1.00031054)273
= $108.85.

Using a financial calculator, input n = 273, i = 0.031054, PV = -100, and PMT = 0. Pressing FV gives $108.85.
An alternative approach would be to first determine the effective annual rate of interest, with daily compounding, using the formula:

EAR = - 1 = 0.12 = 12.0%.

(Some calculators, e.g., the hp 10b and 17b, have this equation built in under the ICNV [interest conversion] function.)
Thus, if you left your money on deposit for an entire year, you would earn $12 of interest, and you would end up with $112. The question, though, is this: how much will be in your account on October 1, 2002?
Here you will be leaving the money on deposit for 9/12 = 3/4 = 0.75 of a year.

0 0.75 1
| | |
-100 FV = ? 112

You would use the regular set-up, but with a fractional exponent:

FV0.75 = $100(1.12)0.75 = $100(1.088713) = $108.87.

This is slightly different from our earlier answer, because n is actually 273/365 = 0.7479 rather than 0.75.


Fractional time periods

Thus far all of our examples have dealt with full years. Now we are going to look at the situation when we are dealing with fractional years, such as 9 months, or 10 years. In these situations, proceed as follows:

As always, start by drawing a time line so you can visualize the situation.

Then think about the interest rate--the nominal rate, the compounding periods per year, and the effective annual rate. If you have been given a nominal rate, you may have to convert to the ear, using this formula:

EAR = .

If you have the effective annual rate--either because it was given to you or after you calculated it with the formula--then you can find the PV of a lump sum by applying this equation:

PV = FVt .

Here t can be a fraction of a year, such as 0.75, if you need to find the PV of $1,000 due in 9 months, or 450/365 = 1.2328767 if the payment is due in 450 days.

If you have an annuity with payments different from once a year, say every month, you can always work it out as a series of lump sums. That procedure always works. We can also use annuity formulas and calculator functions, but you have to be careful.


l. 1. What is the value at the end of year 3 of the following cash flow stream if the quoted interest rate is 10 percent, compounded semiannually?

0 1 2 3 YEARS
| | | | | | |
100 100 100

Answer: 0 1 2 3
| | | | | | |
100 100 100
110.25 = 100(1.05)2
121.55 = 100(1.05)4
331.80

Here we have a different situation. The payments occur annually, but compounding occurs each 6 months. Thus, we cannot use normal annuity valuation techniques. There are two approaches that can be applied: (1) treat the cash flows as lump sums, as was done above, or (2) treat the cash flows as an ordinary annuity, but use the effective annual rate:



Now we have this 3-period annuity:

FVA3 = $100(1.1025)2 + $100(1.1025)1 + $100 = $331.80.

You can plug in n = 3, I = 10.25, PV = 0, and PMT = -100, and then press the FV button to find FV = $331.80.


l. 2. What is the PV of the same stream?

Answer: 0 1 2 3
| | | | | | |
100 100 100
90.70
82.27 PV = 100(1.05)-4
74.62
247.59

PV = $100(2.4759) = $247.59 AT 10.25%.

To use a financial calculator, input N = 3, I = 10.25, PMT = 100, FV = 0, and then press the PV key to find PV = $247.59.


l. 3. Is the stream an annuity?

Answer: The payment stream is an annuity in the sense of constant amounts at regular intervals, but the intervals do not correspond with the compounding periods. This kind of situation occurs often. In this situation the interest is compounded semiannually, so with a quoted rate of 10%, the ear will be 10.25%. Here we could find the effective rate and then treat it as an annuity. Enter N = 3, I = 10.25, PMT = 100, and FV = 0. Now press PV to get $247.59.


l. 4. An important rule is that you should never show a nominal rate on a time line or use it in calculations unless what condition holds? (Hint: think of annual compounding, when iNom = EAR = iPer.) What would be wrong with your answer to questions l(1) and l(2) if you used the nominal rate (10%) rather than the periodic rate (iNom /2 = 10%/2 = 5%)?

Answer: iNom can only be used in the calculations when annual compounding occurs. If the nominal rate of 10% was used to discount the payment stream the present value would be overstated by $272.32 - $247.59 = $24.73.


m. Suppose someone offered to sell you a note calling for the payment of $1,000 15 months from today. They offer to sell it to you for $850. You have $850 in a bank time deposit which pays a 6.76649 percent nominal rate with daily compounding, which is a 7 percent effective annual interest rate, and you plan to leave the money in the bank unless you buy the note. The note is not risky--you are sure it will be paid on schedule. Should you buy the note? Check the decision in three ways: (1) by comparing your future value if you buy the note versus leaving your money in the bank, (2) by comparing the PV of the note with your current bank account, and (3) by comparing the ear on the note versus that of the bank account.

Answer: You can solve this problem in three ways--(1) by compounding the $850 now in the bank for 15 months and comparing that FV with the $1,000 the note will pay, (2) by finding the PV of the note and then comparing it with the $850 cost, and (3) finding the effective annual rate of return on the note and comparing that rate with the 7% you are now earning, which is your opportunity cost of capital. All three procedures lead to the same conclusion. Here is the time line:

0 1 1.25
| | |
-850 1,000

(1) FV = $850(1.07)1.25 = $925.01 = amount in bank after 15 months versus $1,000 if you buy the note. (Again, you can find this value with a financial calculator. Note that certain calculators like the hp 12c perform a straight-line interpolation for values in a fractional time period analysis rather than an effective interest rate interpolation. The value that the hp 12c calculates is $925.42.) This procedure indicates that you should buy the note.
Alternatively, 15 months = (1.25 years)(365 days per year) = 456.25 . 456 days.
FV456 = $850(1.00018538)456
= $924.97.

The slight difference is due to using n = 456 rather than n = 456.25.

(2) PV = $1,000/(1.07)-1.25 = $918.90. Since the present value of the note is greater than the $850 cost, it is a good deal. You should buy it.
Alternatively, PV = $1000/(1.00018538)456 = $918.95.



(3) FVn = PV(1 + i)n, SO $1,000 = $850(1 + i)1.25 = $1,000. Since we have an equation with one unknown, we can solve it for i. You will get a value of i = 13.88%. The easy way is to plug values into your calculator. Since this return is greater than your 7% opportunity cost, you should buy the note. This action will raise the rate of return on your asset portfolio.
Alternatively, we could solve the following equation:

$1,000 = $850(1 + i)456 for a daily i = 0.00035646,

With a result of EAR = EFF% = (1.00035646)365 - 1 = 13.89%.