Companion files
Practitioner guides to private markets and real estate.
Some of the books come with working files — models, templates, checklists. They are free, they need no account and no email address, and they are listed here.
Four Excel workbooks: the complete Meridian House model, an empty template built to the same architecture, the three timed practice cases, and the 53-point review checklist.
The complete Meridian Industrial Trust analysis — FFO and AFFO bridges, the net asset value build, leverage and dividend safety — an empty template for a REIT of your own, two timed practice cases, and the 54-point analysis checklist.
The complete measurement of one fund from cash flows to reporting line, a PME calculator for a fund of your own with all four methods, the three practice cases, and the 51-point measurement checklist.
The asset business plan with a live rent roll and projection, the hold-refurbish-sell comparison, the accept-or-hold-out arithmetic for a vacancy decision, and the monthly asset dashboard.
The worked deal model with its return decomposition and stress case, the bottom-up NAV build, the 30-point underwriting checklist, and the interview and case preparation.
The distribution waterfall with the catch-up solved in the cell, the quarter-end close simulation cross-checked two ways, a capital call and capital account file, and all ten operational checklists.
The lender's model reproducing both published coverage ratios with base, downside and stress cases, the 33-point underwriting and diligence checklist, and the interview and committee memo preparation.
Four workbooks: the fund waterfall of Chapter 6 with the three readings of a “20% promote” side by side, underwriting and exit sensitivity, debt sizing under all four binding tests, and the budget, variance and close cycle.
Three workbooks: both worked waterfalls of Chapter 12 to the dollar, the value-add and development capital stacks, and the performance measures and LP diligence scorecard.
Three workbooks: a fulcrum finder that names the breaking tranche by arithmetic, the recovery model with fees, DIP priority, form and time, and the sum-of-the-parts valuation against an independent liquidation floor.