Max Finance Charge Calculator

Create a spreadsheet for calculating the max finance charge allowed for each class of vehicle. (1) Notwithstanding the provisions of any other law, the finance charge, exclusive of insurance, shall not exceed the following rates: (a) Class 1. Any new motor vehicle designated by the manufacturer by a year model not earlier than the year in which the sale is made—$10 per $100 per year. (b) Class 2. Any new motor vehicle not in Class 1 and any used motor vehicle designated by the manufacturer by a year model of the same or not more than 2 years prior to the year in which the sale is made—$11 per $100 per year. (c) Class 3. Any used motor vehicle not in Class 2 and designated by the manufacturer by a year model not more than 4 years prior to the year in which the sale is made—$15 per $100 per year. (d) Class 4. Any used motor vehicle not in Class 2 or Class 3 and designated by the manufacturer by a year model more than 4 years prior to the year in which the sale is made—$17 per $100 per year. The inputs should be the amount financed and the term of the loan in months. An article on these calculations can be found here: [login to view URL]