Question

PLEASE SHOW YORK WORK!! STEP BY STEP! Posting just the answers or excel spreadsheet doesnt help me

Question 2 A firm issues a bond today with a $1,000 face value, an 8% coupon interest rate, and a 25-year maturity. An invest

0 0
Add a comment Improve this question Transcribed image text
Answer #1

2.1 Par value or FV =1000
PMT =8%*1000 =80
Number of Periods =25
Price or PV =1000
Since price is issued at par YTM and coupon rate are same , Hence YTM =8%

2.2 FV =1000
PMT =80
N=25
PV =-900
Using Financial Calculator
N=25;PMT=80;PV=-900;FV=1000;CPT I/Y =7.05%

2.3 FV =1000
PMT =80
N=25-5 =20
PV =-1100
Using Financial Calculator
N=25;PMT=80;PV=-1100;FV=1000;CPT I/Y =9.02%
YTM =9.02%




Add a comment
Know the answer?
Add Answer to:
PLEASE SHOW YORK WORK!! STEP BY STEP! Posting just the answers or excel spreadsheet doesnt help...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Question 2 A firm issues a bond today with a $1,000 face value, an 8% coupon...

    Question 2 A firm issues a bond today with a $1,000 face value, an 8% coupon interest rate, and a 25-year maturity. An investor purchases the bond for $1,000. (2.1) What is the yield to maturity (YTM)? Explain. (2.2) Suppose the investor bought the bond described previously for $900. What is the YTM? (2.3) Suppose the bond described previously has a price of $1,100 five years after it is issued. What is the YTM at that time?

  • PLEASE SHOW WORK STEP BY STEP THAN YOU 17. An asset promises to pay the following:...

    PLEASE SHOW WORK STEP BY STEP THAN YOU 17. An asset promises to pay the following: $60 each year for the next ten years: and $1,000 in ten years Assume all the cash flows are discounted by 6%. Use the annuity formula to get the price of the first part. Use the standard discounting formula to get the price of the second part. Add them together. This is a bond! It is described as paying a coupon rate of 60/1,000...

  • I'm stuck on this homework question. Please, if possible, use Microsoft Excel to solve this problem....

    I'm stuck on this homework question. Please, if possible, use Microsoft Excel to solve this problem. Any help would be greatly appreciated! 2. A firm issues a bond today with a face value of $1,000, a 6.25% coupon rate, annual coupon payments, and a term of 15 years. An investor purchases the bond for $1,249. What is the yield to maturity?

  • can you help step-by-step so I can enter into Excel have been die A1 f A...

    can you help step-by-step so I can enter into Excel have been die A1 f A B с D K M N E F G H 1 J 10. Bond Pricing. A 30-year maturity bond with face value of $1,000 makes annual coupon payments and has a coupon rate of 8%. What is the bond's yield to maturity if the bond is selling for: (L06-2) a. $900? b. $1,000 c. $1,1002 2 3 4 5 6 7 8 9 10...

  • can you help step-by-step so I can enter into Excel ms B С F H 1...

    can you help step-by-step so I can enter into Excel ms B С F H 1 M 1 2. 3 4 5 DE 11. Bond Pricing. A 30-year maturity bond with face value of $1,000 makes semiannual coupon payments and has a coupon rate of 8%. What is the bond's yield to maturity if the bond is selling for: (L06-2) a. $900? b. $1,000? c. $1,1002 6 7 8 9 10 11 12 13 14 15 16 17 18 19...

  • I need to show step by step in excel the answer please If i can get a detailed explanation. Clipboard Font Alignment TA...

    I need to show step by step in excel the answer please If i can get a detailed explanation. Clipboard Font Alignment TAB dD Инт - You just sold a corporate bond with a 5.75% coupon rate that has 14 years left until it matures. 12 | Interest on the bond is paid twice per year. You paid 8% above face value for the bond. What 31 is your YTM on this bond? Format your answer as a percentage, and...

  • I need all parts answered using step by step. Not excel. E 1&2 and also F....

    I need all parts answered using step by step. Not excel. E 1&2 and also F. percent: What is the yield to maturity on a 10-year, 9 percent annual coupon, $1,000 par value bond that sells for $887.002 That sells for $1,134.202 What does the fact that a bond sells at a discount or at a premium te e. (1) ll about the relationship between ra and the bond's coupon rate? you (2) What is the current yield, the capital...

  • 4 part example I need help with. Calculate the price of a bond that matures in...

    4 part example I need help with. Calculate the price of a bond that matures in 20 years with a coupon rate of 3% paid annually, when the market rate is 3%. Calculate the price of a bond where the coupon rate is 5% (pays annually), the market interest rate is 4%, and the life of the bond is 10 years. Suppose that you have an annual pay 7-year bond with a price of $1,100, paying a 4.5% coupon, with...

  • Show step by step process to answer each of the following. Correct Answers: 7)4.50% 8) 3.632%...

    Show step by step process to answer each of the following. Correct Answers: 7)4.50% 8) 3.632% 9)5.56% (7-7) You are considering the purchase of a coupon bond that has a face value of $1,000, pays 3.80% semi-annual coupons, and matures in 8 years. If this bond is currently selling for $953.41, estimate its yield-to-maturity (YTM). (7-8) Currently, the nominal rate prevailing in the market is 7%. If inflation is expected to be 3.25%, estimate the actual real interest rate. (7-9)...

  • Note: If not otherwise stated, assume that: • Yield-to-maturity (YTM) is an APR, semi-annually compounded •...

    Note: If not otherwise stated, assume that: • Yield-to-maturity (YTM) is an APR, semi-annually compounded • Bonds have a face value of $1,000 • Coupon bonds make semi-annual coupon payments; however, coupon rates (rc) are annual rates, i.e., bonds make a semi-annual coupon payment of rc/2 Four years ago, Candy Land Corp. issued a bond with a 14% coupon rate, semi-annual coupon payments, $1,000 face value, and 14-years until maturity. a) You bought this bond three years ago (right after...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT