01 / Investment Management·Group 1.3 Underwriting & Due Diligence
1.3.01FINANCIAL MODELLING & CASH FLOW PROJECTION
Business record: Direct asset
Build the cash-flow model used to price an acquisition, typically in Argus or Excel. Populate rent, rental-value and cost assumptions from tenancy schedules, valuations and data-room evidence, then update them as diligence progresses. The model links those inputs to the bid: an incorrect lease term or rent figure can change the price the team is prepared to pay.
Where it goes wrong
- Rent roll figures transcribed incorrectly
- Rental value and growth assumptions lacking supporting evidence
- Lease breaks or options missing from cash flows
- Changed inputs failing to update other tabs
- Models built from outdated templates
The full process card
- 3 industry benchmarks, with their sources
- How the industry measures it
- The cost of getting it wrong
- What excellent looks like
- Where automation pays off
- The automation ladder: where to start, scale and lead
- Who does the work: the roles responsible, accountable and consulted
- How the process changes in 6 country editions
Free with registration. Your work email signs you in, and registers you if you are new.