PLEASE SHOW STEP BY STEP AND SHOW FORMULAS THAT ARE USED IN EXCEL THANK YOU SO MUCH $(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.