An investor has two bonds in his portfolio that have a face value of $1,000 and pay a 6% annual coupon. Bond L matures in 20 years, while Bond S matures in 1 year.

Assume that only one more interest payment is to be made on Bond S at its maturity and that 20 more payments are to be made on Bond L.

What will the value of the Bond L be if the going interest rate is 4%? Round your answer to the nearest cent. $ What will the value of the Bond S be if the going interest rate is 4%? Round your answer to the nearest cent. $ 1,019.23 What will the value of the Bond L be if the going interest rate is 9%? Round your answer to the nearest cent. $ What will the value of the Bond S be if the going interest rate is 9%? Round your answer to the nearest cent. $ 972.48 What will the value of the Bond L be if the going interest rate is 13%? Round your answer to the nearest cent. $ What will the value of the Bond S be if the going interest rate is 13%? Round your answer to the nearest cent. $ 938.05

I was able to solve for Bond S problems, but I'm stump on Bond L problems. If you can show me how to do it on Excel, that would be great.