Why replacement reserves and operating expenses need separate schedules
A practical guide for sponsors to prepare distinct replacement reserve and operating expense schedules, explaining how lenders use each in underwriting and how to reconcile cash-basis tax returns with accrual-based financial statements.
A practical guide for sponsors to prepare distinct replacement reserve and operating expense schedules, explaining how lenders use each in underwriting and how to reconcile cash-basis tax returns with accrual-based financial statements.
Understand the purpose of each schedule
A lender's underwriting analysis separates replacement reserves from operating expenses because each affects net operating income (NOI) differently. Operating expenses are the recurring costs to run a property—management fees, insurance, property taxes, utilities, and routine maintenance. Replacement reserves are funds set aside for capital replacements like roofs, HVAC systems, and parking lots that occur periodically but not every year. [1] The OCC Commercial Real Estate Lending handbook explains that some capital expenditures used to calculate NOI may not appear as expenses on tax returns, specifically funds for recurring capital expenditures captured in a replacement reserve. Distinguishing these schedules helps the lender develop a stabilized estimate of income and expenses.
Prepare a separate replacement reserve schedule
Create a document that lists each major capital item, its estimated useful life, and the annual reserve amount needed to replace it. For hotels, the OCC handbook provides guidance on replacement reserves for furniture, fixtures, and equipment without specifying exact percentages. For other property types, base your estimates on the age and condition of improvements observed during property inspection. A suggested way to prepare this information is to record each item, its current condition, replacement cost, and the number of years until replacement is needed. Divide the replacement cost by the years to get an annual reserve amount. This schedule demonstrates to the lender that you have identified future capital needs and have a plan to fund them without disrupting cash flow.
Reconcile cash-basis tax returns with accrual statements
Tax returns prepared on a cash basis reflect only income and expenses actually received or paid during the year. [1] This can understate expenses and overstate income compared with financial statements prepared on an accrual basis. For example, if real estate taxes were not paid during the year, a cash-basis return would show lower expenses than actually incurred. The OCC handbook advises comparing reported expenses with expenses incurred by comparable properties, adjusted for supported variances and lease terms. [1] When preparing your schedules, identify the reporting basis for each document you provide. If your tax returns are cash basis, note this and provide a reconciliation to accrual-based operating statements. This reconciliation helps the lender understand the true economic performance of the property.
Distinguish gross rent, collected income, NOI, and debt service
Your schedules should clearly separate these line items. Gross rent is the total contractual rent from all leases. Collected income is the actual income received after vacancy and collection losses. NOI is gross income less operating expenses, excluding debt service, depreciation, and capital items. [1] Debt service is the annual principal and interest payments on the loan. The debt-service coverage ratio (DSCR) is calculated by dividing NOI by annual debt service requirements. [1] The OCC handbook notes that the determination of an appropriate DSCR should consider the loan amortization period and expected volatility of cash flow. [1] Present these figures in your schedules so the lender can see the progression from gross rent to available cash flow after debt service, without referencing specific numerical benchmarks.
Provide a trailing twelve-month operating statement
A current rent roll is a snapshot of today's occupancy and rents. A trailing twelve-month (T-12) operating statement shows twelve months of historical income and expenses, which may be reported on a cash or accrual basis. The T-12 allows the lender to see seasonal patterns, collection trends, and expense fluctuations over a full year. When comparing the T-12 to the rent roll, explain any timing differences. For example, if the rent roll shows higher occupancy than the T-12 average, note whether occupancy has recently improved and what caused the change. This comparison helps the lender assess whether current performance is sustainable, without implying specific occupancy benchmarks.
Include property-specific considerations in your analysis
The OCC handbook lists property-specific considerations including occupancy history, collection losses, rents compared with competitive properties, management quality, quality of construction, age and condition of improvements, and availability of individual unit metering for utilities. [1] For each item, record your observations and any supporting documentation. For example, if you have a management agreement, include it and note the management fee percentage. The OCC handbook provides guidance on management fees for hotels without specifying exact percentages. For other property types, your management agreement will specify the fee. Include this information in your schedules to show the lender that you have considered all relevant factors.
Prepare an evidence checklist for your loan request
Create a document that lists every item the lender will need to underwrite your loan. [2] For each item, note whether you have it ready and any adjustments needed. This checklist helps you organize your submission and ensures nothing is overlooked. [2]
Frequently asked questions
How do I determine the right amount for replacement reserves?
Base your estimate on the actual condition and expected life of each major capital item. List each item, its replacement cost, and the number of years until replacement is needed. Divide the cost by the years to get an annual reserve amount. For hotels, the OCC handbook provides guidance on reserves for FF&E without specifying exact percentages. Adjust based on your property's age and condition.
What if my tax returns are on a cash basis?
Identify the reporting basis on each document you provide. If your tax returns are cash basis, note this and provide a reconciliation to accrual-based operating statements. Explain any differences, such as unpaid real estate taxes that would understate expenses on a cash-basis return. [1] This helps the lender develop a stabilized estimate of income and expenses.
How do I explain a difference between my rent roll and T-12?
Compare the rent roll snapshot to the T-12 average. If occupancy has recently improved, note the change and explain what caused it, such as new leases or renovations. If expenses in the T-12 include one-time items, identify them separately. This comparison helps the lender assess whether current performance is sustainable.
Run the numbers on your deal
Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.
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).