Why Generic Cash Flow Templates Fail NC Buyers
Most downloadable underwriting spreadsheets were built for national audiences. They assume stable insurance markets, predictable property tax bases, and uniform vacancy patterns. North Carolina breaks all three of those assumptions in ways that matter to your bottom line.
Property tax reassessment is a real risk. NC counties reassess property values on a cycle, and many counties in the Research Triangle and Charlotte metro have completed or are approaching reassessment years. When you buy a property, the county often resets the assessed value to something close to your purchase price. If the current owner is paying taxes on a value from several years ago, your actual tax bill after closing could be meaningfully higher. A generic template will not flag this. You need to underwrite to a full tax reset at your purchase price, not the seller's current bill.
Insurance costs are structurally higher, not temporarily higher. After recent storm seasons and broader carrier exits from certain markets, NC multifamily insurance premiums have risen in ways that are unlikely to reverse quickly. Treat the insurance line as a permanent cost increase when you model expenses, not a one-year anomaly.
Vacancy patterns vary sharply by submarket. A generic template might suggest a flat 5% vacancy assumption. In practice, a property near a university in Chapel Hill or Boone behaves very differently from a stabilized workforce housing asset in a Charlotte suburb. Seasonal turnover, student lease cycles, and new supply pipelines all affect your realistic vacancy rate. You need a local assumption, not a national average.
Understanding these gaps is the first step. The next step is building a model that accounts for them. If you want to see how NC-specific rent dynamics affect your income projections before you even start modeling, the piece on small multifamily rent growth limits in NC college towns is worth reading first.
Build Your Income Stack: GPR, Vacancy, and Ancillary Income
Your income model has three components. Work through them in sequence.
Gross Potential Rent (GPR) is the theoretical maximum: every unit rented at full market rate with zero vacancy. Start here, but do not stop here. Pull current rent rolls from the seller and cross-reference against market rents using CoStar data or conversations with local property managers in your target submarket. Sellers sometimes list units at below-market rents to show long-term tenants, which can inflate the apparent upside. Verify what the market will actually support before you project any rent bumps.
Vacancy and Credit Loss reduces GPR to something realistic. Apply a vacancy rate based on the specific submarket, not a national benchmark. For a stabilized asset in a Charlotte suburb with low turnover, 5% may be defensible. For a property near a university with annual lease cycles, 8 to 10% is more honest. When you get to stress testing later, you will push this number higher. For now, use your base-case assumption.
Ancillary Income covers everything beyond unit rent: parking fees, pet fees, laundry income, storage unit fees, and late charges. These are real dollars, but they require verification. Ask for 12 months of bank statements or a trailing 12-month (T-12) operating statement. Do not model ancillary income from a proforma line item the seller created. If the laundry machines have been broken for six months, that income is not real.
Effective Gross Income (EGI) is GPR minus vacancy and credit loss, plus verified ancillary income. This is the number you carry forward into your expense forecast.
Forecast Operating Expenses the NC Way
Operating expenses are where most buyers underestimate their true cost of ownership. Use the following categories and apply NC-specific adjustments where noted.
Property Management: Budget 8 to 12% of collected rent even if you plan to self-manage. This is not optional padding. It represents the true cost of professional oversight and keeps your model honest if you ever need to hand off management. Local NC property managers in markets like Raleigh, Charlotte, and Greensboro typically fall in this range for small multifamily.
Repairs and Maintenance: A common benchmark is roughly 10% of gross rents for older properties. Adjust upward for deferred maintenance or aging systems. The article on small multifamily inspection red flags covers the physical items that tend to generate surprise repair costs after closing.
Property Taxes: As noted above, underwrite to a full reassessment at your purchase price. Pull the current tax bill, then estimate what the bill becomes if the county resets assessed value to your acquisition price. In some NC counties, this adjustment alone can add several thousand dollars annually to your expense line. If you want to understand your options after closing, the guide on how to appeal NC small multifamily property taxes explains the process.
Insurance: Get an actual quote before you finalize your model. Do not use the seller's current premium as your assumption. Given the structural shifts in NC's insurance market, your quote may be 20 to 40% higher than what the current owner is paying, depending on the property's age, location, and coverage structure.
Utilities: If the property has any owner-paid utilities (water, trash, common area electric), list them as operating expenses. Mixed utility arrangements require their own analysis. The piece on how to analyze multifamily cash flow with mixed utilities covers this in detail.
Capital Expenditure (CapEx) Reserves: Budget $200 to $400 per unit annually for stabilized assets. This reserve covers high-cost items like HVAC replacement, roofing, water heaters, and appliances. It is not an operating expense in the accounting sense, but it is a real cash obligation. Leave it out of your model and you will fund those repairs out of cash flow or equity later.
Total Operating Expenses subtracted from EGI gives you Net Operating Income.
Calculate NOI, Debt Service, and Net Cash Flow
Net Operating Income (NOI) is EGI minus all operating expenses. It does not include mortgage payments, depreciation, income taxes, or CapEx reserves. This is the standard definition used by lenders, appraisers, and buyers when comparing properties. A common mistake is including debt service in the NOI calculation. If you see a proforma where mortgage payments appear above the NOI line, the numbers have been constructed incorrectly.
NOI is also the input for your cap rate calculation. If you want a deeper look at how cap rates translate to value in NC markets, the guide on how to calculate cap rates for small multifamily properties in North Carolina walks through the mechanics.
Debt Service Coverage Ratio (DSCR): Before you calculate net cash flow, check your DSCR. Lenders typically require a minimum of 1.25x, meaning your NOI must be at least 1.25 times your annual principal and interest payment. If your NOI is $48,000 and your annual debt service is $40,000, your DSCR is 1.20x, which falls below most lender thresholds. Run this check early so you know whether the deal is financeable at your target purchase price.
Net Cash Flow is NOI minus annual debt service minus CapEx reserves. This is the actual cash you receive after paying the mortgage and setting aside reserves. It is the number that determines whether the property generates positive monthly income or requires you to write a check.
Cash-on-Cash Return (CCR) is annual pre-tax net cash flow divided by your total equity invested (down payment plus closing costs plus any immediate capital improvements). Stabilized small multifamily assets in NC are generally targeting 7 to 9% CCR in 2026. If your model produces a CCR below 6%, the deal requires either a lower purchase price, better financing terms, or a credible value-add plan with realistic rent upside.
Exit Cap Rate: When you model your hold period (typically five to seven years), apply an exit cap rate that is 25 to 50 basis points higher than your going-in cap rate. This reflects the reality that you cannot predict market conditions at sale and that buyers at your future exit will apply their own underwriting. Building in this cushion prevents you from modeling a profitable exit that depends on cap rate compression.
Stress Test Your Numbers Before You Close
A single-scenario model is not underwriting. It is optimism with a spreadsheet. Before you submit a final offer, run three scenarios using your completed template.
Base Case: Your best estimate of realistic income and expenses, using verified T-12 data, current market rents, and local vacancy rates.
Stress Case: Zero rent growth for two years, vacancy at 8% (or higher if the submarket warrants it), expenses growing at 5% annually, and insurance and taxes at their reset levels. This scenario tells you whether the property still covers debt service if conditions deteriorate.
Upside Case: Modest rent growth (2 to 3% annually), vacancy at the low end of your range, and ancillary income fully stabilized. This scenario tells you what the property is worth if execution goes well, but it should not be the scenario you use to justify your purchase price.
A few additional stress inputs worth running:
- What happens to your CCR if interest rates rise 50 basis points before you close?
- What is your DSCR if one unit sits vacant for four months during a turnover?
- What does your net cash flow look like in year three if a major CapEx item (roof, HVAC) hits earlier than expected?
If the stress case still produces a DSCR above 1.10x and the base case produces a CCR in your target range, you have a deal worth pursuing. If the stress case breaks the debt service coverage, you need to renegotiate the price or walk.
Once your numbers hold up across all three scenarios, the next step is connecting with sellers who are actually ready to transact. FlowExit works with serious NC multifamily owners who are prepared to sell, which means you spend less time on properties that never close and more time on deals that match your underwritten return targets. Visit flowexit.com to see current opportunities in your target NC market.