Question

i need to know on excel how to calculate the yield to maturity of a bond...

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.

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A bond was issued three years ago at a price of $1,040 with a maturity of...
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...
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...
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...
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...
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?
Hi, I need the answer in an excel sheet plz A HCA's bond, maturing in 7...
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 $960 with a maturity of...
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...
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...
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
A bond was issued three years ago at a price of $934 with a maturity of...
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
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT