Calculating a multifamily refinance shortfall

A refinance shortfall is the cash required to complete a refinancing after applying the new loan's usable proceeds and other available transaction funds. The difference between the existing principal balance and a lender's proposed loan amount is only the starting point. Payoff interest, prepayment obligations, fees, funded reserves, and the property's continuing cash needs can make the actual equity requirement materially larger.

The purpose of the calculation is practical: identify how much cash must be available, when it must arrive, and which assumptions could change that requirement. It should also explain whether the shortfall comes from debt sizing, transaction costs, restricted cash, or a combination. Those causes lead to different remedies. The OCC's refinance-risk guidance treats the ability to replace debt under prevailing conditions as an ongoing credit question, rather than a task reserved for the final weeks before maturity.^[1]

Start with the amount needed to retire the existing obligations

Obtain a payoff statement or a current payoff estimate from the existing lender or servicer. Record its effective date and the per-day interest adjustment. Reconcile it to the outstanding loan balance, rather than substituting the balance from last quarter's financial statements. Identify any required release expenses, unpaid amounts, and contractual prepayment charges. If a derivative must be terminated separately, obtain a separate estimate based on the actual hedge documents; a loan payoff statement should not be assumed to cover every related obligation.

Keep amounts needed at closing separate from obligations that continue afterward. A sponsor may have operating expenses, imminent capital work, or an investor payment to fund, but those uses do not all retire the mortgage. Combining them into one unexplained number makes it harder to determine which costs are unavoidable for the refinance and which require a separate business decision.

Likewise, distinguish an old reserve balance from cash that is assured to arrive at the closing table. Ask whether the balance is refundable, subject to unpaid invoices or repair obligations, assignable to the replacement lender, or released only after payoff. The new lender may require fresh deposits even when an old lender holds reserves for a similar purpose. Fannie Mae's conventional term sheet, for example, identifies replacement, tax, and insurance escrows as typical requirements; that statement does not establish that an existing reserve can satisfy a new transaction's deposit requirement.^[2]

Calculate the new loan's binding constraint

Before calculating net proceeds, determine whether the proposed gross principal amount is defensible. A valuation-based leverage limit, a coverage test, and a debt-yield test can produce different amounts. Use the actual lender's definitions and applicable tests. A quoted maximum from a product description is a ceiling within that execution, not a promise to lend that amount on a particular property.^[2]

For a simplified model with level annual debt service, the coverage-based loan amount equals the agreed annual underwritten cash flow divided by the minimum coverage ratio and then divided by the annual debt constant. The debt constant represents annual debt service per dollar of principal; it is not interchangeable with the note's interest rate when principal amortizes. If a lender uses a stressed rate or another underwriting convention, apply that convention. The OCC's bank underwriting discussion distinguishes debt-service coverage, debt yield, and loan-to-value as separate measures.^[3]

Use consistent cash-flow definitions throughout the model. For the following example, assume that the lender has agreed to a particular annual underwritten cash-flow figure and uses that same figure in both the coverage and debt-yield tests. That is an explicit simplifying assumption. In a real proposal, reconcile any differences in reserve treatment or other adjustments before comparing results. The OCC notes that underwriting coverage and a loan's covenant coverage can use different definitions.^[3]

A $72 million payoff with a $65 million replacement loan

Consider a hypothetical stabilized apartment property. These assumptions illustrate the method; they are not current market terms or an offer:

The LTV test allows $65 million. The coverage test allows approximately $68.27 million: $6.4 million divided by 1.25 and then by 0.075. The debt-yield test allows approximately $71.11 million: $6.4 million divided by 0.09. Assuming these are all the applicable sizing limits, the smallest result is $65 million. LTV is the binding constraint.

Now assume $1.30 million of transaction costs must be funded and the replacement lender requires $1.30 million of initial reserve deposits. The usable new-loan proceeds after those deductions are $62.40 million. Against the $72 million payoff, the gross funding gap is $9.60 million, not $7 million.

Suppose $400,000 of existing reserve cash is confirmed available for this closing. The remaining required sponsor cash is $9.20 million. If the borrowing venture already holds $2 million that it can contribute, the amount that must be raised outside the venture is $7.20 million. Those numbers answer different questions: $9.20 million is the cash contribution needed after other closing funds; $7.20 million is the new money needed from elsewhere.

Do not count the same $400,000 once as a source and again as a reduction in required new reserves. Do not count the venture's $2 million unless using it leaves enough cash for payroll, repairs, taxes, and other obligations. The refinance-risk assessment should include the borrower's other debt, financial condition, and timing requirements.^[1]

Identify what would actually reduce the gap

Because LTV binds in the base example, higher cash flow alone does not immediately increase loan proceeds if the lender-accepted value remains $100 million. Increasing cash flow from $6.4 million to $6.7 million improves the coverage and debt-yield results, but the LTV ceiling still limits principal to $65 million. An operational improvement may ultimately support a different valuation; do not assume that separate step happens automatically.

Reducing transaction costs by $200,000 reduces the required closing contribution by $200,000, assuming no other input changes. Moving a reserve payment to a later date can improve closing liquidity, but it does not eliminate the later obligation. A principal paydown funded before closing changes the payoff; it also consumes sponsor cash. A model that reports a smaller closing gap after such a paydown should disclose the earlier contribution instead of presenting it as a financing gain.

Increasing permitted leverage changes the model only if the other tests allow the resulting loan. For example, a hypothetical 70% LTV ceiling produces a $70 million valuation-based amount, but the unchanged coverage test still limits principal to about $68.27 million. At that point coverage becomes binding. This is why asking for a higher advance percentage without calculating the remaining tests can overstate the benefit.

Stress the funding requirement, not just the property value

Run a downside case that changes cash flow and financing assumptions together. Assume annual underwritten cash flow falls to $5.6 million, accepted value declines to $90 million, minimum DSCR increases to 1.30x, and the annual underwriting debt constant becomes 8.00%. Keep the hypothetical LTV limit at 65% and debt-yield requirement at 9%.

The three loan amounts become $58.5 million under LTV, approximately $53.85 million under coverage, and approximately $62.22 million under debt yield. Coverage now binds. Keeping the $2.6 million of closing costs and new reserves, and the confirmed $400,000 closing source, the cash contribution needed is approximately $20.35 million. After applying the venture's assumed $2 million, approximately $18.35 million must come from elsewhere.

The point is not that this downside will occur. It is that a funding plan sized only to the $7.2 million base-case new-money requirement has little explanation for a worse execution. The OCC identifies multivariable stress testing as a way to assess refinancing exposure; the assumptions should be relevant to the particular borrower and property.^[1]

Turn the calculation into a funding plan

Assign an evidence owner and an expected confirmation date to each input. The lender owns its underwriting amount and reserve conditions. The existing servicer confirms payoff mechanics. Property accounting supports cash availability and unpaid obligations. The partners establish who can authorize and fund an equity contribution. Counsel reviews contractual approvals and releases. These are proposed planning responsibilities; the actual transaction team may allocate them differently.

Maintain a dated version of the model whenever terms, value, costs, or timing change. Show a base case, a plausible downside, and the cash that is legally and practically available for each. If an extension, sale, or recapitalization is being evaluated, prepare a separate sources-and-uses schedule for that alternative rather than assuming its economics match the refinance.

A lender accommodation may be worth exploring when replacement financing is insufficient. The 2023 interagency workout policy supports prudent accommodations after a comprehensive borrower review, but it does not give a borrower a contractual right to an extension or a reduced payoff.^[4] Any requested relief needs a credible explanation of how repayment becomes achievable.^[4] A precise shortfall calculation is useful because it turns “the refinancing does not work” into specific decisions about proceeds, contributions, timing, and alternatives.