Custom Financial Model

Multifamily Model

Comprehensive and easy to use. We tailor our multifamily model to your specific needs so you can analyze deals accurately and efficiently.

Interested in a demo? Contact us and we can discuss your specific needs. Below we walk through our multifamily template; we can also build an entirely new template if this one does not fit your business.

Dashboard

It is important to have a succinct summary of your investment that people new to the deal can easily follow in order to gain an understanding of the major deal points. Our default dashboard gives you all of the necessary information about the property. It includes standard items like the property address, basic information (units, SF, parking, etc.), summary, and a property photo at the top of the page. Below, it includes information on the returns at the property and investor level, and the structure of the waterfall that determines the returns at the investor level. You also get information on the debt structure and the sources and uses for the investment.

Multifamily model investment dashboard

Each investor is different when it comes to the information they want displayed, so the Dashboard is our most commonly altered item. We can make the dashboard much more comprehensive if you intend to use the information for presentation purposes. Below are some of the common adjustments we make for clients.

  • More comprehensive Sources & Uses
  • Additional investment metrics (market rent, effective rent, occupancy, etc.)
  • Current income and stabilized income
  • Charts/graphs to represent returns over time

Annual Summary

The annual summary is an important part of any financial model. A lot of time gets spent altering assumptions and formulas on the monthly pro forma, and sometimes you need to take a step back and look at everything on an annual basis to see if all of your changes make sense. On top of this, the annual summary is a great tool to show investors who are not interested in diving into all of the details. Our annual summary follows the same format as the pro forma tab, so it is easy to go back-and-forth between the two.

Multifamily model annual summary

Model Assumptions

A model is nothing without good assumptions. We provide you with the tools to model all of the common assumptions you need for an investment in a multifamily property. We split this up between purchase and sale assumptions, rent assumptions, and expense/capex assumptions. You can adjust the annual growth for each item and set how much of the monthly expense is fixed, and how much is variable depending on occupied units.

Multifamily model assumptions tab

Rent Schedule

The rent schedule is how we keep track of the leasing of the property. It takes the rent assumptions from the assumptions tab and calculates the effective rent, market rent, and occupancy through the investment period. You can alter the rents, roll to market, stabilized occupancy, leasing pace, and rent growth on the Assumptions tab. The rental income feeds into the pro forma, which shows the Gross Scheduled Income, Gain/Loss to Lease, Vacancy Loss, and Effective Rental Income.

Multifamily model rent schedule

Pro Forma

The pro forma is where all of the assumptions and calculations come together to show the returns for the property and investors. It gives you a view of the NOI, capital expenditures, debt service, and purchase and sale assumptions. Based on these values, we show the unlevered and levered returns at the property-level, as well as the returns for the GP and LP based on the waterfall assumptions.

Multifamily model pro forma

Debt

Debt can often be a tricky thing to model, but it’s important to get it right because failing to meet certain covenants can force you to either contribute more equity than you anticipated or refinance. We provide a simple debt page that feeds into the Pro Forma tab in order to determine levered returns. It allows for one fixed-rate loan with an IO Period if necessary, and all loan terms can be adjusted.

Multifamily model debt tab

This will suffice for many real estate deals, but we can customize this template to include many different scenarios. Below is a list of some adjustments and additions we can make to this template so we can accommodate your typical deal structures.

  • Floating rate debt
  • Mezzanine debt
  • Refinance debt
  • Construction loans
  • Tracking loan covenants and handling paydowns/refinances when requirements are not met

Waterfall

The distribution waterfall is often the most complicated part of a real estate model. Waterfalls are different for each deal and it can be challenging to create formulas that will account for multiple structures. We provide a simple waterfall that should work for most standard deals. It includes three IRR hurdles that are based on the LP hitting the specified IRR. It distributes the cash flow using the splits you specify in the model.

Multifamily model distribution waterfall

This structure might not work for your deal, but we have plenty of ways we can modify this tab to fit your needs. Below are some of our most common updates.

  • Addition of equity multiple hurdles
  • Including more than three hurdles
  • Including different hurdles for different investors

See the model in action

Book a demo and we’ll show you how the model can be tailored to your deal structures.