Prepare a spreadsheet using excel or a similar program in

Question

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