How expense growth changes apartment cash flow over a hold
A practical guide to preparing an expense-growth sensitivity worksheet for a multifamily acquisition, showing how rising costs affect NOI, debt-service coverage, and the financing conversation.
A practical guide to preparing an expense-growth sensitivity worksheet for a multifamily acquisition, showing how rising costs affect NOI, debt-service coverage, and the financing conversation.
Understand the expense growth risk in your apartment deal
When you underwrite an apartment acquisition, you build a pro forma that projects income and expenses over the hold period. A common assumption is that expenses will stay flat or grow slowly. In practice, property taxes, insurance, maintenance, and utilities can rise faster than rents, especially in markets with high inflation or aging buildings. This guide explains how to prepare a simple worksheet that tests the effect of expense growth on cash flow and debt-service coverage, and how that analysis shapes the financing discussion with lenders.
Prepare a trailing twelve-month operating statement
Before you can project expense growth, you need a reliable baseline. Lenders expect to see a trailing twelve-month (T-12) operating statement for the property, which reports actual income and expenses for each of the past twelve months. The T-12 is a historical record, not a snapshot like the current rent roll. It captures seasonal patterns in utility costs, repairs, and vacancy. [1] The OCC Commercial Real Estate Lending handbook notes that operating statements prepared on a cash basis may understate expenses or overstate income compared with accrual-based statements. For example, if real estate taxes were not paid in a given year but were accrued, the T-12 on a cash basis would show lower expenses than the true economic cost. [1] To get an accurate baseline, compare the T-12 with financial statements prepared on an accrual basis, and ask the seller or current manager whether any expenses were deferred or paid in a different period.
Build an expense-growth sensitivity worksheet
Create a simple spreadsheet with the following columns: - Expense category (e.g., property taxes, insurance, utilities, repairs and maintenance, management fees, replacement reserves) - Current annual amount from the T-12 - Projected annual growth rate (use a range of assumptions) - Projected amount in selected years of the hold - Effect on net operating income (NOI) at each growth assumption
For each expense category, list the current amount and then apply the growth rates. Subtract the projected expenses from projected gross income (which you can hold flat or grow at a separate assumed rent-growth rate) to show NOI under each scenario. This worksheet is a suggested way to prepare information, not a mandatory lender process. It helps you identify which expenses are most sensitive to growth and how much cash flow cushion you have.
Compare NOI with debt service under stress
Debt-service coverage ratio (DSCR) is calculated by dividing NOI by annual debt service requirements. [1] The OCC handbook notes that factors such as DSCR should be considered under both normal and stressed conditions to determine whether a property will remain viable during economic stress. [1] Your worksheet should show DSCR at each expense-growth scenario. A DSCR below one means cash flow is insufficient to cover debt service. [1] The appropriate DSCR should consider the loan amortization period and the expected volatility of cash flow. [1] Properties with stable, long-term net leases to creditworthy tenants may support a lower DSCR. [1] Your worksheet should show the DSCR at each growth assumption so you can discuss with lenders what stress level they require.
Identify expense categories most at risk
Common expense categories that grow faster than general inflation include: - Property taxes: reassessments after a sale often increase taxes, and local tax rates can rise independently. - Insurance: premiums for property and liability coverage have risen sharply in some markets due to weather events and claims trends. - Utilities: energy and water costs can increase faster than rent growth, especially in older buildings. - Repairs and maintenance: deferred maintenance may surface after acquisition, requiring catch-up spending.
The worksheet should include a line for replacement reserves, which are funds set aside for recurring capital expenditures like HVAC, roof, or parking lot replacements. [1] The OCC handbook notes that funds for recurring capital expenditures, such as replacement reserves, may not be shown as an expense on tax returns. [1] Including a realistic reserve line in your worksheet ensures you are not overstating NOI.
Use the worksheet in your financing request
[2] Lenders quote on what they are given, so providing a clear analysis shows you have thought through the risks. [2] The worksheet helps you answer questions such as: - What happens to DSCR if property taxes increase after reassessment? - Can the property still support debt service if insurance premiums rise significantly? - How much equity contribution or additional reserves might be needed to maintain coverage?
This analysis is not a guarantee of loan approval, but it positions you as a prepared sponsor.
Distinguish source facts from assumptions
The OCC handbook provides supervisory guidance for banks, not rules that bind every borrower or nonbank lender. The handbook's discussion of cash-basis vs. accrual-basis statements, stress testing, and DSCR analysis is bank supervisory guidance, not a mandatory requirement for your worksheet. Your worksheet is a practical tool you prepare in your own words. The specific growth rates you choose are your assumptions, not lender requirements. The DSCR minimum you target should be discussed with the actual lender, not assumed from a generic benchmark. The OCC handbook does not prescribe a specific DSCR floor; it says the appropriate DSCR should consider the loan amortization period and expected cash flow volatility. [1]
FAQs
How do I reconcile a T-12 with a current rent roll?
The current rent roll is a snapshot of today's occupancy and rents. The T-12 is twelve months of historical operating data, which may be reported on a cash or accrual basis. To compare them, adjust the rent roll for any leases that have changed in the past year and for any seasonal vacancy patterns shown in the T-12. The T-12 may show actual collected income, while the rent roll shows gross potential rent. Distinguish gross rent, collected income, NOI, capital expenditures, debt service, and equity cash flow when you build your worksheet.
Can I use seller-provided financial statements as my baseline?
Yes, but verify the reporting basis. If the seller's statements are on a cash basis, compare them with accrual-based statements or with expenses incurred by comparable properties, adjusted for supported variances and lease terms. [1] The OCC handbook says this comparison is helpful to develop a stabilized estimate of NOI. [1] Ask the seller whether any expenses were deferred or paid in a different period, and whether any capital expenditures are included in the operating statement.
Does expense growth affect the loan amount or just the DSCR?
Expense growth can affect both. If the lender uses a lower NOI to underwrite the loan, the maximum loan amount may be smaller. [1] The OCC handbook says underwriting includes determining whether the borrower can meet a realistic repayment plan from available cash flow. [1] A higher expense growth assumption reduces projected NOI, which may lower the loan amount or require a larger equity contribution. The worksheet helps you anticipate this discussion.
We will tell you how we would approach it. Submission is a preliminary request, not an engagement or lender submission.
Model this deal and request financing
Run a multifamily acquisition or value-add model with your own numbers in the financing workbench. Results are calculated on the server with the assumptions shown. If you choose to send the request, you get a preliminary lender-package PDF and can attach your rent roll, T-12 or OM.
Opens the financing workbench operated by Wraith Real Estate. Nothing goes to any lender without Wraith's review and your agreement.
Talk through your financing
Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).