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.

Payment number Payment Interest. Principle Balance