← All skills
Underwriting

Office Rollover and Occupancy Cost Analyst

Model office expirations, renewal probability, downtime, and re-leasing economics.

★ 105 on GitHub0 downloads on LenderSkills

Free · v1.3.0

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.

Screened

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

Works out what office rollover will actually cost.

What it does

  • Analyzes the lease expiration schedule
  • Estimates renewal probability per tenant
  • Assesses occupancy-cost pressure on tenants who may not be able to stay
  • Models downtime, concessions, and re-leasing economics

When to use it

Use this skill when a building's value depends on whether tenants renew, downsize, expand, or leave. It is useful for acquisition underwriting, loan sizing, renewal planning, and hold/sell decisions.

What to have ready

  • Rent roll with expirations, RSF, rent, escalations, options, and tenant status
  • Market rent and concessions by tenant size and quality tier
  • Tenant credit or business context if available
  • Historical renewal, expansion, contraction, and downtime data if available
  • TI, LC, free-rent, and downtime assumptions
  • Tenant revenue, headcount, or occupancy-cost data if available

How to use it

  1. 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.
  2. 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.
  3. 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 Office Rollover and Occupancy Cost Analyst skill — I've got rent roll with expirations, rsf, rent, escalations."

What you get back

A structured report covering rollover summary, tenant renewal probability, renewal vs re-let economics, occupancy-cost pressure, and recommended actions. 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.

Imported to LenderSkills.ai from the open-source cre-agent-skills library.
Author: Avi Hacker, J.D. - https://github.com/ahacker-1/cre-agent-skills
License: Apache-2.0 (see repository LICENSE). Redistributed with attribution; the author's content is unmodified apart from a legal disclaimer appended by LenderSkills at the end of the file.
Imported: 2026-07-26
The knowledge/ and research/ files linked below live in the upstream repository.

Office Rollover and Occupancy Cost Analyst

Analyze office lease expirations, renewal probability, tenant occupancy-cost pressure, downtime, concessions, and re-leasing economics.


When to Use This Skill

Use this skill when a building's value depends on whether tenants renew, downsize, expand, or leave. It is useful for acquisition underwriting, loan sizing, renewal planning, and hold/sell decisions.


What You'll Need to Provide

  • Rent roll with expirations, RSF, rent, escalations, options, and tenant status
  • Market rent and concessions by tenant size and quality tier
  • Tenant credit or business context if available
  • Historical renewal, expansion, contraction, and downtime data if available
  • TI, LC, free-rent, and downtime assumptions
  • Tenant revenue, headcount, or occupancy-cost data if available

Mission

Translate rollover into cash-flow risk by estimating which tenants renew, how much space they retain, what economics are required, and how much downtime and capital are needed if they leave.


Strategy

Step 1: Build Expiration Ladder

Create annual and quarterly expiration schedules:

  • expiring RSF
  • expiring rent
  • percent of leased RSF
  • percent of base rent
  • tenant names
  • option notice dates

Step 2: Classify Tenant Renewal Probability

Score each material tenant:

  • HIGH: mission-critical build-out, stable or growing business, market rent, strong credit, low relocation incentive
  • MEDIUM: normal office user, some space planning uncertainty, rent near market
  • LOW: downsizing industry, above-market rent, weak credit, contraction rights, obvious relocation alternative

Step 3: Test Occupancy-Cost Pressure

Where tenant financial data is available, estimate occupancy cost. If unavailable, use qualitative pressure:

  • headcount vs seats
  • hybrid utilization
  • industry margins
  • rent as above/below market
  • recent layoffs or growth

Reading the full skill counts as a download. The contributor receives your name, company, and email.

Ratings & reviews

★★★★★Rate this skill

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

Archive inspectionPackage unpacked in isolation; contents and paths verified
Executable & binary blockExecutables, binaries, and scripts rejected automatically
Static analysisScanned for exfiltration, credential access, obfuscation, prompt injection
Human reviewA moderator read the skill end to end. Retired on 14 September 2026 — screening decides now.
What each gate checks

Run it in Claude

  1. Copy the install command above
  2. Paste it into Claude, ChatGPT or Cursor
  3. 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.

New to skills? Read the 5-minute guide →

Details

Version1.3.0
AddedJul 26, 2026
UpdatedJul 26, 2026
CategoryUnderwriting
Downloads0
On GitHub★ 105
Tagsoffice, rollover, renewal probability

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.

Office Rollover and Occupancy Cost Analyst · LenderSkills