please include excel or step details if possibke Thank you!!

4-13. A 51.000 bond matures in 10 years. The bond pays interest of 10% a year, with half of the annual interest paid at midyear and the other half paid at year-end. The bond is selling below $1,000, so that the yield to maturity earned by an investor is actually, 6% each 6-month period. What is the price of the bond? 4-14. You purchased new 20-year 6% bonds of Amalgamated Corporation for $1,000 each when they were issued a year ago. Interest rates on investments of this type have fallen to 5% since then. What is the value of one of these bonds today, and what rate of return did you earn on your investment over the 1-year period? (Assume year-end interest payments for simplicity)