Preparing a portfolio capital-needs schedule alongside debt maturities
A practical guide to building a forward-looking schedule that maps upcoming capital requirements against loan maturities, helping sponsors identify refinance risk and prepare for lender conversations.
A practical guide to building a forward-looking schedule that maps upcoming capital requirements against loan maturities, helping sponsors identify refinance risk and prepare for lender conversations.
When a sponsor holds multiple properties, each with its own loan maturity and capital plan, the interaction between those timelines can create hidden pressure points. A portfolio capital-needs schedule is a working document that lines up every property's upcoming debt maturity with its expected capital expenditures, leasing costs, and refinancing assumptions. This guide explains how to build that schedule, what it reveals about refinance risk, and how to use it in a financing discussion.
What a portfolio capital-needs schedule shows
The schedule is a forward-looking table, typically covering the next three to five years, that records for each property: the loan maturity date, the projected outstanding principal at maturity, any balloon payment, planned capital expenditures (roof replacement, HVAC, parking lot, unit renovations), leasing commissions and tenant improvement allowances, and the expected net operating income during the period. When laid out side by side, the schedule reveals whether multiple maturities cluster in the same year, whether capital needs will strain liquidity before a refinancing, and whether any property's debt service coverage could fall below a lender's typical threshold. The OCC notes that refinance risk can be amplified by large volumes of loans set to mature in underperforming markets . A schedule that shows three loans maturing in the same quarter in a softening market is a flag worth addressing before approaching lenders.
Identifying refinance risk at the portfolio level
The OCC states that banks should have processes to identify, measure, monitor, and control refinance risk at both the transaction and portfolio levels . As a sponsor, you can prepare the same analysis yourself. Look for loans where the principal balance remains largely unpaid at maturity, such as interest-only loans, loans with balloon payments, or revolving lines. The OCC lists examples of loan types most affected by refinance risk . Also flag properties with high leverage, constrained liquidity, or poor recent financial performance. Borrower-specific drivers for heightened refinance risk include high leverage, constrained liquidity, a significant volume of near-term maturities, poor financial performance, or unpopular market sentiment . Your schedule should note each property's current debt service coverage ratio and loan-to-value ratio, because those are the cushions lenders evaluate.
Stress-testing the schedule with changing conditions
A common method to assess refinance risk is multivariable stress testing . You can apply a simple version to your schedule. Pick two or three scenarios: a rise in interest rates, a decline in net operating income, or a drop in property value. Then recalculate debt service coverage and the likely loan amount each property could support. The OCC states that transaction-level stress testing can provide insight into the borrower's ability to meet refinancing requirements if financial condition declines or market conditions deteriorate . If a property's projected net operating income under stress cannot cover the higher debt service, that property may need a capital infusion, a longer extension, or a different loan structure. Record those findings in a column called "stress-test gap."
Preparing the capital-needs workpaper
Create a spreadsheet with one row per property. Columns should include: property name, loan maturity date, loan type (interest-only, amortizing, balloon), current outstanding principal, projected outstanding principal at maturity, expected annual net operating income, planned capital expenditures by year, leasing costs by year, current debt service coverage, current loan-to-value, and the stress-test gap you calculated. Below the table, add a summary row that totals the capital needs and maturing principal for each year. This is the document you will share with your financing advisor. This schedule is material you already have, organized to answer the lender's first question: can you refinance all of this?
Distinguishing net operating income, capital expenditures, and equity cash flow
A common confusion is treating net operating income (NOI) as cash available for debt service and capital. NOI is income before debt service and before capital expenditures. From NOI, subtract debt service (principal and interest) to get before-capex cash flow. Then subtract planned capital expenditures to get equity cash flow. If equity cash flow is negative, the sponsor must inject equity or the property cannot fund its own capital needs. The schedule should show each of these lines: NOI, debt service, before-capex cash flow, capex, and equity cash flow. A property with positive NOI but negative equity cash flow is consuming sponsor capital. That is a refinance risk factor the OCC would flag as constrained liquidity .
Asking the actual lender about extension and refinancing requirements
Your schedule is a planning tool, not a lender submission. Use it to prepare questions for your lender or financing advisor. Ask: what debt service coverage and loan-to-value ratios does the lender require for a refinancing today? Does the lender require a minimum period of stabilized occupancy before a maturity extension? Will the lender allow a capital expenditure reserve to be funded from future cash flow, or must it be escrowed at closing? The OCC notes that banks may require covenants that preserve the borrower's ability to refinance, such as leverage covenants or limits on incremental debt . Your schedule should note any existing covenants that could constrain a refinancing.
How far ahead should the schedule look?
Three to five years is typical. If any loan matures beyond five years, you can include it in a separate section. The OCC focuses on near-term maturities because refinance risk increases when a significant volume of loans mature in a short period .
Does the schedule replace a formal loan application?
No. The schedule is a planning and analysis document. It helps you identify which properties need attention before you approach a lender.
What if a property's equity cash flow is negative?
That is a signal to discuss with your financing advisor. The OCC lists constrained liquidity as a borrower-specific driver for heightened refinance risk . You may need to inject equity, restructure the loan, or sell the property before maturity.
We will tell you how we would approach it. Submission is a preliminary request, not an engagement or lender submission.
Run the numbers on your deal
Estimate what a new loan could size to against your current balance and whether there is a gap to fill at maturity.
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).