Office TI / LC Underwriting Model Builder
Build an office model where downtime, TI, LC, and free rent are explicit, not buried.
★ 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
Models office cash flow with the leasing capital shown rather than assumed away.
What it does
- Reflects downtime between leases explicitly
- Carries tenant improvements and leasing commissions as real costs
- Models free rent and renewal cost separately
- Reports net effective rent, not just face rent
When to use it
Use this skill when office underwriting depends on rollover, vacancy lease-up, second-generation leasing, or repositioning capital. It is the right model when NOI alone overstates cash flow because leasing costs are material.
What to have ready
- Rent roll with tenant expirations and current rents
- Vacancy schedule and asking rents
- Market rent, TI, LC, free rent, and downtime assumptions
- Lease terms by tenant size and quality tier
- Purchase price, hold period, exit cap, and debt assumptions
- Base-building capital plan if available
- …and a few more items the skill will ask for as it goes
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 Office TI / LC Underwriting Model Builder skill — I've got rent roll with tenant expirations and current rents."
What you get back
A structured report covering core assumptions, in-place vs stabilized, rollover / lease-up schedule, returns, and sensitivities. 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.
Office TI / LC Underwriting Model Builder
Build an office cash-flow model that explicitly reflects downtime, tenant improvements, leasing commissions, free rent, renewal costs, and net effective rent.
When to Use This Skill
Use this skill when office underwriting depends on rollover, vacancy lease-up, second-generation leasing, or repositioning capital. It is the right model when NOI alone overstates cash flow because leasing costs are material.
What You'll Need to Provide
- Rent roll with tenant expirations and current rents
- Vacancy schedule and asking rents
- Market rent, TI, LC, free rent, and downtime assumptions
- Lease terms by tenant size and quality tier
- Purchase price, hold period, exit cap, and debt assumptions
- Base-building capital plan if available
- Sponsor strategy: stabilize, reposition, sell, refi, or harvest cash flow
Mission
Produce a defensible office underwriting model that separates GAAP/stabilized NOI from real cash flow after leasing costs and capital requirements.
Strategy
Step 1: Build In-Place Income
Calculate:
- current base rent
- reimbursements
- parking/storage/other income
- signed-not-commenced rent
- abatements
- vacant suite market rent
- recoverable vs non-recoverable expenses
Step 2: Build Rollover Schedule
For each tenant or vacant suite:
- expiration date
- probability of renewal
- downtime if vacated
- market rent
- free rent
- TI
- LC
- renewal TI/LC if retained
- new lease term
Step 3: Model Leasing Costs Below NOI
Calculate:
TI Dollars = RSF x TI PSF LC Dollars = Gross Lease Value x Commission Rate Free Rent Dollars = Monthly Rent x Free Rent Months Net Leasing Cost = TI + LC + Free Rent + Landlord Work
Show timing by year. Do not bury leasing costs in operating expenses.
Step 4: Calculate Net Effective Rent
For each new or renewed lease:
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.