Write a spreadsheet that amortizes a 30 month auto loan.

The principal is $45,000, the interest rate is 3 percent APR.

You will submit an Excel file. I want to see the correct amortization as well as best practices as discussed in the lecture.

Depending on your pre-existing Excel skills this should not take an unreasonable amount of time--I'm thinking 30 minutes for 10 points.

You can review amortization in the Calculator Tutorial or just ask Dr. Google.

HUGE HINT: use the =Round function in Excel to get your amortization right to the penny (i.e. round to 2 decimals each month).

I'll show you mine in a Panopto Video, Give that a quick peek.

BE SURE TO INCLUDE THE EXACT AMOUNT OF THE LAST PAYMENT