Gemini Data Analysis advanced

Property Investment Analyzer

Added Apr 2, 2026

You are a real estate investment analyst specializing in residential and commercial property evaluation. Analyze the following property as a potential investment and provide a comprehensive financial assessment: Property Details: - Property Type: [PROPERTY_TYPE] - Purchase Price: [PURCHASE_PRICE] - Location: [LOCATION] - Estimated Monthly Rent: [MONTHLY_RENT] - Down Payment: [DOWN_PAYMENT_PERCENT]% - Interest Rate: [INTEREST_RATE]% - Loan Term: [LOAN_TERM] years - Estimated Annual Property Tax: [PROPERTY_TAX] - Estimated Monthly Insurance: [INSURANCE] - Estimated Monthly Maintenance/Reserves: [MAINTENANCE] - HOA Fees (if applicable): [HOA_FEES] Provide the following analysis: 1. Cash Flow Analysis: Monthly and annual net operating income, mortgage payment breakdown, and cash flow after debt service 2. Key Investment Metrics: Cap rate, cash-on-cash return, gross rent multiplier, and debt service coverage ratio 3. Break-Even Analysis: Occupancy rate needed to break even 4. 5-Year Projection: Projected returns assuming [APPRECIATION_RATE]% annual appreciation and [RENT_INCREASE]% annual rent increases 5. Risk Assessment: Key risks specific to this investment and location 6. Verdict: Clear buy/hold/pass recommendation with reasoning Show all calculations step by step so the investor can verify the math.

Try in Gemini

About This Prompt

This prompt transforms Gemini into a real estate investment calculator and advisor that evaluates properties using the same financial metrics professional investors rely on. It covers cash flow analysis, cap rates, cash-on-cash returns, break-even points, and multi-year projections — all with transparent, step-by-step calculations. This is particularly useful for new investors who need help understanding whether a deal makes financial sense, or for experienced investors who want to quickly screen properties before conducting deeper due diligence. The structured output format makes it easy to compare multiple properties side by side and present findings to partners or lenders.

Variables to Customize


[PROPERTY_TYPE]

Type of investment property

Example: single-family rental


[PURCHASE_PRICE]

Total purchase price

Example: $285,000


[LOCATION]

Property location

Example: Indianapolis, IN


[MONTHLY_RENT]

Expected monthly rental income

Example: $2,100


[DOWN_PAYMENT_PERCENT]

Down payment as percentage

Example: 20


[INTEREST_RATE]

Mortgage interest rate

Example: 6.5


[LOAN_TERM]

Mortgage term in years

Example: 30


[PROPERTY_TAX]

Annual property tax amount

Example: $3,400


[INSURANCE]

Monthly insurance cost

Example: $150


[MAINTENANCE]

Monthly maintenance and reserve amount

Example: $200


[HOA_FEES]

Monthly HOA fees if applicable

Example: $0


[APPRECIATION_RATE]

Expected annual property appreciation

Example: 3


[RENT_INCREASE]

Expected annual rent increase percentage

Example: 2

Tips for Best Results

Use conservative estimates for rent and appreciation — it is better to be pleasantly surprised than overextended
Include a vacancy factor of 5-8% in your MONTHLY_RENT estimate for more realistic projections
Run the analysis multiple times with different interest rates to stress-test the deal

Example Output

PROPERTY INVESTMENT ANALYSIS: Single-Family Rental — Indianapolis, IN

1. CASH FLOW ANALYSIS
Purchase Price: $285,000
Down Payment (20%): $57,000
Loan Amount: $228,000
Monthly Mortgage Payment (P&I): $1,440.58

Monthly Income: $2,100
Monthly Expenses:
  - Mortgage: $1,440.58
  - Property Tax: $283.33
  - Insurance: $150.00
  - Maintenance/Reserves: $200.00
  - HOA: $0
Total Monthly Expenses: $2,073.91
Monthly Cash Flow: $26.09
Annual Cash Flow: $313.08...

real-estate investment-analysis financial-modeling ROI property-evaluation

Also Featured In

Best Gemini Prompts for Data Analysis AI Prompts for Real Estate AI Prompts for Data Analysts Best Gemini Prompts