Real Estate Broker Financial Model Template
This Real Estate Broker Financial Model Template is a professional Excel workbook built for residential estate agencies, property brokerages and real estate franchise owners who need credible, investor-ready financial projections. It combines two years of monthly historical financials with a five-year monthly forecast and annual roll-ups. It is driven by the metrics that really move a brokerage’s numbers: agent headcount, agent productivity, property listings, sales pipeline conversion, average selling price and commission rates. Whether you are raising finance, applying for a bank loan, valuing a brokerage for sale or building next year’s budget, this real estate financial model gives you a complete, fully linked view of revenue, profitability, cash flow and business value.
Financial Model for a Real Estate Broker
At the heart of the template is a realistic brokerage revenue model. Gross Commission Income (GCI) is built bottom-up from transactions, not guessed. Recruited agents ramp up to full productivity over five months and generate new instructions. Listings convert into offers, sales agreed and completed transactions, after allowing for withdrawals, expiries and sales fall-throughs. Commission income is then split between sole agency, multi-agency, referral and other revenue. The agent commission split engine covers junior, standard, senior, top-performer and team-leader agents, plus overrides, bonuses and clawbacks, to calculate the net brokerage revenue your firm actually keeps.
Every figure flows into a fully integrated three-statement financial model: Profit & Loss, Cash Flow Statement and Balance Sheet. The balance sheet balances in every month, and 14 built-in integrity checks prove it. The model also includes employee payroll, 70 operating expense lines, capex and depreciation, working capital, VAT and corporation tax, debt and a revolving credit facility. It adds Base, Upside and Downside scenarios, budget vs actuals reporting, sensitivity and break-even analysis, and a full DCF valuation with WACC and terminal value sensitivity grids. Change one start date and the entire model re-dates automatically.
What’s Inside: Tab-by-Tab Overview
01. Cover & Dashboard
The executive dashboard summarises your real estate brokerage’s performance on one page. It shows key financials for every year, a valuation snapshot, live integrity checks and clickable navigation to every tab. Investors, lenders and buyers can see revenue, EBITDA, cash, agent headcount and transaction growth within seconds, presented in a clean, professional format.
- Seven-year summary covering two actual years and five forecast years
- Net revenue and EBITDA chart, plus agents and transactions chart
- 14 model integrity checks with a single OK / REVIEW status
- Selected enterprise value, equity value and implied EBITDA multiple
- Hyperlinked table of contents and colour legend
02. Assumptions
All inputs for the estate agency financial model live in one organised tab. It covers model settings, market data, commission rates, agent economics, payroll, cost inflation, capex, working capital, tax, financing and DCF inputs. A scenario selector switches every key driver between Base, Upside and Downside, and the master timeline re-dates the entire model automatically.
- One master start date drives every date, label and escalation
- Base / Upside / Downside values for ten key business drivers
- Monthly property market seasonality factors
- Agent class mix, ramp-up profile and role-by-role salary tables
- Year-1 cost rates for 70 operating expense lines
Real Estate Broker Revenues & Commissions
03. Historical Financials
Enter two years of monthly actuals to anchor your brokerage financial projections in real performance. The tab holds a historical profit and loss, balance sheet, cash flow statement and operating KPIs. Closing December balances automatically seed every forecast opening balance, so your projections start exactly where your management accounts finish.
- 24 months of monthly P&L, balance sheet and cash flow
- Balance check and cash reconciliation built in
- Operating KPIs: agents, instructions, listings, offers and completions
- GCI per agent, revenue per agent and average commission rate
- Opening forecast balances linked automatically
04. Agent Headcount
Model the most important driver of any real estate brokerage: your agents. This tab rolls headcount forward month by month using recruitment targets, voluntary and involuntary attrition, and class mix. A five-month ramp-up profile converts new hires into productive full-time equivalents, giving a realistic view of agent capacity and recruitment costs.
- Monthly agent roll-forward: opening, recruits, departures and closing
- Recruitment pipeline, conversion rate and recruitment cost per agent
- Agent classes from junior to team leader
- Five-month ramp-up to productive agent FTE
- Retention rate, GCI per agent and productivity growth
05. Listings & Pipeline
Follow the full property sales funnel, from new instruction to completion. New listings are driven by productive agents, productivity, seasonality and market growth. Active listings convert into offers and sales agreed. The sales pipeline then exits monthly based on your average time to completion, after fall-throughs are deducted, producing a defensible forecast of completed transactions.
- Sole agency and multi-agency instructions
- Withdrawals, expiries, lost listings and duplicates
- Offers received, accepted, rejected and withdrawn
- Sales-agreed pipeline with fall-through analysis by cause
- Conversion rates and transaction cycle timing in days
06. Revenue Build
The real estate commission revenue model turns completed transactions into income. Transaction volumes are multiplied by indexed selling prices and commission rates to produce Gross Commission Income. Ancillary revenue streams such as mortgage, conveyancing, surveying and financial services referrals are added. Discounts, rebates and clawbacks are then deducted to reach total net revenue.
- Sole agency, multi-agency, referral and other transactions
- Gross transaction value with monthly property price indexation
- GCI by revenue stream with blended commission rate
- Five ancillary referral income streams based on attach rates and fees
- Revenue growth, GCI per transaction and revenue per listing
07. Agent Commissions
Calculate what agents earn and what the brokerage keeps. GCI is allocated across agent classes using productivity weightings, then commission splits are applied by tier. Team leader overrides, sales and performance bonuses, referral payouts, external agency sharing and clawbacks complete the picture, giving an accurate net brokerage commission revenue and retention rate.
- Productivity-weighted GCI by agent class
- Tiered commission splits and payouts
- Team leader overrides, bonuses and referral payouts
- External agency commission sharing and agent clawbacks
- Brokerage retention rate and net revenue per agent
Real Estate Broker Financial Statements
08. Employee Payroll
Plan support-staff costs separately from self-employed agent commissions. Headcount for management, administration and support teams rolls forward with growth and attrition. Salaries are built role by role, from managing director to receptionist, with annual salary inflation. Employer National Insurance, pension, bonuses and benefits complete a detailed payroll forecast.
- Headcount roll-forward for three staff groups
- 15 roles with individual salaries and headcount mix
- Employer NI, pension, bonus, health insurance and other benefits
- Payroll memo lines covering pay rises, new hires and leavers
- Payroll as a percentage of revenue, plus revenue and EBITDA per employee
09. Operating Expenses
Forecast 70 brokerage overhead lines, each linked to the driver that genuinely causes the cost. Drivers include branches, users, agents, new instructions, completions or revenue. Each line has its own inflation index, covering rent, rates, marketing, portal costs, software, insurance, professional fees, recruitment and general administration, making budgeting precise and easy to defend.
- Office occupancy, property marketing and digital marketing
- Rightmove, Zoopla and OnTheMarket portal costs
- Technology, CRM, professional fees, insurance and compliance
- Recruitment, training and general administration
- Opex per agent, per transaction, per listing and as a % of revenue
10. CapEx & Depreciation
Plan investment in office fit-outs, furniture, IT equipment, software and website development. The fixed asset register depreciates opening net book value over its remaining life and new additions straight-line over each category’s useful life. It produces a full roll-forward from gross cost to net book value, linked directly to the balance sheet.
- Eight capex categories with annual growth
- Opening asset split by category with remaining useful lives
- Straight-line depreciation by asset class
- Net book value roll-forward, gross cost and accumulated depreciation
- Capex per agent, per employee and as a % of revenue
11. Working Capital
Understand the cash timing of your estate agency. Commission receivables, trade payables, accruals and prepayments are calculated on a days basis. VAT is settled after a configurable lag and corporation tax is paid in the following year, so cash flow forecasts reflect when money actually moves, not just when profit is earned.
- Commission receivables with collection period and invoicing lag
- Trade payables, accrued expenses and prepayments
- VAT output, input, payments and refunds
- Corporation tax charge, payments and closing liability
- Net working capital movement and working capital days KPIs
12. Debt & Financing
Model bank loans, a revolving credit facility, shareholder funding and dividends. The term loan amortises over your repayment period. The revolver draws automatically to protect your minimum cash balance and repays from surplus cash. Equity injections, dividend payouts and financing KPIs give lenders exactly the debt analysis they ask for.
- Bank loan schedule with drawdowns and amortisation
- Automatic revolving credit facility to hold minimum cash
- Interest expense and interest income on deposits
- Equity contributions, shareholder loans and dividend policy
- Debt/EBITDA, net debt, interest cover, DSCR and gearing
13. Profit & Loss
The monthly Profit & Loss statement takes Gross Commission Income through agent commissions to net revenue, then deducts payroll, property marketing and operating expenses to reach EBITDA. Depreciation, finance costs and corporation tax take it down to net profit, with annual roll-ups and year-on-year profitability KPIs for every forecast year.
- 60-month P&L with FY Total columns
- Net brokerage revenue after agent commission costs
- EBITDA, EBIT, profit before tax and net profit
- Gross and net margins plus year-on-year growth rates
- Revenue per agent and EBITDA per agent
14. Cash Flow
The indirect cash flow statement reconciles net profit to cash. It shows operating, investing and financing cash flows every month, with working capital movements broken down line by line. Cash flow KPIs such as free cash flow, cash conversion and runway show whether your real estate business generates cash or needs funding.
- Operating cash flow with detailed working capital movements
- Investing cash flow by capex category
- Financing cash flow covering debt, equity and dividends
- Opening and closing cash every month
- Free cash flow, cash conversion, burn rate and cash runway
15. Balance Sheet
A complete monthly balance sheet built from every supporting schedule. It covers cash, receivables, fixed assets, payables, tax liabilities, borrowings and shareholders’ equity. A balance check runs in every period alongside reconciliations to fixed assets, debt and retained earnings, giving reviewers complete confidence that the three statements are fully integrated.
- Current and non-current assets and liabilities
- Fixed assets at cost less accumulated depreciation
- Current and long-term split of bank loans
- Retained earnings with year-to-date profit and dividends
- Balance check plus three reconciliation checks every month
Real Estate Model Key Metrics & DCF
16. BvA & Sensitivity
Track performance and stress-test your plan. Monthly budget vs actuals reporting compares the forecast with your real results across revenue, agents, transactions, commissions, payroll, costs, profit and cash. Scenario outcomes, driver sensitivities and break-even analysis show how resilient the brokerage is to changes in the market.
- Monthly budget vs actuals with variances and year-to-date totals
- Base, Upside and Downside revenue, EBITDA and cash
- Side-by-side scenario driver comparison
- Revenue and EBITDA sensitivity to key drivers
- Break-even transactions, agent headcount and revenue
17. DCF Valuation
Value your real estate brokerage using a discounted cash flow model. Unlevered free cash flows are discounted at your WACC, with a CAPM cross-check, and terminal value is calculated by both the perpetuity growth and exit multiple methods. Enterprise value bridges to equity value, supported by WACC and growth sensitivity tables.
- WACC build with levered beta and cost of equity
- Five-year unlevered free cash flow forecast
- Terminal value by perpetuity growth and exit EBITDA multiple
- Enterprise value to equity value bridge
- 11 × 6 enterprise value and equity value sensitivity grids
Why Buy This Model?
Building a real estate brokerage financial model from scratch takes weeks and is easy to get wrong. This template gives you a proven, fully integrated structure from day one. It contains nearly 54,000 live formulas, no hardcoded results and no macros, and it passes all 14 integrity checks in every month. It is built around how real estate brokerages actually make money: agents, listings, conversions and commission splits. That means your forecast stands up to scrutiny from banks, investors and buyers. Professional formatting, a colour-coded input system, automatic date chaining, scenario analysis and a built-in DCF valuation mean you spend your time on decisions, not spreadsheet mechanics. Simply replace the illustrative inputs with your own data and present with confidence.
Real Estate Broker Frequently Asked Questions
Q: I run a small estate agency with one office. Is this model suitable, or is it only for large brokerages?
A: It works for any size. Set the number of branches, opening agents, staff headcount and cost rates in the Assumptions tab and everything scales automatically. A one-branch agency with eight agents uses exactly the same logic as a multi-branch brokerage with 100 agents.
Q: Do I need to be an Excel expert to use it?
A: No. All inputs sit on one tab and are colour-coded: blue cells on a yellow background are the only cells you change. Every other tab calculates automatically. Each tab also has a summary line and notes explaining what it does.
Q: Can I enter my own historical figures?
A: Yes. Tab 03 holds 24 months of actuals for the P&L, balance sheet, cash flow and KPIs. Overwrite the illustrative numbers with your management accounts, and the December balances automatically become the opening balances for the forecast.
Q: My financial year doesn’t start in January, and I want the forecast to start in a different year. Can I change that?
A: Yes. Change the Financial Year Start Date in the Assumptions tab and every date, year header, month label, inflation step, tax payment and dividend timing across all 17 tabs updates automatically.
Q: Our agents are self-employed on commission splits. Does the model handle that?
A: Yes, that is exactly how it is designed. Agent payouts are calculated through tiered commission splits for junior, standard, senior, top-performer and team-leader agents, plus overrides, bonuses and clawbacks. Salaried support staff are modelled separately in the payroll tab.
Q: How is revenue calculated? Is it just a growth percentage?
A: No. Revenue is built bottom-up. Productive agents generate new listings, listings convert into offers and sales agreed, and the pipeline completes after fall-throughs. Completed transactions are then multiplied by selling price and commission rate. Ancillary income such as mortgage and conveyancing referrals is added on top.
Q: Can I use this model to get a bank loan or raise investment?
A: Yes. It produces the outputs lenders and investors expect: an integrated P&L, cash flow and balance sheet, debt service coverage, interest cover, gearing, scenario analysis and a DCF valuation. All of it is presented in a clean, professional format.
Q: Can I value my brokerage for a sale or acquisition?
A: Yes. The DCF Valuation tab calculates enterprise value and equity value using both the perpetuity growth and exit EBITDA multiple methods. Sensitivity grids show how value changes across a range of WACC and terminal growth assumptions.
Q: How do the Base, Upside and Downside scenarios work?
A: Ten key drivers each have three values in the Assumptions tab. Choose a scenario from the drop-down and the whole model recalculates. These drivers include recruitment, attrition, productivity, selling price, commission rate, agent split, listing conversion, fall-through rate and cost inflation.
Q: Does it include budget vs actuals tracking?
A: Yes. Tab 16 compares the budget with actual results month by month for revenue, agents, transactions, commissions, payroll, operating costs, EBITDA, net profit, cash and capex. It also shows variances and year-to-date totals.
Q: Is it in US dollars only? We’re based in the UK.
A: The model is presented in USD, but the currency label and every input can be changed. Simply enter your figures in pounds or any other currency. UK-specific items such as VAT, Employer National Insurance and property portal costs are already built in.
Q: Does the model use macros or VBA?
A: No. It uses standard Excel formulas only. There are no macros, no VBA and no external links, so it opens without security warnings and every calculation is transparent and auditable.
Q: How do I know the model is accurate?
A: The dashboard runs 14 integrity checks covering balance sheet balancing, cash reconciliation, fixed assets, debt, retained earnings, working capital, input mixes and minimum cash. All of them show “OK” in the delivered model, and they will flag immediately if anything breaks after you edit.
Q: Can I add more branches, cost lines or revenue streams?
A: Branches are a single input that drives per-branch costs automatically. The model is fully unlocked, with a consistent row and column structure, so experienced users can extend it. The 70 cost lines and five ancillary revenue streams already cover most estate agency businesses.
Q: What version of Excel do I need?
A: Any modern version of Microsoft Excel, on Windows or Mac. The model uses widely supported standard functions such as INDEX, MATCH, SUMPRODUCT and EOMONTH, and avoids newer dynamic array functions for maximum compatibility.
Final Notes on the Financial Model
This 5 Year Real Estate DCF Financial Model focuses on balancing capital expenditures with steady returns. By optimizing expenditure costs, and efficiency, and maximizing high-margin services, the models ensure sustainable profitability and cash flow stability.