Please complete the following problem on Excel before class:

On February 15, 2009, Cisco Systems, Inc. issued 30-year bonds with a total par value of $2,000,000 with a coupon rate of 5.9%. They were priced to yield 5.92% and paid coupon payments on August 15 and February 15 of each year.

1. Calculate the initial issue price of the bonds.
2. Prepare an amortization table.
3. On 8/15/21, the bonds were being priced to yield 2.698%. Calculate the price of the bonds on that date.