Acquisitions & due diligence

From T12 to IC approval: underwriting, pipeline deadlines, the footnote that moves the price, the number the model already had, technical and legal due diligence, and a stress test in minutes.

13 videos46:34 total
Start watching
  1. 1
    3:01

    T12 Extraction

    Financial Statement Standardization

  2. 2
    3:08

    What does the tax notice do to your bid? (EN)

    Ellie underwrites a multifamily acquisition and connects a tax reassessment in the data room to NOI, loan coverage and the bid price.

  3. 3
    3:25

    Is your pipeline tracker showing the right deadline? (EN)

    Ellie checks a deal pipeline against the latest broker letters and catches a bid deadline brought forward four weeks.

  4. 4
    3:25

    Ready for the investment committee vote? (EN)

    Ellie tests every approval condition before an IC vote and finds the lender's final terms take the fund over its single-deal limit.

  5. 5
    4:04

    The S$85 million footnote (EN)

    Three deal documents in, every vendor claim rebuilt from source, and the buried break notice caught before the IC meeting instead of in it.

  6. 6
    4:39

    The number the model already had (EN)

    A fund's deal team keys a broker's data-centre case into its Anaplan pipeline model; Ellie ties every input back to the pack and to the line item, finds the three variances the model inherited and writes the verified case back.

  7. 7
    0:00

    The number the model already had — 30 s short (EN)

    Thirty seconds for data-centre deal teams: Ellie checks the seller's numbers against their own documents, flags the power-cost recovery that doesn't hold, and prices it — over a hundred million off the guide price, before the bid.

  8. 8
    3:28

    Which Tokyo office district deserves the capital? (EN)

    Ellie checks the basis of every vacancy figure and re-ranks a fund's Tokyo submarket shortlist before the committee votes.

  9. 9
    5:39

    What should Fund VI pay for a Tokyo building? (EN)

    A broker's brochure prices a Tokyo retail building at ¥13.5bn. Ellie reads the Japanese data room behind it and works out what Fund VI should really pay.

  10. 10
    3:46

    What will this building really cost you? (EN)

    Ellie reads a Tokyo office's technical due diligence, including Japanese reports, and finds the seismic risk the IM understates.

  11. 11
    2:46

    Which document actually wins? (EN)

    Ellie reviews a UK legal pack of planning, title and tenancy documents and resolves the conflicts between them.

  12. 12
    5:08

    A model is a program (EN)

    Trenmoor Partners' underwriting of Verrand House lives in a workbook of 4,800 formulas that one person understands. MicroModeller rebuilds it as a program of standard bricks.

  13. 13
    4:05

    Stress test in minutes (EN)

    An analyst attaches their own multifamily pro forma to a conversation and runs one skill.