Portfolio debt maturity calendars

Treat maturity as a cash obligation with a date

A debt maturity calendar is a schedule of obligations to repay principal, not merely a list of the months when loans renew. A property can make every scheduled interest payment and still lack the cash required when its note matures. Start with executed loan documents and current servicing records for every obligation. Confirm the relevant borrower, collateral, balance, payment structure, maturity, and any pending modification with qualified professionals. Do not use an old origination spreadsheet as the sole source for a current repayment decision.

Distinguish maturity from amortization. A loan’s payments may be calculated using a long amortization schedule while the remaining balance becomes due much earlier. Also record interest-rate resets, interest-only expirations, extension notice dates, reporting deadlines, covenant tests, and any rate-protection expiration. These dates can change the cash plan before final maturity. Ask counsel or another qualified reviewer how disputed or conditional dates should be interpreted; the operating calendar should not make legal conclusions from abbreviated marketing descriptions.

Every amount and loan in this guide is hypothetical. The planning intervals and refinancing assumptions are internal scenario choices, not lender standards or promises of credit. OCC’s refinance-risk guidance highlights the importance of timing, asset performance, other debt, and refinancing cost at both transaction and portfolio levels. Apply that perspective to your own records: the objective is to expose when the portfolio needs cash and what evidence supports its repayment plan, while leaving actual credit decisions to the relevant lenders and professional advisers.

Build a register that can survive a document review

Create one debt record per obligation with an immutable identifier and links to restricted source documents. Include original principal, current balance and statement date, expected maturity balance, payment amount, rate mechanism, amortization, collateral, guarantees, required reserves, and servicing contact. Identify whether other properties or obligations are connected through collateral or covenants. A portfolio summary should not imply each property can be sold or refinanced independently if the actual documents require releases, approvals, or broader repayment conditions.

Store extension provisions as conditional events. Record any notice window, required payment, operating test, documentation, lender approval, and other condition identified by professional review. An option subject to unmet conditions should not silently replace the original maturity date. Keep the original obligation visible and show an extension scenario separately until its requirements are satisfied and the controlling evidence is received. Informal encouragement from a lender contact is not the same as an executed change in the repayment obligation.

Reconcile the register to statements, the accounting debt ledger, and professional payoff information as appropriate. Investigate differences caused by principal payments, capitalized amounts, advances, servicing adjustments, or documentation errors. Preserve the reconciliation date and responsible reviewer. Restrict account details and sensitive documents rather than emailing a full debt packet to every vendor. The working calendar generally needs dates, amounts, conditions, and owners; detailed financial and identity evidence belongs in an access-controlled location available to authorized participants.

Measure concentration in rolling windows

Consider four hypothetical interest-only obligations with unchanged principal for this example: loan A has $300,000 due March 31, 2027; loan B has $450,000 due May 31, 2027; loan C has $250,000 due October 31, 2027; and loan D has $800,000 due June 30, 2028. Total portfolio principal is $1,800,000. The three 2027 maturities total $1,000,000, or approximately 55.56% of that principal. The percentage describes this invented schedule only; it is not a recommended limit.

Annual totals can hide a tighter problem. In the 90-day window from March 3 through May 31, 2027, loans A and B together require $750,000 of principal repayment, approximately 41.67% of the $1,800,000 portfolio. Review rolling 90-day and 180-day windows as well as quarters and years. A late-December maturity and an early-January maturity fall into different annual reports but can require cash and professional work almost simultaneously. Choose windows that reveal the actual sequence of obligations rather than whichever display looks least concentrated.

Measure more than the share of principal. Count concurrent refinancing processes, reliance on the same lender, shared guarantor obligations, common property risks, and overlapping capital projects. Two loans with different collateral may still depend on the same cash pool or the same uncertain sale. A small loan with unresolved title or construction issues may require more attention than a larger stabilized loan. Use concentration metrics to prioritize investigation; a low percentage cannot certify that an individual maturity is manageable.

Estimate refinancing proceeds before assuming a full payoff

For loan A, suppose a preliminary planning scenario produces $250,000 of replacement financing. Assume $7,500 of financing and closing costs are deducted from those proceeds, leaving $242,500 available toward the $300,000 existing principal. The modeled principal funding gap is $57,500, before any accrued interest, prepayment charges, reserve requirements, or other actual payoff adjustments. Label those omitted items so the preliminary gap is not mistaken for a complete settlement cash figure. Obtain current professional quotes and payoff statements when making a real decision.

For loan B, use hypothetical lender assumptions to illustrate why refinancing may be smaller than the current balance. Assume $40,500 annual underwritten net operating income, a 1.25 required debt-service coverage ratio, a 9% annual debt-service constant, a $600,000 valuation, and a 65% loan-to-value ceiling. These are invented inputs, not market norms. Coverage permits $32,400 annual debt service: $40,500 divided by 1.25. Dividing $32,400 by 9% gives $360,000 of debt capacity under that simplified payment assumption.

The separate value constraint would permit $390,000: $600,000 multiplied by 65%. The lower of $360,000 and $390,000 is $360,000, before other lender constraints. Assume costs of 3% of the new loan, or $10,800, leaving $349,200 toward loan B’s $450,000 principal. Its preliminary gap is $100,800. This calculation is not an approval or a universal underwriting formula. It demonstrates that a property’s ability to service debt and its collateral value can independently limit a proposed refinance.

Reconcile the cash pool only once

Suppose the portfolio has $180,000 of unrestricted cash, with $60,000 already designated for documented near-term capital work and $45,000 needed for the stated operating reserve policy and scheduled bills. Available cash for the example maturity gaps is $75,000. Loans A and B require $57,500 plus $100,800, totaling $158,300 under the preliminary scenarios. The resulting uncovered amount is $83,300. Adding an unexplained reserve line to each property would not create more cash; the same shared account cannot fund both gaps twice.

Separate legally or contractually restricted funds from management designations and genuinely uncommitted liquidity. Security deposits, lender-controlled reserves, partnership funds, and property-level accounts can have restrictions requiring professional interpretation. Do not assume money can be moved between entities or properties simply because the same person manages them. Ask advisers to explain permitted transfers, approvals, documentation, and consequences. Your schedule should identify which cash source is usable for which obligation, on what date, and subject to what conditions.

Calendar the cash movements, not just the eventual total. If A’s $57,500 gap is funded in March from the $75,000 available pool, $17,500 remains for B’s May gap, leaving the same $83,300 shortfall. If capital work must be paid earlier than expected, the usable balance could be lower. Track committed but unpaid invoices alongside debt events. A portfolio can have substantial equity while lacking liquid funds on the date needed to settle a maturity, because equity is not an immediately spendable bank balance.

Stress income, terms, and simultaneous failure paths

Recalculate B under a combined adverse scenario rather than changing just one favorable input. Suppose underwritten annual net operating income falls to $36,000 and the assumed annual debt-service constant rises to 10%, while the hypothetical 1.25 coverage requirement remains. Maximum debt service becomes $28,800, and simplified coverage-based debt capacity becomes $288,000. Keep the same $600,000 value and 65% value constraint solely to isolate this scenario. The lower capacity is $288,000, which is $72,000 below the earlier $360,000 planning amount.

With the same assumed 3% financing costs, deductions are $8,640 and net proceeds are $279,360. Against $450,000 principal, B’s gap becomes $170,640, an increase of $69,840 from $100,800. Combined with A’s unchanged $57,500 gap, total needs become $228,140. After the same $75,000 available cash, the uncovered amount is $153,140. The point is not to predict these terms but to identify how quickly several ordinary changes can exceed a reserve plan built around one optimistic refinancing estimate.

Also test a delay rather than only smaller proceeds. A refinance approved after maturity does not meet an earlier repayment date unless another documented arrangement bridges the timing. Consider what happens if an intended sale is delayed, one lender declines, required documents are incomplete, or a capital project prevents an expected valuation. Do not treat all backup plans as independent if they rely on the same lender, buyer, guarantor cash, or market conditions. The calendar should expose common dependencies that a property-by-property summary can miss.

Work backward from the first irreversible deadline

For each maturity, create a backward plan with a named owner and evidence required at each milestone. As an internal planning example, a team might begin an initial review twelve months before maturity, gather current operating and property records nine months before, assess documented financing or sale alternatives six months before, and set a fallback decision point earlier than any notice or settlement deadline. These intervals are illustrative. Actual lead times depend on the property, documents, lender process, market, and professional advice.

Attach deliverables instead of vague tasks. Obtain updated operating statements means a reconciled package with a responsible preparer and delivery date; explore refinance means recorded lender requirements and dated indications clearly labeled as preliminary; confirm payoff means the appropriate professional statement for a specified date. Track which tasks can proceed in parallel and which wait on another result. A valuation dependent on completed repairs should not be shown as certain before the scope and completion evidence exist.

Define escalation triggers when time remains to change direction. Examples include proceeds below the modeled repayment need, an unfilled cash gap, a missed documentation milestone, or an extension condition that cannot be satisfied. Potential responses may include professional negotiations, revised financing, additional suitable capital, or an orderly sale assessment. Their availability and consequences require specific review. Do not assume a lender must extend because payments are current, and do not wait until the final week to tell decision-makers that the assumed exit has become unavailable.

Produce a calendar that drives monthly action

The practical calendar has three views. The obligation view shows contractual dates and expected balances. The funding view shows plausible proceeds, costs, cash contributions, and unresolved conditions. The execution view shows the next owner, deliverable, and deadline. Keep original maturity dates visible even when the operating plan includes a proposed extension. Use a clear as-of date and preserve prior versions so changes in assumptions can be explained rather than disappearing when a cell is overwritten.

Review the calendar alongside bank cash, capital commitments, actual property operations, and lender communications. A new acquisition should be tested against existing maturities before its projected future profit is counted as a source of support. Reconcile balances and milestone status monthly, with additional updates when material events occur. Have a second reviewer reproduce the largest gap and confirm that shared cash is counted once. The most useful review asks which action must happen next and what happens if it does not.

The actionable takeaway is to prepare the next ninety days of decisions before focusing on distant portfolio growth. Identify the earliest binding date, the evidence supporting its repayment source, the usable cash shortfall, and the fallback decision date. Then extend the same discipline across the longer horizon. A maturity calendar earns its value when it causes timely changes to commitments and funding plans, while there is still room to act, rather than when it accurately records an approaching obligation nobody has prepared to meet.

• Reconcile the loan register to controlling documents and statements.
• Keep original maturity and conditional extension dates separate.
• Review rolling maturity windows and common funding dependencies.
• Model net refinancing proceeds after costs and constraints.
• Assign available cash without duplicating shared reserves.
• Name each milestone owner, required evidence, and fallback date.