Financial Analyst API

Hotel acquisition underwriting — stabilized or bridge-to-perm value-add. Quarterly ADR x occupancy RevPAR build, other/ancillary revenue, PIP capital, construction loan with capitalized interest, permanent loan sized on min(stabilized-value LTV, purchase-price LTV, DSCR), and exit. Returns unlevered and levered project IRR and MOIC. Reconciled to a SHA-pinned Excel model — see /hotel-acq/reconcili

Ground-up hotel development underwriting. Land + hard costs (S-curve draw) + soft costs + developer fee, funded by a construction loan (LTC) with capitalized interest, refinanced into a permanent loan sized on min(stabilized-value LTV, DSCR) at the CL term. Occupancy begins the month after construction; the hold is measured from construction end. Returns unlevered and levered project IRR and MOIC.

Industrial ground-up development underwriting — construction to hold to exit. S-curve hard cost draws, blended LTC construction loan, capitalized interest, per-tenant NNN lease stabilization, perm loan sizing, TI/LC reserves on rollover. Returns yield on cost, spread to cap, profit on cost, IRR and MOIC.

Industrial acquisition underwriting — NNN and gross lease multi-tenant. Per-tenant lease modeling with contractual rent bumps and rollover vacancy. Blended OpEx based on NNN vs gross SF mix. Returns cap rate, NOI per SF, WALE, DSCR, IRR and MOIC.

Multifamily development underwriting — construction to hold to exit. Models construction draws (S-curve or straight-line), capitalized interest, lease-up ramp, construction-to-perm refi, and hold period returns. Returns development yield on cost, spread to cap rate, profit on cost, IRR and MOIC.

Single-Family Rental (SFR) underwriting — monthly buy-and-hold proforma to unlevered AND levered project returns (IRR via XIRR + equity multiple). Loan-to-cost financing, optional interest-only, appreciation-floored exit. Deterministic, Excel-reconciled, SHA-pinned (pass attest=true).

Multifamily acquisition underwriting — mixed unit mix through a monthly proforma to unlevered AND levered project returns (IRR via XIRR + equity multiple). Stub acquisition month, trailing-NOI exit. Deterministic, Excel-reconciled, SHA-pinned (pass attest=true).