I need to know how to do this in excel please!

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. a. 1. What will be the value of each of these bonds when the going rate of interest is 4%? Assume that there is only one more interest payment to be made on Bond S. Do not round intermediate calculations. Round your answers to the nearest cent. Bond L: $ Bond S: $ 2. What will be the value of each of these bonds when the going rate of interest is 7%? Assume that there is only one more interest payment to be made on Bond S. Do not round intermediate calculations. Round your answers to the nearest cent. Bond L: $ Bond S: $ 3. What will be the value of each of these bonds when the going rate of interest is 14%? Assume that there is only one more interest payment to be made on Bond S. Do not round intermediate calculations. Round your answers to the nearest cent. Bond L: $ Bond S: $