Is your spreadsheet reliable enough to make an acquisition decision?
Why acquisition teams are moving their preliminary analysis to Forbury without leaving their spreadsheets behind.
Is your spreadsheet reliable enough to make an acquisition decision?
Why acquisition teams are moving their preliminary analysis to Forbury without leaving their spreadsheets behind.
Contributor

Jesse Bennett
Product Manager
Key highlights:
In-house, uncontrolled spreadsheets collect one-time adjustments and small errors that compound modelling risks over time
Manual data entry can elevate risk and waste time in preliminary acquisition modelling
A well-reasoned deal rejection is as valuable as a decision to proceed; at four to five hours per manual preliminary assessment, Forbury materially reduces that and changes what it costs to say no
Forbury operates within a spreadsheet environment but replaces ungoverned spreadsheet modelling with a centralised database for models, a standardised calculation engine, and a shared basis (house view) that keeps everyone modelling consistently without giving up their local assumptions
An off-market deal lands at four o'clock. An agent who knows your acquisition criteria has flagged it before it hits the open market, sometimes with a clean spreadsheet attached, but more often a forty-page PDF investment memorandum. Time is short, and a competing investment firm may move faster and seize the opportunity.
For most acquisition teams, what happens next hasn't changed in years: you open a spreadsheet, pull the tenancy schedule, manually populate, and run your scenarios in a workbook you or another team member built. It's familiar, and it works… until it doesn't.
As Jesse Bennett, Product Manager of Forbury, points out, this is precisely where the trouble usually starts.
The commercial real estate acquisition model nobody quite trusts
A manually built and maintained in-house model rarely fails all at once. Instead, it decays over time. You start with something clean that runs the numbers well, and then the deals arrive with their own quirks: a new lease structure here, a one-off output request there, each fix layered on under deadline pressure with none of it built to reliably scale.

Then one analyst's version reflects two of the six changes the committee saw last week, and the questions start: why is this different from the model you showed us on Tuesday? Most of those edits are immaterial on their own. But when small errors are allowed to compound over months, the consequence usually arrives in the form of mispriced assets, sometimes amounting to millions.
This is a governance problem as much as a spreadsheet problem. In a traditional spreadsheet model, incorrect inputs cascade errors through the entire model, leaving an acquisition team to locate and correct them, requiring significant time and effort with no guarantee that everything has been caught. Because Forbury runs every model through a calculation engine, errors are flagged immediately, and every calculation is standardised and consistent across the acquisition team's models. Forbury, the Australian market standard for acquisition modeling, brings that structure to acquisition teams: a model you can open and audit exactly as you would your own, with the added integrity checks a self-built workbook could never offer.
Rapidly reveal a number you can defend
Platform and process transitions can feel complex, if not entirely daunting for teams. But Forbury sits on top of the spreadsheet environment your analysts are already familiar with, which is what makes the speed-to-model believable. You can import the agent's PDF or spreadsheet into Forbury where it automatically detects the tenancy table and aligns it to the model's columns. Two minutes are spent checking headers instead of an afternoon of reconciliation and manual entry which is the single biggest source of error and wasted time in manual spreadsheet modelling.
From there, you can move almost immediately to generating your outputs. You could enter the agent's quoted yield, hit run, and you have an IRR; a first assessment of the asset before you've committed to a deeper analysis. Or you might select a house view (a pre-defined set of assumptions agreed on by your team) for an industrial site in Melbourne, and the model populates your growth, CPI, and leasing assumptions in a click, leaving you to focus on the questions that matter in easy-to-deploy, side-by-side scenarios: what if these leases renew? What if that unit needs refurbishing?

Instead of staying at the office late, working with spreadsheet formulas, an analyst can spend as little as 15 minutes putting the data in, knowing that Forbury is using consistent assumptions and underlying calculations to output the analyst’s best-case and worst-case scenarios, and know immediately if it's a deal worth taking to a team lead for deeper analysis.
It's a real use case, and we've shown it again and again, an agent's tenancy schedule can be imported and modelled to an IRR in five to ten minutes, through the direction of an acquisition analyst. The harder number is what it replaces: four to five hours of manual modelling down to just a fraction of the time. An analyst screening ten deals a week recovers close to thirty hours. It also changes the economics of saying “no”: you could spend four hours on a model only to realise it was never a deal you'd have bought. A confident “no” is just as important as a “yes”, and with Forbury it is fast enough to spot the next deal worth pursuing.
When everyone's "yield" means something different
Speed only helps if the output stands up to committee scrutiny, and that's where cross-border teams usually encounter friction. Two separate acquisition teams can both price on net initial yield and mean different things by it. Without a shared modelling structure, one team's acquisition cost treatment, growth assumptions, or void conventions will differ from the other's, not because either is wrong, but because they built their models independently. By the time those deals are compared directly, the reconciliation becomes the conversation instead of the decision.

House views centralise your firm's assumptions - entry and exit, growth, leasing - and when you apply them consistently, no one is guessing which version a colleague is working from. Through Forbury, every property-level calculation runs on the same engine for everyone; what sits on top is your specific adjustments, complete with custom sheets and return metrics calculated your way, every time. One global investment manager is deploying the model across its acquisition and business-planning teams for exactly this reason. An investment house already runs its international deals this way, with each region keeping its own assumptions and tax treatments, all preserved through Forbury’s house views.
Conviction, not just speed
Speed is the headline, but it isn't the whole story. Conviction for what has been modelled is critical; looking at a deal and saying yes or no, and standing behind the number either way. But sometimes a demonstration speaks louder than a description; bring us a deal you'd normally dread modelling and we’ll show you how Forbury turns it into a defensible IRR before the session ends.
Want to be notified of our new and relevant CRE content, articles and events?
Contributor

Jesse Bennett
Product Manager



