Question

 

Sam Strother and Shawna Tibbs are vice presidents of Mutual of Seattle Group Health Cooperative and codirectors of the organization's pension fund management division. The unions that represent the GHC hospital staff have requested an investment seminar so that they better understand the decisions being made on behalf of their members. Strother and Tibbs, who will make the actual presentation, have asked you to help them by answering the following questions.

a. What is the value of a ten-year, $1,000 par value bond with a 10 percent annual coupon if its required rate of return is 10 percent?

b. What would be the value of the bond described in question a. if, just after it had been issued, the expected inflation rate rose by 3 percentage points, causing investors to require a 13 percent return? Would we now have a discount or a premium bond?

c. What would be the value of the bond described in question a. if, just after it had been issued, the expected inflation rate fell by 3 percentage points, causing investors to require a 7 percent return? Would we now have a discount or a premium bond?

d. What would happen to the value of the ten-year bond over time if the required rate of return remained at 13 percent, remained at 7 percent, or remained at 10 percent? Graph your results using the table below:

	Value of Bond in Given Year:
N	7%	10%	13%
0
1
2
3
4
5
6
7
8
9
10

e. What is the yield to maturity on a ten-year, 9 percent annual coupon, $1,000 par value bond that sells for $887.00?

f. What are the total return, the current yield, and the capital gains yield for the bond in question e.? (Assume the bond is held to maturity and the company does not default on the bond.)

Answer 1

a-	VALUE OF BOND	USING PRESENT VALUE FUNCTION IN M S EXCEL	PV(RATE,NPER,PMT,FV,TYPE)	PV(10%,10,100,1000,0)	($1,000.00)
b-	VALUE OF BOND	USING PRESENT VALUE FUNCTION IN M S EXCEL	PV(RATE,NPER,PMT,FV,TYPE)	PV(13%,10,100,1000,0)	($837.21)
	Bond would be issued at discount
C-	VALUE OF BOND	USING PRESENT VALUE FUNCTION IN M S EXCEL	PV(RATE,NPER,PMT,FV,TYPE)	PV(7%,10,100,1000,0)	($1,210.71)
	Bond would be issued at premium
		Value of bond
D-	Year	7%	10%	13%
	0	-837.21	1000	1210.71
	1	($846.05)	1000	($1,195.46)
	2	($856.04)	1000	($1,179.14)
	3	($867.32)	1000	($1,161.68)
	4	($880.07)	1000	($1,143.00)
	5	($894.48)	1000	($1,123.01)
	6	($910.77)	1000	($1,101.62)
	7	($929.17)	1000	($1,078.73)
	8	($949.96)	1000	($1,054.24)
	9	($973.45)	1000	($1,028.04)
	10	($1,000.00)	1000	($1,000.00)
E	Yield to maturity	Using rate function in MS excel	rate(nper,pmt,pv,fv,type)	RATE(10,90,-887,1000,0)	10.91%
F-	current yield	interest/current market price	(90*10)/887	101%
	capital gain yield	(1000-887)/887		12.74%
	total return			114.21%