An off-market deal lands at four o'clock. A broker 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 in France and Germany, what happens next hasn't changed in years: you open a spreadsheet, pull the tenancy schedule, enter it by hand, and run your scenarios in a workbook you or another team member built. It's familiar, and it works… until it doesn't.

As Ryan Spear, Senior Product Manager of ARGUS Workbook by Forbury (ARGUS Workbook), 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, 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 ARGUS Workbook runs every model through the ARGUS Calculation Engine, errors are flagged immediately, and every calculation is standardised and consistent across the acquisition team's models. ARGUS Workbook 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.

Fifteen minutes to reveal a number you can defend

Platform and process transitions can feel complex, if not entirely daunting for teams. But ARGUS Workbook 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 broker's PDF or spreadsheet into ARGUS Workbook 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, Spear notes, “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 broker'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 Berlin, 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 15 minutes putting the data in, knowing that ARGUS Workbook 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," Spear says — a broker's tenancy schedule 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 ARGUS Workbook 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. A French team and a German team 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 ARGUS Workbook, 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. Spear notes that one global investment manager is deploying the model across its European acquisition and business-planning teams for exactly this reason. A French investment house already runs its UK and German deals this way, with each region keeping its own assumptions and tax treatments, all preserved through ARGUS Workbook’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 a deal you'd normally dread modelling to the Altus Innovation Summits in Paris on 16 June, or Munich on 18 June, and watch ARGUS Workbook turn it into a defensible IRR before the session ends.

Register for the date nearest you.

Want to be notified of our new and relevant CRE content, articles and events?