Question: Start with the partial model in the file Ch04 P24 Build a Model.xls on the textbook's Web site. A 20-year, 8% semiannual coupon bond with

Start with the partial model in the file Ch04 P24 Build a Model.xls on the textbook's Web site. A 20-year, 8% semiannual coupon bond with a par value of $1,000 may be called in 5 years at a call price of $1,040. The bond sells for $1,100. (Assume that the bond has just been issued.)

a. What is the bond's yield to maturity?

b. What is the bond's current yield?

c. What is the bond's capital gain or loss yield?

d. What is the bond's yield to call?

e. How would the price of the bond be affected by a change in the going market interest rate?

f. Now assume the date is October 25, 2016. Assume further that a 12%, 10-year bond was issued on July 1, 2016, pays interest semiannually (on January 1 and July 1) and sells for $1,100. Use your spreadsheet to find the bond's yield.

Step by Step Solution

★★★★★

3.44 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

A 20year 8 semiannual coupon bond with a par value of 1000 may be called in 5 years at a call price of 1040 The bond sells for 1100 Assume that the bo... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1069-B-F-F-M(8050).xlsx

300 KBs Excel File

Students Have Also Explored These Related Finance Questions!

Start with the partial model in the file Ch04 P35 Build a Model.xlsx from the textbook's Web site. Answer the following questions, using the spreadsheet model to do the calculations. a. Find the FV...

Start with the partial model in the file Ch09 P10 Build a Model.xlsx on the textbook's Web site, which contains the 2015 financial statements of Zieber Corporation. Forecast Zeiber's 2016 income...

Start with the partial model in the file Ch09 P11 Build a Model.xlsx on the textbook's Web site, which contains Henley Corporation's most recent financial statements. Use the following ratios and...

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...

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 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...

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...

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...

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 ....

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...

For mechanism shown in figure, find the velocities of the links with complex algebraic method |AA,] = 2 m, |A,Bol = 4 m, |BC| = 4 m %3D H |BOB| = 8 m, |A,H| = 5 m %3D B rad and 02 = 45, w2 3 cw %3D...

A farmer wants to test three brands of weight-gain diets for chickens to determine if the mean weight gain for each of these brands is the same. He selected 15 chickens and randomly put each of them...

Is Support Vector Regression ( SVR ) robust to Irrelevant features

In Figure 3-7 , what are the effects of a price increase from $2 per portable power bank to $4 per portable power bank on the quantities supplied by supplier 1 and by supplier 2 individually and...

What is the compressed adjusted present value (APV) model and how does this differ from the Modigliani and Miller models?

In what circumstances is the compressed adjusted present value (APV) model useful and how would it be applied?

Start with the partial model in the file Ch18 P08 Build a Model.xls on the textbook's Web site. Schumann Shoe Manufacturer is considering whether or not to refund a $70 million, 10% coupon, 30-year...

Martin Development Co. is deciding whether to proceed with Project X. The cost would be $10 million in Year 0. There is a 50% chance that X would be hugely successful and would generate annual...

On January 1, 2020, a machine costing $210,000 with a four-year life and an estimated $18,000 salvage value is installed in Apple Company's factory to Required: Compute depreciation for each year and...

Matt is analyzing two mutually exclusive projects of similar size and has prepared the following data. Both projects have 5 year lives. Matt has been asked for his best recommendation given this...