FAB Analytics creates bespoke Excel-based Real estate financial modelling services that assist developers, investors, fund managers, and REITs in evaluating prospects, structuring finance, forecasting returns, and monitoring performance. Our models are intended to be clear, adaptable, and financially viable, from early-stage feasibility to deal execution and continuous asset or portfolio reporting.
FAB Analytics helps clients build models that provide clear answers to critical commercial questions:
We build detailed real estate development models for residential, commercial, mixed-use, hospitality, industrial and other property development projects. These models assist developers, landowners, investors, and joint venture partners in assessing the project's viability, the required funding, and anticipated returns.
Our development models can support both build-to-sell and build-to-lease / build-to-hold strategies. They usually include project schedules, land purchase expenses, hard and soft costs, construction schedules, sales or leasing assumptions, operating expenses, debt financing, equity financing, tax assumptions, valuation, and investor returns.
We develop acquisition and disposition models for investors, analysing current income-generating real estate assets.. These models help assess purchase price, rental income, operating expenses, capex, debt financing, exit value and investor returns over the hold period.
For acquisitions, the model helps determine whether the asset meets the investor’s return thresholds. For dispositions, the model can evaluate expected exit proceeds, debt repayment, distribution waterfall and investor-level returns.
We build real estate private equity fund models for fund managers, sponsors and investment teams. These models help evaluate acquisitions, consolidate asset-level cash flows, model fund-level returns and structure distributions between LPs and GPs.
These models are particularly useful when the investment structure includes multiple assets, investor classes, capital calls, management fees, preferred returns, promos, or complex distribution waterfalls.
We build REIT financial models to support asset-level forecasting, portfolio consolidation, investor reporting and valuation. These models help REITs and investment teams track income, occupancy, debt, distributions, and key performance metrics.
We assist real estate investors, developers, family offices and funds in developing portfolio reporting models that combine the performance of multiple assets, projects or investment vehicles.
These models are useful for monthly or quarterly reporting, budget-to-actual analysis, rolling forecasts, covenant monitoring, and investor communication.
We have experience in our real estate modelling in a variety of asset classes and investment strategies, such as:
| Model Module | What It Covers |
|---|---|
| Assumptions | Timeline, property stats, revenue drivers, cost assumptions, financing terms and exit assumptions |
| Revenue Forecast | Sales, leasing, rental income, occupancy, renewals and escalations |
| Expense Forecast | Land, construction, soft costs, operating expenses, tenant improvements and contingencies |
| Financing | Debt sizing, drawdowns, repayments, interest, refinancing and covenants |
| Valuation & Analysis | Cap rate, NAV, exit value and sensitivity analysis |
| Returns | Project IRR, equity IRR, MOIC, NPV, and cash-on-cash return |
| Waterfall | Preferred return, return of capital, catch-up, promote and investor distributions |
| Dashboard | Executive summary, key KPIs, charts, scenarios and investment decision outputs |
| Quality Checks | Error checks, balance checks, source tracking and model integrity checks |
Real estate models are not generic spreadsheets. They need to reflect the transaction's commercial structure, cash flow timing, funding strategy, asset class, investor return requirements, and the way decisions are actually made.
FAB Analytics combines financial modelling expertise with real estate transaction experience to build models that are technically robust and commercially practical.
Our models are built with a clear structure, consistent formulas, transparent calculations, and easy-to-follow logic. This allows the model to be reviewed, updated, and used by many stakeholders.
We do not simply force your transaction into a generic template. We design the model around the specific project, asset, capital structure, investor terms and reporting requirements.
We support developers, real estate PE funds, REITs, family offices and investment teams across appraisal, acquisition, development, waterfall, portfolio and reporting models.
Real estate models often continue beyond the transaction stage. We can help maintain, update and evolve the model for actual performance tracking, investor reporting, refinancing, asset management and future acquisitions.
Where a full rebuild is not required, we can also
review and retrofit existing models to improve structure, accuracy, usability and reporting outputs.
We will arrange a call to listen to your requirements and discuss how we can help you better understand your business.
We normally exchange NDA's (non-disclosure agreements) so we can review existing spreadsheets or other data that we will be referencing.
We will work with you to agree on the initial scope of work and the likely cost.
We will prepare a simple agreement for your signature.
Our delivery process is very efficient and follows a collaborative approach.
Kick-off: To get the ball rolling, we will introduce you to our modelling team, who will work directly with you, exchange information and reference material.
Our team will begin work in accordance with the agreed scope of work. They will keep you posted on progress, share WIP models, take your comments during model construction, and resolve your queries as the build progresses, to ensure you understand the model from the beginning.
Once the full model is complete, we will assist you in updating it with real data and in debugging and correcting bugs discovered during live runs.
Once the live run is complete, we will offer one-on-one training to ensure your team utilises the model effectively.
We provide long-term support on a separate support and maintenance agreement so that your investment can continue to serve your company for many years to come. Our clients find this invaluable. Not only does it keep the model fit for purpose, but it also provides continuity when key employees are promoted or leave.
FAQ
