# Zero-Coupon Discount Rate

I would like to have the solution to the following sample problems in EXCEL format, so that I can see the formulas used. Thanks.

1. What is the current value of a zero-coupon bond that pays a face value of $1,000 at maturity in 9 years if the appropriate discount rate is 7%.

Please round your answer to the nearest cent.

2. What interest rate is implicit in a $1,000 par value zero-coupon bond that matures in 5 years if the current price is $430.

Please specify your answer in decimal terms and round your answer to the nearest thousandth (e.g., enter 12.3 percent as 0.123).

3. What is the current value of a $1,000 bond with a 8% annual coupon rate (paid annually) that matures in 9 years if the appropriate discount rate is 5%.

Please round your answer to the nearest cent.

4. What is the current value of a $1,000 bond with a 5% annual coupon rate (paid semi-annually) that matures in 6 years if the appropriate stated annual discount rate is 8%.

Please round your answer to the nearest cent.

© BrainMass Inc. brainmass.com October 25, 2018, 9:43 am ad1c9bdddfhttps://brainmass.com/math/consumer-mathematics/zero-coupon-discount-rate-584101

#### Solution Summary

A few problems related to zero coupon, discount rate, interest, current value, face value calculations are solved here in an Excel file.

Risk-Free Zero Coupon Bond

1. Suppose prices for risk-free zero coupon bonds of 100 face value

with different maturities are:

1 year 93.50, 2 years 85.75, 3 years 77.25

Determine the discount rate for one, two and three-year cash flows.

2. A risk-free 5% annual coupon bond has

a remaining maturity of three years, just having paid its annual interest.

Based on the discount rates determined above, what is its current value?

what is PV of interest year 1, 2, 3, Redemption and Total.

3. Is this a par, premium or discount bond?

4. Compute the current yield of that bond. (Current Yield

is the ratio of the annual interest payment and the bond's

current clean price)

5. Now state the general relationship between coupon rate and current

yield for

a) Par bonds b) Discount bonds c) Premium bonds

6.Explain what a swap rate is. What is the relationship between swap

rates and par yields.

7. The 1 year Libor rate is 10%. A bank trades swaps where a fixed rate of interest is

exchanged for 12 months Libor with payments being

exchanged ANNUALLY (yes annually). The 2 and 3 year swap rates for

annually payment exchange swaps are 11% and 12%. Estimate the 2 and 3 year

Libor zero rates.

8.A corporate treasurer tells you that he has just negotiated a 5

year loan at a competitive fixed interest rate 5.2%

The treasurer explains that he achieved the 5.2% rate by borrowing at

6-month Libor plus 150 basis points asnd swapping Libor for 3.7%

He goes on to say that this is possible because his company has a

comparative advantage in the floating rate market.

What has the treasurer overlooked.