Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    commercial real estate analyzer

    1

    Manual underwriting of commercial assets is slow and prone to spreadsheet errors.

    $10

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    commercial real estate analyzer

    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

    YearBase rentDowntimeRecoveriesVacancyEGIOpex + feeNOICash flow before debt
    1450,00000(22,500)427,500(120,000)307,500307,500
    2463,50000(23,175)440,325(123,600)316,725316,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
    YearDebt ServiceInterestPrincipalBalanceDSCRCash-on-Cash
    1(198,692)(198,692)03,311,5381.547.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

    1. Confirm the 5% vacancy assumption against current submarket physical vacancy.
    2. Provide a management fee percentage to refine the NOI.
    3. 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

    1. Supply property data including leases, operating expenses, and a capitalization rate.
    2. The agent builds a request.json file mapping your inputs to the internal schema.
    3. The run.py script executes the arithmetic with exact decimals to ensure calculation integrity.
    4. 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.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.

    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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    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

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Environment Variables
    Listed5 days ago

    What's inside

    Frequently Asked Questions

    Standard LLMs often make errors in multi-step financial math; this skill uses a deterministic Python engine to ensure every calculation—from DSCR to IRR—is mathematically perfect and audit-ready.

    The skill requires a structured input of rent rolls (leases), operating expenses, and financing terms, which it then maps to a specialized JSON schema for processing.

    No, this tool is an analytical engine; you must provide the cap rates and market data, which the skill then uses to model valuations and sensitivity scenarios.

    You receive the core Python execution script, the JSON input schema, and the agent instructions necessary to generate the standardized eight-part investment report.

    The skill is designed for any AI agent capable of executing Python code in a sandboxed environment, ensuring the 'run.py' script can process your property data securely.

    Yes, the 'Scenario Sensitivity' feature allows you to shock variables like exit cap rates and interest rates to see how they impact your levered IRR and cash-on-cash returns.

    New in Finance & Accounting