AI Prompts for Real Estate Investors: Deal Analysis, Market Research, and Portfolio Management

You are an experienced real estate analyst. Evaluate this potential investment for a quick go/no-go decision.

PROPERTY DETAILS:
- Address/Market: [CITY, STATE, NEIGHBORHOOD]
- Property type: [SINGLE FAMILY / MULTIFAMILY / COMMERCIAL / MIXED USE]
- Asking price: $[PRICE]
- Units: [NUMBER OF UNITS]
- Total square footage: [SQ FT]
- Year built: [YEAR]
- Current gross rent (monthly): $[RENT]
- Listed vacancy rate: [X%]
- Annual property taxes: $[TAX]
- Insurance estimate: $[INSURANCE]
- Any known issues: [LIST KNOWN ISSUES]

Calculate:
1. Gross rent multiplier (GRM)
2. Price per unit and price per square foot
3. Back-of-envelope cap rate using 50% expense ratio
4. Monthly cash flow estimate using the 50% rule
5. Pass/fail on the 1% rule

Based on these quick metrics, is this worth deeper analysis? Flag any numbers that look unusual for the market.

Build a detailed monthly cash flow projection for this rental property.

PROPERTY: [ADDRESS]
PURCHASE PRICE: $[PRICE]
DOWN PAYMENT: [X]% ($[AMOUNT])
LOAN TERMS: [X]% interest, [30]-year fixed, $[MONTHLY P&I]

INCOME:
- Unit 1: $[RENT]/month
- Unit 2: $[RENT]/month (if applicable)
- Other income (laundry, parking, storage): $[AMOUNT]/month

EXPENSES (monthly estimates — use market averages where I've left blanks):
- Property taxes: $[AMOUNT]
- Insurance: $[AMOUNT]
- Property management: [X]% of gross rent
- Maintenance reserve: [X]% of gross rent (suggest appropriate % if blank)
- Vacancy reserve: [X]% (suggest if blank based on market)
- Utilities (owner-paid): $[AMOUNT]
- HOA/Condo fees: $[AMOUNT]
- Lawn/Snow: $[AMOUNT]

Produce:
1. Monthly cash flow statement (gross income → effective gross income → NOI → cash flow after debt service)
2. Annual cash flow
3. Cash-on-cash return
4. Cap rate
5. Debt service coverage ratio (DSCR)
6. Break-even occupancy rate
7. Sensitivity table: show cash flow at -10%, -5%, actual, +5%, +10% rent levels

Perform a cap rate and valuation analysis for this investment property.

PROPERTY: [ADDRESS / DESCRIPTION]
CURRENT NOI: $[NOI] (or I'll provide income/expense details)
PURCHASE PRICE: $[PRICE]
MARKET: [CITY, STATE]
PROPERTY TYPE: [TYPE]

Analyze:
1. Current cap rate based on asking price
2. Implied value at market cap rates of [X]%, [Y]%, [Z]% (suggest appropriate market cap rates if I haven't provided them)
3. What cap rate makes this property worth the asking price?
4. NOI needed to justify the asking price at a [X]% target cap rate
5. Compare this cap rate to typical ranges for this property type and market
6. Cap rate trend implications — is this market compressing or expanding?

Note any assumptions you're making and where I should verify with local market data.

You are a real estate market analyst. Help me evaluate [NEIGHBORHOOD/ZIP CODE] in [CITY, STATE] as an investment market.

Create a research framework covering:

1. DEMAND DRIVERS: What should I research about employment, population trends, major employers, university proximity, and transit access in this area?
2. SUPPLY FACTORS: What data should I gather on building permits, new construction pipeline, housing inventory levels, and days on market?
3. RENT TRENDS: What questions should I answer about current rent levels by unit type, rent growth trajectory, and rent-to-income ratios?
4. RISK FACTORS: What should I investigate regarding crime trends, environmental risks (flood zones, etc.), regulatory environment (rent control, landlord-tenant laws), and property tax trajectory?
5. COMPARABLE PROPERTIES: What recently sold or listed comparables should I be looking for, and what metrics should I compare?

For each category, give me the specific data points to find and suggest where to find them (county records, Census data, Zillow, Redfin, local MLS, etc.).

I'm deciding between investing in these markets. Help me build a comparison framework.

MARKET A: [CITY, STATE]
MARKET B: [CITY, STATE]
MARKET C: [CITY, STATE] (optional)

INVESTMENT STRATEGY: [BUY AND HOLD / FLIP / BRRRR / SHORT-TERM RENTAL]
BUDGET: $[RANGE]
TARGET: [PROPERTY TYPE]

Compare these markets on:
1. Price-to-rent ratios
2. Population and job growth trends
3. Landlord-friendliness (eviction process, rent control, regulations)
4. Property tax rates
5. Insurance costs and natural disaster risk
6. Typical cap rates for my target property type
7. Barrier to entry (median price, competition level)
8. Appreciation potential vs. cash flow characteristics

Present as a comparison table, then give me your analysis of which market best fits my strategy and why. Flag any data points I should verify with current local sources.

Help me analyze the rental market for a [PROPERTY TYPE] in [NEIGHBORHOOD, CITY, STATE].

Property specifics:
- Bedrooms: [X] / Bathrooms: [X]
- Square footage: [X]
- Condition: [UPDATED / AVERAGE / NEEDS WORK]
- Amenities: [LIST — parking, laundry, AC, etc.]

Analyze:
1. What rent range should I target based on these specs? What methodology should I use to determine market rent?
2. What amenities or upgrades would justify the highest rent in this range?
3. What's the typical vacancy rate for this property type in this market?
4. Seasonal rental patterns — when is the best/worst time to list?
5. Tenant demographics — who rents this type of property and what do they prioritize?
6. Competitive advantage analysis — what would make this unit stand out?
7. Short-term rental potential — would this property perform better as a STR? (Include regulatory check)

Base your analysis on what I should research, and tell me where to find the data points I need.

Build a 5-year financial projection for this rental property investment.

PROPERTY: [ADDRESS]
PURCHASE PRICE: $[PRICE]
CLOSING COSTS: $[AMOUNT] (estimate if unknown)
RENOVATION BUDGET: $[AMOUNT]
FINANCING: [LOAN DETAILS]
YEAR 1 NOI: $[NOI]

ASSUMPTIONS (use reasonable defaults where I leave blanks):
- Annual rent growth: [X]%
- Annual expense growth: [X]%
- Annual appreciation: [X]%
- Capital expenditure reserve: $[AMOUNT]/year
- Tax rate (income): [X]%

Produce:
1. Year-by-year cash flow statement
2. Cumulative cash flow
3. Annual cash-on-cash return
4. Equity buildup (appreciation + principal paydown)
5. Total return (cash flow + equity + tax benefits)
6. IRR calculation
7. Equity multiple
8. Year-by-year net worth impact

Present as a clean table, then summarize: total 5-year return, average annual return, and breakeven timeline.

Analyze the ROI of planned renovations for my investment property.

PROPERTY: [ADDRESS / DESCRIPTION]
CURRENT VALUE: $[VALUE]
CURRENT RENT: $[RENT]/month

PLANNED RENOVATIONS:
1. [RENOVATION 1]: Estimated cost $[X]
2. [RENOVATION 2]: Estimated cost $[X]
3. [RENOVATION 3]: Estimated cost $[X]
4. [RENOVATION 4]: Estimated cost $[X]

For each renovation:
1. Estimated rent increase it would support
2. Estimated value increase (ARV impact)
3. Payback period based on increased rent
4. ROI as a percentage (annual rent increase / renovation cost)
5. Priority ranking — which renovations to do first based on ROI

Also calculate:
- Total renovation budget
- Combined ARV (after-repair value)
- New cash flow projection post-renovation
- Whether the numbers support a BRRRR refinance (if applicable)

Generate a comprehensive due diligence checklist for purchasing a [PROPERTY TYPE] investment property in [STATE].

Organize by category:
1. FINANCIAL VERIFICATION — rent rolls, P&L statements, tax returns, utility bills, existing leases, security deposits
2. PHYSICAL INSPECTION — structural, mechanical, roof, plumbing, electrical, environmental, pest, code compliance
3. LEGAL AND TITLE — title search, survey, zoning verification, permits, liens, easements, HOA documents
4. INSURANCE — current coverage, claims history, flood zone status, required coverage types
5. MARKET VERIFICATION — comparable sales, comparable rents, vacancy verification, neighborhood trends
6. TENANT VERIFICATION — lease terms, payment history, estoppel certificates, Section 8 status
7. REGULATORY — local landlord-tenant laws, rent control, lead paint, certificates of occupancy

For each item, include:
- Why it matters (one sentence)
- Where to get it
- Red flag to watch for
- Typical timeline to obtain

Mark items as CRITICAL (deal-breaker if not resolved) or IMPORTANT (affects valuation/negotiation).

I received the following financial documents from a property seller. Help me analyze them critically.

PROPERTY: [DESCRIPTION]
ASKING PRICE: $[PRICE]

SELLER'S REPORTED NUMBERS:
- Gross rental income: $[AMOUNT]/year
- Vacancy: [X]%
- Operating expenses: $[AMOUNT]/year
  - [Break down if available]
- NOI: $[AMOUNT]/year
- Cap rate (as advertised): [X]%

Review these numbers:
1. Do the reported expenses look realistic? What's typically missing from seller-reported expenses? (List common omissions: management fees, capex reserves, turnover costs, etc.)
2. Is the vacancy rate realistic for this market and property type?
3. Are there expense categories that seem suspiciously low?
4. What's the NOI if I apply realistic expense assumptions?
5. What does the real cap rate look like with adjusted numbers?
6. What additional financial documentation should I request?
7. List the top 5 questions I should ask the seller or their broker based on these numbers.

Help me review my real estate portfolio performance.

PORTFOLIO:
Property 1: [ADDRESS], [TYPE], purchased [DATE] for $[PRICE], current value ~$[VALUE], monthly cash flow $[CF]
Property 2: [ADDRESS], [TYPE], purchased [DATE] for $[PRICE], current value ~$[VALUE], monthly cash flow $[CF]
Property 3: [ADDRESS], [TYPE], purchased [DATE] for $[PRICE], current value ~$[VALUE], monthly cash flow $[CF]
[Add more as needed]

TOTAL EQUITY INVESTED: $[AMOUNT]
TOTAL OUTSTANDING DEBT: $[AMOUNT]

Analyze:
1. Portfolio-level metrics: total cash flow, average cash-on-cash return, portfolio cap rate, total equity, LTV ratio
2. Per-property performance ranking — which properties are carrying the portfolio and which are underperforming?
3. Concentration risk — am I too concentrated in one market, property type, or tenant type?
4. Debt analysis — overall LTV, DSCR, and interest rate exposure
5. Which property should I focus on improving?
6. Does the portfolio support acquiring another property? What would be the ideal next acquisition to improve diversification?

I'm considering a 1031 exchange. Help me think through the analysis.

PROPERTY TO SELL:
- Address: [ADDRESS]
- Current value: $[VALUE]
- Original purchase price: $[PRICE]
- Remaining mortgage: $[BALANCE]
- Estimated depreciation taken: $[AMOUNT]
- Estimated selling costs: [X]%
- Annual cash flow: $[AMOUNT]

TARGET REPLACEMENT PROPERTY (or criteria):
- [DESCRIBE TARGET OR CRITERIA]
- Target price range: $[RANGE]

Analyze:
1. Estimated capital gains tax if I sell without a 1031
2. Tax deferred through the 1031 exchange
3. Key 1031 deadlines (45-day identification, 180-day close)
4. Requirements for qualifying replacement property
5. Cash flow comparison: current property vs. target replacement
6. Does trading up make financial sense beyond the tax deferral?
7. Risks and complications to watch for
8. What questions should I ask my CPA and attorney?

Note: This is for analysis purposes. I'll verify all tax calculations with my CPA.

I'm preparing for tax season. Help me review common real estate investor deductions to make sure I'm not missing anything.

MY SITUATION:
- Number of rental properties: [X]
- Total rental income: $[AMOUNT]
- My tax filing status: [STATUS]
- My other income: $[APPROXIMATE — for MAGI/passive loss context]
- Am I a real estate professional for tax purposes? [YES/NO/UNSURE]

Walk me through these deduction categories and help me identify what I should be claiming:

1. OPERATING EXPENSES — management, maintenance, repairs, utilities, insurance, advertising, travel, professional fees
2. MORTGAGE INTEREST — deductibility and any limitations
3. DEPRECIATION — residential schedule, cost segregation potential, bonus depreciation status
4. PASSIVE ACTIVITY LOSSES — can I deduct losses against other income? What are the thresholds?
5. HOME OFFICE — if I manage properties from home
6. VEHICLE EXPENSES — property visits, maintenance trips
7. EDUCATION AND PROFESSIONAL DEVELOPMENT — courses, books, conferences

For each category, list specific deductible items and flag anything that commonly gets missed. Note where I should talk to a CPA for my specific situation.

Help me evaluate whether a cost segregation study makes sense for my property.

PROPERTY: [ADDRESS / DESCRIPTION]
PURCHASE PRICE: $[PRICE] (building value approximately $[AMOUNT])
PROPERTY TYPE: [TYPE]
YEAR ACQUIRED: [YEAR]
MY TAX BRACKET: [APPROXIMATE %]

Explain:
1. What is cost segregation and how does it differ from standard depreciation?
2. Based on my property type and value, what's a rough estimate of the percentage that might be reclassified to shorter depreciation schedules (5, 7, 15 years)?
3. What's the estimated first-year tax benefit?
4. What does a cost segregation study typically cost for this property type?
5. ROI of the study: cost of study vs. tax benefit
6. Depreciation recapture implications when I eventually sell
7. Does this make sense given my tax situation?
8. Questions to ask when interviewing cost segregation firms

Provide a rough cost-benefit framework. I'll get exact numbers from a qualified cost seg firm and my CPA.

I want to explore creative financing options for acquiring a property.

PROPERTY: [DESCRIPTION]
PRICE: $[PRICE]
MY AVAILABLE CASH: $[AMOUNT]
MY CREDIT SCORE: [APPROXIMATE RANGE]
THE SITUATION: [DESCRIBE — e.g., seller is motivated, property needs work, bank won't finance, etc.]

Analyze the viability of these financing approaches for my situation:

1. SELLER FINANCING — typical terms, how to structure, what sellers usually want
2. SUBJECT-TO (taking over existing mortgage) — when it works, risks, legal considerations
3. LEASE OPTION — structure, pros/cons for investors, typical terms
4. HARD MONEY / BRIDGE LOAN — when to use, typical rates, exit strategy requirements
5. PARTNERSHIP / SYNDICATION — structuring a deal with investor partners
6. BRRRR STRATEGY — buy, rehab, rent, refinance, repeat — does this property fit?
7. HELOC FROM EXISTING PROPERTY — using current equity

For each option:
- Does it work for my situation?
- What are the risks?
- What numbers do I need to make it work?
- What legal/professional help do I need?