Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Real Estate ROI Pro Forma Builder

    1

    Ingests property purchase price, rehab costs, and local rent data to generate a detailed 5-year cash-on-cash return and cap rate projection for property investors.

    $5

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Real Estate ROI Pro Forma Builder

    Real Estate ROI Pro Forma Builder

    Example session with this skill installed

    Analyze this deal: Purchase price $250,000, Rehab $40,000, Rent $2,800/mo. I'm putting 20% down at 6.5% interest on a 30-year term. Generate the pro forma.

    • Read your context and instructions
    • Compiled the real estate roi

    I have processed the investment data for the $250,000 acquisition. The model assumes a 5% vacancy rate and a 35% operating expense ratio based on standard industry baselines.

    🏢 Deal Executive Summary

    This is a value-add residential investment opportunity requiring a $40,000 renovation. With a projected monthly rent of $2,800, the property shows strong gross yield potential, though the financing costs significantly impact the net cash flow in the early years.

    💰 Initial Capital Requirements

    • Purchase Price: $250,000
    • Rehab Costs: $40,000
    • Down Payment / Cash to Close: $50,000 (20%)
    • Total Initial Cash Invested: $90,000

    📊 Year 1 Performance Metrics

    • Gross Potential Rent: $33,600
    • Estimated Operating Expenses & Vacancy: $13,440 (40% Total Ratio)
    • Net Operating Income (NOI): $20,160
    • Annual Debt Service: $15,168
    • Year 1 Cap Rate: 6.95%
    • Year 1 Cash-on-Cash Return: 5.55%

    📈 5-Year Financial Pro Forma

    MetricYear 1Year 2Year 3Year 4Year 5
    Gross Income$33,600$34,608$35,646$36,716$37,817
    Operating Exp.$13,440$13,843$14,258$14,686$15,127
    NOI$20,160$20,765$21,388$22,030$22,690
    Debt Service$15,168$15,168$15,168$15,168$15,168
    Net Cash Flow$4,992$5,597$6,220$6,862$7,522
    Cum. Cash-on-Cash5.55%11.77%18.68%26.30%34.66%

    Assumptions applied: 3% annual rent growth, 3% expense inflation, 5% vacancy, 35% OpEx ratio, 3% annual appreciation.

    ⚖️ Analyst Verdict

    This deal meets the 1% rule ($2,800 rent on $250k purchase), indicating strong top-line revenue. The 6.95% Cap Rate is healthy for a residential asset, but the 5.55% Year 1 Cash-on-Cash return is modest due to the current interest rate environment. This property is a solid long-term hold for appreciation and principal paydown rather than an immediate high-cash-flow play.

    Next steps

    • Verify local property tax rates to refine the Operating Expense ratio.
    • Obtain a formal contractor quote for the $40,000 rehab to confirm the initial capital requirement.
    • Review recent rental comps to justify the $2,800/mo projection.

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

    About this skill

    Manual real estate deal analysis is slow and prone to spreadsheet errors. This skill automates the creation of professional investment models, turning raw property data into detailed financial projections. It ensures every deal is evaluated against the same rigorous math, from Cap Rate to multi-year cash flow.

    What it does

    • Automated Pro Formas generates a full 5-year financial projection including income, expenses, and net cash flow.
    • KPI Calculation computes Cap Rate, Cash-on-Cash Return, and Net Operating Income with precision.
    • Capital Modeling breaks down initial cash requirements, rehab costs, and down payments.
    • Gap Filling applies industry-standard assumptions for vacancy and maintenance when data is missing.
    • Investment Assessment provides an objective verdict based on established investor benchmarks.

    How it works

    1. Input Data Provide the purchase price, rehab budget, and expected monthly rental income.
    2. Define Terms Specify financing details like down payment percentage and interest rates, or indicate a cash purchase.
    3. Review Assumptions The skill applies standard expense ratios and appreciation rates which you can override.
    4. Analyze Output Receive a structured executive summary, performance tables, and a professional analyst verdict.

    Frameworks & tools

    This skill uses standardized real estate accounting principles. It is designed for use in any environment that supports Markdown rendering, such as Claude, ChatGPT, or specialized real estate CRM tools.

    Why this beats prompting it yourself

    Generic prompts often miss critical hidden costs like vacancy reserves or capital expenditures. This skill forces a standardized financial structure that mirrors professional private equity models, ensuring you never overlook the "1% rule" or debt service coverage.

    Use cases

    • Quick Triage determining if a listing is worth a site visit within seconds of getting the numbers.
    • Lender Packages creating clean financial summaries to present to private money or hard money lenders.
    • Portfolio Planning modeling how a property might perform over a 5-year hold period before selling.
    • Wholesaling generating professional deal sheets to send to a cash buyer list.

    Known limitations

    Does not provide legal or certified financial advice. Calculations for specific local taxes or HOA fees must be provided as manual inputs for maximum accuracy.

    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.

    Does not provide certified financial advice. Accuracy depends on user-provided financing terms. Local tax variations require manual input.

    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 1 month ago

    Permissions

    No special permissions declared or detected

    Listed1 month ago
    Updated1 month ago

    What's inside

    Frequently Asked Questions

    Simply provide the purchase price, rental income, and financing terms; the skill automatically applies industry-standard vacancy and maintenance ratios to fill in any gaps for a complete 5-year outlook.

    Yes, while it provides smart defaults, you can manually override any assumption including appreciation rates, property management fees, or specific HOA costs to match your local market.

    This skill is designed for any platform that supports Markdown rendering, including ChatGPT (GPT-4), Claude, and professional real estate CRMs with AI integration.

    You receive the full skill logic designed for real estate modeling and a quick-start guide on how to input property data for the most accurate 5-year projections.

    Unlike generic prompts, this skill uses a structured financial framework that accounts for debt service coverage and capital expenditure reserves, ensuring your analysis mirrors professional private equity models.

    Buyers receive lifetime access to this version of the skill, and any critical logic updates or refinements to the financial modeling structure are included as part of the purchase.

    New in Finance & Accounting