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.

On fifthdimensionai.com