Calculating cash required when new loan proceeds do not cover payoff
A practical guide for sponsors to prepare a refinance gap analysis workpaper, identify shortfall sources, and present findings to lenders.
A practical guide for sponsors to prepare a refinance gap analysis workpaper, identify shortfall sources, and present findings to lenders.
When a new permanent loan's proceeds fall short of the existing debt payoff, the difference must come from the sponsor's equity or another source. This guide provides a concrete evidence checklist and a workpaper to prepare before approaching lenders, focusing on documented assumptions and lender tests rather than specific numerical benchmarks.
Identify the payoff amount and its components
Start by recording the full payoff required for the existing loan. This includes the principal balance, accrued interest, prepayment premium (if any), and any fees or penalties. Ask the current lender for a written payoff statement that breaks down each component. [1] notes that prepayment terms on commercial permanent loans can include yield maintenance or defeasance, which may add significant cost. The payoff statement should be dated close to the expected closing date of the new loan to reflect accurate payoff amounts.
Determine the new loan proceeds under each lender test
A permanent lender typically sizes a loan using several tests, including maximum loan-to-value, minimum debt service coverage ratio, and often minimum debt yield. [1] explains that the most restrictive test generally sets the maximum loan amount. Prepare a workpaper that calculates the maximum loan under each test based on the lender's underwritten net operating income and appraised value. Compare these amounts to identify the binding constraint.
Prepare a refinance gap workpaper
Create a simple spreadsheet with the following line items: - Existing debt payoff (from payoff statement) - New loan proceeds (the binding constraint amount from above) - Shortfall (difference between payoff and proceeds) - Sponsor equity contribution to close the gap - Other sources of funds (e.g., mezzanine financing, cash reserves)
This workpaper should be a living document that you update as you receive more information from lenders. It helps you identify the gap early and plan how to fill it.
Understand why the gap occurs
Refinance risk is a key concern for lenders. states that refinance risk affects loans with principal balances remaining at maturity and borrowers who rely on recurring debt to finance their capital structure. Factors that can create a gap include: - Declining property value due to market conditions - Increased expenses reducing NOI - Tighter underwriting standards (higher DSCR or lower LTV requirements) - Higher interest rates reducing debt service capacity - Prepayment penalties on the existing loan
Assess the sponsor's ability to cover the gap
Lenders will evaluate the sponsor's financial capacity to contribute additional equity. [1] notes that lenders look at the sponsor's net worth, liquidity, and record. Prepare a summary of your available cash, liquid investments, and any committed equity from partners. Be ready to document the source and timing of funds.
Present the gap analysis to the lender
When you approach a lender, present the workpaper along with your operating history and pro forma. advises that a prudent assessment of refinance risk includes the borrower's refinancing needs, the performance of the underlying asset, and the cost of refinancing. Show the lender that you have identified the gap and have a credible plan to close it. This demonstrates financial discipline and reduces the lender's concern about refinance risk.
Consider stress testing the gap
recommends transaction-level stress testing to assess the borrower's ability to meet refinancing requirements if financial condition declines or market conditions deteriorate. Run a sensitivity analysis on your workpaper considering scenarios such as a decrease in net operating income, an increase in interest rates, or a decline in appraised value. This prepares you for lender questions and helps you evaluate whether the refinancing is viable under adverse conditions.
Frequently asked questions
What if the gap is too large to cover?
If the shortfall exceeds available equity, consider restructuring the existing loan with the current lender, seeking mezzanine financing, or delaying the refinance until property performance improves. discusses loan workouts as an option when borrowers are unable to meet contractual payment obligations.
Does the gap analysis affect loan terms?
A large gap may signal higher refinance risk to the lender, potentially affecting pricing or structure. However, focuses on the lender's risk assessment, not specific pricing outcomes. The workpaper helps you address concerns proactively.
How do prepayment penalties affect the gap?
Prepayment penalties, especially yield maintenance or defeasance, can substantially increase the payoff amount. [1] explains that yield maintenance compensates the lender for the difference between the loan's interest rate and a reinvestment rate, while defeasance requires purchasing securities to cover remaining scheduled payments. Include these costs in your payoff calculation.
This guide is a suggested way to prepare information for a financing discussion, not a mandatory lender process. Submission of a workpaper is a preliminary request, not an engagement or lender submission.
Model this deal and request financing
Run a refinance model with your own numbers in the financing workbench. Results are calculated on the server with the assumptions shown. If you choose to send the request, you get a preliminary lender-package PDF and can attach your rent roll, T-12 or OM.
Opens the financing workbench operated by Wraith Real Estate. Nothing goes to any lender without Wraith's review and your agreement.
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).