AI Rental Property ROI Calculator
Generate comprehensive investment analyses including cash flow projections, cap rates, and risk assessments for rental properties.
Act as an expert Real Estate Investment Analyst and Financial Modeling Specialist with 20+ years of experience in residential and commercial property valuation. Perform a comprehensive ROI analysis and investment feasibility study for the following rental property. ## PROPERTY FINANCIAL DATA - **Property Address/Type**: [PROPERTY_LOCATION] - **Purchase Price**: $[PURCHASE_PRICE] - **Down Payment**: [DOWN_PAYMENT_PERCENT]% ($[DOWN_PAYMENT_AMOUNT] if fixed) - **Loan Details**: [INTEREST_RATE]% interest, [LOAN_TERM] years, [LOAN_TYPE: Fixed/ARM] - **Acquisition Costs**: Closing Costs $[CLOSING_COSTS] | Immediate Repairs $[REPAIR_COSTS] - **Holding Period**: [HOLD_PERIOD] years ## INCOME PROJECTIONS - **Monthly Market Rent**: $[MONTHLY_RENT] - **Vacancy Rate**: [VACANCY_RATE]% (include leasing fees if applicable) - **Additional Income**: $[OTHER_INCOME] (parking, storage, laundry, late fees) - **Rent Growth Rate**: [RENT_APPRECIATION]% annually ## OPERATING EXPENSES (Monthly) - **Property Taxes**: $[PROPERTY_TAXES] - **Insurance**: $[INSURANCE] - **Property Management**: [MANAGEMENT_FEE]% of collected rent (or $[MANAGEMENT_FEE_AMOUNT]) - **Maintenance/Repairs**: [MAINTENANCE_PERCENT]% of rent (or $[MAINTENANCE_AMOUNT]) - **Capital Expenditures (CapEx) Reserve**: $[CAPEX_RESERVE] (roof, HVAC, appliances) - **HOA Fees**: $[HOA_FEES] - **Utilities (Owner Paid)**: $[UTILITIES] - **Landscaping/Snow Removal**: $[LANDSCAPING] - **Other**: $[OTHER_EXPENSES] ## MARKET ASSUMPTIONS - **Property Appreciation**: [APPRECIATION_RATE]% annually - **Expense Growth**: [EXPENSE_GROWTH]% annually - **Exit Strategy**: [EXIT_STRATEGY: Hold/Sell/1031 Exchange] - **Selling Costs (if applicable)**: [SELLING_COSTS]% of sale price ## REQUIRED ANALYSIS 1. **Investment Summary Table**: Total Cash Invested, Loan Amount, Monthly Mortgage (P&I) 2. **Cash Flow Analysis**: Monthly and Annual Cash Flow (NOI - Debt Service) 3. **Key Performance Indicators**: - Cash-on-Cash Return (Year 1 and Average) - Capitalization Rate (Cap Rate) - Gross Rent Multiplier (GRM) - Debt Service Coverage Ratio (DSCR) - Break-even Occupancy Rate - Internal Rate of Return (IRR) and Net Present Value (NPV) if held for [HOLD_PERIOD] years 4. **5-Year Pro Forma**: Year-by-year projection of income, expenses, equity buildup, and appreciation 5. **Tax Benefits Analysis**: Depreciation schedule (residential: 27.5 years), deductible expenses estimate 6. **Risk Assessment**: - Identify 3 major financial risks - Recommended cash reserves (months of expenses) - Sensitivity Analysis: Impact of [VACANCY_RATE]% + 5% vacancy OR [MONTHLY_RENT] - 10% rent reduction 7. **Comparative Metrics**: How does this Cap Rate compare to local market averages (if provided)? 8. **Final Verdict**: BUY, PASS, or NEGOTIATE with specific price target and 3 strategic recommendations ## FORMATTING REQUIREMENTS - Use professional financial formatting with $ and % symbols - Highlight negative cash flow or DSCR < 1.25 in red flags section - Include formulas used for transparency - Provide both optimistic and conservative scenarios - End with an "Action Items" checklist for due diligence
Act as an expert Real Estate Investment Analyst and Financial Modeling Specialist with 20+ years of experience in residential and commercial property valuation. Perform a comprehensive ROI analysis and investment feasibility study for the following rental property. ## PROPERTY FINANCIAL DATA - **Property Address/Type**: [PROPERTY_LOCATION] - **Purchase Price**: $[PURCHASE_PRICE] - **Down Payment**: [DOWN_PAYMENT_PERCENT]% ($[DOWN_PAYMENT_AMOUNT] if fixed) - **Loan Details**: [INTEREST_RATE]% interest, [LOAN_TERM] years, [LOAN_TYPE: Fixed/ARM] - **Acquisition Costs**: Closing Costs $[CLOSING_COSTS] | Immediate Repairs $[REPAIR_COSTS] - **Holding Period**: [HOLD_PERIOD] years ## INCOME PROJECTIONS - **Monthly Market Rent**: $[MONTHLY_RENT] - **Vacancy Rate**: [VACANCY_RATE]% (include leasing fees if applicable) - **Additional Income**: $[OTHER_INCOME] (parking, storage, laundry, late fees) - **Rent Growth Rate**: [RENT_APPRECIATION]% annually ## OPERATING EXPENSES (Monthly) - **Property Taxes**: $[PROPERTY_TAXES] - **Insurance**: $[INSURANCE] - **Property Management**: [MANAGEMENT_FEE]% of collected rent (or $[MANAGEMENT_FEE_AMOUNT]) - **Maintenance/Repairs**: [MAINTENANCE_PERCENT]% of rent (or $[MAINTENANCE_AMOUNT]) - **Capital Expenditures (CapEx) Reserve**: $[CAPEX_RESERVE] (roof, HVAC, appliances) - **HOA Fees**: $[HOA_FEES] - **Utilities (Owner Paid)**: $[UTILITIES] - **Landscaping/Snow Removal**: $[LANDSCAPING] - **Other**: $[OTHER_EXPENSES] ## MARKET ASSUMPTIONS - **Property Appreciation**: [APPRECIATION_RATE]% annually - **Expense Growth**: [EXPENSE_GROWTH]% annually - **Exit Strategy**: [EXIT_STRATEGY: Hold/Sell/1031 Exchange] - **Selling Costs (if applicable)**: [SELLING_COSTS]% of sale price ## REQUIRED ANALYSIS 1. **Investment Summary Table**: Total Cash Invested, Loan Amount, Monthly Mortgage (P&I) 2. **Cash Flow Analysis**: Monthly and Annual Cash Flow (NOI - Debt Service) 3. **Key Performance Indicators**: - Cash-on-Cash Return (Year 1 and Average) - Capitalization Rate (Cap Rate) - Gross Rent Multiplier (GRM) - Debt Service Coverage Ratio (DSCR) - Break-even Occupancy Rate - Internal Rate of Return (IRR) and Net Present Value (NPV) if held for [HOLD_PERIOD] years 4. **5-Year Pro Forma**: Year-by-year projection of income, expenses, equity buildup, and appreciation 5. **Tax Benefits Analysis**: Depreciation schedule (residential: 27.5 years), deductible expenses estimate 6. **Risk Assessment**: - Identify 3 major financial risks - Recommended cash reserves (months of expenses) - Sensitivity Analysis: Impact of [VACANCY_RATE]% + 5% vacancy OR [MONTHLY_RENT] - 10% rent reduction 7. **Comparative Metrics**: How does this Cap Rate compare to local market averages (if provided)? 8. **Final Verdict**: BUY, PASS, or NEGOTIATE with specific price target and 3 strategic recommendations ## FORMATTING REQUIREMENTS - Use professional financial formatting with $ and % symbols - Highlight negative cash flow or DSCR < 1.25 in red flags section - Include formulas used for transparency - Provide both optimistic and conservative scenarios - End with an "Action Items" checklist for due diligence
More Like This
Back to LibraryLuxury Real Estate Listing Generator
This prompt helps real estate agents and property marketers generate professional, SEO-optimized listings that highlight unique selling points and emotional appeal. It transforms basic property details into captivating narratives that attract qualified buyers while maintaining compliance with fair housing regulations.
AI Property Marketing Strategy Creator
This prompt helps real estate professionals, property managers, and investors create customized, comprehensive marketing strategies for any property type. It analyzes market positioning, identifies ideal buyer personas, and delivers actionable tactical plans across digital and traditional channels to maximize exposure and accelerate transactions.
AI Real Estate Email Campaign Generator
This comprehensive prompt creates complete real estate email marketing campaigns tailored to specific property types, buyer personas, and market conditions. It generates psychologically-optimized subject lines, body copy following proven frameworks like AIDA and PAS, and strategic send schedules to maximize open rates and conversions.