Why an undefined IRR should not be replaced with an invented return
A well-defined internal rate of return (IRR) is a critical metric for evaluating commercial real estate investments. Substituting it with an invented or arbitrary return figure can misrepresent project viability and mislead lenders. This guide provides an actionable evidence checklist to help sponsors prepare a defensible IRR calculation, distinguish source facts from assumptions, and improve financing discussions.
A well-defined internal rate of return (IRR) is a critical metric for evaluating commercial real estate investments. Substituting it with an invented or arbitrary return figure can misrepresent project viability and mislead lenders. This guide provides an actionable evidence checklist to help sponsors prepare a defensible IRR calculation, distinguish source facts from assumptions, and improve financing discussions.
Understand the role of IRR in financing discussions
The internal rate of return (IRR) measures the annualized effective compounded return on an investment, considering the timing and magnitude of cash flows. In commercial real estate, IRR is a metric used by investors to assess whether a project generates sufficient return relative to risk. An undefined or invented IRR undermines this assessment, potentially leading to unrealistic expectations or loan denial. The OCC's Commercial Real Estate Lending handbook notes that budgets lacking detail or appearing overly optimistic should be scrutinized [1]. Therefore, a well-supported IRR is essential for credible financing requests.
Distinguish IRR from other return metrics
Before calculating IRR, clarify how it differs from other metrics lenders may request. IRR focuses on the time value of money, while metrics like cash-on-cash return or equity multiple do not. The OCC guidance emphasizes that interest or preferred returns payable to equity partners should not be included in the construction budget [1]. This distinction matters because IRR calculations should reflect only project-level cash flows, not investor-level returns. Record each metric separately and explain why IRR is the appropriate measure for your project.
Prepare a concrete evidence checklist for IRR calculation
Use the following checklist to assemble the data needed for a defensible IRR. This is a suggested way to prepare information, not a mandatory lender process. Each item supports a specific input in the IRR formula.
- Sources and uses of funds: Itemize all capital sources (equity, debt, grants) and uses (acquisition, hard costs, soft costs, reserves). The OCC handbook warns against including developer overhead or selling costs in the construction budget [1].
- Cash flow projections: For each period (typically monthly or quarterly), estimate gross revenue, vacancy/collection losses, operating expenses, capital expenditures, and debt service. Distinguish gross rent from collected income and net operating income (NOI) from equity cash flow.
- Exit or refinance assumptions: State the assumed sale price, cap rate, or refinance proceeds at the end of the holding period. Do not equate a cap rate with a debt constant; they serve different purposes.
- Timing of cash flows: Record the exact dates or periods for each cash inflow and outflow. The OCC notes that general conditions should not be fully funded upfront but funded with each loan advance [1].
- Relevant financial statements: Provide historical operating statements (e.g., trailing twelve months or T-12) for existing properties, and pro forma projections for new developments. Identify the reporting basis (cash or accrual) and reconcile periods.
Reconcile rent roll and operating statement timing
A current rent roll is a snapshot of occupancy and rents at a single point in time. A T-12 statement covers twelve historical months. Comparing totals from these two sources without adjustment can misrepresent income. Explain the timing difference: the rent roll shows what is leased now, while The T-12 reports historical income and expenses on its stated accounting basis over the past year. Reconcile by noting seasonal vacancies, rent concessions, or one-time events. The OCC recommends periodic property inspections to verify that tenants and vacancies are accurately reported in the rent roll [1].
Identify and document key assumptions
Every IRR projection relies on assumptions about rent growth, expense inflation, vacancy rates, and exit cap rates. Clearly document each assumption and its source. The OCC handbook advises reviewing budgets to determine whether they realistically reflect costs and time required [1]. If you assume rents above market or occupancy rates above historical norms, note this as a risk factor. Do not present assumptions as certainties; instead, frame them as inputs subject to change. This transparency helps lenders evaluate the project's risk profile.
Compare your IRR to lender expectations
Lenders may have internal thresholds for acceptable IRR, but these vary by institution, property type, and market conditions. Ask the actual lender what range they consider viable for your project type. Do not rely on invented benchmarks or claims about what all lenders demand. The OCC guidance highlights that loans with unrealistic assumptions, such as higher than current rents or occupancy rates, are risk factors [1]. Present your IRR alongside sensitivity analyses showing how changes in key variables affect returns.
Prepare a worksheet for your IRR calculation
Create a simple spreadsheet with the following columns: period (e.g., month or year), net cash flow (inflows minus outflows), and cumulative cash flow. Use the IRR function in your spreadsheet software to calculate the rate. Include a separate row for the initial investment (negative cash flow) and final proceeds (positive cash flow). Label each input clearly and cross-reference it to your evidence checklist. This worksheet is a concrete workpaper you can share with your lender to demonstrate rigor.
FAQs
What if my project has multiple phases or funding rounds?
Calculate a separate IRR for each phase, then combine them into a blended IRR if the phases are interdependent. Document the assumptions for each phase separately. The OCC handbook notes that ADC (acquisition, development, and construction) arrangements may initially be classified as investments but later reclassified as loans when risk diminishes [1]. This underscores the need for periodic re-evaluation of IRR assumptions.
How do I handle debt service in IRR calculations?
Include debt service (interest and principal payments) as cash outflows in the periods they occur. Do not include interest or preferred returns payable to equity partners [1]. The resulting IRR reflects the return to the equity investor after debt service, which is the relevant metric for most lenders.
Can I use an IRR from a similar project as a proxy?
Only as a starting point. Adjust the proxy IRR for differences in property type, market, leverage, and timing. The OCC handbook warns against budgets that lack detail or appear overly optimistic [1]. A proxy without adjustment is an invented return, not a defensible estimate. Always base your final IRR on your project's specific cash flows.
Run the numbers on your deal
Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.
Talk through your financing
Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).