Please give an excel spread sheet answer with calculations.
Question:
A company with the name "Unique Motors Company" sells an issue of bonds on the first of January, 2001. These bonds are purchased at $960 per unit (i.e., the bonds had been issued at 96 percent of par), have an even 12 percent coupon rate payable semi-annually, and mature in two decades, that is on the last day of 2020.
1) Say a person buys that bond on the date of issuing at the price of issuing and predicts that they will keep hold of that bonds up until its date of maturity, the last day of 2020. What would their average annual rate of return be for this particular investment?
2) The going rate of interest on similar bonds falls to 8 percent over the two years following the issuing of these bonds. What is the new selling price?
3) Now, six years after the original date of issuing for these bonds, the interest rate on similar bonds has peaked at 14 percent. What is the new selling price today?
4) Finally, eight years on from the date the bonds were originally issued, they are selling at a market price of $925. What now if the bond's yield to maturity? Please also find the current yield and capital gains yield.