Why an acquisition model should show the debt balance at exit
An acquisition pro forma that stops at the loan closing date misses the most important underwriting question: does the property generate enough cash to pay down the debt before the loan matures? This guide explains how to model the ending debt balance, reconcile the rent roll with the trailing twelve-month operating statement, and prepare a document workpaper that shows the lender the same cash-flow story the sponsor sees.
An acquisition pro forma that stops at the loan closing date misses the most important underwriting question: does the property generate enough cash to pay down the debt before the loan matures? This guide explains how to model the ending debt balance, reconcile the rent roll with the trailing twelve-month operating statement, and prepare a document workpaper that shows the lender the same cash-flow story the sponsor sees.
A sponsor who provides a lender with an acquisition model showing only the initial loan amount leaves out a critical part of the underwriting story. Lenders evaluate the loan based on its status at maturity, not just at closing. The OCC's Commercial Real Estate Lending handbook states that for interest-only loans, the property should meet the bank's repayment capacity requirements as though the loan were amortizing in a manner consistent with safe and sound banking practices [1]. This means lenders want to understand what the debt balance will be at loan maturity and whether the property's cash flow can support repaying that balance.
Distinguish the rent roll from the trailing twelve-month statement
The rent roll provides a snapshot of current occupancy and rent. It shows who occupies the building, their rent amounts, and lease expiration dates. The T-12 statement summarizes twelve months of historical operating data, revealing what the property actually collected, spent, and delivered as net operating income (NOI) over the past year. These reports serve different purposes and rarely show the same totals. The rent roll reflects gross rent at a point in time, while The T-12 reports historical income and expenses on its stated accounting basis over time, net of vacancy, bad debt, and concessions. Lenders need both to compare current rents against historical collections. Differences between the two do not indicate errors but should be explained by the sponsor as seasonal effects, lease-up activity, or permanent occupancy changes.
To prepare the workpaper, list each unit from the rent roll with its current monthly rent, then add a column showing the average monthly rent collected for that unit over the T-12 period. The difference between these columns forms the basis for pro forma rent assumptions.
Build the cash-flow layers from gross rent to equity cash flow
A pro forma that jumps directly from gross rent to NOI omits important details lenders need to verify. The workpaper should present five cash-flow layers:
Each layer should have its own line in the workpaper so the lender can track cash consumption.
Model the debt balance at maturity, not just at closing
To prepare this section of the workpaper, use the proposed loan amount, interest rate, amortization period (if any), and loan term to calculate monthly payments and project the balance month by month until maturity. If the loan includes an interest-only period followed by amortization, show the balance at the end of the interest-only period and at maturity. Lenders use this projection to assess whether NOI can support debt service.
Compare NOI to debt service with a debt yield check
Debt yield, calculated as NOI divided by the loan amount, is a common metric to quickly assess loan risk. Lower debt yields indicate higher leverage [1]. The workpaper should include debt yield calculations at closing and at maturity. A declining debt yield over time may raise lender concerns. Debt yields reflecting normalized or higher interest rates can help establish stressed loan amounts less vulnerable to rate increases [1]. Sponsors can use this approach to demonstrate how debt yield would respond to rising interest or capitalization rates.
Prepare sponsor financial information for a global cash-flow analysis
Lenders evaluate the sponsor's overall financial situation. The OCC handbook recommends comprehensive global cash-flow analyses even when significant liquid assets exist, as those assets may be needed for other liabilities or cash flow shortfalls [1]. Sponsors should prepare schedules of real estate owned, financial statements for principals and guarantors, and personal cash-flow statements including debt payments, taxes, and living expenses. The analysis should consider the liquidity of assets securing guarantees, and unpledged assets should not substitute for project equity [1]. The workpaper should include a section showing how the property's equity cash flow fits into the sponsor's broader financial picture.
Document the loan request for the lender
After completing the workpaper, the sponsor should assemble the loan request package including the business plan, sources and uses of funds, development budget or operating history, pro forma with assumptions, sponsor's real estate owned schedule, financial statements, and organizational documents [2].
Frequently asked questions
Does the rent roll or the T-12 determine the lender's underwriting NOI?
Neither alone determines underwriting NOI. The lender uses the T-12 as the historical baseline and the rent roll as the current snapshot. The pro forma should reconcile the two and explain any differences. Lenders may also stress test NOI assumptions to ensure debt service coverage under adverse conditions.
What is the difference between debt yield and debt service coverage ratio?
Debt yield is NOI divided by the loan amount, independent of interest rate and amortization. Debt service coverage ratio (DSCR) is NOI divided by annual debt service (principal and interest). Debt yield provides a quick risk assessment and complements DSCR and LTV ratios [1]. Both should be included in the workpaper.
How should a sponsor handle a loan that is interest-only for the full term?
The property should meet repayment capacity requirements as if the loan were amortizing [1]. The sponsor should model the debt balance at maturity assuming amortization and demonstrate that NOI supports the higher debt service. The workpaper should show both actual interest-only payments and hypothetical amortizing payments with corresponding DSCR calculations.
It is not a lender and does not make loans or loan commitments. All financing is subject to lender underwriting and approval [2].
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).