Underwrite a short-term rental purchase with an AI skill that operates an Excel acquisition model
Adventures in CRE built an AI Skill for its Short-Term Rental Acquisition Model that teaches Claude, ChatGPT, or Gemini every input cell; the Skill asks whether the user is an STR buyer, an LP, or a lender and leads with the matching metrics, such as minimum DSCR for lenders because seasonal revenue can hide weak months.
At a glance
- Tools used
- Claude SkillsExcelA.CRE STR Acquisition Model
- Category
- Investing & underwriting
- Audience
- investor, STR host
- Difficulty
- No-code setup
- Source
- An AI Skill for the A.CRE Short-Term Rental Acquisition Model
Adventures in CRE · Blog · Jun 15, 2026 - First step
- Download the STR acquisition model and fill in one property you already own to calibrate the inputs.
Compliance note: Confirm the city or county permits short-term rentals at the address and budget for local registration and occupancy taxes.
Suggested prompt
Written by this directory, inspired by the source. Replace the [bracketed] parts.
I am evaluating a short-term rental purchase as a [buyer / LP / lender]. Property: [address], price [$], loan terms [rate, LTV, amortization]. Revenue inputs I verified: monthly ADR and occupancy for each of the 12 months [paste, with data source]. Expenses: cleaning, platform fees, management, utilities, insurance, property tax, supplies, maintenance reserve, furnishing budget. Compute monthly NOI, minimum and average DSCR, cash-on-cash, and levered IRR over a [5]-year hold. Show the 3 weakest months and a downside case with occupancy 15% lower. Do not supply any revenue or expense figure I did not give you; list the missing inputs instead.