- Home
- Skills
- Finance & Accounting
- Real Estate Rental Investment Analyzer
More screenshots
Works with the AI tools you already use
Real Estate Rental Investment Analyzer
Professional long-term rental property analyzer for cash flow, cap rate, and multi-year wealth projections.
$11
Real Estate Rental Investment Analyzer
Example session with this skill installed
Analyze this rental: $450,000 purchase price, 20% down, 6.8% interest on a 30-year term. Monthly rent is $3,800. Property tax is $500/mo and insurance is $150/mo. Assume a 10-year hold.
- Read your context and instructions
- Compiled the real estate rental
- Generated the document
This property shows negative year-one cash flow of $94.28 per month, indicating that the investment does not currently meet its cash-flow target despite potential long-term equity growth. Over a 10-year holding period, the investment is projected to generate a total return of $248,034, primarily driven by property appreciation and equity buildup.
Investment Analysis Report
Year-One Performance
Total Investment: $99,000 (Down Payment: $90,000 + Est. Closing/Rehab: $9,000)
Monthly Gross Income: $3,534.00 (Adjusted for 7% vacancy)
Monthly Mortgage (P&I): $2,347.12
Monthly Operating Expenses: $1,281.16 (Tax, Insurance, 8% Management, 5% Maintenance, 5% CapEx)
Net Monthly Cash Flow: -$94.28
Annual Cash Flow: -$1,131.36
Cap Rate: 5.34%
Cash-on-Cash Return: -1.14%
The property produces negative cash flow during the first year. While the projected long-term return may be attractive, the current operating performance indicates that the investment relies substantially on appreciation and equity buildup rather than immediate cash generation.
Quick Screening
1% Rule: 0.84% — Below the 1.0% threshold
50% Rule: Expenses represent approximately 33.7% of gross rent — Passes the 50% screening threshold
Gross Rent Multiplier (GRM): 9.87
The screening metrics present a mixed picture. The property does not meet the traditional 1% rule, while its operating expense ratio remains below the commonly used 50% screening threshold.
Multi-Year Projection
Assuming 3% annual property appreciation and the stated operating assumptions:
Year Property Value Loan Balance Equity Cumulative Cash Flow
1 $463,500 $355,592 $107,908 -$1,131
5 $521,673 $335,015 $186,658 -$4,920
10 $604,785 $300,562 $304,223 -$7,854
The projection indicates that equity increases substantially over the holding period, primarily through property appreciation and mortgage principal reduction. However, cumulative operating cash flow remains negative under the stated assumptions.
Exit Summary — 10-Year Hold
Final Property Value: $604,785
Estimated Selling Costs: 8%
Loan Balance at Exit: $300,562
Net Sale Proceeds: Approximately $255,888
Cumulative Cash Flow: -$7,854
Total Return: Approximately $248,034
Approx. Annualized Return: 15.65%
The projected return is primarily driven by appreciation and accumulated equity rather than positive operating cash flow. Investors should therefore evaluate whether the expected appreciation adequately compensates for the property's negative cash-flow profile and associated risks.
Key Investment Takeaways
Cash Flow: Negative during the first year at approximately -$94.28 per month.
1% Rule: Does not pass the traditional 1% screening threshold.
Operating Expense Ratio: Passes the stated 50% screening test.
Long-Term Equity: Projected to increase significantly over the 10-year holding period.
Primary Return Driver: Property appreciation and equity buildup rather than current cash flow.
Key Risk: The investment remains dependent on assumptions about appreciation, rent growth, vacancy, expenses, and future selling costs.
Next Steps
Verify local property tax assessments, particularly if taxes may be reassessed following a purchase.
Confirm whether the assumed $3,800 monthly rent reflects current market rent and determine whether additional rent growth is realistic.
Obtain a professional property inspection and refine maintenance and CapEx assumptions.
Test the investment under more conservative appreciation, rent-growth, vacancy, and expense scenarios.
Evaluate whether the negative cash flow is acceptable relative to the expected long-term equity growth.
This analysis is an educational estimate based on the information provided and standard real estate investment analysis methodology. It is not financial, investment, tax, or legal advice. Long-term projections depend on assumptions about rent growth, appreciation, vacancy, operating expenses, financing, and selling costs, which may not hold true. Consult a qualified financial advisor, accountant, tax professional, or real estate professional before making an investment decision.
real-estate-rental-investment-analyzer.pdf
PDF · document
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
What you get
About this skill
The problem Evaluating rental properties is time-consuming and prone to error when done manually. Investors often struggle to account for the long-term impact of compounding appreciation, loan paydown, and expense inflation alongside immediate cash flow.
What it does Calculates core year-one metrics including Cap Rate, Cash-on-Cash Return, and debt service coverage.
Applies standard screening heuristics like the 1% Rule, 50% Rule, and Gross Rent Multiplier.
Generates multi-year wealth projections for 5, 10, or 30-year holding periods.
Produces a detailed exit summary showing net sale proceeds, total return, and approximate annualized return.
Why this beats prompting it yourself General-purpose LLMs often hallucinate financial math or omit critical long-term factors like loan amortization schedules and capex reserves. This skill enforces rigorous methodology, ensures all assumptions are explicitly labeled, and applies professional range discipline to long-term forecasts.
Use cases Screening potential buy-and-hold rental acquisitions during the due diligence phase.
Running "what-if" scenarios on different rent growth, vacancy, or interest rate assumptions.
Comparing the total wealth impact of a 10-year versus a 30-year investment horizon.
Auditing the long-term viability of a property based on realistic maintenance and management overhead.
Known limitations Does not support short-term rental (Airbnb) specialized metrics. Projections over 15 years are illustrative and carry high uncertainty. Does not provide tax advice or specific market comps.
How to install
Works the same in every agent - Claude, Cursor, Codex, Copilot and 20+ more.
- 1
Download the ZIP
Free skills download straight away. Paid skills unlock right after purchase.
- 2
Unzip into your skills folder
Every agent reads skills from one folder on your machine. Drop the unzipped folder in there.
- 3
Ask your agent to use it
Restart the agent if it was already running. It picks the skill up automatically - no config needed.
Skills folder by agent
Click the path to copy it. Create the folder if it does not exist yet.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
Fresh listing
Recently published to Agensi
30-day refund
Not a fit? Get your money back
Trust & safety
Security scanned
Verified clean 7 days ago
- Passed all security checks, Safe to install