Suppose you can buy a U.S. Treasury bond which makes no payments until the bond matures 10 years from now, at which time it will pay you $1,000. What interest rate would you earn if you bought this bond for $585.43?

N 10

PMT $0

PV $585.43

FV $1,000

I =

What rate would you earn if you could buy the bond for $550?

N 10

PMT $0

PV $550.00

FV $1,000

I =

Microsoft earned $0.33 per share in 1997. Fourteen years later, in 2011, it earned $2.75. What was the growth rate in Microsofts earnings per share (EPS) over the 14-year period?

N 14

PMT $0

PV $0.33

FV $2.75

I =

EPS 2011 been $2.00 than $2.75 what would the growth rate have been?

N 14

PMT $0

PV $0.33

FV $2.00

I =

Use Excel Functions Show please show how to get there.