Please help answer the question in excel format

Which format is correct? or Show the correct way in excel spreadsheet.

4. An Eminence Water Utility Revenue Bond matures in fifteen years, pays a 5.5 percent coupon rate semiannually, and has a face value of $5,000. The mar- ket interest rate for similar risk and maturity municipal bonds is 4 percent. What is the current price of the bond? What would be its price if the market rate was 6 percent FB Copy Paste B . Mei Format Painter Clipboard Font Alignment E19 EX fr =D19*1.064-15 A B C D E IL H J G 6% R 0.02 Rate Inper, pmt, pv, fu)'2 - 0.03 - . - 1 FV CPN N R 5000 137.5 15 Payment PV PMT Maturity Value PV of the MV 1 137.5 129.72 137.5 122.37 137.5 115.45 137.5 108.91 137.5 102.75 137.5 96.93 7 137.5 91.45 8 137.5 86.27 9 137.5 81.39 10 137.5 76.78 11 137.5 72.43 12 137.5 68.33 13 137.5 64.47 14 137.5 60.82 15 137.5 57.37 5000 2.086.33 1,335.43 2,086.33 GWE 00 OWN + = - - - . 3,421.76 2 3 Paste BIU Merge B Format Painter Clipboard Font Alignment D5 X fix =D3/G3*(1-1/(1+G3)E3)+C3/(1+G3)E3 A B D E F G H 1 6% 4% 2 FV CPN N R R 30 0.03 0.02 in N 00 OY 3 5000 137.5 4 5 Current Price of the Bond at 4% 5,839.87| 6 Market Rate Price at 6% 4,754.99 7