DMF has developed a Microsoft Excel workbook to assist dealers in the calculation of title ad valorem tax (TAVT). 
There are separate Excel worksheets for each type of vehicle sale: new, used, leased and directly-financed. The sheets are easy to use and include a list of taxable as well as non-taxable items to include in the calculation. Just fill in the dollar amounts as indicated, and formulas in the worksheet will give you the correct TAVT for that purchase.
We hope these calculation tools save time for you and your staff; please let us know if we can assist in any other way.
For vehicles purchased in 2020, use this workbook

Vehicles purchased 2015-2019

Updated 2/11/2020