{"uid":"cap_VddNzpC1bjNYWr57vg8pL","slug":"financial-analyst-api-hotel-acquisition-underwriting-7c1a2b77","name":"Financial Analyst API – Hotel Acquisition Underwriting","description":"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/reconciliation.","url":"https://financial-analyst.ai/hotel-acq/underwrite?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object"},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"2","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$2/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"2","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"2","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_HJeSEKSqToMTimAmE6CJH","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"2","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Underwrites hotel acquisitions (stabilized or bridge-to-perm value-add) with full RevPAR build, ancillary revenue, PIP capital, construction and permanent loan sizing, and exit analysis returning unlevered/levered IRR and MOIC.","exampleAgentPrompt":"Underwrite this hotel acquisition for me — we're buying a 150-key select-service hotel for $18M, targeting a value-add bridge-to-perm strategy. Quarterly ADR starts at $120 and ramps to $145 by year 2, occupancy builds from 62% to 76%, ancillary revenue is $8 per occupied room, PIP budget is $3.5M, construction loan is 70% LTV at 7.5% interest with an 18-month term, and permanent loan sizing should use a 1.25x DSCR floor and 65% LTV cap. Exit at a 7.5% cap rate in year 5 — give me unlevered and levered IRR and MOIC.","exampleUseCases":[{"title":"Value-add hotel bridge-to-perm deal","prompt":"Model a bridge-to-perm hotel deal for us — 200-key full-service property, purchase price $30M, PIP of $5M, construction loan at 68% LTV and 8% rate for 24 months with capitalized interest. ADR ramps from $150 to $185 over four quarters, occupancy goes from 58% to 74%, ancillary revenue $12 per occupied room. Size the perm loan at min of 1.25x DSCR, 65% stabilized-value LTV, and 65% purchase-price LTV. Exit at a 7.0% cap rate in year 5 and show me levered and unlevered IRR and MOIC."},{"title":"Stabilized hotel acquisition returns","prompt":"Run an underwriting on a stabilized hotel acquisition — 90-key limited-service property for $12M, no PIP needed, occupancy already at 72% with ADR of $105 and minimal ancillary revenue of $4 per occupied room. Permanent loan sized at 65% LTV and 1.30x DSCR minimum, 5% fixed rate, 25-year amortization. We plan to exit in year 7 at a 7.8% cap rate. What are the unlevered and levered project IRR and MOIC?"},{"title":"PIP-heavy value-add underwriting","prompt":"We're acquiring a 120-key extended-stay hotel for $15M that needs a heavy PIP — $4.2M in capital, funded through a construction loan at 70% LTV and 7.75% interest rate for 20 months. ADR starts at $95 in stabilization and ramps quarterly to $130 by year 3, occupancy builds from 55% to 78%, ancillary revenue $6 per occupied room. Perm loan constraints are 1.25x DSCR and 65% LTV. Exit at year 6 at a 7.25% cap rate — run the full unlevered and levered IRR and MOIC."}],"resultDescription":"Returns unlevered and levered project IRR and MOIC, a quarterly RevPAR and revenue build (ADR × occupancy), ancillary revenue contribution, PIP capital schedule, construction loan draw with capitalized interest, permanent loan sizing based on the binding constraint among stabilized-value LTV, purchase-price LTV, and DSCR, and exit valuation — reconciled to a SHA-pinned Excel model.","failureModes":["Missing or invalid quarterly ADR/occupancy inputs causing revenue build failure","Infeasible debt constraints (DSCR or LTV) where no permanent loan can be sized — returns error or zero debt","Construction loan term shorter than stabilization period causing negative carried interest","Purchase price or PIP inputs out of plausible range triggering validation error","Malformed JSON input body returning 400 bad request","Payment failure or insufficient USDC balance returning 402 payment required"],"whenToPreferThis":"Choose this endpoint specifically for hotel and hospitality property acquisitions, particularly when the deal involves a value-add or bridge-to-perm structure with PIP capital, a construction loan with capitalized interest, and permanent loan sizing governed by multiple constraints (LTV and DSCR). Prefer it over generic DCF or debt-sizing endpoints when you need the full integrated hotel underwriting stack — RevPAR build, ancillary revenue, capital schedule, loan sizing, and levered/unlevered returns — in a single call reconciled to a reference Excel model.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-10T18:41:34.078Z","isFirstParty":false,"canonicalSlug":"financial-analyst-api-hotel-acquisition-underwriting-7c1a2b77"}