Argument Input Values

Annual Rate

$7\mathrm{.}50\%$

# year Financed $30$

Create a Two$-$Input Table that shows the Monthly Payment for a loan $at$ rate ranges starting $at3\mathrm{.}50\%$ and ending $at8\mathrm{.}50\%in$

increments $of\mathrm{.}50\%$ and the Loan Amount ranging from $$50,000to$ $$100,000in$ $$5,000$ increments. $(20$ Points$)$

Loan Amount $ $250,000\mathrm{.}00$

$0$

$20$ points possible

HINT: The two input table pivots $on$ the formula entered $in$

$0$

Formula

$0$

Table $(10pts)$