Skip to main content

How To Model Income

Updated this week

The Income section in IntellCRE gives you full control over modeling rental income and revenue for multifamily, retail, self-storage, or mixed-use properties. Whether you’re uploading rent rolls, forecasting proforma rents, or analyzing comps, this section is designed to help you quickly and accurately model property’s current and potential income.

In this tutorial, IntellCRE's CEO walks through how to use each feature effectively, from uploading rent rolls to forecasting performance rents and analyzing comps:

1. Getting Started

  1. Navigate to the Analysis section in the left side panel.

  2. Select a property (either from your existing portfolio or by entering the property address).

  3. Click on Analysis option to open the Property Analysis Form.

  4. Confirm or edit property details at the top.

  5. Navigate to the Income section.


2. Uploading Documents

At the start of your analysis, you’ll be prompted to upload key financials. Supported files: PDF or Excel.

  • Rent Roll

  • Operating Memorandum (OM)

  • T12s or other financial statements

Uploading these files will auto-populate the Income section. If you don’t upload, you can still enter data manually.


3. Working with the Rent Roll

Data Entry Options

  • Manual Entry: Add units one by one or enter unit mix (type, SF, current rent, pro forma rent).

  • Summary Totals: Enter just total unit counts, total SF, and total rent.

  • Rent Roll Upload: Upload a PDF or spreadsheet (see [Rent Roll Upload Guidelines]).

Editing & Validation

  • Filtering: Narrow down by unit type (e.g., 1-bedrooms).

  • Grouping: Group units based on custom criteria or create stratified rent roll view

  • Bulk Edits: Update multiple rents or values at once.

  • Advanced Options: Enable Year 1 or Pre-Renovated rents, group units, or disable unit numbers.

  • Notes:

    • Internal Notes — team-only visibility

    • Public Notes — included in reports

The platform also flags discrepancies between your rent roll and assessor records, with easy one-click reconciliation.


4. Rent Growth & Vacancy Assumptions

Set assumptions for:

  • Pro Forma Rent Growth

  • Vacancy %

  • Bad Debt, Concessions, or other rent gain and loss factors

You can:

  • Model year-by-year or use flat assumptions

  • Apply lease-up modeling for vacant properties

  • Enable rent stabilization (set starting/ending months, or lease base rent increase)

Tip: Be careful not to double-count rent growth. If you are using a timeline that phases rents from current to pro forma values, do not also apply a separate year-1 rent growth rate to the pro forma rents at the same time.


5. Lease-Up & Rent Stabilization

  • Lease-Up: Model occupancy ramp-up for vacant buildings.

  • Stabilization: Model transition from current rents to proforma rents over time.

Tip 1: For ground-up development projects, set all current rents to zero. Then, align the stabilization start month with the anticipated launch of leasing for the first units, and the stabilization end month with the point at which the property is expected to be fully leased and stabilized.

Tip 2: Avoid applying vacancy assumptions, lease-up schedules, and rent stabilization simultaneously, as this can result in double- or even triple-counting vacancy.


6. Modeling Other Income

Add revenue sources beyond rent: laundry, parking, storage, etc.

  • Manual Entry: Add line items by unit, month, or year.

  • Document Upload: Use T12 to upload and auto-populate.

  • Apply growth rates and pro forma values as needed.


7. Rent Comps

Three ways to search or add comps:

  • AI-Suggested Comps: Based on your property profile.

  • Map Search: Use filters, map selection, or polygon tools.

  • Creating or Importing Comps: See [How to create, import, and manage comps Guide]

You can:

  • Compare unit-level rents and $/SF

  • Edit existing data or add additional information for any comp

  • Autofill proforma rent from selected comps

  • Upload your own comp library


8. Accessory Dwelling Units (ADUs)

If you plan to add ADUs:

  1. Enter unit details (type, SF, rent).

  2. Account for build costs and timeline in the Expenses section.


9. Mixed-Use Properties

If your deal includes multiple property types (i.e. multifamily + retail):

  • Select multiple property types in the Property section (i.e. enabling MF + Retail).

  • Each income type gets separate rent roll component, vacancy, and growth.


Tips & Troubleshooting

  • Use the thumbs-down icon if an upload doesn’t parse correctly — our team will be notified and reach out to you with assistance.

  • Use the reset button to clear a section.

  • For vacant units with $0 rent, mark as Vacant in rent roll inputs. For institutional modeling of gross potential rent enter the would-be rent instead of $0 in the current rent values for vacant units.

  • Still need help? Use the Support button in the platform or reach out to our team anytime.


If you have any questions while working through this section, click the Support button in the platform or reach out to our team—we’re here to help!

Did this answer your question?