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. CALCULATE USING EXCEL AND SHOW FORMULAS USED SUCH AS $"$pmt$,$etc.