Prompt Details
Model
Chat - (gpt-5.5)
Token size
933
Example input
[INSERT PROPERTY ADDRESS OR LOCATION — PURCHASE PRICE — PROPERTY TYPE — ESTIMATED RENT — ESTIMATED EXPENSES — YOUR INVESTMENT STRATEGY — YOUR FINANCING PLAN — YOUR INVESTMENT GOAL]: Location: Houston Texas 77051. Purchase price: $185,000. Property type: single family 3 bedroom 2 bathroom built 1998. Estimated rent: $1,450 per month. Estimated expenses: property tax $300, insurance $120, maintenance reserve $150, property management $145 per month. Investment strategy: buy and hold. Financing: 25 percent down conventional at 7.5 percent 30-year fixed. Goal: positive cashflow from day one.
Example output
🏠 REAL ESTATE INVESTOR CASHFLOW MATRIX REPORT
Property: Houston Texas 77051 — Single Family 3BR 2BA — $185,000 Purchase Price — Buy and Hold Strategy
Investment Analysis ACTIVATED
🔍 POINT 1 — PROPERTY INVESTMENT SNAPSHOT
Investment Opportunity Score: 7.2 out of 10. Houston zip code 77051 is one of the highest opportunity wholesale and rental markets in the city. This is a working class neighborhood with strong rental demand, stable tenant base and significant long-term appreciation potential driven by Houston’s continued population growth. The property is priced at $185,000 in a market where comparable rentals command $1,400 to $1,550 per month — putting your price to rent ratio in an acceptable range for cashflow investing. Biggest Opportunity: Houston 77051 has experienced consistent rent growth of 4 to 6 percent annually over the last 5 years. Locking in a tenant at $1,450 today means your rent revenue grows annually while your fixed-rate mortgage payment stays the same — a powerful long-term wealth building dynamic. Biggest Risk: At 7.5 percent interest rate the cashflow margin is thin in year one. Any significant unexpected repair or vacancy period in the first 12 months will require cash reserves. Minimum recommended cash reserve for this property is $8,000 to $12,000 at closing in addition to down payment.
💰 POINT 2 — CASHFLOW ANALYSIS ENGINE
Purchase Price $185,000. Estimated Monthly Rent $1,450. Vacancy Allowance 8 percent $116 per month. Effective Gross Income $1,334 per month. Monthly Operating Expenses: Property Tax $300. Insurance $120. Maintenance Reserve $150. Property Management 10 percent $145. Total Operating Expenses $715 per month. Net Operating Income $1,334 minus $715 equals $619 per month equals $7,428 per year. Financing Scenario 1 — 20 Percent Down $37,000: Loan $148,000 at 7.5 percent 30-year. Monthly Payment $1,035. Cashflow negative $416 per month. NEGATIVE — do not proceed at 20 percent down at this price. Financing Scenario 2 — 25 Percent Down $46,250: Loan $138,750 at 7.5 percent. Monthly Payment $970. Cashflow negative $351 per month. STILL NEGATIVE — requires price negotiation or rent increase. Financing Scenario 3 — All Cash $185,000: No mortgage. Monthly Cashflow $619. Annual Cashflow $7,428. Cash on Cash Return 4.0 percent. Acceptable for all-cash but below optimal 6 to 8 percent target. Minimum Rent for Positive Cashflow at 25 Percent Down: Need $1,832 in gross rent. Current market rent $1,450 is $382 below positive cashflow threshold at 7.5 percent interest. Recommendation: Negotiate purchase price down to $155,000 to $165,000 to achieve positive cashflow at current rents and rates.
📊 POINT 3 — KEY METRICS CALCULATOR
Cap Rate: NOI $7,428 divided by Purchase Price $185,000 equals 4.01 percent. Houston benchmark 5 to 7 percent. BELOW benchmark — indicates overpricing for cashflow investor. Cash on Cash Return at 25 Percent Down: Negative — does not meet minimum threshold. Gross Rent Multiplier: $185,000 divided by $17,400 annual rent equals 10.6. Target under 10. ABOVE target — further confirmation of overpricing for cashflow. Price to Rent Ratio: $185,000 divided by $1,450 equals 127.6. Under 100 strong cashflow market, 100 to 150 moderate, above 150 appreciation market. This property falls in moderate range. Debt Service Coverage Ratio at 25 Percent Down: NOI $7,428 divided by Annual Debt Service $11,640 equals 0.64. Lenders require minimum 1.0 to 1.25. This property does not meet DSCR requirements at current price and rent. Break Even Occupancy Rate: $1,685 total monthly obligations divided by $1,450 equals 116 percent — need MORE than 100 percent occupancy to break even. Confirms property is overpriced for cashflow at current rent and rate levels.
📈 POINT 4 — APPRECIATION AND EQUITY ANALYSIS
Purchase Price $185,000. Down Payment 25 Percent $46,250. Loan $138,750. Conservative Appreciation 2 Percent: Year 1 $188,700. Year 3 $196,300. Year 5 $204,200. Year 10 $225,600. Equity at Year 10 including principal paydown $225,600 minus $115,000 remaining loan equals $110,600. Moderate Appreciation 4 Percent Houston Historical Average: Year 1 $192,400. Year 3 $208,100. Year 5 $225,200. Year 10 $274,100. Equity at Year 10 $274,100 minus $115,000 equals $159,100. Aggressive Appreciation 6 Percent: Year 1 $196,100. Year 3 $220,400. Year 5 $247,600. Year 10 $331,400. Equity at Year 10 $331,400 minus $115,000 equals $216,400. Total Return at Moderate Appreciation: Equity gain $159,100 minus down payment $46,250 equals $112,850. Minus negative cashflow cost $42,000 over 10 years. Adjusted net return $70,850 on $46,250 invested equals 153 percent total return over 10 years equals approximately 9.8 percent annualized.
⚠️ POINT 5 — RISK ASSESSMENT MATRIX
Cashflow Risk Score 9/10 HIGH: Property is cashflow negative at current price and rates. Any unexpected expense requires out-of-pocket capital. Mitigation: Negotiate price down or increase rent at lease signing. Maintain $10,000 minimum cash reserve. Vacancy Risk Score 6/10 MODERATE: 77051 has strong rental demand but working class tenants can have payment instability. Mitigation: Screen tenants rigorously — credit 620 plus, income 3 times rent, no recent evictions. Maintenance Risk Score 7/10 MODERATE-HIGH: 1998 build means HVAC, roof and plumbing are 26 years old. Major system replacement likely within 5 years. Budget $15,000 to $25,000 for major system replacements. Market Risk Score 4/10 LOW: Houston is a strong diverse economy with consistent population growth. Financing Risk Score 7/10 MODERATE-HIGH: At 7.5 percent and negative DSCR some lenders may decline. Work with investment property mortgage broker. Worst Case Scenario: 20 percent vacancy plus $8,000 emergency repair equals $15,680 total out of pocket in single year. Manageable with $20,000 cash reserve.
🚪 POINT 6 — EXIT STRATEGY ANALYSIS
Exit Strategy 1 — Sell After 5 Years at Moderate Appreciation: Sale Price $225,200. Remaining Loan $126,000. Gross Profit $99,200. Capital Gains Tax 15 percent $14,880. Closing Costs 6 percent $13,512. Net Profit After Tax and Costs $70,808. Minus negative cashflow cost $21,000 over 5 years. Adjusted Net Profit $49,808 on $46,250 invested equals 107 percent return in 5 years equals 15.6 percent annualized. Exit Strategy 2 — Refinance and Hold at Year 5: Property appreciates to $225,200. Cash-out refinance at 75 percent LTV generates $168,900 minus $126,000 remaining balance equals $42,900 cash out. Use as down payment on second rental property. BRRRR completion play. Exit Strategy 3 — 1031 Exchange at Year 10: Sell at $274,100 moderate projection. 1031 exchange to defer all capital gains. Roll $159,100 equity into larger multifamily with better cashflow metrics. Recommended Exit Strategy: Hold 10 years and execute 1031 exchange into better cashflow property.
🏙️ POINT 7 — MARKET INTELLIGENCE REPORT
Houston 77051 Market Analysis: Rental Demand High. Working class rental market with consistent tenant demand. Vacancy rates historically 5 to 7 percent. Rent Growth 4 to 6 percent annually over last 5 years. Your $1,450 rent becomes $1,762 by Year 5. Neighborhood Trajectory: 77051 is a transitional neighborhood with increasing investor activity. Trajectory positive but slow — 10 plus year horizon for significant gentrification impact. Comparable Sales: Similar 3BR 2BA properties sold $165,000 to $210,000 in last 90 days. Your $185,000 is mid-range. Market Condition: Balanced to slight buyer’s market. Days on market averaging 45 to 60 days. Sellers have some motivation. Negotiating room $15,000 to $25,000 below list is realistic.
📋 POINT 8 — INVESTMENT DECISION AND ACTION PLAN
RECOMMENDATION: NEGOTIATE — Do not buy at $185,000 at current interest rates. Target Offer Price $158,000. Negotiation Strategy: Present offer at $152,000. Reference comparable sales at $165,000 to $170,000 as ceiling. Use negative DSCR as negotiation leverage — explain that at current rates and rents the property does not cashflow at asking price. Negotiate to $158,000 to $163,000. At $160,000 cashflow at 25 percent down: Loan $120,000 at 7.5 percent equals mortgage $840. NOI $619. Cashflow negative $221 — still slightly negative but manageable. Due Diligence Checklist: Full property inspection including roof, HVAC, foundation, plumbing, electrical. Title search for liens. Rental comp verification — confirm $1,450 achievable with 3 current lease comparables. Insurance quote before closing. Houston flood zone status verification. Property tax verification with county. 90-Day Action Plan: Week 1 to 2 — Submit offer at $152,000. Negotiate to $158,000 to $163,000. Week 3 to 4 — Inspection period. Negotiate repairs. Confirm financing. Week 5 to 8 — Appraisal and loan processing. Week 9 to 12 — Closing and tenant placement. Begin marketing for tenant immediately — target 2-week vacancy maximum post-closing. REAL ESTATE CASHFLOW SCORE: 6.1 out of 10 at $185,000. 7.8 out of 10 at $160,000. The property and market are solid — the price needs to come down for this to be a good cashflow deal. Negotiate aggressively. Houston is a strong long-term market and this neighborhood has real appreciation upside. Do not overpay for a cashflow property in a rising rate environment. Get the price right and this becomes a solid 10-year wealth building asset.
By purchasing this prompt, you agree to our terms of service
GPT-5.5
The ChatGPT prompt for real estate investors leaving money on the table with every property they analyze. This AI tool for real estate investors builds your complete property cashflow analysis with exact numbers, cap rates, cash on cash returns and a full investment decision report. For educational and informational purposes only.
...more
Added 2 weeks ago
