Comparing budgeted expenses with actual property results for a lender
Turn a common lender request into a strategic advantage by learning how to prepare an expense reconciliation workpaper that shows a lender you understand your property's operations and can defend your underwriting assumptions.
Turn a common lender request into a strategic advantage by learning how to prepare an expense reconciliation workpaper that shows a lender you understand your property's operations and can defend your underwriting assumptions.
A lender asks for budget versus actual expenses and many sponsors hand over a stack of annual statements. That is a missed opportunity. A well-prepared expense reconciliation shows a lender that you know where your money goes, why variances happened, and whether those variances are one-time events or a sign of something structural. This guide explains how to prepare a concrete workpaper that supports your financing request and answers the questions a prudent lender will ask.
Why a lender asks for this comparison
Lenders use historical operating statements to develop a stabilized estimate of net operating income (NOI). [1] The OCC's Commercial Real Estate Lending handbook explains that a key underwriting objective is to develop an NOI that represents a stabilized estimate of income and expenses. Comparing budgeted to actual expenses helps a lender decide which line items to underwrite at historical averages, which to adjust, and which to flag for further inquiry. A sponsor who can explain each variance demonstrates operational competence and reduces the perceived risk of the loan.
The timing difference between a rent roll and a T-12
A current rent roll is a snapshot of who is in place, what they pay, and what space they occupy today. A trailing twelve-month (T-12) operating statement is a historical report of income received and expenses paid over the past twelve months. These two documents cover different periods and different types of information. The rent roll shows contractual rent; The T-12 reports historical income and expenses on its stated accounting basis. Comparing the two reveals collection issues, concessions, or rent abatements that do not appear on the rent roll. When you prepare your reconciliation, start by noting the date of the rent roll and the period covered by the T-12. A lender will notice if the rent roll shows full occupancy but The T-12 reports historical income and expenses on its stated accounting basis at a lower percentage of potential gross rent.
Prepare a budget versus actual variance workpaper
Create a simple spreadsheet with the following columns: line item, budgeted amount, actual amount, variance in dollars, variance in percentage, and explanation. List every operating expense line item from your most recent fiscal year. Include property taxes, insurance, utilities, repairs and maintenance, management fees, payroll, legal and professional fees, and any other recurring cost. For each line item, record the budgeted amount and the actual amount. Calculate the variance. Then write a one- or two-sentence explanation for any variance that is significant according to your lender's actual test or the sponsor's documented assumption.
What to look for in each variance
Property taxes. [1] The OCC handbook notes that for hotels, property taxes should reflect the actual assessment and should be expected to increase after a sale or renovation. If your actual property taxes are higher than budgeted, check whether a reassessment occurred during the year. If a reassessment is pending after your acquisition, budget for a higher amount in your pro forma.
Insurance. Insurance premiums have risen sharply in many markets. If your actual insurance cost exceeds budget, document the renewal date and the premium increase. A lender will expect you to underwrite at the higher actual amount going forward.
Utilities. Weather and occupancy changes affect utility costs. Compare actual usage to budgeted usage, not just cost. A variance driven by rate changes is different from one driven by higher consumption, which may indicate a maintenance issue.
Repairs and maintenance. A large variance here may be a one-time capital item that should be excluded from stabilized underwriting. If you replaced a roof or an HVAC unit, separate that cost from routine maintenance. Explain what the work was and that it is not expected to recur.
Management fees. [1] The OCC handbook references management fees typically expected as a percentage of gross revenues for hotels. For other property types, the management fee is usually a percentage of effective gross income, though the OCC handbook does not specify a standard range for non-hotel properties. Compare your actual management fee to the contract rate. A variance may mean the manager earned a performance bonus or that the fee was calculated on a different base.
Reconcile the reporting basis
[1] The OCC handbook warns that a tax return prepared on a cash basis may understate expenses such as real estate taxes that were not paid during the year, and that operating statements prepared on a cash basis have the same issue. Before you compare budget to actual, identify whether your financial statements are prepared on a cash basis or an accrual basis. If they are cash basis, add back unpaid expenses and subtract uncollected income to approximate an accrual picture. Document the adjustment. A lender will want to see a consistent basis across all periods you present.
Distinguish gross rent, collected income, NOI, and debt service
Your workpaper should clearly separate these four figures. Gross rent is the total contractual rent from the rent roll. Collected income is what actually arrived in the bank account. NOI is collected income minus operating expenses before debt service. Debt service is the annual principal and interest payment on the proposed loan. The DSCR, or debt-service coverage ratio, is NOI divided by debt service. [1] The OCC handbook states that the DSCR measures the borrower's ability to service its debt and that the determination of an appropriate DSCR should consider the loan amortization period and expected volatility of cash flow. Do not equate a cap rate with a debt constant; they measure different things. A cap rate values the property; a debt constant measures the annual cost of debt.
Identify the effect on the financing discussion
A reconciliation that shows actual expenses consistently higher than budget will reduce the NOI a lender is willing to underwrite. That may lower the maximum loan amount or require a higher debt-service coverage ratio based on the lender's underwriting criteria. A reconciliation that shows actual expenses at or below budget, with clear explanations for any variances, supports your pro forma assumptions and may allow a lender to underwrite at your historical levels. If your actual NOI is volatile, a lender may require a higher debt-service coverage ratio or a shorter amortization to compensate for the risk. [1] The OCC handbook notes that a lower debt-service coverage ratio may be a prudent trade-off for a shorter amortization period or appropriate for properties with stable and certain cash flows.
Suggested way to prepare your information
- Record the reporting basis of each financial statement you provide (cash or accrual).
- Reconcile the rent roll date to the T-12 period and note any timing gaps.
- Build the budget versus actual variance workpaper with explanations for each line item.
- Calculate gross rent, collected income, NOI, and debt service separately.
- Compare your actual NOI to the NOI in your pro forma and write a brief narrative explaining any difference.
- Ask the actual lender whether they prefer to underwrite at your historical averages or at industry benchmarks for any line item.
FAQs
Should I include capital expenditures in the expense reconciliation?
No. Capital expenditures are not operating expenses and should not appear in the NOI calculation. If you replaced a major building system during the year, record it separately and explain that it is a one-time cost that will not recur in the stabilized operating period. A lender may still ask about deferred maintenance or future capital needs, but the expense reconciliation should focus on recurring operating costs.
What if my actual expenses are much lower than budget?
A large favorable variance may raise questions about whether you are deferring maintenance or underinsuring the property. Explain why the variance occurred. If you negotiated a lower insurance premium or a property tax appeal, document that. If you simply did not spend money on repairs that were needed, a lender may require a reserve for replacement or adjust the underwriting to reflect expected future costs.
How many years of history should I prepare?
Lenders may want to see multiple years of operating history for an existing property. [1] The OCC handbook references analysis over at least a three-year period for religious organizations. For other property types, lenders may request multiple years of history, but the OCC does not prescribe a universal requirement. If you have only one year of ownership, provide the prior owner's statements if available, or explain why the period is shorter. The more history you can show, the more confidence a lender will have in the stabilized NOI.
We are not a lender and do not make loans or loan commitments. All financing is subject to the lender's underwriting and approval. If you have a property, a business plan, and an amount and timing in mind, send us those details and we will tell you how we would approach the financing.
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).