Real Estate Property Types

Bulletproof financial models for multiple property types and sectors

The CRE Suite is Packed with Financial Models for:

  • Data Center
  • Retail
  • Industrial/Flex
  • Multifamily
  • Manufactured Homes
  • Master-Planned Communities
  • Office
  • Hospitality
  • Self-Storage
  • Senior Housing
  • Student Housing
  • Low-Income Housing Tax Credit (LIHTC)

Custom Microsoft Excel models can be converted to work with the CRE Suite and our online reporting tools. Taking advantage of this ease of use, many of our clients use the platform to manage internal finances, corporate M&A and other non-real estate matters.

BYOM! Bring Your Own Model and we will convert it to work with the CRE Suite and its Model Governance and online reporting tools.

That could include your models for business planning, franchise analysis, internal finance, corporate M&A and other non-real estate matters.

Income

This table breaks down the metrics of collecting rent on a value-add property:
• What are our rental numbers?
• What numbers can be achieved if this property commands market rates?
• What are we losing from leases in place not at market rate?
• As units are scheduled for reno and closed down temporarily, how much are we losing during that time period?
• Once reno’s are done, what’s the rental spike?
• Displays how economic occupancy compares to physical occupancy.

Value Add Analysis

Same information as chart at bottom right, but in numerical form.

Value Add Analysis

This chart shows the cumulative costs to add value to the property (either through normal upgrades or renovating a distressed property) and increase rents. It displays those costs and cumulative premiums.

Summary Fields

These isolate the returns specifically for the value-add components of a multifamily asset. Carving these out from the whole project - which may include units already renovated and already achieving market rents - is a special metric our software offers. Use it to zoom in on the effect of renovation investments.

Stabilized Cash Flow

The orange column displays the development’s stabilized cash flow, once the project is done and tenants are occupying spaces. The columns to the right of the orange column show the timeframe of when the annual return metrics hit desired targets.

Sources and Uses Tables

Easily view both Sources and Uses. For example, compare how a development’s soft costs like permitting and design compare to the hard costs of the build itself. Use this to get clarity on where funds are being spent on a development.

Development Spend Curve

Use this chart to view the timing of expenditures throughout the development. Gain perspective on the chronological sequence of spending. This chart identifies when large spending will occur and can help identify atypical jumps or front loading that affects interest reserve.

Income

This table breaks down the metrics of collecting rent on a value-add property:

  • What are our rental numbers?
  • What numbers can be achieved if this property commands market rates?
  • What are we losing from leases in place not at market rate?
  • As units are scheduled for reno and closed down temporarily, how much are we losing during that time period?
  • Once reno’s are done, what’s the rental spike?
  • Displays how economic occupancy compares to physical occupancy.
Value Add Analysis

Same information as chart at bottom right, but in numerical form.

Value Add Analysis
Nonstop Updates

This chart shows the cumulative costs to add value to the property (either through normal upgrades or renovating a distressed property) and increase rents. It displays those costs and cumulative premiums.

Summary fields
Lorem ipsum

These isolate the returns specifically for the value-add components of a multifamily asset. Carving these out from the whole project - which may include units already renovated and already achieving market rents - is a special metric our software offers. Use it to zoom in on the effect of renovation investments.

Stabilized Cash Flow

The orange column displays the development’s stabilized cash flow, once the project is done and tenants are occupying spaces. The columns to the right of the orange column show the timeframe of when the annual return metrics hit desired targets.

Sources and Uses Tables

Easily view both Sources and Uses. For example, compare how a development’s soft costs like permitting and design compare to the hard costs of the build itself. Use this to get clarity on where funds are being spent on a development.

Development Spend Curve
Nonstop Updates

Use this chart to view the timing of expenditures throughout the development. Gain perspective on the chronological sequence of spending. This chart identifies when large spending will occur and can help identify atypical jumps or front loading that affects interest reserve.

General Features (All Models)

  • IRR Monthly
  • IRR Annual
  • XIRR
  • 4 Tier Waterfalls
  • GP Catch up
  • Purchase Price
  • Sensitivites
  • Mezzanine Debt
  • Ability to model up to 2 loans
  • OpEx Ratio Annual
  • Cash-On-Cash Annual
  • Cash-On-Cash Monthly
  • DSCR Annual
  • DSCR Monthly
  • Debt Yield Annual
  • Debt Yield Monthly
  • Floating Rate Debt
  • Detailed Real Estate
  • Taxes
  • Real Estate Tax Annual Abatement Calculations
  • Implied (Land) Contribution to Equity from LP or GP
  • Separate project level metrics from partnership LP/GP level metrics

Model Specific Features

  • Detailed Tenant Expense Reimbursements
  • Unit Renovation schedule
  • Separate rent rolls for each senior housing care segment: Independent Living, Assisted Living, Memory Care, and Skilled Nursing
  • 2nd Occupant rent for each senior housing care segment
  • Rent Concessions and New Resident Fees for each senior housing care segment
  • 5 levels of Care Fees for Assisted Living and Memory Care units
  • Exit Cap Sensitivities
    Office and Retail components
  • Outparcel Sales – ability to sell off individual parcels/buildings with different timings

Applicable Models

  • Commercial Acquisition/Valuation
  • Multifamily Acquisition/Valuation
  • Senior Housing Acquisition/Development
  • Senior Housing Acquisition/Development
  • Senior Housing Acquisition/Development
  • Senior Housing Acquisition/Development
  • All Models
  • Multifamily and Mixed Use
  • All Models

Get a Demo