Question

Mark​ Goldsmith's broker has shown him two bonds issued by different companies. Each has a maturity of

5

​years, a par value of

​$1,000​,

and a yield to maturity of

8.70 %

  The first bond is issued by Crabbe Waste Disposal and has a coupon interest rate of

6.319​%

paid annually. The second ​ bond, issued by Malfoy​ Enterprises, has a coupon interest rate of

8.80​%

paid annually.

 Calculate the selling price for each of the bonds.906.66 and 1,003.92

 Mark has

​$21,000

to invest. If he wants to invest only in bonds issued by Crabbe Waste​ Disposal, how many of those bonds could he​ buy? What if he wants to invest only in bonds issued by Malfoy​ Enterprises 23 and 20

 What is the total interest income that Mark could earn each year if he invested only in Crabbe​ bonds? How much interest would he earn each year if he invested only in Malfoy​ bonds 1,453.37 and 1,760.00

 Assume that Mark will reinvest all the interest he receives as it is paid and that his rate of return on the reinvested interest will be

11​%.

Calculate the total dollars that Mark will accumulate over

5

years if he invests in Crabbe bonds or Malfoy bonds. Your total calculation will include the interest Mark​ gets, the principal he receives when the bonds​ mature, and all the additional interest he earns from reinvesting the coupon payments he receives.

Answer 1

here I have shown both methods of solving i.e without excel and also with excel.

In case of any doubt or query regarding the solution, feel free to ask in comments.

And please like the solution. Thank You.