how did he arrive at the numbers listed below? please use excel

Question 6 0/7 points The Garraty Company has two bond issues outstanding. Both bonds pay $100 annual interest plus $1,000 at maturity. Bond L has a maturity of 15 years and Bond S has a maturity of 1 year. What will the value of Bond L be if the required rate of return is 5%? x ($1518.98, $1,518.98, 1518.98, 1,518.98) What will the value of Bond L be if the required rate of return is 8%? __x ($1171.19, $1,171.19, 1171.19, 1,171.19) What will the value of Bond L be if the required rate of return is 12%? -------- * ($863.78, 863.78) What will the value of Bond S be if the required rate of return is 5%? * (1047.62, 1,047.62, $1047.62, $1,047.62) What will the value of Bond S be if the required rate of return is 8%? * (1018.52, 1,018.52, $1018.52, $1,018.52) What will the value of Bond S be if the going required rate of return is 12%? * 1982.14, $982.14) Which bond, L or S, fluctuate more when interest rate fluctuates? Note: only type "L" or "S" in the answer box. -- * (L)