Rental Income Modeling

The Income Statement of a Rental Property

Every rental property is a small business. It generates revenue (rent and ancillary income), incurs operating expenses, and produces a profit or loss. The accuracy of your income and expense projections determines whether you buy a cash-flowing asset or a money pit. Garbage in, garbage out applies to real estate modeling more than almost any other domain. Sellers inflate rents, understate expenses, and omit deferred maintenance. Listing brokers present pro formas that assume 100% occupancy at above-market rents with below-market expenses. Your job as the buyer is to build your own model from independently verified numbers. Never underwrite a deal using the seller's pro forma.

Gross Potential Rent to Effective Gross Income

Start with gross potential rent (GPR): the total rent you would collect if every unit were occupied at market rate for 12 months. Verify this number with rent comparables within a 1-mile radius, same bedroom count, same condition class. Use Zillow Rentals, Apartments.com, Rentometer, or local property managers for comps. From GPR, subtract vacancy and credit loss. Vacancy accounts for turnover periods between tenants. Credit loss accounts for tenants who occupy the unit but do not pay. Together, these run 5-8% for well-located residential properties in healthy markets. Higher in Class C properties (8-12%) and student housing (10-15%). Lower in Class A properties in supply-constrained markets (3-5%). Add other income: late fees, pet rent ($25-50/month per pet is standard), laundry revenue, parking, storage. For multifamily, this can add 3-8% to effective gross income. For SFRs, it is usually minimal. The result is effective gross income (EGI), the actual money you expect to collect.

• Gross Potential Rent = Market Rent x Units x 12 months
• Vacancy + Credit Loss: 5-8% typical, 8-12% for Class C, 3-5% for Class A
• Other Income: pet rent, laundry, parking, late fees, application fees
• Effective Gross Income = GPR - Vacancy/Credit Loss + Other Income

Operating Expense Breakdown

Operating expenses are everything it costs to run the property, excluding debt service and capital expenditures. Each line item has a typical range, but local conditions can push any of them far outside the norm.

• Property Taxes: Varies enormously by state. Texas and New Jersey run 2-3% of assessed value. Alabama and Hawaii run under 0.5%. Always verify current assessed value AND check if a sale triggers reassessment (it does in most states, which can double the tax bill overnight).
• Insurance: $1,200-$2,400/year for a standard SFR. Higher in hurricane zones (FL, Gulf Coast: $3,000-$6,000+), flood zones (add flood insurance: $700-3,000/year), and areas with older housing stock.
• Maintenance: 1% of property value per year is the rule of thumb. A $250K property budgets $2,500/year for routine repairs. Older properties (pre-1980) should budget 1.5-2%.
• Property Management: 8-10% of collected rent for residential, plus a leasing fee of 50-100% of first month's rent for each new tenant placement.
• CapEx Reserves: 5-10% of gross rent set aside for major component replacement. Roof ($8K-$15K, 20-30 year life), HVAC ($5K-$10K, 15-20 year life), water heater ($1K-$2K, 10-12 year life), flooring, appliances.
• Utilities (if owner-paid): Water/sewer $50-150/month, trash $30-75/month, electric/gas in common areas for multifamily.
• Landscaping: $100-300/month depending on lot size and region.
• Administrative: Legal fees, accounting, advertising for vacancies, software. Budget $500-1,500/year.

The 50% Rule for Quick Screening

The 50% rule is a rough screening tool: operating expenses will consume approximately 50% of gross rent. It is not precise, but it is close enough to kill bad deals in seconds. If a property rents for $2,000/month ($24,000/year), assume $12,000 in operating expenses and $12,000 in NOI. Then subtract debt service to estimate cash flow. The 50% rule tends to slightly overestimate expenses on SFRs (which lack common area costs) and slightly underestimate expenses on older multifamily (which have deferred maintenance and higher turnover). It works best as a first-pass filter. If a deal does not work at 50% expenses, it is not worth modeling in detail. If it does work at 50%, build a line-item budget to verify.

• $2,000/month rent x 12 = $24,000 gross annual rent
• 50% rule: $12,000 estimated operating expenses
• Estimated NOI: $12,000
• If debt service is $11,000, estimated cash flow: $1,000/year
• If debt service is $14,000, estimated cash flow: -$2,000/year
• Use as first filter, then build detailed model for deals that pass

Common Modeling Mistakes

The three most expensive modeling errors new investors make all share a root cause: optimism bias.

• Overestimating rent: Using the highest comp in the neighborhood instead of the median. Your property is probably not the nicest on the block.
• Underestimating vacancy: Running 3% vacancy in a market where actual vacancy is 7%. One month of vacancy on a $1,800/month rental wipes out $1,800 of projected income.
• Ignoring CapEx: The roof does not care about your pro forma. A $12,000 roof replacement in year 3 erases two years of cash flow if you did not budget for it.
• Forgetting turnover costs: Every tenant changeover costs $2,000-$5,000 in vacancy, cleaning, painting, minor repairs, and leasing fees. Budget for one turnover every 2-3 years.
• Using seller's expense numbers: Sellers who self-manage and defer maintenance will show artificially low expenses. Your actual operating costs will be 20-40% higher.

Income modeling starts with verified rent comps and realistic vacancy. Expense modeling requires line-item budgets for taxes, insurance, maintenance, management, and CapEx reserves. The 50% rule screens deals fast. Detailed models catch the nuances. Always stress-test your assumptions, because the market will do it for you if you do not.