Rent Roll Analyst
Validate a rent roll — in-place vs market, loss-to-lease, and economic vs physical occupancy.
★ 105 on GitHub0 downloads on LenderSkills
Install it in one line — paste a single command into Claude, ChatGPT or Cursor and it writes the skill into your project.
Free, and about thirty seconds: a work email and a six-digit code.
Downloading shares your name, firm, role, and email with Avi Hacker, J.D.. That introduction is what keeps every skill here free.
What this skill does
Checks whether a rent roll supports the story being told about it.
What it does
- Compares in-place rents to market
- Quantifies the loss-to-lease opportunity
- Separates economic from physical occupancy
- Flags unit-mix imbalance, tenant concentration, and revenue anomalies
When to use it
Use this skill when you have a property's rent roll and need to verify revenue quality before making an acquisition decision. It is most valuable during due diligence when you want to understand how in-place rents compare to the market, identify red flags in the tenant roster, and project stabilized revenue.
What to have ready
- Rent roll data — unit number, tenant name, lease start date, lease end date, monthly rent, security deposit, and unit status (occupied/vacant/NTV/down) for every unit
- Property details — property name, address, submarket, total unit count, and unit mix (studio/1BR/2BR/3BR counts)
- Asking rents (if available) — the seller's quoted rents by unit type
- Market rent data (optional) — if you have already gathered comparable rents, provide them; otherwise this analysis will research them
How to use it
- Download it with the button above. You'll sign in with a work email — that's how the creator knows who is using their skill.
- Copy the install prompt from the "Run it in Claude" box, and paste it into Claude along with the file. Claude installs the skill, fills in your firm's details where the file has
[BRACKETED]placeholders, and runs a quick test with you. - Then just ask in plain English. Claude picks the skill up on its own when a request matches it. Anything it still needs, it asks you for — it won't invent a number.
"Use the Rent Roll Analyst skill — I've got rent roll data unit number, tenant name, lease start date."
What you get back
A structured report covering unit summary, occupancy, rent analysis, concentration risk, anomalies, other income, and revenue projection. You get it as readable analysis plus the underlying data, so it can feed straight into a memo or another skill.
Good to know
- Output quality tracks input quality. A missing figure is flagged as missing — it is never estimated to fill a gap.
- Every draft is a starting point for your own review, not a finished decision.
- Runs anywhere Claude does: the Claude app, Claude Desktop, or Claude Code.
Source & credit
Imported from the open-source cre-agent-skills library by Avi Hacker, J.D. (github.com/ahacker-1/cre-agent-skills), Apache-2.0 license. The author's content is unmodified apart from a legal disclaimer appended at the end of the package. Full credit to the author.
Legal disclaimer
This skill drafts; it does not decide. Its output is not legal, tax, accounting, appraisal, or investment advice, and using it creates no attorney-client, fiduciary, or advisory relationship. Nothing it produces is a commitment to lend or an offer to sell a security. Verify every number, date, citation, and conclusion against the source documents, and have a qualified professional licensed in the relevant jurisdiction review the work before you rely on it or send it to a borrower, investor, counterparty, or regulator. Laws, rates, and market data change. The final work product is yours.
Inside this skill
The actual file you get. Members can read it in full before saving it.
Rent Roll Analyst
Validates a property's rent roll — analyzing in-place rents vs. market, loss-to-lease opportunity, unit mix, economic vs. physical occupancy, tenant concentration risks, and revenue anomalies.
When to Use This Skill
Use this skill when you have a property's rent roll and need to verify revenue quality before making an acquisition decision. It is most valuable during due diligence when you want to understand how in-place rents compare to the market, identify red flags in the tenant roster, and project stabilized revenue.
What You'll Need to Provide
- Rent roll data — unit number, tenant name, lease start date, lease end date, monthly rent, security deposit, and unit status (occupied/vacant/NTV/down) for every unit
- Property details — property name, address, submarket, total unit count, and unit mix (studio/1BR/2BR/3BR counts)
- Asking rents (if available) — the seller's quoted rents by unit type
- Market rent data (optional) — if you have already gathered comparable rents, provide them; otherwise this analysis will research them
Mission
Validate the property rent roll. Analyze in-place rents vs market, identify loss-to-lease opportunity, verify unit mix, calculate economic vs physical occupancy, identify tenant concentration risks, and flag anomalies (same-day leases, below-market rents, related-party tenants).
Strategy
Step 1: Parse Rent Roll from Deal Inputs
- Use the property details provided to extract the address, unit count, unit mix, and asking rents
- Read rent roll data (CSV, JSON, or structured text)
- Build internal data model: array of unit records with all fields
- Validate completeness: every unit accounted for, no missing fields
Step 2: Research Market Rents via Web Search
- Search for market rents in the submarket by unit type
Reading the full skill counts as a download. The contributor receives your name, company, and email.
Ratings & reviews
No written reviews yet. If you run this on a live file, say how it went. The next lender reading this page is deciding whether to trust it.
Examination record
Run it in Claude
- Copy the install command above
- Paste it into Claude, ChatGPT or Cursor
- It writes the skill in, fills in your firm’s details, and test-runs it with you
Prefer the file? The prompt above is for a package you already downloaded.
Details
More from Avi Hacker, J.D.
Imported from their public repository with attribution. Their other skills, and where to find the original, are on their contributor page.