B$-$ Suppose you have two loan options with different interest rates

and terms and want to compare them to determine which one has a

lower monthly payment. Assume the following data in Excel:

Loan Option $1$:

Loan Amount: $$30,000$

Annual Interest Rate: $5\%$

Loan Term: $3$ years $(36$ months$)$

Loan Option $2$:

Loan Amount: $$30,000$

Annual Interest Rate: $6\%$

Loan Term: $4$ years $(48$ months$)$

Write the two PMT functions in A$2$ and B$2$: