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 2015-2019, use this workbook
 



 
 
Updated 1/4/2019