Can I Afford This Property?Commercial real estate financing, worked out

How to present a sponsor's existing real estate debt schedule

An actionable guide to preparing a clear, source-grounded debt schedule for commercial real estate financing discussions, with a concrete evidence checklist.

Source: CodexTopic: Sponsor equity and liquidity1213 wordsUpdated 2026-11-19

An actionable guide to preparing a clear, source-grounded debt schedule for commercial real estate financing discussions, with a concrete evidence checklist.

When you prepare a debt schedule for a commercial real estate financing request, you are giving the lender a snapshot of your current obligations and how they interact with the property's cash flow. This guide explains what to include, why each item matters, and how the information shapes the underwriting conversation. The task is to build a single workpaper—a sponsor debt schedule—that you can update and share with your financing partner.

What a debt schedule should record

A debt schedule lists every loan or other obligation secured by the sponsor's real estate assets, whether at the property level or the entity level. For each loan, record the lender name, original loan amount, current principal balance, interest rate, maturity date, amortization type (interest-only, fully amortizing, balloon), and the collateral property or entity. Also note whether the loan is senior or mezzanine. [2] explains that senior loans are paid first and mezzanine loans are subordinate, typically secured by a pledge of ownership interests. This distinction matters because a lender assessing a new request will want to know where its loan would stand in the repayment order.

Include any guarantees, recourse provisions, and prepayment penalties. These terms affect the sponsor's flexibility to refinance or sell. The OCC handbook notes that loan administration includes understanding the terms and conditions of existing debt [1]. While that guidance is directed at banks, it is a useful reminder that a complete schedule helps the lender evaluate the sponsor's capacity to manage its current obligations.

Why the schedule affects the financing discussion

The debt schedule is not just a list; it is a tool for the lender to assess leverage and risk. The OCC handbook discusses debt yield as the ratio of net operating income (NOI) to debt, and notes that lower debt yields indicate higher leverage [1]. When you present a debt schedule alongside the property's NOI, the lender can calculate the debt yield for each individual loan or property. If the debt yield is low, the lender may view the sponsor as highly leveraged and may require a lower loan-to-value ratio or additional equity.

Similarly, the schedule reveals maturity concentrations. If several loans mature in the same year, the sponsor may face refinancing risk. The OCC handbook notes that banks should consider geographic and property-type diversification in their loan portfolios [1]. While this guidance is directed at banks, a sponsor's debt schedule can reveal similar concentrations that a lender may evaluate.

Distinguish gross rent, collected income, NOI, capex, debt service, and equity cash flow

A common mistake is to present a debt schedule without reconciling the cash flow that services the debt. The lender needs to see how the property's income supports each layer of debt. Start with gross potential rent, then subtract vacancy and credit loss to arrive at gross collected income. From there, deduct operating expenses to get net operating income (NOI). The OCC handbook defines debt yield as NOI divided by the loan amount [1]. Debt yield provides a measurement of risk that is independent of the interest rate, amortization period, and capitalization rate [1].

After NOI, subtract capital expenditures (capex) that are not already in operating expenses. The remaining amount is available for debt service. The debt service includes interest and principal payments on all loans, not just the proposed one. Whatever is left after debt service is equity cash flow—the return to the sponsor. If you present these layers in a simple waterfall, the lender can see whether the proposed loan fits within the available cash flow.

Prepare a trailing twelve-month operating statement and a current rent roll

A current rent roll is a snapshot of the property's occupancy and rent at a single point in time. A trailing twelve-month (T-12) operating statement shows the actual income and expenses over the past twelve months. These two documents serve different purposes. The rent roll tells the lender who is in place and what they are paying today. The T-12 shows the historical performance, including seasonal variations and one-time expenses. When you compare the two, you can identify trends—for example, if the rent roll shows higher rents than the T-12 average, the property may be in a lease-up phase. The lender will want to understand whether the increase is sustainable.

To reconcile the timing difference, note the date of the rent roll and the period covered by the T-12. If the rent roll is current and the T-12 ends three months ago, explain any material changes in occupancy or rent since the T-12 period. This transparency helps the lender trust the numbers.

Suggested way to organize the information

Create a single spreadsheet or document with two sections. The first section is the sponsor debt schedule, with the columns described above. The second section is a cash flow waterfall for the subject property, showing gross rent, collected income, operating expenses, NOI, capex, debt service on all existing loans, and equity cash flow. Add a row for the proposed loan's estimated debt service so the lender can see the impact. Label this as your workpaper, not a lender form. It is a tool for you and your financing partner to discuss the structure.

Evidence checklist for the debt schedule

  • [ ] List of all real estate-secured loans with lender name, original amount, current balance, rate, maturity, amortization type, and collateral.
  • [ ] Notation of senior or mezzanine position for each loan.
  • [ ] Guarantees, recourse provisions, and prepayment penalties noted.
  • [ ] Current rent roll dated within 30 days.
  • [ ] Trailing twelve-month operating statement with clear period.
  • [ ] Reconciliation of differences between rent roll and T-12.
  • [ ] Cash flow waterfall showing gross rent, collected income, NOI, capex, debt service, and equity cash flow.
  • [ ] Calculation of debt yield for each loan (NOI divided by loan amount).
  • [ ] Maturity concentration analysis: list loans maturing in the next 24 months.

FAQs

Should I include loans that are not secured by real estate?

Include any loan that affects the sponsor's liquidity or that is guaranteed by the sponsor, even if it is not secured by real estate. The lender will want to see the sponsor's total debt picture to assess capacity. The OCC handbook defines CRE lending as including loans secured by liens on real estate, but the sponsor's overall financial condition matters [1].

How do I handle a loan that is in forbearance or modification?

Disclose the current status and any modified terms. The lender will want to understand whether the loan is performing and what the resolution plan is. The OCC handbook notes that loans that are renewed, refinanced, or restructured as part of a workout program can be treated differently for regulatory purposes [1].

What if I do not have a T-12 for a recently acquired property?

Provide whatever operating history you have, even if it is only a few months. Supplement it with the seller's historical statements if available. The lender may also ask for a pro forma based on the current rent roll and market assumptions. The key is to be transparent about what information is available and what is estimated.

Closing invitation

We arrange debt on behalf of sponsors and can help you assemble the request for the lenders suited to your situation.

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.

Open the loan sizing calculator

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.

Contact us

Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).

Sources

  1. OCC Commercial Real Estate Lending handbook
  2. Wraith commercial real estate debt