$*$ i'll give a thumbs up$*$ Please finish the sentence or answer the questions: As we will see momentarily, you should keep the following in mind when looking at a bond: All other things being equal, $...1.$ For the otherwise similar bonds except maturity, which bond has greater interest rate risk? $1-$year or $5-$year? Observation on the maturity on the interest rate risk $($read p$\mathrm{.}173$ bottom and type in the two conclusions$)2.$ When market interest rate increases which bond will have greater price decrease, $10-$year or $5-$year? $3.$ When market interest rate decreases which bond will have greater price increase, $20-$year or $30-$year?

Datasheet $-$ "Maturity"

Requirement $1-$

In the "Illustration of Cash Flow" part, input the cash flow payoffs for bonds with different

maturities. List the cash flows in the column. Cash flows for different bonds should be in

different columns.

Learnings objective:

Create datasheets with columns and simple formulas.

Requirement $2-$

In the "Dynamics of Prices" part, input the prices of bonds with different maturities under

different market interest rates. Make sure the formula of bond price is correctly set up$.$

Learnings objective:

Create datasheets with columns and simple formulas.

Utilizes formatting and appropriately complex formulas in a datasheet.

Uses a datasheet to summarize information appropriate to the discipline

Requirement $3-$

Use the data from the "Dynamics of Prices" section to draw a graph of bond price against

the market interest rates for bonds with different maturities.

Learning objective:

Uses datasheet functionality $($graphics$)$ to synthesize and evaluate information appropriate to

the project

Requirement $4-$

Offer interpretation of data analysis results. Answer the questions at the end of each

worksheet.

Learning objective:

Communicate the academic findings using the academic standard vocabulary.

Datasheet $-$ "Coupon Rate"

Requirement $1-$

In the "Illustration of Cash Flow" part, input the cash flow payoffs for bonds with different

coupon rates. List the cash flows in the column. Cash flows for different bonds should be

in different columns.

Learnings objective:

Create datasheets with columns and simple formulas.

Requirement $2-$

In the "Dynamics of Prices" part, input the prices of bonds with different coupon rates

under different market interest rates. Make sure the formula of bond price is correctly set

up$.$

Learnings objective:

Create datasheets with columns and simple formulas.

Utilizes formatting and appropriately complex formulas in a datasheet.

Uses a datasheet to summarize information appropriate to the discipline

Requirement $3-$

Use the data from the "Dynamics of Prices" section to draw a graph of bond price against

the market interest rates for bonds with different coupon rates.

Learning objective:

Uses datasheet functionality $($graphics$)$ to synthesize and evaluate information appropriate to

the project

Requirement $4-$

Offer interpretation of data analysis results

Learning objective: