Explore BrainMass
Share

Zero-Coupon Discount Rate

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

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 September 24, 2018, 11:21 am ad1c9bdddf - https://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.

$2.19