please explain the formulas used by excel

Page 90 4. XeUsing a Spreadsheet to Calculate Bond Values. What is the value of a $1,000 bond with a 12-year maturity and an S percent coupon rate (paid semiannually) if the required rate of return is 5 percent. 6 percent, & percent, and 10 percent? (LG 3-2 ) Face Number of Periodic Coupon Payment, Required The Bond Value Will Value Payments Return Be S1.000 12 x 2 = 24 1.000(0.05)/2 = 40 5 $1.268.27 1.000 24 40 1.109.36 1.000 24 10 S 1.000.00 1.000 24 40 10 S62.01