roblem 6: (See Problem 1_ Demonstration)

Bond Valuation

Time to Maturity (Years)

15

Coupon Rate

6.50%

Price

$897.25

Frequency

2 (Semi-Annual)

Face Value

$ 1,000

Given the price; Calculate the yield to maturity (YTM) for the bond in

Excel

Use RATE function

Problem 7:

See Problem 2 Demonstration

2)

Settlement Date

2/15/20

Maturity Date

2/15/30

Coupon Rate

6.00%

Required Return

(YTM)

7.00%

Face Value

1000

Frequency

2

Semi-Annual

Interest Payment

Basis

0

Given the yield to Maturity;

calculate the price of the bond

using PRICE function in

Excel

Problem 8:

Settlement Date

2/15/20

Maturity Date

2/15/30

Coupon Rate

6.00%

Price of the bond

$900.00

Face Value

1000

Frequency

2

Semi-Annual

Interest Payment

Basis

0

Given the price of the bond

calculate the Yield to maturity

using YIELD function in

Excel.