Your company wants to pay off some long-term debt, so you decide to buy back some conventional 10-year bonds that you issued 8 years ago. The par value of the bonds is $1200, and the bonds were issued at a 5% coupon rate. Currently, other companies with the same risk profile as your company are offering new 2-year bonds at an interest rate of 8%. Assume that you are at the start of year 9, i.e., the 8th interest payment has been made. What is a fair offer to buy back the bonds? Answer:

Need to know how to do it in excel!!

Please help me with these questions. Please don't use excel

GrowthSec Ltd has raised $10M in debt funding by issuing 100 5 year bonds with a face value of $100,000 each. The bonds pay semi-annual coupons at 6% p.a. If the yield to maturity is 7% p.a., what will be the price of each bond? If after one year the bond is trading at a premium, what must have happened to market interest rates? Why has this impacted the bond price?

please help solve

The Chief Financial Officer of a company would like to raise money for new equipment by floating a new bond issue.  The CFO would like to receive $1000 (full face value) for each of the bonds she sells.  After collecting the below bond market data, and if the bonds carry a rating of A and have a term of 10 years, what coupon rate should be included in the bond contract?   Assume an annual coupon payment.      Security& Rating          Maturity Face     Coupon     Price  Treasury    1 $    1,000    0.00% $     965.00  Treasury    3 $    1,000    1.90% $     939.06  Treasury    5 $    1,000    4.30% $     932.42  Treasury   10 $    1,000    6.80% $   1,007.12  Treasury   15 $    1,000    6.60% $     908.25  CorpA  A   5  $    1,000    8.10% $     990.00  CorpB  BB  10 $    1,000    7.90% $     859.88  CorpC  AA  15 $    1,000    7.00% $     660.00