Solve Using Excel

Bond scenarios

Apex, Inc. issues a series of $100,000 bonds on January 1, 2022. The bonds pay interest at the end of each year at the rate of 7.0% per year and matures in 10 years.

If investors decide that 7.8% per year is an appropriate interest rate for the Apex bonds, how much will they be willing to pay for each bond?

If investors decide that 6.8% per year is an appropriate interest rate for the Apex bonds, how much will they be willing to pay for each bond?