How to Build a Real Estate Proforma for Commercial Properties

A real estate proforma is the financial model behind every commercial property decision: what the asset earns today, what it could earn tomorrow, and whether the deal works at your price. Lenders read it before they quote terms. Partners read it before they commit capital. And every assumption inside it is a claim you will eventually have to defend.

This guide walks through how to build a proforma for commercial real estate from the documents up - the same structure EVALUAITE automates - so you know exactly what belongs in the model, where each number comes from, and which assumptions deserve the most scrutiny.

Every proforma for real estate starts with the income the property can actually produce. Begin with gross potential rent: every unit or suite at its contracted rent, with vacant space carried at market. Layer in other income - parking, storage, laundry, signage - as separate lines so each can be tested on its own.

Then subtract a vacancy and credit-loss allowance. Even a fully leased building deserves one; it prices the risk of turnover and non-payment into the model instead of pretending it away.

Operating expenses come next, and lease structure decides how they behave. Under a gross lease the owner absorbs them; under a triple-net (NNN) lease most are recovered from tenants, so your model must separate recoverable from non-recoverable expenses or it will misstate the owner's true burden. Property taxes, insurance, utilities, management, repairs and maintenance, and reserves each get their own line.

What remains is net operating income - the number the rest of the model, and most of the valuation conversation, is built on. A proforma that gets NOI right is defensible; one that buries a bad expense assumption underneath it is a liability with formatting.

NOI describes the property; the rest of the proforma describes the deal. Layer in financing - loan amount, interest rate, amortization - to get annual debt service, then cash flow after debt. Two ratios tell you immediately whether the structure works: debt service coverage (NOI divided by debt service), which lenders want comfortably above their minimum, and cash-on-cash return, which measures what your actual invested equity earns.

Then extend the model through time. Project rent growth, expense growth, and vacancy year by year - separately, because they move for different reasons - and carry the model far enough to cover your intended hold. Add a disposition: an exit value based on stabilized income at sale, less selling costs.

Finally, stress it. A proforma is a set of assumptions, and sensitivity analysis is how you learn which one is doing the heavy lifting. Move vacancy, rates, and exit assumptions through realistic ranges and watch which swing changes the decision. The deals that go wrong are rarely wrong everywhere - they are wrong in the one assumption nobody tested. Test the income-to-value relationship yourself with our free cap rate calculator: https://evaluaite.io/tools/cap-rate-calculator

A buy-and-hold proforma is the base case. Other strategies restructure it. A value-add model adds a rehab budget, holding costs during renovation, and a refinance at the new stabilized income. A development pro forma starts from land and construction costs, carries financing through the build, and only then hands off to the stabilized operating model. A disposition model compresses everything into acquisition, improvement, and sale.

The most common proforma mistakes are the quiet ones: using asking rents instead of contracted rents; valuing in-place income as if it were stabilized income; forgetting that NNN recoveries do not cover everything; letting expense growth lag rent growth forever; and modeling refinance proceeds at today's rates on tomorrow's timeline.

The deeper discipline is provenance. Every number in the model should trace back to a document - a rent roll, a lease, an operating statement - because that is the standard a lender or partner will hold it to. That traceability is precisely what EVALUAITE automates: upload the deal documents, and the platform extracts the financials, reconciles them, and builds the proforma with every figure linked to its source.

Key takeaways

• Build income top-down: gross potential rent, other income, vacancy allowance, then expenses split by recoverability
• NOI is the foundation - make it defensible before touching debt
• DSCR and cash-on-cash test the structure; projections and an exit test the deal
• Match the model to the strategy: value-add, development, and disposition each restructure the base case
• Trace every number to a source document