Retail Income Proforma Calculator

A retail proforma follows a fundamental formula to get from income to value. The first step is to calculate Potential Gross Income (PGI), which is the total rent you would collect if every space were leased and every tenant paid in full. From this, we subtract an allowance for empty spaces and non-payment, known as the Vacancy and Credit Loss, to arrive at Effective Gross Income (EGI).

Next, we add any other income generated by the property. This most commonly includes reimbursements from tenants for operating expenses like taxes, insurance, and common area maintenance (CAM), which are standard in triple-net (NNN) leases. It can also include income from sources like parking or percentage rent. The total of EGI plus this other income gives you Gross Operating Income. Subtracting the property's total Operating Expenses yields the Net Operating Income (NOI). The NOI is the property’s unlevered profit and the single most important figure in the valuation, which is found by dividing the NOI by the market capitalization (cap) rate.

Let's model a 40,000 sq. ft. center. An anchor hardware store leases 25,000 sq. ft. at $14/sf/yr, and three smaller tenants lease 5,000 sq. ft. each at $22/sf/yr. The Potential Gross Income (PGI) is (25,000 * $14) + (3 * 5,000 * $22) = $350,000 + $330,000 = $680,000.

We'll apply a 7% vacancy factor ($47,600), making the Effective Gross Income (EGI) $632,400. The property's operating expenses (taxes, insurance, CAM) are $170,000, but because they are NNN leases, the tenants reimburse this full amount, so we add $170,000 in other income. Additionally, one tenant pays percentage rent of 6% over a natural breakpoint of $366,667 in sales ($22/sf / 6%). With annual sales of $500,000, they pay an extra ($500,000 - $366,667) * 0.06 = $7,999.

The Gross Operating Income is $632,400 (EGI) + $170,000 (Reimbursements) + $7,999 (Percentage Rent) = $810,399. We then subtract the $170,000 in operating expenses to find the Net Operating Income (NOI), which is $640,399. Applying a 6.5% cap rate, the property's estimated value is $640,399 / 0.065 = $9,852,292.

A primary mistake is taking the rent roll at face value without scrutinizing tenant quality. A lease from a local, unproven business carries significantly more risk than a lease from a publicly traded national brand. Always assess the creditworthiness of each tenant, as this directly impacts the reliability of the income stream. A long-term lease with a weak tenant can be less valuable than a shorter-term lease with a strong one.

Another common pitfall is assuming 100% of operating expenses will be reimbursed, even with NNN leases. In practice, "CAM slippage" is common. Certain costs, like management fees or capital improvement reserves, may not be fully passed through to all tenants depending on the specific language in their leases. This slippage eats directly into your bottom line, so budgeting for a 95-98% reimbursement rate is more prudent and realistic than assuming a perfect 100%.

Finally, misinterpreting lease clauses can lead to major errors. Co-tenancy clauses, for example, can allow smaller tenants to pay reduced rent or even terminate their lease if a major anchor tenant leaves. This creates a cascading risk. Similarly, the exact formula for calculating percentage rent breakpoints must be clearly understood to forecast income accurately. Never assume; always verify the specific terms in each lease.

Look beyond the current numbers and analyze the lease expiration schedule. A property where multiple major leases expire in the same year presents a significant future risk. Staggered lease expirations provide a much more stable and predictable cash flow, insulating the property from the impact of any single tenant choosing not to renew. You should apply a higher cap rate (indicating higher risk) to properties with concentrated lease rollover.

Always compare the in-place rents to current market rates. If existing tenants are paying below-market rents, there is a clear opportunity to increase NOI as those leases expire and are renewed at the higher market rate. Conversely, if tenants are paying above-market rents, you must budget for a potential decrease in income on renewal to retain them, which will lower the property's value.

Stress-test your core assumptions to understand the deal's resilience. What happens to your returns if vacancy unexpectedly jumps to 15% for a year? How does the valuation change if future market cap rates rise by 0.50%? Running these different scenarios provides a range of potential outcomes and exposes the property's vulnerabilities, leading to a more informed and risk-aware investment decision than a single, optimistic forecast.