Please solve this problem on Microsoft Excel and showcase the formulas to get the answers. Thank you.

8. Calculating Investment Returns You bought one of Bergen Manufacturing Co.'s 7 percent coupon bonds one year ago for $1,080.50. These bonds make annual payments and mature six years from now. Suppose you decide to sell your bonds today when the required return on the bonds is 5.5 percent. If the inflation rate was 3.2 percent over the past year, what would be your total real return on the investment