Need help and formulas please for excel thank you

In a spreadsheet, create three separate sheets, labelled Part a Then answer the following questions.

1. On your sheet labelled Part a do the following. Firstly, you are required to price a number of bonds (30 in all). We start by considering a 2% Treasury bond, maturing in 7 years. Price this bond at yields to maturity of

47 basis points under CY20.

153 basis points over CY20.

353 basis points over CY20

. . . .

1753 basis points over CY20. where CY20 is the Australian 10-year government bond yield for calendar year 2020 (i.e., the 10-year government bond yield on 31 December 2020).

Next, consider a 10% Treasury bond, maturing in 7 years. Also price this bond at yields to maturity of

47 basis points under CY20.

153 basis points over CY20.

353 basis points over CY20

. . . .

1753 basis points over CY20.

Finally, consider a 20% Treasury bond, maturing in 7 years. Also price this bond at yields to maturity of

47 basis points under CY20.

153 basis points over CY20.

353 basis points over CY20.

. . . .

1753 basis points over CY20.