I uploaded a T-12, but after speaking with the broker I learned about some one-time expenses that I want to remove or reclass.
The Archer Underwriting Tool is exported in Excel and is completely customizable for the user. Any adjustments to the T-12 can be made in the T-12_Input tab. From here the user can either chose to ignore the entire line (example being the current owner has a fee that isn’t applicable to new ownership) or enter a new value into the expense month.
To ignore the line item, click on the dropdown menu in the yellow cells and chose “IGNORE”. This removes the line item from all T-12 calculations and analysis in the model.
The user can also choose to re-categorize the expense by changing the mapping if the original mapping needs to be adjusted.
To enter a new value, the user needs to adjust the value in the applicable yellow cell, and the total value will automatically adjust to the updated value.