How to document recurring maintenance in a multifamily acquisition model
This guide explains how to prepare a concrete maintenance reserve worksheet that distinguishes recurring upkeep from deferred capital needs, and shows how that information affects a lender's view of the property's cash flow and condition.
This guide explains how to prepare a concrete maintenance reserve worksheet that distinguishes recurring upkeep from deferred capital needs, and shows how that information affects a lender's view of the property's cash flow and condition.
When preparing an acquisition model for a multifamily property, the recurring maintenance line item often receives less focus than the rent roll or market cap rate. However, lenders carefully review how ongoing physical care of the building is accounted for. The OCC Commercial Real Estate Lending handbook highlights that inadequate maintenance can pose significant risks to multifamily properties, and deferred maintenance can increase loan losses and expenses if foreclosure occurs [1].
This guide outlines the documents and workpapers you can prepare to demonstrate to a lender that you have identified, budgeted for, and can sustain the property's recurring maintenance needs. The objective is not to predict every repair but to show a clear understanding of the property's physical condition and a plan to maintain it.
Gather the property's current maintenance records
Begin by collecting maintenance records from the seller or property manager. A comprehensive file should include work orders, invoices, and service contracts covering the past twelve months. Look for evidence of regular servicing for HVAC, plumbing, electrical systems, roofing, parking lots, and common area finishes. The OCC handbook advises that banks monitor property maintenance and improvements to ensure they are timely and appropriate, and that inspections should determine how many vacant units are rentable in their current condition [1]. Your documentation should address this for each vacant unit.
Record the frequency and cost of each recurring service. For example, note whether the elevator is inspected monthly or quarterly, the landscaping contract frequency, and the cost for each service. If the property has individual unit metering for utilities, this affects both your expense model and the lender's assessment of utility risk, as the OCC handbook identifies individual unit metering availability as a property-specific consideration [1].
Create a trailing twelve-month maintenance expense schedule
Develop a spreadsheet listing each maintenance category and the actual monthly costs incurred over the past twelve months. The OCC handbook emphasizes careful analysis of historical operating expenses [1]. A trailing twelve-month (T-12) schedule is standard for lenders, showing actual spending and capturing seasonal variations that a single month or annual average might miss. Specify whether the T-12 is based on cash collections or accrual accounting to clarify the basis of reported expenses.
Calculate the monthly average, as well as the highest and lowest months for each category. This helps identify whether the property has been under-maintained. If the seller deferred normal upkeep to inflate net operating income, the trailing twelve months will reveal unusually low maintenance spending. The OCC handbook notes that undercapitalized borrowers may neglect necessary maintenance when cash flows are insufficient, leading to increased tenant turnover and vacancies [1]. Your documentation should demonstrate that you do not intend to repeat this pattern.
Separate recurring maintenance from deferred capital needs
A frequent error in acquisition models is combining all repair spending into one line item. Lenders require a clear distinction. Recurring maintenance covers predictable, ongoing work that preserves the property's current condition. Deferred maintenance refers to backlog repairs the seller did not complete, such as roof replacement or parking lot repaving.
The OCC handbook states that appraisals should reflect the property's actual physical condition, use, and zoning designation, known as the 'as is' value [1]. If deferred maintenance exists, document it separately in your sources and uses of funds and show how acquisition or bridge financing will address it. Lenders want assurance that cash flow supports necessary replacements and upgrades over time [1].
Prepare a deferred maintenance log listing each item, estimated cure cost, priority, and completion timeline. This log becomes part of your business plan and shows the lender you have a realistic understanding of the property's condition.
Develop a maintenance reserve worksheet
A practical workpaper for this task is a maintenance reserve worksheet. This is a suggested format, not a required lender form. The worksheet should have three sections:
- Section one: List each recurring maintenance category, trailing twelve-month actual cost, and the monthly average budgeted going forward.
- Section two: List deferred maintenance items, estimated cure costs, and planned completion months.
- Section three: Show the total monthly reserve set aside and how it compares to the property's net operating income.
The OCC handbook notes that operating expenses are an important consideration relative to the property's revenue [1]. Your worksheet should help the lender see where your maintenance spending fits within the overall operating expense context and whether your reserve is sufficient. If your budgeted maintenance is significantly lower than the trailing twelve-month actual, be prepared to explain why.
Reconcile the maintenance reserve with the rent roll and operating statements
A current rent roll provides a snapshot of tenants and their rents, while a trailing twelve-month operating statement records historical income and expenses. These documents serve different purposes, so explain timing differences before comparing totals.
The rent roll shows gross rent scheduled for the current month. Operating statements show collected income and actual expenses for the past twelve months. To reconcile, compare the gross rent on the current rent roll to the average collected income from the trailing twelve months. The difference represents collection loss, which the OCC handbook identifies as a property-specific consideration [1]. Your maintenance reserve should be based on collected income, not gross rent, since only received cash is available for expenses. Note that a rent-loss gap is not effective gross income.
Clarify cash flow layers in your model
Your acquisition model should distinctly separate gross rent, collected income, net operating income, capital expenditures, debt service, and equity cash flow. The OCC handbook advises banks to assess whether cash flow is sufficient to cover necessary replacements and upgrades over time [1]. Lenders need to see each layer clearly.
- Gross rent: Total rent from all signed leases.
- Collected income: Gross rent minus vacancies and collection losses.
- Net operating income: Collected income minus all operating expenses, including the maintenance reserve.
- Capital expenditures: Large, infrequent costs for items with useful lives beyond one year, such as roofs or HVAC systems.
- Debt service: Principal and interest payments on the loan.
- Equity cash flow: Remaining cash after expenses, capital reserves, and debt service.
Place your maintenance reserve within operating expenses, not capital expenditures. Recurring maintenance is an operating expense because it maintains the property's current condition. Capital expenditures are separate and typically funded from a different reserve or initial loan proceeds.
Consult the lender about reserve requirements
Lenders vary in whether they require a specific maintenance reserve held in a separate account or simply budgeted in the operating pro forma. The OCC handbook states that bank staff should confirm that property descriptions on the mortgage, security agreement, and title insurance policy match [1]. It does not mandate a particular reserve structure. Your best source of information is the lender you are working with.
When you receive a term sheet, ask if the lender requires a physical maintenance reserve, a deferred maintenance reserve, or both. Inquire how the reserve is funded, whether it is held in cash or a letter of credit, and if the balance can be used for other purposes. Document these details and include them in your closing checklist.
Frequently asked questions
How far back should I go when gathering maintenance records?
A trailing twelve months is the standard period lenders expect. This timeframe captures seasonal variations and provides a full operating history cycle. If management has recently changed, be prepared to explain any gaps or inconsistencies.
Should I include a maintenance reserve for a property that appears to be in good condition?
Yes. Even well-maintained properties incur recurring costs for painting, landscaping, elevator service, and minor repairs. The OCC handbook advises assessing whether cash flow supports necessary replacements and upgrades over time [1]. Including a reserve shows you have planned for these costs rather than assuming they will not occur.
What if the seller's maintenance records are incomplete or unavailable?
Document what you can verify and note any gaps. Industry benchmarks can serve as temporary placeholders, but plan to conduct a property condition assessment soon after closing to establish a baseline. The lender may require this assessment as a loan condition.
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).