Audit Rental Property Cash Flow for Hidden Expenses

This prompt audits your rental property pro forma to identify missing operating costs like vacancy, capital expenditures, and maintenance reserves.

Prompt

Prompt
Act as a seasoned real estate investor and property manager. Your job is to audit a rental property financial worksheet for missing or underestimated expenses. First, ask me these three questions: 1. What is the monthly gross rent? 2. Please list your current estimated annual expenses in categories like taxes, insurance, and utilities. 3. What is the age and condition of the property? Wait for my answers. Then, provide an audit report that calculates realistic reserves for vacancy, repairs, capital expenditures, and management fees. Rules: 1. Use industry standard percentages (e.g., 5-8% for vacancy, 10% for management). 2. Highlight any line items that are missing or below market rates. 3. Provide a revised monthly cash flow projection. 4. State clearly that this is not professional financial or tax advice and that I should consult a qualified accountant or licensed real estate professional before making investment decisions. Output format: 1. Audit Summary. 2. Expense Gap Analysis Table. 3. Revised Cash Flow Projection. 4. Warning regarding professional advice.

Example output

Example for: a 1985-built single-family home in suburban Ohio with $1,800 monthly rent.

1. Audit Summary

The current projections are overly optimistic. You have failed to account for long-term capital expenditures and professional management fees, which will turn your perceived positive cash flow into a net loss over a 5-year horizon.

2. Expense Gap Analysis
Expense CategoryYour EstimateMarket StandardStatus
Vacancy$0$1,080/yrMissing
Cap-Ex$0$1,800/yrMissing
Maintenance$500/yr$1,800/yrUndercounted
Management$0$2,160/yrMissing
3. Revised Cash Flow Projection
  • Gross Monthly Income: $1,800
  • Total Estimated Monthly Expenses (Taxes, Insurance, Utilities): $450
  • Total Monthly Reserves (Vacancy, Cap-Ex, Mgmt): $570
  • Net Monthly Cash Flow: $780
4. Disclaimer

This analysis is for educational purposes only and is not professional financial or tax advice. Please consult a qualified accountant or licensed real estate professional before making investment decisions.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Forces inclusion of ignored costs like vacancy and cap-ex.
  • Uses industry-standard benchmarks to validate user data.
  • Provides a clear before-and-after view of monthly cash flow.

Use this prompt when evaluating a potential rental property purchase or reviewing current portfolio performance. Have your expense spreadsheet ready to paste or summarize. Supported in ChatGPT, Claude, and Gemini.

Common edits

  • Change the management fee percentage if you plan to self-manage.
  • Adjust the Cap-Ex reserve percentage based on the specific age of the roof and HVAC.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Real Estate