$1$

earned

possible

cell

currency$/$accounting with $0$ decimal places

$15$ H$28$

Annual Loan Payment: Use the formula above to compute the annual loan payment. Format answers as accounting with $0$ decimal places

Note that the interest rate is $i,$ the amount borrowed is $p,$ and the number of payments is $n.$ Also note that the equation is asking for negative $n(-n)$

Monthly Loan Payment: Compute the monthly payment. Reference $12$ instead of typing it$.$ Format answer as accounting with $0$ decimal places

Average Monthly Loan Payment: Use Excel functions to compute the average Monthly Loan Payment. Use shortcut keys to select the data.

Above $/$ Below Monthly Average: If an account's monthly toan payment is above the average, display 'Above'. If not, display 'Below'.

$\backslash$table$[[$Interest Rate $($i$),3\mathrm{.}21\%$