#### Transcript Chapter 6 Homework

```Chapter 6 Homework
Pg. 268 ST-2; ST-4
Pg. 270 6-6; 6-10
Pg. 271 6-12
Pg. 274 6-25
Pg. 268 ST-2
In the introduction to this chapter we asked
whether you would prefer to invest \$5,500 today
and receive either \$7,020 in five years or \$8,126
in eight years. You should now be able to
determine which investment alternative is better.
a.
Based only on the return you would earn from each
investment, which is better?
b. Can you think of any factors other than the
expected return that might be important to consider
when choosing between the two investment
alternatives?
Pg. 268 ST-2a
0
1
2
3
4
5
6
7
7, 020
Option A -5,500
Option B -5,500
8,126
FVn = PV(1+i)n
Option A
7,020
7,020/5,500
1.2764
1.27641/5
1.0500
i
8
= 5,500(1+i)5
= (1+i)5
= (1+i)5
= (1+i)
= (1+i)
= 5%
Option B
8,126
= 5,500(1+i)8
8,126/5,500 = (1+i)8
1.4775
= FVIFi,8
Table Lookup
1.4775
= FVIF5%,8
Pg. 268 ST-2b
Other Factors to Consider:
– Risk of 8-year investment vs. 5-year
– Timing
– Rate Expectations
Pg. 268 ST-4
Assume that it is now January 1, 2000,
and you will need \$1,000 on January 1,
2004. Your bank compounds interest at an
eight percent annual rate.
‘00
8%
‘01
‘02
‘03
‘04
1,000
‘00
8%
Pg.
268
ST-4
‘01
‘03
‘02
1,000
PV=?
a.
‘04
How much must you deposit on January 1, 2001, to
have a balance of \$1,000 on January 1, 2004?
PV=FV[1/(1+i)n]
PV
PV
PV
= 1,000[1/(1+0.08)3]
= 1,000[0.7938]
= 793.83
‘00
8%
Pg.
268
ST-4
‘01
‘03
‘02
PMT
PMT
PMT
‘04
PMT
1,000
b. If you want to make equal payments to each January
1 from 2001 through 2004 to accumulate the \$1,000,
how large must each of the four payments be?
FVAn = PMT(FVIFAi,n)
1,000
= PMT(4.5061)
1,000/4.5061 = 221.92
‘00
8%
Pg.
268
ST-4
‘01
‘03
‘02
750
c.
‘04
FV
If your father were to offer either to make the payments
calculated in part (b) (\$221.92) or to give you a lump sum of
\$750 on January 1, 2001, which would you choose?
Input:
3
8
-750
N I/Y PV
Output:
0
PMT
FV
944.78
You should take the payments of \$221.92 (FV = \$1,000) instead
of the \$750 on 1/1/01 which will only be worth \$944.78.
‘00
?%
Pg.
268
ST-4
‘01
‘03
‘02
750
‘04
1,000
d. If you have on \$750 on January 1, 2001, what interest
rate, compounded annually, would you have to earn
to have the necessary \$1,000 on January 1, 2004?
FV = PV(1+i)n
1,000
1,000/750
1.33331/3
1.1006
i
= 750(1+i)3
= (1+i)3
= (1+i)
= (1+i)
=10.06%
‘00
?%
Pg.
268
ST-4
‘01
‘03
‘02
-186.29
e.
-186.29
-186.29
1,000.00
Suppose you can deposit \$186.29 on each January 1
from 2001 through 2004, but you still need \$1,000 on
January 1, 2004. What interest rate, with annual
compounding, must you seek out to achieve your
goal? Input:
1,000
4
N I/Y
Output:
19.99
-186.29
‘04
0 -186.29
PV PMT
FV
‘00
8%
Pg.
268
ST-4
‘01
‘03
‘02
-400
f.
PMT
PMT
PMT
PMT
‘04
PMT
PMT
1,000
you \$400 on January 1, 2001. You will get a part-time job and
make six additional payment of equal amounts each six months
thereafter. If all of this money is deposited in a bank that pays
eight percent, compounded semiannually, how large must each
of the six payments be?
Part 1 Input:
6
4
400
N I/Y PV
Output:
Part 2 Input:
FV
506.13
6
4
0
N I/Y PV
Output:
0
PMT
493.87
PMT
74.46
FV
‘00
8%
Pg.
268
ST-4
‘01
‘03
‘02
‘04
g. What is the effective annual rate being paid
by the bank in part f?
Effective Annual Rate = EAR = [1+(isimple/m)]m-1
Where: m = # of compounding periods per year
EAR
EAR
= [1+(.08/2)]2-1
= 8.16%
Pg. 270 6-6
Find the present values of the following cash
flow streams under the following conditions:
Year
Cash Stream A
1
2
3
4
5
\$100
400
400
400
500
Cash Stream B
\$300
400
400
400
100
Pg. 270 6-6
a. i = 8%
Stream A:
8%
Year
1
2
3
4
5
Rate
FV PVIFi,n
PV
\$100 0.9259
\$92.59
\$400 0.8573
\$342.94
\$400 0.7938
\$317.53
\$400 0.7350
\$294.01
\$300 0.6806
\$204.17
PVA
\$1,251.25
Stream B:
CF
CFo=
C01=
F01=
C02=
F02=
C03=
F03=
CPT
0.00
300.00
1.00
400.00
3.00
100.00
1.00
NPV
I =
NPV CPT
8.00
1,300.32
Pg. 270 6-6
b. i = 0%
Stream A:
0%
Year
1
2
3
4
5
Rate
FV PVIFi,n
PV
\$100 1.0000
\$100.00
\$400 1.0000
\$400.00
\$400 1.0000
\$400.00
\$400 1.0000
\$400.00
\$300 1.0000
\$300.00
PVA
\$1,600.00
Stream B:
CF
CFo=
C01=
F01=
C02=
F02=
C03=
F03=
CPT
0.00
300.00
1.00
400.00
3.00
100.00
1.00
NPV
I =
NPV CPT
0.00
1,600.00
Pg. 270 6-10a
Find the future values of the following
ordinary annuities:
a.
FV of \$400 each six months for five years at a simple
rate of 12 percent, compounded semiannually.
Input:
10
6
0
N I/Y PV
Output:
-400
PMT
FV
5,272.32
Pg. 270 6-10b
Find the future values of the following ordinary
annuities:
b. FV of \$200 each three months for five years at a
simple rate of 12 percent, compounded quarterly.
Input:
20
3
0
N I/Y PV
Output:
-200
PMT
FV
5,374.07
Pg. 270 6-10c
Find the future values of the following ordinary
annuities:
c. The annuities described in parts (a) and (b) have the
same amount of money paid into them during the fiveyear period and both earn interest at the same simple
rate, yet the annuity in part (b) ears \$101.76 more than
the one in part (a) over the five years. Why does this
occur?
The first payment is made 3 months earlier in (b) than
in (a) and the effect of more frequent compounding
both contribute to the higher earnings.
Pg. 271 6-12
Lorkay Seidens Inc. just borrowed \$25,000. The
loan is to be repaid in equal installments at the end of
each of the next five years, and the interest rate is ten
percent.
a. Set up an amortization schedule for the loan.
b. How large must each annual payment be if the loan is
for \$50,000? Assume that the interest rate remains at
ten percent and that the loan is paid off over five
years.
Pg. 271 6-12a
a. 10% Interest
Year Payment
1
(\$6,594.94)
2
(\$6,594.94)
3
(\$6,594.94)
4
(\$6,594.94)
5
(\$6,594.94)
Interest
Loan Amount
25,000
Principal
Balance
(\$2,500.00)
(\$2,090.51)
(\$1,640.06)
(\$1,144.58)
(\$599.54)
(\$4,094.94)
(\$4,504.43)
(\$4,954.87)
(\$5,450.36)
(\$5,995.40)
(\$32,974.69) (\$7,974.69)
(\$25,000.00)
In Excel:
Payment = PMT(rate,Nper,PV,FV,Type)
Interest = IPMT(rate,Per,Nper,PV,FV)
Principle = PPMT(rate,Per,Nper,PV,FV,Type)
Balance = Loan Amount -Principal
\$20,905.06
\$16,400.63
\$11,445.76
\$5,995.40
\$0.00
Pg. 271 6-12b
a. 10% Interest
Year Payment
1
(\$13,189.87)
2
(\$13,189.87)
3
(\$13,189.87)
4
(\$13,189.87)
5
(\$13,189.87)
Interest
Loan Amount
50,000
Principal
Balance
(\$5,000.00)
(\$4,181.01)
(\$3,280.13)
(\$2,289.15)
(\$1,199.08)
(\$8,189.87)
(\$9,008.86)
(\$9,909.75)
(\$10,900.72)
(\$11,990.79)
(\$65,949.37) (\$15,949.37)
(\$50,000.00)
In Excel:
Payment = PMT(rate,Nper,PV,FV,Type)
Interest = IPMT(rate,Per,Nper,PV,FV)
Principle = PPMT(rate,Per,Nper,PV,FV,Type)
Balance = Loan Amount -Principal
\$41,810.13
\$32,801.26
\$22,891.52
\$11,990.79
\$0.00
Pg. 271 6-12c
c.
How large must each payment be if the loan is for \$50,000, the
interest rate is ten percent, and the loan is paid off in equal
installments at the end of each of the next ten years? This loan
is for the same amount as the loan in part (b), but the payments
are spread out over twice as many periods. Why are these
payments not half as large as the payments on the loan in part
(b)?
Input:
10
N I/Y PV
Output:
0
10 50,000
PMT
FV
8,137.27
Because the payments are spread out over a longer period of
time, more interest must be paid. The total interest paid on the
10-year loan is \$31,373, while the total for the 5-year loan is
\$15,949, however the same principal (\$50,000) is repaid over a
longer period of time so that the total payment per year is not
doubled.
Pg. 274 6-25
While Steve Bouchard was a student at the University of Florida, he
borrowed \$12,000 in student loans at an annual interest rate of nine
percent. If Steve repays \$1,500 per year, how long, to the nearest year,
will it take him to repay the loan?
PVAn = PMT(PVIFAi,n)
Input:
N
Output: 14.77
9 12,000 1,500
I/Y PV PMT
0
FV
```