Calculators

Our AMIQuiC (Arch MI Qualifying Income Calculator) and AMITRAC (Arch MI Tax Return Analysis Calculator) are updated annually to reflect the most current tax years. Both calculators are automated and easy to use.

Income Analysis

Qualifying Income Calculator (AMIQuiC)

A set of calculators for base, bonus, overtime and commission income designed to streamline processing, AMIQuiC makes it easier to determine base and variable income for qualifying with these key features:

  • Calculates income trends, so you can clearly see whether income is increasing or decreasing year-over-year.
  • Allows you to choose which data to include or exclude in your calculations, based on the trends you observe.
  • Includes a Pay Stub Decimal Calendar, which enables you to accurately determine the Year-to-Date factor by using the Pay Period Ending Date and the Pay Frequency.

AMIQuiC (CU)

Download XLSX

Tax Return Analysis Calculators (AMITRAC)

These interactive spreadsheets follow the Schedule Analysis Method (SAM) of tax return evaluation. Two versions — one macro-enabled and the other macro-free — reflect current tax years and include:

  • The ability to accommodate one or two years of data entry, so if you receive documentation relief from your automated underwriting system, the AMITRAC is on point.
  • More user control for determining qualifying income based on trending. A default setting averages two years of data, and users can choose to use only the prior year or only the most recent year.
  • Automatic error messaging for certain types of simple data entry errors.
  • Fannie Mae and Freddie Mac guidelines pertaining to Corporation analysis integrated into the calculations.

The macro-free version features the following:

  • No macro-enabling is necessary (so no need to make a trusted document).
  • One section for each business structure instead of five. Users can still enter multiple businesses, but only one of each business type (one sole proprietorship, one partnership, etc.).

AMITRAC (CU)

Download XLSM

AMITRAC – No Macros (CU)

Download XLSX

AMITRAC – Basic Navigation

AMITRAC – Mileage Depreciation

Rental Income

excel

Fannie Mae Form 1037 new tab icon

Principal Residence, 2- to 4-unit Property

excel

Fannie Mae Form 1038A new tab icon

Individual Rental Income from Investment Property(s) (up to 10 properties)

pdf

Freddie Mac Form 92 new tab icon

Schedule E – Net Rental Income Calculations

excel

Fannie Mae Form 1038 new tab icon

Individual rental Income from Investment Property(s) (up to 4 properties)

excel

Fannie Mae Form 1039 new tab icon

Business Rental Income from Investment Property(s)