(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =PV(), =FV(), =PMT(), =NPER(), =RATE(), =PRICE() or =YIELD() whenever applicable. Please show me the EXCEL functions that was used to help me better understand was equals what. Using Excel finance formulas

Please use Excel functions to find the solutions with screenshots if possible.. please please please :)

We find the data for a municipal bond issued by the Illinois state government.

The bonds last trade date (i.e., settlement date) is June 05, 2020.

The bonds maturity date is October 14, 2054.

The bonds coupon rate is fixed as 5.000% per year.

The bonds coupon payment frequency is semi-annual.

The bonds last trade yield (i.e., yield-to-maturity) is quoted as 4.280% per year.

(a) Based on the aforementioned settlement date, maturity date, coupon rate, coupon payment frequency and yield to maturity, what shall be the corresponding bond PRICE (relative to redemption par of 100)?

(b) Assumes that the Fed suddenly tightens its monetary policy now, causing interest rates to rise across financial markets. The aforementioned IL municipal bonds yield-to-maturity also rises from 4.280% to 5.280% per year. Will the bond PRICE go up or go down then? By how much?

(c) Assumes that the Fed suddenly loosens its monetary policy now, causing interest rates to drop across financial markets. The aforementioned IL municipal bonds yield-to-maturity also drops from 4.280% to 3.280% per year. Will the bond PRICE go up or go down then? By how much?

(d) Based on your answers to (b) and (c), is there a positive, negative or zero association between bond YIELD and its PRICE? (Hint: Positive association means moving in the same direction, negative association means moving in the opposite directions, while zero association means one moves but the other does not get affected.)