if possible please include excel functions or steps taken thank you!!

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)