How to create an assumption register for an apartment financing request
A practical guide to building an assumption register that documents every underwriting input for an apartment acquisition, helping sponsors demonstrate disciplined underwriting to lenders.
A practical guide to building an assumption register that documents every underwriting input for an apartment acquisition, helping sponsors demonstrate disciplined underwriting to lenders.
When a sponsor submits an apartment financing request, the lender will evaluate whether the projected net operating income (NOI) of the property supports the expected value upon completion [1]. One way to prepare for that evaluation is to create an assumption register: a single document that lists every input used in the underwriting, states the source for that input, and notes whether the input is a fact or an assumption. This guide explains how to build that register and how it affects the financing discussion.
The assumption register is a working document you prepare before approaching a lender. It is not a loan application or a term sheet. It is a record of the choices you made when you built the pro forma, the budget, and the business plan. When a lender reviews your request, the register shows that you have thought through each variable and can point to a documented basis for your numbers.
What an assumption register records
The register is a simple spreadsheet or table with four columns: input category, input value, source of the input, and fact or assumption. The input categories correspond to the main sections of your financing request. For an apartment acquisition, those categories include the rent roll, operating expenses, capital expenditures, the business plan for improvements, the sources and uses of funds, and the sponsor financial information [2].
Each row in the register records one input. For example, one row might record the projected vacancy rate, the percentage you used, the source (such as the current rent roll or a market report), and whether that input is a fact (the current vacancy rate) or an assumption (the projected vacancy rate after lease-up).
Why lenders look for an assumption register
For loans financing the acquisition of an underperforming property that the borrower intends to improve, it is important for the bank to closely examine the borrower's assumptions to determine the likelihood that the projections can be realized and assess the borrower's ability to achieve its objectives [1]. When you provide an assumption register, you give the lender a clear picture of where your numbers come from. That can reduce the number of follow-up questions and speed up the review process.
The register also helps you identify which inputs are most sensitive to change. If the lender adjusts one assumption, you can see immediately how that change flows through the rest of the underwriting, without implying any specific benchmark.
How to build the register: suggested steps
These steps are a suggested way to prepare information for your financing request. They are not a mandatory lender process.
First, list every input you used in your pro forma. Start with the rent roll: current gross rent, collected income, and any concessions. Then add operating expenses, including property taxes, insurance, utilities, management fees, and maintenance. Include capital expenditures for deferred maintenance or planned upgrades. Add the business plan assumptions, such as the time frame for achieving full occupancy and the anticipated rents after improvements [1].
Second, identify the source for each input. For current data, the source might be the trailing twelve months of operating statements, which is a historical record covering twelve months and may be reported on a cash or accrual basis [2]. For projected data, the source might be a market report, an appraisal, or your own experience with similar properties. If you do not have a source, note that the input is an assumption.
Third, distinguish facts from assumptions. A fact is a measurable current condition, such as the current vacancy rate from the rent roll. An assumption is a projection about future conditions, such as the projected vacancy rate after lease-up. Label each input clearly.
Fourth, reconcile the timing of your data. A current rent roll is a snapshot of the property at one point in time [2]. The trailing twelve months of operating statements show the actual income and expenses over the past year. These two sources may show different totals because the rent roll reflects current leases while the trailing twelve months reflect historical collections. Note the difference in your register.
Fifth, compare the net operating income from the trailing twelve months to your projected net operating income. The register should show the historical net operating income and the projected net operating income side by side. If there is a gap, explain the reason, such as planned rent increases or expense reductions.
What to include in the register for an apartment acquisition
For an apartment acquisition, the register should cover the following categories:
- Rent roll inputs: current gross rent, collected income, concessions, vacancy rate, and lease renewal trends [1]. Use the lender's actual test or the sponsor's documented assumption for vacancy and lease renewal trends.
- Operating expense inputs: property taxes, insurance, utilities, management fees, maintenance, and reserves. Distinguish historical expenses from projected expenses, noting the basis for any changes.
- Capital expenditure inputs: deferred maintenance items, planned upgrades, and the timing and cost of each item.
- Business plan inputs: the value-add plan, the time frame for improvements, and the projected rent after improvements, based on documented assumptions or market sources.
- Sources and uses of funds: the purchase price, loan amount, equity contribution, and any other sources of capital [2].
- Sponsor financial information: financial statements for the principals and guarantors, and the schedule of real estate owned [2].
How the register affects the financing discussion
The register helps you have a more productive conversation with the lender. When the lender asks about a particular input, you can point to the register and show the source and the basis for your number. That can build confidence in your underwriting.
The register also helps you negotiate. If the lender challenges an assumption, you can discuss whether the adjustment is reasonable and how it affects the overall deal. If you have multiple lenders reviewing the request, the register allows you to compare their reactions to the same set of assumptions.
Distinguishing source facts from assumptions in practice
A practical example: you project that after renovations, the property will achieve higher rents per unit per month. The current rent roll shows actual rents per unit per month. In the register, you would record the current rent as a fact, with the source being the rent roll. You would record the projected rent as an assumption, with the source being a market report or your experience with similar properties.
The same distinction applies to expenses. The trailing twelve months show actual operating expenses for the year. You project that after improvements, expenses will be lower. The register records the historical expense as a fact and the projected expense as an assumption, with the basis for the reduction explained.
A concrete workpaper to prepare
The assumption register itself is the workpaper to prepare. It does not need to be long or complex. A simple spreadsheet with the four columns listed above is sufficient. The key is to be thorough and honest about which inputs are facts and which are assumptions.
When you send the register to the lender, include it as a separate document or as a tab in your pro forma workbook. The lender can then refer to it during underwriting.
Final note on lender review
Lenders quote on what they are given [2]. The more complete and transparent your request, the more efficiently the lender can evaluate it. The assumption register is one tool to achieve that transparency.
Frequently asked questions
Does the assumption register guarantee lender approval?
No. The register is a tool to help you prepare your financing request and to demonstrate disciplined underwriting. Lender approval depends on many factors, including the property, the sponsor, the lender's portfolio, and market conditions [2]. The register does not guarantee any particular outcome.
Do I need to update the register after the lender reviews it?
Yes, if the lender requests adjustments to your assumptions, update the register to reflect the new inputs. That keeps the document current and helps you track changes throughout the financing process.
Can I use the same register for multiple lenders?
Yes. The register is your document, and you can share it with any lender you approach. Having a single register helps ensure consistency across lender discussions.
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).