You are considering buying $2024$ BMW M$340$i xDrive Sedan

for $$61945$ for a $5-$year term at an annual rate of $5\mathrm{.}25\%.$

Calculate monthly payment for

a variety of principal balances

from $$52,000$ to $$70,000($in

$$2000$ increments$)$ and for a

variety of terms ranging from $3$

years to $6$ years.

USE EXCEL.