A bond is currently selling for $1040. It pays the amounts listed in the file P02_32.xlsx at

Question:

A bond is currently selling for $1040. It pays the amounts listed in the file P02_32.xlsx at the ends of the next six years. The yield of the bond is the interest rate that would make the NPV of the bond’s payments equal to the bond’s price. Use Excel’s Goal Seek tool to find the yield of the bond.