- Home
- Skills
- Finance & Accounting
- commercial real estate analyzer
Works with the AI Agents you already use
commercial real estate analyzer
Manual underwriting of commercial assets is slow and prone to spreadsheet errors.
$10
commercial real estate analyzer
Example session with this skill installed
Analyze this rent roll for 123 Maple St. It has $450k base rent, 5% vacancy, and $120k opex. Use a 6.5% market cap rate from the Q3 CBRE report. Model a 5-year hold with 70% LTV at 6% interest.
- Read your context and instructions
- Compiled the commercial real estate
Analysis for 123 Maple St has been completed using the deterministic underwriting engine. All figures are based on a 6.5% market-evidenced cap rate.
Commercial Real Estate Investment Analysis — 123 Maple St, 2023-10-27
1. Scope, sources and assumptions
- Sources: Rent roll (E1), Operating Statement (E2), CBRE Q3 Market Report (E3).
- Currency: USD.
- Hold Period: 5 Years.
- Key Assumptions: 5.0% General Vacancy (User Supplied), 3.0% Annual Growth (Default).
2. NOI and operating forecast
| Year | Base rent | Downtime | Recoveries | Vacancy | EGI | Opex + fee | NOI | Cash flow before debt |
|---|---|---|---|---|---|---|---|---|
| 1 | 450,000 | 0 | 0 | (22,500) | 427,500 | (120,000) | 307,500 | 307,500 |
| 2 | 463,500 | 0 | 0 | (23,175) | 440,325 | (123,600) | 316,725 | 316,725 |
3. Capitalisation value
- Indicated Value: $4,730,769
- NOI (Forward): $307,500
- Cap Rate: 6.5% (Market Evidence - E3)
- Status: Completed
4. Financing and coverage
- LTV: 70.0%
- Debt Yield: 9.29%
- DSCR (Year 1): 1.54x
- Loan Amount: $3,311,538
| Year | Debt Service | Interest | Principal | Balance | DSCR | Cash-on-Cash |
|---|---|---|---|---|---|---|
| 1 | (198,692) | (198,692) | 0 | 3,311,538 | 1.54 | 7.67% |
5. Returns
- Equity Invested: $1,419,231
- Unlevered IRR: 8.42%
- Levered IRR: 12.15%
- Equity Multiple: 1.78x
7. Warnings and data gaps
- Information gap — organizational validation required: Management fee not specified; used 0.0% default.
8. Interpretation and items for human review
- Year 1 DSCR of 1.54x provides significant cushion above typical 1.25x lender requirements.
- Levered IRR of 12.15% is driven by the 6.5% going-in cap rate and 6.0% interest rate spread.
- Management decision required: Final approval of acquisition price and financing terms.
Next steps
- Confirm the 5% vacancy assumption against current submarket physical vacancy.
- Provide a management fee percentage to refine the NOI.
- Run a scenario shock for a 7.0% exit cap rate to test sensitivity.
Connects securely to your tools. The creator never sees your data.
About this skill
Manual underwriting of commercial assets is slow and prone to spreadsheet errors. This skill provides a deterministic engine to process rent rolls and expense data into precise investment models.
What it does
- Rent roll analysis computes effective gross income and NOI with vacancy and downtime logic.
- Valuation modeling calculates property value using direct capitalization, separating market evidence from hypothetical rates.
- Debt testing evaluates LTV, DSCR, debt yield, and refinancing schedules across a hold period.
- Return metrics generates levered and unlevered IRR, equity multiples, and cash-on-cash returns.
- Scenario sensitivity runs shocks on exit cap rates, rent growth, vacancy, and interest rates.
How it works
- Supply property data including leases, operating expenses, and a capitalization rate.
- The agent builds a
request.jsonfile mapping your inputs to the internal schema. - The
run.pyscript executes the arithmetic with exact decimals to ensure calculation integrity. - The agent generates a structured eight-part report covering the operating forecast, financing, and investment returns.
Frameworks & tools
This skill uses a Python-based deterministic script for all financial calculations. It follows a strict JSON schema for property inputs and generates standardized Markdown reports.
Why this beats prompting it yourself
LLMs struggle with complex financial arithmetic and often hallucinate IRR or DSCR values. This skill offloads all math to a dedicated script, ensuring the agent only interprets verified, deterministic outputs.
Use cases
- Underwrite an office or retail asset from a raw rent roll and expense statement.
- Test the impact of different interest rate environments on debt service coverage.
- Model the levered return for a 5 or 10-year hold including capex and terminal sale.
- Audit a property's value based on market-evidenced cap rates versus hypothetical scenarios.
Known limitations
Does not perform market research for comparables or cap rates. Not valid for certified appraisals, tax filings, or GAAP compliance.
Requires user-supplied market evidence for cap rates. Does not support corporate DCF or portfolio-level modeling. Arithmetic is restricted to the provided Python script scope.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 5 days ago