Question

How to solve this problem in excel? A 20-year, 9.00% semi-annual coupon bond with a face...

How to solve this problem in excel?

  1. A 20-year, 9.00% semi-annual coupon bond with a face value of $1,000 is selling for $914.20. The yield to maturity of the bond is closest to: A. 8%.B. 9%. C. 10%.

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Ans:- In this question we need to find the Yield To Maturity. we will use the RATE function of excel to find the answer.

Nper = 20*2=40,Pmt = $1000*9%/2 = $45, PV = -$914.20, FV = $1000.

we have multiplied by 2 because the RATE function has given the YTM semi-annually and we need to convert it annually.

Therefore, the YTM for the bond is closest to 10%. option (c) is the right answer.

Note:- If this answer helps you pls give thumbs up.

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
Genesis corp. issued a 20-year semi-annual bond with a face value of $1,000, and an annual...
Genesis corp. issued a 20-year semi-annual bond with a face value of $1,000, and an annual coupon rate of 8%. The bond equivalent yield (BEY) is 9%. What is the Bond’s price? $936 $908 $1,080 $1,000 $966
a 10-year bond, $1,000 face value bond with a 8% coupon rate and semi-annual coupons has...
a 10-year bond, $1,000 face value bond with a 8% coupon rate and semi-annual coupons has a yield to maturity of 12%. the bond should be trading at the price of? round to nearest cent
a)You purchase a 3-year US government bond with a face value of €1,000 and semi-annual coupon...
a)You purchase a 3-year US government bond with a face value of €1,000 and semi-annual coupon payments amounting to €25. The bond will still make six coupon payments plus pay back the principal. If the semi-annual yield to maturity is currently 5%, the present value of this bond would be? b) Computer stocks currently provide an expected rate of return of 16%. MBI, a large computer company, will pay a year-end dividend of €2 per share. If the stock is...
A 20-year maturity bond with face value of $1,000 makes annual coupon payments and has a...
A 20-year maturity bond with face value of $1,000 makes annual coupon payments and has a coupon rate of 8.8%. (Do not round intermediate calculations. Enter your answers as a percent rounded to 3 decimal places.) a. What is the bond’s yield to maturity if the bond is selling for $980? b. What is the bond’s yield to maturity if the bond is selling for $1,000? c. What is the bond’s yield to maturity if the bond is selling for...
A 20-year, $1,000 par value bond has a 9% semi-annual coupon. The bond currently sells for...
A 20-year, $1,000 par value bond has a 9% semi-annual coupon. The bond currently sells for $925. If the yield to maturity remains at its current rate, what will the price be 8 years from now? a. $937.7 b. $956.95 c. $939.85 d. $503.21
A 20-year, $1,000 par value bond has a 9% semi-annual coupon. The bond currently sells for...
A 20-year, $1,000 par value bond has a 9% semi-annual coupon. The bond currently sells for $925. If the yield to maturity remains at its current rate, what will the price be 10 years from now? a. $935.01 b. $930.01 c. $952.84 d. $945.72
What is the value of a bond that pays a 6% semi-annual coupon, has a face...
What is the value of a bond that pays a 6% semi-annual coupon, has a face value of $1,000, matures in 20 years, and has a yield to maturity of 8%? Question 45 options: $803.64 $808.43 $805.12 $802.07
1. Analyze the 20-year, 8% coupon rate (Semi-annual payment), $1,000 par value bond. The bond currently...
1. Analyze the 20-year, 8% coupon rate (Semi-annual payment), $1,000 par value bond. The bond currently sells for $1,218. What's the bond's yield to maturity? A. 5.06% B. 5.68% C. 5.38% D. 6.10% 2. Analyze the 20-year, 8% coupon rate (Semi-annual payment), $1,000 par value bond. The bond currently sells for $1,218. What's the bond's current yield, and capital gain yield? (Please show your work) A. 6.57%, -0.47% B. 6.07%, -0.69% C. 6.57%, -0.47% D. 6.07%, 0.69%
An 8%, semi-annual coupon bond has a $1,000 face value and matures in 8 years. What...
An 8%, semi-annual coupon bond has a $1,000 face value and matures in 8 years. What is the current yield on this bond if the yield to maturity is 7.8%?
A bond has a face value of $1,000, a coupon rate of 8%, and a maturity...
A bond has a face value of $1,000, a coupon rate of 8%, and a maturity of 10 years.  The bond makes semi-annual coupon payments.  The bond’s yield to maturity is 9%.  In Excel, the =PV formula can be used to find the price of the bond.  Fill in the table with the appropriate values: RATE NPER PMT FV TYPE Repeat problem , but with annual coupon payments. RATE NPER PMT FV TYPE
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT