Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    multi unit investment pro

    1

    Reconcile rent rolls and operating statements to build auditable multifamily investment pro formas and equity models.

    Free

    1 useSecurity scanned
    multi unit investment pro

    multi unit investment pro

    Example session with this skill installed

    Analyze this 12-unit property. Price: $2.4M. T12 NOI: $140k. Rent roll shows 2 vacancies. Loan: 70% LTV at 6.5%. Model a 5-year hold with a 6% exit cap and $100k capex in year 1.

    • Read your context and instructions
    • Compiled the multi unit investment

    I have reconciled the T12 operating history with the current rent roll and modeled the 5-year investment horizon. The analysis accounts for the $100k Day 1 capital expenditure and the 70% LTV financing structure.

    Multi-Unit Investment Pro Forma

    MetricCurrent (In-Place)Year 1 (Stabilizing)Year 5 (Exit)
    Potential Gross Rent$188,000$194,000$218,000
    Vacancy/Loss (7%)($13,160)($13,580)($15,260)
    Effective Gross Income$174,840$180,420$202,740
    Operating Expenses($34,840)($36,000)($41,500)
    Net Operating Income$140,000$144,420$161,240
    Debt Service (DSCR: 1.28)($109,200)($109,200)($109,200)
    Net Cash Flow$30,800$35,220$52,040

    Investment Summary

    • Purchase Price: $2,400,000
    • Total Basis: $2,500,000 (Incl. $100k Capex)
    • Equity Required: $820,000 (Incl. Closing Costs)
    • Projected Exit Value: $2,687,333 (at 6% Cap)
    • Projected IRR: 14.2%
    • Equity Multiple: 1.68x

    Sensitivity Analysis (Exit Cap vs. Exit NOI)

    Exit Cap / NOI-5% NOIBase NOI+5% NOI
    5.5% Cap15.8% IRR17.1% IRR18.4% IRR
    6.0% Cap12.9% IRR14.2% IRR15.5% IRR
    6.5% Cap10.4% IRR11.6% IRR12.8% IRR

    Next steps
    1.

    Verify Rent Roll: Confirm if the 2 vacancies require specific tenant improvements not covered in the $100k capex.
    2. Review Debt Terms: Validate the 6.5% rate with lenders as the DSCR of 1.28 is near typical 1.25 minimums.
    3. Expense Audit: The 19% expense ratio is low for this asset class; verify if taxes will reassess upon sale.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Investment analysis for multi-unit real estate is often slowed down by fragmented rent rolls, messy operating statements, and complex debt structures. This skill automates the reconciliation of property data to produce auditable pro formas and equity cash flow models.

    What it does

    • Data reconciliation harmonizes unit-level rent rolls with T12 operating statements and collection periods.
    • Performance modeling separates current in-place performance from projected lease-up and renovation scenarios.
    • Capital structuring builds detailed models for debt, capital funding, and specific equity distribution terms.
    • Return analysis calculates periodic cash flows, net exit proceeds, and core metrics like IRR and equity multiple.
    • Risk assessment generates sensitivity matrices and risk registers to highlight material unknowns and assumptions.

    How it works

    1. Provide the property's unit-level rent roll, operating history, capital plan, and financing terms.
    2. The agent reconciles the data and calculates current versus stabilized Net Operating Income (NOI).
    3. The agent models the debt and equity waterfall based on your specific hold period and exit assumptions.
    4. Review the generated pro forma, sensitivity tables, and investment brief for final verification.

    Frameworks & tools

    This skill is framework-agnostic and processes data from property management systems, CRM exports, and standard spreadsheets. It uses financial modeling logic for multifamily real estate including T12 analysis and discounted cash flow.

    Why this beats prompting it yourself

    Generic prompts often fail to distinguish between actual in-place rents and conditional projections, leading to inflated NOI. This skill follows a specific audit workflow that separates confirmed records from modeled assumptions, ensuring the debt and equity terms are applied correctly across the entire hold period.

    Use cases

    • Analyze a 50-unit acquisition target using a T12 statement and current rent roll.
    • Model the impact of a $2M renovation plan on stabilized yield and investor IRR.
    • Compare financing scenarios with different interest rates and amortization schedules.
    • Generate an investor brief for a multi-unit development project.

    Known limitations

    Does not provide professional legal or tax advice. Requires user-supplied market evidence for exit cap rates. Analysis must be reviewed by qualified local professionals for jurisdictional compliance.

    Does not provide legal/tax advice. Requires user-supplied market data for exit caps. User must provide rent roll and T12 records for accurate reconciliation.

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

    1 use

    Times used to date

    Free forever

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 1 month ago

    • Free with an Agensi account

    Permissions

    No special permissions declared or detected

    Listed1 month ago

    What's inside

    Frequently Asked Questions

    This skill automates the reconciliation of messy T12 statements and unit-level rent rolls, ensuring your Net Operating Income (NOI) and equity waterfall calculations are based on audited data rather than generic projections.

    The skill is designed to work with major LLMs that support document processing and can ingest standard exports from property management systems (like Yardi or AppFolio) and Excel spreadsheets.

    Yes, the model allows you to input custom capital improvement budgets and renovation timelines to see how phased rent premiums impact your stabilized yield and investor IRR.

    You receive the core logic framework for multifamily analysis, templates for data input, and a structured workflow that guides the agent through debt and equity distribution modeling.

    Unlike generic prompts, this skill follows a strict financial audit workflow that separates in-place performance from modeled assumptions, preventing the common mistake of inflating NOI by blending current and future rents.

    While the skill calculates metrics like IRR and equity multiples based on your inputs, it requires you to provide market-specific data such as exit cap rates and local tax assumptions.

    New in Trading & Investing