Question

i need to know on excel how to calculate the yield to maturity of a bond with the information below. it can be random numbers

- Number of periods
- Present value (price)
- Face value
- Coupon rate

i also need a second calculation that shows me the YTM if this bond pays semi-annually instead of annually it can be random numbers.

Answer #1

A bond was issued three years ago at a price of $1,040 with a
maturity of six years, a yield-to-maturity (YTM) of 5.25%
compounded semi-annually, and a face value of $1,000 with
semi-annualy coupons. What is the price of this bond today
immediately after the receipt of today's coupon if the YTM has
risen to 6.50% compounded semi-annually?

A bond was issued three years ago at a price of $1,052 with a
maturity of six years, a yield-to-maturity (YTM) of 6.75%
compounded semi-annually, and a face value of $1,000 with
semi-annualy coupons. What is the price of this bond today
immediately after the receipt of today's coupon if the YTM has
risen to 8.00% compounded semi-annually?

A bond was issued three years ago at a price of $934 with a
maturity of six years, a yield-to-maturity (YTM) of 4.75%
compounded semi-annually, and a face value of $1,000 with
semi-annualy coupons. What is the price of this bond today
immediately after the receipt of today's coupon if the YTM has
fallen to 3.50% compounded semi-annually?

A bond was issued three years ago at a price of $1,060 with a
maturity of six years, a yield-to-maturity (YTM) of 7.75%
compounded semi-annually, and a face value of $1,000 with
semi-annualy coupons. What is the price of this bond today
immediately after the receipt of today's coupon if the YTM has
risen to 9.00% compounded semi-annually?

A bond was issued three years ago at a price of $1,040 with a
maturity of six years, a yield-to-maturity (YTM) of 5.25%
compounded semi-annually, and a face value of $1,000 with
semi-annualy coupons. What is the price of this bond today
immediately after the receipt of today's coupon if the YTM has
risen to 6.50% compounded semi-annually?

A bond was issued three years ago at a price of $960 with a
maturity of six years, a yield-to-maturity (YTM) of 8.00%
compounded semi-annually, and a face value of $1,000 with
semi-annualy coupons. What is the price of this bond today
immediately after the receipt of today's coupon if the YTM has
fallen to 6.75% compounded semi-annually?
options: $985
$1,011
$1,036
$1,061
$1,086

A bond was issued three years ago at a price of $1,038 with a
maturity of six years, a yield-to-maturity (YTM) of 5.00%
compounded semi-annually, and a face value of $1,000 with
semi-annualy coupons. What is the price of this bond today
immediately after the receipt of today's coupon if the YTM has
risen to 6.25% compounded semi-annually? $962 $986 $1,011 $1,036
$1,060

A bond was issued three years ago at a price of $1,034 with a
maturity of six years, a yield-to-maturity (YTM) of 4.50%
compounded semi-annually, and a face value of $1,000 with
semi-annualy coupons. What is the price of this bond today
immediately after the receipt of today's coupon if the YTM has
risen to 5.75% compounded semi-annually?
$885
$910
$935
$959
$984

Hi, I need the answer in an excel sheet plz A HCA's bond,
maturing in 7 years, pays 8 percent interest on a $1,000 face
value. However, interest is paid semi-annually. If your required
rate of return is 10 percent, what is the value of the bond? What
is the value if the interest were paid annually? Note: format is
$xxx.xx

A bond was issued three years ago at a price of $934 with a
maturity of six years, a yield-to-maturity (YTM) of 4.75%
compounded semi-annually, and a face value of $1,000 with
semi-annualy coupons. What is the price of this bond today
immediately after the receipt of today's coupon if the YTM has
fallen to 3.50% compounded semi-annually?
Question 14 options:
$974
$999
$1,024
$1,049
$1,074

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 12 minutes ago

asked 36 minutes ago

asked 37 minutes ago

asked 40 minutes ago

asked 46 minutes ago

asked 47 minutes ago

asked 54 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago