金融学的问题（swap valuation）

exsp888

7. Term structure of interest rates and swap valuation
Suppose the current term structure of interest rates, assuming annual compounding,
is as follows:

Recall that interest rates are always quoted on an annual basis unless stated otherwise.
Suppose a 6-year swap with a notional principal of $10 million is being configured.
What is the fixed rate of interest that will make the value of the swap equal to zero?
Round your answer to 3 decimal points (in decimal form, not in percentage).
Solution:The value of the fixed interest rate, typically called the swap rate, is given
by the formula

（该如何分析以上程式所计算出的答案[8.62%]，我想明白计算的过程，如明白此程式者请以EXCEL的程式来解答或其他方面的解答也行，谢谢。）