Alternative Minimum Tax (AMT)

In financial modeling, we do not often consider the United States’ Alternative Minimum Tax (“AMT”). We do so here only to expose you to the maximum complexity you will likely encounter in modeling taxes. The AMT is a parallel tax system designed to ensure that all taxpayers pay at least some minimum amount of tax. The 20% corporate AMT tax rate and 90% minimum taxable income offset are features of the AMT promulgated by the IRS. State and local taxes are deductible for the purpose of computing AMT.

 

Create Financial Models 10x Faster with Macabacus

Gain access to 100+ shortcuts, formula auditing visualizations, easy Excel-to-PowerPoint linking and productivity tools to help you accelerate financial modeling and presentations.

Start your Free Trial
 

The AMT has no bearing on our model because federal taxes computed the “regular way” exceed the AMT in each projected period. However, if pre-NOL taxable income is sufficiently low, the AMT will be triggered. Try hardcoding $15mm for taxable income in the first projected period to observe this. Also, note that triggering the AMT generates an AMT tax credit carryforward that can be used to offset federal cash taxes in subsequent periods. We have assumed that the MRY AMT tax credit carryforward is zero, as companies do not generally disclose this figure.

Note that the calculation of taxable income for the purposes of computing AMT may differ from the “regular way” calculation of taxable income in our model. Such differences add complexity beyond the scope of our model, and are best addressed by an experienced tax professional.

Discover more topics

Build an operating model
In this tutorial, we will walk through how to build a general industry business operating model.
Read more
Build an M&A model
In this section, we demonstrate how to model a merger of two public companies in Excel.
Read more
Build an LBO model
In this tutorial, we will walk you through building an LBO model in Excel.
Read more
Asset and Stock Deals
The first step in purchase price allocation, or PPA, is to determine the purchase price.
Read more