A commercial real estate debt schedule review framework evaluates a portfolio’s debt tranches, maturity dates, interest rates, DSCR, and covenants. We audit these metrics to calculate WACC and identify upcoming maturity wall risks to optimize capital structure strategy.
Executive Summary & Key Takeaways
Managing commercial real estate liabilities across dynamic market cycles requires a structured, diagnostic approach. A commercial real estate (CRE) debt schedule review provides owners, asset managers, and capital advisors with clear visibility into portfolio leverage, debt service obligations, covenant exposure, and upcoming refinancing risks.
- Comprehensive Tranche Auditing: An institutional review aggregates senior mortgages, mezzanine debt, preferred equity, and lines of credit into a unified financial model.
- Core Financial Metrics: Key diagnostic indicators include Debt Service Coverage Ratio (DSCR), Debt Yield, Loan-to-Value (LTV), Weighted Average Cost of Capital (WACC), and interest rate cap parameters.
- Maturity Wall Preparedness: Stress-testing debt positions 12 to 36 months prior to expiration helps identify “cash-in” refinancing gaps caused by higher replacement rates or cap rate expansion.
- Capital Structure Optimization: Calculating mark-to-market WACC enables sponsors to re-balance capital stacks and reduce blended capital costs.
How Do You Review a Commercial Real Estate Debt Schedule?
Reviewing a commercial real estate debt schedule requires auditing every active debt tranche across senior mortgages, mezzanine debt, preferred equity, and credit lines. We aggregate principal balances, interest rate structures, amortization periods, maturity dates, and covenants to calculate total debt service obligations and highlight near-term refinancing liabilities.
A commercial real estate debt schedule is a comprehensive financial audit model detailing all active debt liabilities across a real estate asset or portfolio, including principal balances, interest rate terms, repayment structures, and covenant compliance thresholds.
Step-by-Step Debt Schedule Review Framework
To execute an institutional-grade review, follow this sequential procedural framework:
- Aggregate Loan Documentation: Gather all underlying promissory notes, mortgage agreements, intercreditor agreements, interest rate derivative contracts, and prepayment penalty schedules.
- Inventory Loan Tranches and Terms: Record current principal balances, interest rate structures (fixed vs. floating spreads over SOFR), amortization schedules, and exact maturity dates for each capital position.
- Map Debt Service and Rate Caps: Calculate monthly and annual debt service obligations, modeling forward SOFR curves for variable-rate liabilities and evaluating strike prices or expiration dates on interest rate caps.
- Audit Operating Performance and Covenants: Cross-reference trailing 12-month (T12) operating cash flows and certified rent rolls against lender covenants, establishing actual DSCR, debt yield, and LTV metrics.
- Calculate Blended Portfolio WACC: Model the weighted average cost of capital across senior debt, subordinate financing, preferred equity, and common equity to measure true capital stack drag.
- Model Refinancing Stress Tests: Project replacement debt sizing 12 to 36 months ahead under prevailing interest rate, LTV, and debt yield criteria to pinpoint potential equity gaps or maturity wall risks.
Conditions and Caveats
This debt schedule review framework applies to portfolio owners, asset managers, family offices, and capital advisors managing multi-tranche or near-term expiring commercial debt stacks across retail, multi-family, industrial, and office assets. The diagnostic accuracy of a debt schedule audit degrades if off-balance-sheet guarantees, derivative contracts, interest rate caps, or contingent liabilities are excluded from the initial ledger.
Furthermore, evaluating floating-rate debt without incorporating forward curve projections or interest rate cap strike points creates a false sense of debt service stability. When interest rate caps expire mid-term, debt service obligations can expand rapidly, compressing the debt service coverage ratio (DSCR) below bank covenant levels even if top-line revenue remains constant.
Evidence: The Debt Audit Document Requirements
Executing an institutional-grade capital structure audit requires gathering and cross-referencing primary loan documentation across all capital providers. We utilize the following primary document checklist to audit every active capital position:
- Promissory Notes and Loan Agreements: Establishes base interest rate, margin spread over benchmarks (e.g., 30-day Secured Overnight Financing Rate [SOFR] or Prime), payment schedules, default rate triggers, and true maturity dates.
- Derivative Interest Rate Cap Contracts: Identifies counterparty, strike rate, cap term, and replacement obligations upon expiration.
- Rent Rolls and Lease Summaries: Certified within 30 days of audit, establishing current gross income, tenant rollover timing, and rent collection history.
- Trailing 12-Month (T12) Operating Statements: Validates line-item net operating income (NOI), management fees, tax accruals, and replacement reserves.
- Intercreditor and Subordination Agreements: Defines payment waterfall rights, standstill periods, and remedy rights between senior lenders and mezzanine or preferred equity holders.
- Prepayment Penalty Schedules: Establishes exact cost parameters for defeasance, yield maintenance, or step-down prepayment penalties upon exit or refinancing.
Action: Initiating Your Debt Schedule Inventory
To establish an accurate diagnostic baseline across your assets, compile all active promissory notes and cross-reference debt obligations against current asset performance. You can systematically evaluate your portfolio liabilities against capital market underwriting thresholds using our Commercial Mortgage Maturity Risk Checklist: A Capital Structure Diagnostic for CRE Owners.
What Key Metrics Are Included in a CRE Debt Schedule Audit?
A comprehensive CRE debt schedule audit tracks fundamental financial metrics: total debt principal, interest rate structures (fixed versus floating SOFR spreads), loan-to-value (LTV), debt service coverage ratio (DSCR), debt yield, prepayment penalty schedules (defeasance, yield maintenance, step-down), maturity dates, and liquidity covenants.
Debt yield is defined as the net operating income (NOI) divided by total outstanding loan principal, expressed as a percentage, representing a lender’s unleveraged return on capital in the event of default.
Conditions and Caveats
Audit metrics must be benchmarked against asset class, tenant credit profiles, and location parameters. A retail asset anchored by national credit tenants may tolerate a lower debt yield benchmark (e.g., 8.5%) than a unanchored strip center (e.g., 10.5%). For variable-rate liabilities, metrics like DSCR must be stress-tested against interest rate shifts of +100 bps, +200 bps, and +300 bps over forward SOFR curves to establish realistic downside buffer metrics.
Evidence: Comparative Debt Stack Metrics Audit Matrix
The matrix below illustrates a multi-tranche debt structure for a multi-tenant commercial property, detailing how individual credit metrics shift as capital stack seniority changes:
| Capital Stack Tranche | Capital Contribution | Loan-to-Value (LTV) | Interest Rate / Rate Structure | Minimum DSCR Requirement | Minimum Debt Yield Benchmark | Prepayment Structure |
|---|---|---|---|---|---|---|
| Senior First Mortgage | 60.0% ($10,000,000) | 60.0% Cumulative | 6.25% Fixed (5-Yr Treasury + 225 bps) | 1.35x (Senior Debt Service) | 9.50% (Senior Debt Yield) | Yield Maintenance / Defeasance |
| Subordinate Mezzanine Debt | 15.0% ($2,500,000) | 75.0% Cumulative | 11.50% Fixed (Interest Only) | 1.10x (Total Debt Service) | 7.60% (Combined Debt Yield) | 12-Month Minimum Interest Call |
| Preferred Equity | 9.0% ($1,500,000) | 84.0% Cumulative | 13.00% Preferred Return (Pari-Passu Current) | N/A (Soft Covenant Cash Flow) | 6.78% (Implied Capital Yield) | No Penalty / Flexible Payoff |
| Sponsor Common Equity | 16.0% ($2,666,667) | 100.0% Total Capital | Targeted IRR / Equity Multiple | N/A (Residual Distributions) | N/A | N/A |
Action: Benchmarking Capital Stack Metrics
When reviewing portfolio metrics, compare current senior and secondary leverage points against prevailing lender underwriting standards. If total debt yield drops below 8.0% or combined DSCR falls under 1.15x, the property will require structural adjustments prior to refinancing. Explore tailored capital restructuring options in our core Loan Maturities and Capital-Structure Advisory Hub, or review our specialized frameworks for Structuring Grocery-Anchored Retail Center Capital Stacks and evaluating Commercial Real Estate Mezzanine Debt Providers.
What Is the Formula for Weighted Average Cost of Capital (WACC) in CRE?
Weighted average cost of capital (WACC) in commercial real estate measures the blended effective cost of all capital stack components—senior debt, secondary debt, preferred equity, and common equity—weighted by their proportion in the overall balance sheet. We calculate WACC using exact interest rates, fee amortization, and target equity returns.
Capital stack WACC is the aggregate weighted discount rate representing the minimum net return a commercial real estate property must generate to satisfy all capital providers across senior debt, subordinate financing, preferred equity, and common equity.
Conditions and Caveats
Calculating commercial real estate WACC accurately depends on using current mark-to-market asset values rather than historical cost basis. Using book value understates capital weights when property values decline, resulting in an artificially depressed calculated cost of capital. Furthermore, debt costs should incorporate annualized loan fees, origination costs, and legal expenses spread over the hold period to reflect true effective yield requirements.
Evidence: Worked WACC Calculation Example
Consider a $16,666,667 total capital stack structured to finance a commercial asset generating $1,266,667 in annual Net Operating Income (NOI). The capital stack comprises four distinct tiers: senior debt, mezzanine debt, preferred equity, and sponsor common equity.
Step 1: Define Capital Tranche Values, Weights, and Individual Costs
- Senior Debt: $10,000,000 (60.0% Weight) at an effective interest rate of 6.00%.
- Mezzanine Debt: $2,500,000 (15.0% Weight) at an effective interest rate of 11.00%.
- Preferred Equity: $1,500,000 (9.0% Weight) at a required return rate of 13.00%.
- Sponsor Equity: $2,666,667 (16.0% Weight) at a targeted hurdle return of 15.00%.
Step 2: Apply the Mathematical Formula
The standard CRE WACC formula is expressed as:
WACC = (Wd1 × Cd1) + (Wd2 × Cd2) + (Wpe × Cpe) + (We × Ce)
Where W represents the proportion of total capital (weight) and C represents the cost of capital for each respective tranche.
Step 3: Execute the Calculation
- Senior Debt Component: 0.600 × 6.00% = 3.600%
- Mezzanine Debt Component: 0.150 × 11.00% = 1.650%
- Preferred Equity Component: 0.090 × 13.00% = 1.170%
- Sponsor Equity Component: 0.160 × 15.00% = 2.400%
Summing the component contributions yields:
Blended Portfolio WACC = 3.600% + 1.650% + 1.170% + 2.400% = 8.82%
In this capital structure, the property must generate an unleveraged yield higher than 8.82% to create positive economic leverage for the sponsor’s common equity after satisfying senior debt service and preferred return obligations.
Action: Optimizing Capital Stack Allocations
To reduce your asset’s total cost of capital, analyze the proportion of high-cost equity relative to lower-cost debt or institutional mezzanine tranches. Read our complete guide on Commercial Real Estate Capital Stack Structuring: Optimization Guide to evaluate how re-balancing your capital stack lowers overall WACC while maintaining necessary coverage covenants.
How Does a Debt Schedule Help Identify Maturity Wall Risk?
A debt schedule maps maturity dates against forward debt service projections and market refinancing rates, exposing liquidity cliffs where debt comes due before property cash flow can support a full exit or rate-and-term refinance. We leverage this timeline to model capital shortfalls 12 to 36 months in advance.
A maturity wall cliff occurs when a concentration of maturing debt instruments across a portfolio or market must be refinanced during a tight liquidity environment or elevated interest rate regime, causing cash-in refinancing gaps for assets underwritten at lower interest rates.
Conditions and Caveats
Maturity wall analysis is essential for commercial properties with debt originated between 2014 and 2021 at interest rates between 3.0% and 4.5%. When these assets face refinancing at current baseline coupon rates of 6.5% to 8.0%, higher interest expense reduces debt coverage, shrinking total available loan principal. This risk is amplified in properties experiencing net operating income flatlining, tenant concession expansion, or cap rate expansion.
Evidence: The $2.2M Refinancing Gap Case Example
Consider a 75,000 square-foot neighborhood retail center with a $15,000,000 senior interest-only loan maturing in 18 months. The loan was originated at a 4.00% fixed interest rate, creating an annual debt service obligation of $600,000. Under original underwriting, the property generated $870,000 in NOI, providing a 1.45x DSCR and an 5.80% debt yield.
Upon reviewing the debt schedule 18 months prior to maturity, we model replacement senior debt using current market underwriting criteria: 7.00% interest rate, 30-year amortization schedule, 1.25x minimum DSCR, and an 8.50% minimum debt yield requirement.
- Current Property NOI: $975,000 (after leasing adjustments and operating expense growth).
- Maximum Debt Supported by 8.50% Debt Yield: $975,000 / 0.085 = $11,470,588.
- Maximum Debt Supported by 1.25x DSCR (at 7.00% amortizing rate): Max Debt Service = $975,000 / 1.25 = $780,000 annual payment ($65,000/month). At 7.00% interest on a 30-year amortization schedule, a $65,000 monthly payment supports maximum loan principal of $9,769,825.
Because lenders apply the most restrictive constraint (the DSCR sizing constraint), the replacement senior loan sizing is capped at $9,770,000 (rounded). Subtracting this amount from the maturing $15,000,000 principal leaves a $5,230,000 equity gap.
Even if the lender allows an interest-only structure at 7.00% ($975,000 NOI / 1.25 DSCR = $780,000 max debt service / 0.070 = $11,142,857 loan amount), the property still faces a $3,857,143 refinancing shortfall.
To eliminate this shortfall without selling the asset at a discounted cap rate, we structure a dual-tranche exit plan: securing an $11.0M senior loan paired with a bridge-to-permanent preferred equity injection or utilizing an SBA 504 capital stack exit strategy for eligible owner-occupied properties. Detailed real-world applications of these structures are documented in our Maturing Commercial Loan Restructuring Success Stories and our guide for Commercial Debt Restructuring for Maturing Loans.
Action: Managing Maturity Timeline Risk
Perform a forward maturity audit across all loans expiring within 36 months. Map out expected property NOI against replacement interest rates to calculate potential equity gaps well ahead of lender maturity notices.
- 36 to 24 Months Before Maturity: Audit all underlying loan agreements, confirm option extension requirements (e.g., minimum DSCR tests, extension fees, rate cap purchase requirements), and establish baseline NOI trajectories.
- 24 to 12 Months Before Maturity: Model market replacement sizing (DSCR, LTV, Debt Yield). Quantify cash-in equity gap requirements or identify preferred equity, bridge debt, or mezzanine capital requirements.
- 12 to 6 Months Before Maturity: Execute capital sourcing or initiate formal restructuring dialogues with existing loan servicers and secondary capital providers.
If your portfolio analysis reveals upcoming maturity cliffs or equity gaps on maturing loans, contact our team to request a maturity plan review and evaluate your capital structure options.
Frequently Asked Questions
How do you review a commercial real estate debt schedule?
To review a commercial real estate debt schedule, asset managers aggregate all active promissory notes and loan agreements, index interest rates and floating spreads, map annual debt service obligations, and analyze maturity timelines against current market underwriting criteria to identify potential equity shortfalls early.
What key metrics are included in a CRE debt schedule?
A CRE debt schedule includes principal loan balances, interest rate structures such as fixed rates or floating index spreads, amortization terms, annual debt service, loan-to-value ratios, debt service coverage ratios, minimum debt yield benchmarks, prepayment penalty terms, and contractual loan maturity dates.
How does a debt schedule help identify maturity wall risk?
A debt schedule visualizes upcoming loan expirations across a multi-year timeline. By benchmarking maturing debt tranches against prevailing replacement interest rates and lender debt yield requirements, property owners can spot cash-in refinancing gaps and liquidity bottlenecks years before contractual maturity defaults occur.
What is the formula for weighted average cost of capital in CRE?
The formula for weighted average cost of capital in commercial real estate is: WACC = (Weight of Senior Debt × Cost of Senior Debt) + (Weight of Subordinate Debt × Cost of Subordinate Debt) + (Weight of Preferred Equity × Preferred Return) + (Weight of Common Equity × Required Equity Return Rate).
References
Sources reviewed while researching commercial real estate debt schedule review framework, taken from the US search results on 2026-09-20.
- Real Estate Mortgage and Debt Models – Adventures in CRE — adventuresincre.com
A collection of real estate Excel models for analyzing mortgage and real estate debt. Includes models for construction, permanent and refinance debt. - [PDF] Commercial Real Estate Lending | Comptroller’s Handbook – OCC.gov — occ.gov
(A) (M) (E) (L) (S) (O)Commercial
Version 2.0, March 2022
as of March 20, 2025. Refer to OCC Bulletin 2025-4.
Introduction…..1 Lending…..4 CRE Industry, Property Types, and Loan Types…..4
Evaluating the Developer Borrower…..32 Loss…..60
Comptroller’s Handbook ii Commercial Real Estate Lending
Examinat
- Real Estate Development Modeling: Equity, Debt Draws & Repayment — breakingintowallstreet.com
Real Estate Development Modeling: Allocate funds required between equity and debt, ensure that the proper amounts are drawn, and allow for repayments. - Build a Real Estate Financial Model, Part 2: Amortization Tables – YouTube — youtube.com
for the analysis of a real estate investment. In this specific episode, I add a basic amortization schedule. — Want more commercial real … - REFM: Real Estate Financial Modeling Ultimate Guide w — mergersandinquisitions.com
Free REFM (Real Estate Financial Modeling) Templates Including Sample XLS Files or Real Estate Acquisition, Renovation and Development Projects. - Debt Schedule | Formula + Calculator – Wall Street Prep — wallstreetprep.com
3. [Senior Debt vs. Subordinated Debt: What is the Difference?](https://www.wallstreetprep.com/knowledge/debt-schedule/#h2_3)
4. [Debt Schedule — Excel Template](https://www.wallstreetprep.com/knowledge/debt-schedule/#h2_4)
5. [Step 1. Debt Tranches Table and Financing Assumptions](https://www.wallstreetprep.com/knowle - Commercial Real Estate and Projected Debt Maturities — schneiderdowns.com
Explore the potential challenges of debt maturity in commercial real estate as $1.5 trillion is projected to be due by the end of next year. - Debt Yield Calculation in Commercial Real Estate Explained – Cactus — trycactus.com
## FAQ
To simplify this process and eliminate calculation errors, Cactus’ commercial real estate underwriting software automates debt yield analysis alongside other essential metrics, allowing you to model multiple scenarios quickly and present professionally formatted reports that demonstrate your deal’s strength to p - 2026 commercial real estate outlook | Deloitte Insights — deloitte.com
# 2026 commercial real estate outlook
## Upside may be on the horizon as renewed capital and the return of traditional lenders help breathe life into CRE debt markets, even as distress persists
Looking ahead, CRE lending seems to be a tale of two markets: existing loans are often stressed by refinancing and defaults, w - Policy Statement on Prudent Commercial Real Estate Loan … — federalreserve.gov
# REAL ESTATE LENDING—Policy Statement on Prudent Commercial Real Estate Loan Accommodations and Workouts
– analyzed the available cash flow of guarantors;When analyzing a commercial borrower’s repayment ability, examiners should consider the following factors:
For these loans, examiners should assess the adequacy o
SERP features this page targets
| Feature | Likelihood | How this page wins it |
|---|---|---|
| AI Overview | 90% | Comprehensive Executive Summary & Key Takeaways Section |
| Featured Snippet (Paragraph/List) | 85% | Step-by-Step Debt Schedule Review Framework List |
| Data Table Snippet | 80% | CRE Debt Schedule Audit Matrix & Metrics Table |
| People Also Ask | 95% | FAQ Accordion with Schema Markup |