Question: just need question E & F answered please. Start with the partial model in the file Ch04 P24 Build a Model.xlsx. A 20-year, 9% semiannual

just need question E & F answered please.

Start with the partial model in the file Ch04 P24 Build a Model.xlsx. A 20-year, 9% semiannual coupon bond with a par value of $1,000 may be called in 6 years at a call price of $1,080. The bond sells for $1,130 (Assume that the band has just been issued.) The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations x Download spreadsheet.Cho4P24. Bild a Model-cents3,XX What is the bond's yield to maturity? Round your answer to two decimal places, 7.71% b. What is the bond's current yield? Round your answer to two decimal places. 7.96 % c. What is the bond's capital gain or loss yield? Round your answer to two decimal places. Use a minus sign to enter a negative value. If any. -0.25 d. What is the band's yield to call? Found your answer to two decimal places 17.36 How would the price of the bond be affected by a change in the going market interest rate? (Hint: Conduct a sensitivity analysis of price to changes in the going market interest rate for the bond. Assume that the bond will be called it and only if the going rate of interest is below the coupon rate. This is an oversimplification, but assume it for purposes of this problem.) Round your answers to the nearest cent Nominal market rate Actual hond price 09 A o e. How would the price of the bond be affected by a change in the going market interest rate? (Hint: Conduct a sensitivity analysis of price to changes in the going market interest rate for the bond. Assume that the bond will be called it and only if the going rate of interest fails below the coupon rate. This is an oversimplification, but assume it for purposes of this problem.) Round your answers to the nearest cent. Nominal market rate Actual bond price 0% 2% 4 4 $ $ $ $ 4 6% 8% 10% 12% 14% 16% $ $ 5 $ 5 t. Now assume the date is October 25, 2020. Assume further that an 11%, 15-year bond was issued on July 1, 2020, pays interest semiannually (on January 1 and July 1), and sells for $1,130. Again, it may be called in 6 years from the date of issue at a call price of $1,080. Use your spreadsheet to find the band's yield. Round your answers to two decimal places Yield to maturity Yield to call

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

I am literally spinning my wheels here everything I did before was completely wrong and I have been wasting hours with a massive question mark over my head. The main main thing I need help with is...

Excel Activity: Bond Valuation Start with the partial model in the file Ch04 P24 Build a Model.xlsx. A 25-year, 6% semiannual coupon bond with a par value of $1,000 may be called in 8 years at a call...

Start with the partial model in the file Ch04 P24 Build a Model.xlsx . A 20-year, 9% semiannual coupon bond with a par value of $1,000 may be called in 6 years at a call price of $1,080. The bond...

Excel Activity: Bond Valuation Start with the partial model in the file Ch 0 4 P 2 4 Build a Model.xIsx. A 2 5 - year, 6 % semiannual coupon bond with a par value of $ 1 , 0 0 0 may be called in 5...

Excel Activity: Bond Valuation Start with the partial model in the file Ch 0 4 P 2 4 Build a Model.xlsx . A 2 0 - year, 8 % semiannual coupon bond with a par value of $ 1 , 0 0 0 may be called in 5...

Bond Valuation Years to maturity 1 5 Number of coupon payment per year 2 Coupon rate 7 % Par value $ 1 , 0 0 0 Current price $ 1 , 0 9 0 Call price $ 1 , 0 3 0 Years until bond is callable 5 a ....

3 Bond Valuation Years to maturity a . Calculating the bond's yield to maturity Periodic YTM Annualized nominal YTM b . Calculating the bond's current yield Current yield Formulas I $ N A #N / A #N /...

Start with the partial model in the file Ch 0 4 P 2 4 Build a Model.xlsx . A 2 0 - year, 8 % semiannual coupon bond with a par value of $ 1 , 0 0 0 may be called in 5 years at a call price of $ 1 , 0...

Excel Activity: Bond Valuation Start with the partial model in the file Ch 0 4 P 2 4 Build a Model.xlsx . A 1 5 - year, 9 % semiannual coupon bond with a par value of $ 1 , 0 0 0 may be called in 4...

Start with the partial model in the file Ch 0 4 P 2 4 Build a Model.xlsx . A 2 5 - year, 9 % semiannual coupon bond with a par value of $ 1 , 0 0 0 may be called in 4 years at a call price of $ 1 , 0...

Explain physical activity and physical fitness.

Summarize arguments for and against genetic screening and genetic engineering of offspring.

Why would an intemational e - commerce marketer consider adding a "butler margin" to product prices in cortain markets? Thothimk ieud complance rate is lower than 1 , and the marketer neods to cover...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...