Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are considering an investment in the bonds of the Front Range Electric Company. The bonds pay interest semiannually, will mature in 15 years, and

You are considering an investment in the bonds of the Front Range Electric Company. The bonds pay interest semiannually, will mature in 15 years, and have a coupon rate of 6% on a face value of $1,000. Currently, the bonds are selling for $920.

a. If your required return is 6.80% for bonds in this risk class, what is the highest price you would be willing to pay? (Use the pv function.)

b. What is the current yield of these bonds?

c. What is the yield to maturity on these bonds if you purchase them at the cur-rent price? (Use the RaTe function.)

d. If you hold the bonds for one year, and interest rates do not change, what total rate of return will you earn, assuming that you pay the market price? Why is this different from the current yield and YTM?

e. If the bonds can be called in three years with a call premium of 4% of the face value, what is the yield to call? (Use the RaTe function.)

f. Now assume that the settlement date for your purchase is 7/30/2020, the maturity date is 7/30/2035, and the first call date is 7/30/2023. Using pRice and yield recalculate your answers to parts a, c, and d.

g. If market interest rates remain unchanged, do you think it is likely that the bond will be called in three years? Why or why not?

h. Create a chart that shows the relationship of the bonds price to your required return. Use a range of 0% to 15% in calculating the prices.

Please answer all parts of the question in excel, thumbs up given

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Military Finances Personal Money Management For Service Members Veterans And Their Families

Authors: Cheryl Lawhorne-Scott, Don Philpott

1st Edition

144222214X, 978-1442222144

More Books

Students also viewed these Finance questions