Question

Calculate Bond price : In reference to problem above, If borrower (corporation) has financial issues and...

  1. Calculate Bond price :
    1. In reference to problem above, If borrower (corporation) has financial issues and the company gets downgraded by rating agencies (like Moody’s or Fitch) and the YTM goes up to 6 %. Calculate the price of the bond with this higher risk situation ( hence higher YTM)
  1. Calculate expected rate ( Yield to maturity) :
    • Bond Price : 900
    • N= 10 years
    • Coupon rate : 6 % ( Annual payments)
    • Par Value : 1000
    • YTM: ? ( Hint Use “RATE” from Excel financial formulas)

Homework Answers

Answer #1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Know the answer?
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
Similar Questions
Calculate the new price of bond at the new YTM of 2%, 4%, 6%, 8%, and...
Calculate the new price of bond at the new YTM of 2%, 4%, 6%, 8%, and 10% for both 5-years bond and 30-years bond. Plot the graph of the relationship between the price and YTM for each bond on the same graph. What did you find regarding the relationship between price and YTM for shorter and longer maturity bond? Which bond has a higher sensitive to the change in the price when the yield change? Bond Rating Coupon Rate (%)...
Hamilton Pawn Shop has two bond issues outstanding. Compute the weighted average cost of debt for...
Hamilton Pawn Shop has two bond issues outstanding. Compute the weighted average cost of debt for HPS using the following data: Bond Issue A                  Bond Issue B Face Value                                                    1000                           1000 Current Price                                                97                                104 Coupon rate                                                  5%                              7% Payable                                                         Annually                     Semiannually            Years to maturity                                          14                                6 Number of bonds outstanding                   4000                           2500 What is the YTM on bond A? _________________ What is the YTM on bond B? _________________ What is the market value weight (percentage)...
Part (A) Assume an original issue bond with 30 years remaining to maturity which has a...
Part (A) Assume an original issue bond with 30 years remaining to maturity which has a coupon rate of 4.5 % and the going rate of interest in the market is 4.5%. Its par value is $1000. Part (B) What would its price be? Show all calculations, either in formulas or in Excel Part (C) In Part (A)above, did you actually have to calculate the price? Could make a reason that the price should be $1000.
Microhard has issued a bond with the following characteristics: Par: $1,000 Time to maturity: 20 years...
Microhard has issued a bond with the following characteristics: Par: $1,000 Time to maturity: 20 years Coupon rate: 8 percent Semiannual payments Calculate the price of this bond if the YTM is: a. 10 percent b. 8 percent c. 6 percent Bond yields are quoted as APRs. For part a, use 3 methods to calculate the bond price: 1. PV of future cash flows; 2. Bond price formula; 3. Excel built-in function “PRICE”. For parts b and c, use excel.
Ques 1 a) Assume an original issue bond with 30 years remaining to maturity which has...
Ques 1 a) Assume an original issue bond with 30 years remaining to maturity which has a coupon rate of 4.5 % and the going rate of interest in the market is 4.5%. Its par value is $1000. b. What would its price be? Show all calculations, either in formulas or in Excel. c. In a above, did you actually have to calculate the price? Could make a reason that the price should be $1000. Ques 2. a) If the...
You are currently considering buying an Ecolab corporate bond. The bond has the following characteristics: The...
You are currently considering buying an Ecolab corporate bond. The bond has the following characteristics: The current year is 2018 $1000 Par value of bond 8% Coupon rate   Bond was issued in 2013 Bond will mature in 2043 Payments are made semi-annually Callable 10 years after issue Call price $1050 Current market interest rate   6% What is this bond's current yield? What is this bond's yield - to - maturity? What is this bond's yield - to - call? Why...
Finance 1. A bond has a $1,000 par value, 10 years to maturity, and an 8%...
Finance 1. A bond has a $1,000 par value, 10 years to maturity, and an 8% annual coupon and sells for $980. a. What is its yield to maturity (YTM)? Round your answer to two decimal places. __% b. Assume that the yield to maturity remains constant for the next four years. What will the price be 4 years from today?Do not round intermediate calculations. Round your answer to the nearest cent. $____ 2. Nesmith Corporation's outstanding bonds have a...
Calculation of individual costs and WACC   Dillon Labs has asked its financial manager to measure the...
Calculation of individual costs and WACC   Dillon Labs has asked its financial manager to measure the cost of each specific type of capital as well as the weighted average cost of capital. The weighted average cost is to be measured by using the following​ weights: 30​% ​long-term debt, 10​% preferred​ stock, and 60​% common stock equity​ (retained earnings, new common​ stock, or​ both). The​ firm's tax rate is 22​%. Debt The firm can sell for ​$1025 a 13​-year, ​$1, 000​-par-value...
Calculation of individual costs and WACC   Dillon Labs has asked its financial manager to measure the...
Calculation of individual costs and WACC   Dillon Labs has asked its financial manager to measure the cost of each specific type of capital as well as the weighted average cost of capital. The weighted average cost is to be measured by using the following​ weights: 30​% ​long-term debt, 10​% preferred​ stock, and 60​% common stock equity​ (retained earnings, new common​ stock, or​ both). The​ firm's tax rate is 22​%. Debt The firm can sell for ​$1025 a 13​-year, ​$1, 000​-par-value...
The financial data for a corporation is provided to calculate all the following question. Most recent...
The financial data for a corporation is provided to calculate all the following question. Most recent annual common dividend $4.00 Today’s common stock price $50.00 U.S. Treasury 10y annual rate 3 percent Market risk premium 5 percent Equity Risk Premium on Bond Yield 10 percent Number of common shares outstanding 2.5 million Today’s preferred stock price $100.00 Fixed preferred dividend $8.00 Constant growth rate 6 percent Beta β 2.0 Floatation costs for Preferred and common stock issuance 7 percent Market...