Two best friends, Thelma and Louise, are making long-range plans for a road trip vacation to Mexico. They will embark on this adventure in five years and want to invest during the five-year period to earn money for the trip. They decide to purchase a $1000 Grand Canyon Oil Company bond with an annual coupon rate of 10 percent with interest to be paid annually. The bond will mature in five years. The YTM of similar bonds is 8%. How much should they be willing to pay for the bond if they purchase it today? Enter the excel formula you would use to soive this problem. Example: =PMT(3%,8,500,0) Do NOT put any spaces in your formula and use capital letters