I am struggling with my finance course but I am extremely interested in learning and understand my assignments. I plan to be a business owner someday and I know how crucial it is to understand what I am learning. I have attached an assignment that I dont understand and I plan to research your answers to better understand the assignment, especially if I dont understand what you write. I will more than likely continue to seek your help for the rest of this course also. I need help but I need to learn it. We are required to put formulas in the spreadsheet as well. Thank you!

Background:

Decisions involving capital expenditures often require managers to weigh the costs and benefits of different options related to the financing of a project. For instance, deciding when to call a bond before maturity due to changing interest rates can lower the overall cost of a project significantly through refinancing. So, it is important to be able to understand the real interest rate being paid out to your bondholders (yield) at any given time.

For this Assignment, review the information presented. You will utilize the information to make a recommendation with regard to when to call a bond.

INFO:

Yield to maturity and yield to call:

Company A has bonds outstanding with a $1000 face value and 10 years left until maturity. They have an 11% annual coupon payment and their current price is $1175. The bonds may be called in 5 years at 109% of face value (Call price= $1090)

A. Yield to maturity?

B. Yield to call if called in 5 years?

C. The bonds indenture indicates that the call provision gives the firm the right to call the bonds at the end of each year, beginning in year 5. In year 5, the bonds may be called at 109% of face value; but in each of the next 4 years, the call percentage will decline by 1%. This, in year 6, they may be called at 108% of face value; in year 7, they may be called at 107% of face value and so forth. If they yield curve is horizontal and interest rates remain at their current level, when is the latest that investors might expect the firm to call the bonds?

Assignment:

Prepare a spreadsheet using Excel or a similar program in which you compute the items listed in parts a, b, and d. Be sure to compute the Yield-to-Maturity (YTM) and Yield-to-Call (YTC) for each of years 5, 6, 7, 8, and 9.

Utilizing Word, prepare a written report to your finance director:

Include a detailed explanation of the conclusion you reached concerning whether or not to call the bond before maturity.

If your recommendation is to call the bond early, explain when to call the bond and your rationale.

Discuss the advantages and disadvantages of using a long-term loan instead of a bond.