DMF has developed a Microsoft Excel workbook to assist dealers in the calculation of the new title ad valorem tax (TAVT). The implementation of this new tax has been a challenge for all of us, and these forms should help reduce the number of returned titles requiring re-work.
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 2015 through 2018, use this workbook

Updated 7/25/2018