You wish to purchase a new BMW $700$ series at a cost of $$85,000.$ You plan to finance

$100\%$ of the cost of the car over $3$ years. Payments will be made at the end of each

month. Interest is $6\%$ per year. Calculate the monthly payment and prepare a $36$ month

amortization table below.

Once the table has been created, hide the rows that contain payments $11$ thru $30.$

write formulas $to$ use $in$ excel