Artificial intelligence is rapidly transforming the way professionals approach real estate financial modelling. But while AI tools like ChatGPT and Claude are powerful, they are far from perfect—and understanding their limitations is just as important as leveraging their strengths.
In a recent webinar hosted by Smart Cookie Jobs, Maria Vidne, Founder and CEO of Cambridge Finance, shared practical insights into how AI fits into real estate financial modelling, where it adds value, and where human expertise remains essential.
The Role of AI in Financial Modelling
AI can significantly speed up parts of the modelling process. It can:
- Generate structured cash flow models
- Write and troubleshoot Excel formulas
- Build sensitivity tables
- Format outputs and presentations
With the right prompt, AI can quickly create a high-level financial model, saving hours of manual work. It can also act as a helpful assistant when tackling specific modelling challenges or unfamiliar deal structures.
However, speed does not equal accuracy.
Where AI Falls Short
AI lacks true understanding of market context and deal-specific nuances. It cannot:
- Reliably source or validate real-time market data
- Judge whether assumptions (e.g., rent growth, yields) are realistic
- Apply deal-specific logic without detailed guidance
- Replace professional judgement in investment decisions
In many cases, AI-generated outputs may look polished and convincing—but contain fundamental errors.
For example, AI might:
- Use incorrect yield calculations
- Misapply valuation methods
- Double count costs or omit key expenses
- Confuse gross and net figures
These errors can compound quickly, especially if the model is built in one go without proper checks.
The Biggest Risk: Over-Reliance
One of the most common pitfalls is trusting AI outputs without fully understanding them.
A model that “looks right” is not necessarily correct. Without a strong grasp of financial modelling fundamentals, it becomes difficult to spot errors—leading to flawed analysis and poor decision-making.
As Maria emphasised, AI should be treated as:
A highly capable assistant—not a decision maker.
How to Use AI Effectively
To get real value from AI in financial modelling, professionals should:
1. Start with Fundamentals
Understand how financial models work before relying on AI. The model should reflect your thinking—not replace it.
2. Use AI for Specific Tasks
AI works best when applied to:
- Formula support
- Structuring templates
- Generating presentation materials
- Brainstorming modelling approaches
3. Build and Control Your Own Models
Having a reliable, self-built model is often more efficient than auditing a fully AI-generated one.
4. Audit Everything
Always check:
- Assumptions
- Formula logic
- Data sources
- Sensitivity analysis
If you cannot explain how a number is derived, you should not rely on it.
5. Be Precise with Prompts
The quality of AI output depends heavily on the input. Clear, detailed instructions improve results—but even then, validation is essential.
A Real-World Example
During the session, an example highlighted how AI generated a detailed property comparison dataset for the Frankfurt office market—complete with pricing, yields, and tenant data.
While impressive at first glance, the data could not be verified against actual sources.
This illustrates a key point:
AI can produce highly convincing outputs that are partially or entirely incorrect.
AI as an Efficiency Tool—Not a Replacement
When used correctly, AI can enhance productivity, streamline workflows, and support analysis. But it cannot replace domain knowledge, market awareness, or critical thinking.
Professionals who combine strong fundamentals with smart AI usage will gain a clear advantage.
Those who rely on AI without understanding risk making costly mistakes.
Final Thoughts
AI is here to stay—and it will continue to evolve. But in real estate financial modelling, the fundamentals remain unchanged.
- Understand the deal
- Know your assumptions
- Control your model
- Validate your outputs
Use AI to work faster—but rely on your expertise to work correctly.
