07.14.07

Michigan Business Tax Calculator

The NFIB Michigan Business Tax Plan Estimator is an Excel 2003 spreadsheet based program. Its purpose is to allow users to estimate tax liability under the new Michigan Business Tax (MBT) which replaces the previous Michigan Single Business Tax (SBT).  

• Data is only accepted in the yellow highlighted cells.
• Data cells with small red triangles in the upper right
  corner include pop-up notes and information.
• More information can be viewed by selecting the
  worksheet tabs at the bottom of the screen.

The spreadsheet is intended to give the average in-state Michigan business an approximation of tax liability under the MBT. It does not attempt to calculate unique circumstances or narrow exemptions and credits that are part of the MBT but not used by most taxpayers. The exemptions, circumstances and credits NOT considered include, but are not limited to, research and development, brownfield redevelopment, MEGA, Renaissance Zone, ME-2, ITC recapture, loss carry forward or carry back, historic preservation and others. If you have unique tax circumstances, you should consult a tax professional. For more information, select the MBT Information tab at the bottom of the screen.

Tax base apportionment
The MBT Estimator will apportion your tax base by multiplying it by a fraction where the numerator is gross receipts, or sales, in Michigan and the denominator is total sales. If you leave the "Michigan only Gross Receipts" data cell blank, the Estimator will assume a zero amount and your tax liability will be zero. If your total sales and Michigan sales are the same, enter the same amount in both cells.

Disclaimer
NFIB/Michigan is providing the MBT Estimator free of charge as a public service to allow business owners and interested individuals to determine approximate tax liability under the MBT. NFIB assumes no liability for incorrect results or determination of tax liability. The MBT Estimator is not a substitute for competent counsel from a tax professional. The Estimator may be downloaded, distributed and shared by users without permission as long as NFIB is referenced as the source. Altering or changing the spreadsheet in any way or removing the NFIB masthead is prohibited without permission.
 
The spreadsheet will only calculate from information provided by the user. It is the responsibility of the user to determine if the data they input is correct relative to their specific tax situation and the definitions and criteria under the MBT.

If you receive errors after running the spreadsheet with data you input, or if the numbers do not seem to be correct, e-mail the spreadsheet, as is, to charles.owens@nfib.org and I will try to determine the problem. Users should check back with the Web site periodically for updated or corrected versions. The highest version number (such as 7.2) will be the latest version.

The Errata tabbed worksheet at the back of the workbook lists a history of development, changes, upgrades and corrections.