Reading a monthly debt balance schedule before comparing financing options
How to prepare a debt balance schedule, reconcile it with the rent roll and trailing operating statements, and use the resulting evidence to compare financing options with lenders.
How to prepare a debt balance schedule, reconcile it with the rent roll and trailing operating statements, and use the resulting evidence to compare financing options with lenders.
What a debt balance schedule is and why it matters for financing
A monthly debt balance schedule lists each loan on a property, its current principal balance, interest rate, payment terms, maturity date, and the monthly payment (principal and interest) for the trailing twelve months. Lenders use this schedule to calculate debt service coverage, which compares net operating income (NOI) to total debt payments. The OCC Commercial Real Estate Lending handbook states that examiners review current rent rolls and leases, assess cash flow adequacy to meet debt service requirements, and analyze the potential effect on future debt-service coverage from tenant turnover [1]. Preparing this schedule yourself ensures you have the same numbers the lender will use, so you can spot gaps or errors before they affect your financing discussion.
How to build a monthly debt balance schedule
Start with a spreadsheet. For each existing loan on the property, record: lender name, loan number, original amount, current balance, interest rate, amortization term, maturity date, and the monthly payment for each of the past twelve months. The OCC handbook notes that examiners may reconcile the trial balance to the general ledger and examine notes for completeness, reconciling date, amount, and terms to the trial balance [1]. You are doing the same work in advance. Include all loans secured by the property, including mezzanine debt if applicable. For construction loans, record the expected draw schedule and the resulting balance each month. Label the schedule clearly so a lender can follow it without guessing.
Reconciling the balance schedule with the rent roll and T-12
A current rent roll is a snapshot of in-place leases, showing unit, tenant, rent, and lease term as of today. A trailing twelve months (T-12) operating statement shows actual income and expenses for each of the past twelve months. These two documents serve different purposes. The rent roll shows what rents should be; The T-12 reports historical income and expenses on its stated accounting basis. To compare them, line up the rent roll's gross potential rent with the T-12's gross collected income, then subtract vacancy and collection loss, operating expenses, and capital expenditures to arrive at NOI. The OCC handbook says that for income-producing properties, assess the adequacy of cash flow to meet debt service requirements and comment on trends in NOI, vacancy, and expenses [1]. If the T-12 shows a different NOI than the rent roll suggests, investigate the gap: was there a vacancy period, a tenant default, or a one-time expense? Record the reason in your workpaper.
Calculating debt service coverage from the schedule
Debt service coverage ratio (DSCR) is NOI divided by total annual debt payments (principal and interest). Using your balance schedule, sum the monthly payments for all loans secured by the property, then multiply by twelve to get annual debt service. Divide the trailing twelve months' NOI by that annual debt service. The OCC handbook states that for interest-only loans, the property should nonetheless 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 that even if your current loan is interest-only, the lender may underwrite it as if it amortizes over a standard term. To prepare for that, also calculate DSCR using an imputed amortizing payment: use the same interest rate but a 25-year amortization, for example. Compare the two ratios to understand how much cushion you have.
Using debt yield as a complementary metric
Debt yield is NOI divided by loan amount, expressed as a percentage. The OCC handbook explains that debt yield provides a measurement of risk independent of the interest rate, amortization period, and capitalization rate, and that lower debt yields indicate higher leverage [1]. To calculate it, divide your trailing twelve months' NOI by the current total loan balance from your schedule. This number helps lenders size the loan relative to the property's cash flow, especially in low interest rate environments where DSCR might look strong but leverage is high. The handbook also notes that debt yields that reflect normalized or higher-rate levels can be used to establish stressed loan amounts less vulnerable to higher-rate environments [1]. You can prepare a stressed debt yield by using a scenario with higher vacancy or lower rent assumptions.
Identifying gaps and questions for the lender
Once you have your balance schedule reconciled and your DSCR and debt yield calculated, identify any discrepancies between the rent roll and T-12, any loans not captured, or any assumptions that differ from what a lender might use. The OCC handbook says examiners evaluate the basis of disbursements for construction loans and assess whether cost estimates appear reliable [1]. For existing properties, ask the actual lender: What amortization period do you assume for interest-only loans? Do you use trailing twelve months NOI or a stabilized pro forma? What debt yield minimum do you apply for this property type? Prepare a list of these questions and your answers based on the schedule you built.
Concrete workpaper: debt balance reconciliation worksheet
Create a single-page worksheet with these sections: - Loan inventory: list each loan with original amount, current balance, rate, amortization, maturity, monthly payment. - Rent roll summary: gross potential rent, vacancy %, effective gross income. - T-12 summary: gross collected income, total operating expenses, NOI. - Reconciliation: explain any difference between rent roll effective gross income and T-12 collected income. - DSCR calculation: NOI divided by annual debt service (actual and imputed amortizing). - Debt yield calculation: NOI divided by total loan balance. - Questions for lender: three to five specific items you identified.
This worksheet is a suggested way to prepare information for your financing discussion, not a mandatory lender process. It gives you a clear picture before you compare term sheets.
Frequently asked questions
Do I need to include mezzanine debt in the balance schedule?
Yes. Mezzanine debt is subordinate to the senior loan, but it still affects total debt service and leverage. Lenders will want to see all debt secured by the property or the ownership interests. Include the mezzanine loan's balance, rate, and payment terms in your schedule.
How do I handle a construction loan that has not fully funded?
Record the expected draw schedule and the resulting balance at each stage. Use the fully funded loan amount for debt yield calculations, but use actual draws for the trailing twelve months' debt service. The lender will underwrite based on the maximum loan amount, so prepare both scenarios.
What if the trailing twelve months NOI is lower than the pro forma NOI?
That is common. The trailing twelve months shows actual performance; the pro forma shows projected performance after your business plan is executed. Lenders will look at both. Use the trailing twelve months for current DSCR and debt yield, and the pro forma for stabilized projections. Be ready to explain the gap and how your plan closes it.
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).