show excel formula for the highlighted section.

$4)$ Fill in the sheet titled $$Loan Analysis$$ but ONLY include cash$-$flow related to Ann$$s loan in the sheet

$$NPV$-$IRR$.$ Leave cells unrelated to the loan cash flow blank.

$(4.$a$)$ What is the annualized IRR for Ann$$s loan?

$(4.$b$)$ Is the IRR for Ann$$s loan higher or lower than the advertised loan contract rate?

$(4.$c$)$ Why?

$(4.$d$)$ Plot Ann$$s NPV for Ann$$s loan, for discount rates $0\%-10\%.$ Copy and paste the chart below.