Integrating an In-House Excel Underwriting Model with IntellCRE (Enterprise Feature)

Introduction

Hey everyone, this is Anton with IntellCRE. In this video, we’re going to look at an enterprise feature: integrating your own in-house underwriting Excel model with the IntellCRE platform.

We’re going to use a sample deal to explore the mapping between your model and the platform and discuss how this feature actually works.

Uploading a Complete Excel Model

Any deal that we start running through the platform begins with the first prompt, where we have four boxes that we can use to upload various documents for the property and financials.

The last box, Complete Excel Model, is where, after enterprise integration, you will be able to upload your entire model.

This is very beneficial for teams that still prefer to complete their underwriting workflow in their in-house models and then use the platform for marketing workflows and creating reports for the deal.

Uploading the Model and Extracting Data

We’re working with a self-storage deal, and we are going to upload our Excel model directly into this box.

Within a few seconds, the system extracts all the data. All the important data from our model has been mapped to the relevant data points in the platform.

Overview of the Excel Model Structure

Let’s look at the model. It can have multiple tabs.

We have:

• A summary of the deal

• A tab with assumptions

• Separate tabs for different parts of the unit mix:

  • Climate-controlled ground

  • Climate-controlled non-ground

  • Non-climate-controlled ground

  • Non-climate-controlled non-ground

  • Drive-up units

  • Parking and other units

• A summary of the unit mix

• A proforma tab with proforma numbers

• A price proposal tab

• Sensitivity analysis

• An amortization schedule

Next, we’ll explain how all of this maps into the platform.

Mapping Income and Unit Mix Data

After clicking Continue, all numbers populate automatically in the right sidebar.

In the Income section, we see the entire self-storage unit mix or rent roll:

• Unit types and dimensions

• Unit counts

• Vacancy

• Current rents

• Square footage

• Lease expirations (if available)

• Proforma rents

We can also map income assumptions such as rent growth rate, vacancy, and rent loss.

The detailed unit mix from the separate Excel tabs is mapped directly to the detailed rent roll in the platform. The assumptions tab maps directly into the income assumptions.

Mapping Other Income

Other income can be taken from the proforma tab.

This income can be expressed as:

• Per square foot

• Per unit

• Nominal total values

In this case, those values are mapped to Other Income in the platform for both current and proforma numbers.

If all data exists in the uploaded model, it can be mapped directly without needing custom assumptions.

If rent comps or sales comps exist on another tab, the platform can also detect and import those, including all relevant comp data.

Mapping Expenses

Expenses are taken from the proforma tab and mapped directly into current and proforma expense categories in the platform.

This includes:

• Taxes

• Tax resets

• Expense growth assumptions

All of these assumptions are mapped automatically.

Mapping Value and Financing

In the Value and Financing section, the most important data point is the property value.

The platform grabs this from the price proposal tab, specifically the optimal price defined in the model. In this case, it is $27 million.

That value is mapped directly into the platform. If sales comps were present, those would be imported as well.

This example is primarily a sale model, so acquisition and sale assumptions are limited, but those can also be mapped if included.

Completing the Analysis and Next Steps

At this point, the mapping is complete.

To recap how this enterprise feature works:

Once you’re on an enterprise plan, we integrate your in-house model. From then on, you can upload your model at the beginning of creating a property, and all data flows seamlessly into the analysis form.

This creates your analysis with proforma cash flow and financials. Once you click Create Property with Analysis, the deal is created with all financials populated.

From here, you can proceed to comps or begin building marketing presentations such as a BOV or an OM.

Closing

That’s it. We hope this video provides clarity on how the model integration works.

If you need this type of integration, don’t hesitate to reach out so we can start working on it together.

Thank you, and see you in the next tutorial.