Use cases
Finished models, memos and decks for private equity, credit, real estate and public markets, each one traced to its source.
Deals and diligence
- Deal SourcingScreens for the next target, checked against the filings.
- AI Due DiligenceData room review, QoE retest and fund DDQ, cited to source.
- Financial Due DiligenceA seller's quality of earnings, retested against the data room.
- Data Room ExplorationSearch and analyze an entire data room.
- CIM ReviewA banker's CIM tied out, rebuilt and turned into an IOI.
- Adjusted EBITDAEach add-back in a seller's bridge, tested.
- Net Working Capital PegThe NWC definition, the peg and the closing true-up.
- Add-On AcquisitionSynergies, funding and returns on a bolt-on.
- Investment MemoAn investment committee memo, every figure cited.
- Risk AssessmentStructured, cited risk analyses.
Models and valuation
- AI Financial ModelingThree-statement, DCF and LBO models in live Excel.
- Three-Statement ModelIncome statement, balance sheet and cash flow built from the filings.
- LBO ModelPurchase price, financing and returns on a real take-private.
- DCF ModelA DCF from the 10-Ks that tests management's projections.
- Valuation ModelingDCF, comps and precedents on one football field.
- Comparable Company AnalysisTrading and transaction comps, cited to filings.
- Sensitivity AnalysisData tables, tornado charts, and scenarios.
- Debt ScheduleEvery loan term rolled forward, with leverage and covenant tests.
- PE ReturnsIRR, MOIC and carry, from exit value to the LP's net.
- SOFR Forward CurveA floating-rate loan repriced on the market's SOFR path, with caps and swaps.
- Cost of DebtA company's cost of debt from its bonds, the Treasury curve, forward SOFR and its filings.
- Customer Cohort AnalysisCohort tables, retention curves, and waterfalls.
Portfolio and fund reporting
Real estate
- AI for Commercial Real EstateRent roll, pro forma and diligence on one acquisition.
- Real Estate Pro FormaNOI and cap rate underwritten from the data room.
- Real Estate Due DiligenceThe diligence checklist worked through every report.
- Real Estate Market AnalysisTrade area demographics by radius and the submarket, tested against the model.
- Multifamily Market Screening50 U.S. metros ranked on rents, vacancy and supply, then tested against CMBS loans and REIT cost.
- Real Estate Deal ScreenerOne sheet, ten inputs, four flags and a verdict, tested on a real self-storage property.
- Deal Pipeline Screen31 Midwest properties with maturing CMBS loans, gated and ranked on one sheet of shared loan terms.
- Core Multifamily UnderwritingWhat to pay for a 258-unit 2018 apartment property: levered IRR at five prices around appraised value.
- Value-Add Multifamily ScreenA one-sheet screen of a real 157-unit CMBS property: yield on cost, DSCR, IRR and four warning flags.
- Office Rollover ScreenA one-sheet rollover screen of a Scottsdale office building, built from its CMBS filing.
- Shopping Center ScreenA one-sheet screen of a Home Depot-anchored center: anchor and shop rent split, loan and four flags.
- Acquisition Pro FormaA 10-year monthly model of a 281-unit Los Angeles tower where the loan costs more than the cap rate.
- Small Multifamily Pro FormaA 21-unit Brooklyn walk-up sized under Freddie Mac, bank and DSCR loans, with a unit rent roll.
- Bridge-to-Perm ModelLease-up, bridge loan, interest reserve and refinance test on a Houston apartment property from CMBS filings.
- Value-Add Pro FormaA 320-unit renovation plan from CMBS filings: monthly schedule, debt, flags and a 15.6% IRR.
- Development Pro FormaA 300-unit DC apartment build: budget, draws, two loans and an 11 bp spread over the cap rate.
- Industrial Warehouse AcquisitionA triple-net warehouse underwritten from its CMBS filing: WALT, rollover costs, loan sizing and IRR.
- Retail Value-Add Pro FormaA 60-month model of re-anchoring a strip center, leasing it up, adding two pads and refinancing.
- JV Equity WaterfallThree LP classes, a GP catch-up, three IRR hurdles and a clawback test on one hotel's filed cash flows.
- Affordable Housing AcquisitionA 264-unit CMBS apartment property underwritten with AMI rent ceilings, voucher income and a stress-sized loan.
- Office Lease-by-Lease ModelA 120-month office cash flow from a CMBS filing, with expense stops that reset and a largest-tenant stress case.
- LIHTC Pro FormaA 100-unit tax credit building in Miami-Dade: 9% and 4% cases, basis, equity and the funding gap.
- Core Office Pro FormaA single-tenant office building underwritten from CMBS filings, with the exit cap rate an 8% target needs.
- Grocery-Anchored Retail ModelA Kroger-anchored center from a CMBS filing: percentage rent, recoveries and an anchor-goes-dark case.
- Adaptive Reuse Pro FormaOffice-to-apartment conversion of a Hartford office complex: cost against finished value, two exits.
- Construction-to-Perm LoanTest whether the permanent loan repays the construction loan, and size the cash needed if not.
- Construction Budget TrackerBudget, committed, spent, change orders and contingency for a 120-home build-to-rent project at month 12.
- Rent Roll AnalysisEvery rent roll line tied to its lease and estoppel.
Private credit
- Direct Lending Underwriting ModelXponential's HPS term loan from filings: addback haircuts, three cases, covenant step-downs and all-in yield.
- Private Credit MemoAn IC credit memo on a BDC's Petco first lien: lender EBITDA, documents, recovery and risk rating.
- Credit Agreement AnalysisStandardAero's credit agreement: uncapped addbacks, 7.58x of debt room and two missing LME blockers.
- Covenant Compliance CalculationWestrock Coffee's new credit agreement tested over eight past quarters and four ahead, with a risk rating.
- Recovery AnalysisiHeartMedia's creditor waterfall from its 10-Q: first lien recovers 59.3% and is the fulcrum class.
- Borrowing Base CalculationRyerson's ABL borrowing base from its 10-Q and credit agreement, with NOLV backed out of availability.
- Recurring Revenue Loan ModelEvolv's MidCap ARR loan: the ARR covenant, estimated retention, runway and the EBITDA test added June 2027.
- BDC Portfolio AnalysisBain Capital Specialty Finance's 10-Q schedule as a loan tape: marks, PIK, non-accruals, dividend coverage.
- Private Credit ValuationCaris Life Sciences' first-lien loan valued by yield method, calibrated to issue price, vs two Blue Owl marks.
- Asset-Backed Finance ModelCollateral and structure model of an Exeter auto ABS trust: ABS-EE strats, loss curves, waterfall, breakevens.
- Distressed Debt AnalysisSinclair's 2025 uptier rebuilt from its 8-Ks: recoveries before and after, fulcrum and holdout sensitivity.
- Mezzanine Financing ModelTeam, Inc.'s all-PIK second lien: PIK accretion, warrant value, IRR at each call date and recovery.
Public markets and research
- Earnings Call AnalysisEvery call since the IPO, guidance scored against results.
- Financial Statement AnalysisThree-statement data, ratios, and trends.
- Industry ResearchThe competitive landscape from rivals' filings and calls.
- Market SizingTAM, SAM and SOM built bottom-up and checked top-down.
- Regulatory Filing ReviewDisclosures and changes from SEC filings.
- Twitter (X) ResearchEvery take on X, ranked and checked against the filing.
- X Video SummaryThe video behind an X post, transcribed, summarized and emailed.