Templates · Cin Nova Real Estate · Template · 7 min read
Real Estate Cash Flow Analysis Template
A ready-to-use worksheet for running income, expense, financing, and return calculations on any residential investment property.
Income inputs
Enter: gross monthly rent, vacancy rate (%), and other income (parking, laundry, etc.). Calculate: effective gross income = (rent × 12) × (1 − vacancy rate) + other annual income. This is your top-line revenue before any expenses.
Expense inputs
Annual expenses to include: property taxes, insurance, repairs and maintenance (budget 1% of purchase price), property management (8–12% of rent), utilities paid by owner, HOA fees if applicable, and a CapEx reserve (5–10% of gross rent for future capital expenditures).
Return calculations
Net Operating Income (NOI) = Effective Gross Income − Total Expenses. Cap Rate = NOI ÷ Purchase Price × 100. Cash-on-Cash Return = Annual Cash Flow ÷ Total Cash Invested × 100. Monthly Cash Flow = (NOI − Annual Debt Service) ÷ 12. Use all four numbers together, not any one metric in isolation.