How to separate gross refinance proceeds from cash available to the sponsor
A practical guide to preparing a refinance gap analysis workpaper that distinguishes total loan proceeds from net cash to the sponsor, with an evidence checklist and task-specific worksheet.
A practical guide to preparing a refinance gap analysis workpaper that distinguishes total loan proceeds from net cash to the sponsor, with an evidence checklist and task-specific worksheet.
When a commercial real estate sponsor refinances a property, the total loan amount is rarely the cash that reaches the sponsor's account. Understanding the difference between gross refinance proceeds and available cash is critical for planning capital improvements, distributions, or reinvestment. This guide provides a concrete workpaper and evidence checklist to help sponsors prepare this analysis before approaching a lender.
Identify the current debt that must be retired
Start by listing every existing loan, line of credit, or other secured obligation that will be paid off from the refinance proceeds. For each debt, record the lender, the outstanding principal balance as of the expected closing date, the per diem interest accrual, any prepayment penalty or yield maintenance premium, and the payoff contact at the lender. This is not a theoretical exercise—the new lender will require a payoff statement from each existing lender before closing. The OCC notes that refinance risk increases when a borrower has a significant volume of near-term maturities, so the sponsor should also note the maturity date of each existing loan to show the urgency of the refinance.
Suggested workpaper column: Debt name, lender, current balance, per diem interest, prepayment penalty formula, maturity date, payoff contact.
Estimate transaction costs that reduce net proceeds
Closing a commercial permanent loan involves several third-party costs that are typically deducted from the loan proceeds at closing. These include the lender's origination fee or points, appraisal, environmental report, survey, title insurance, legal fees for borrower's counsel and lender's counsel, and recording taxes. [1] The sponsor should request good-faith estimates from each vendor and the lender early in the process. While some costs are fixed, others vary with loan size or property complexity. Recording these estimates in a single table helps the sponsor compare the gross loan amount to the net funds available after all deductions.
Suggested workpaper column: Cost category, estimated amount, vendor name, whether the cost is paid at closing or upfront.
Calculate sponsor equity cash-out after reserves
After paying off existing debt and transaction costs, what remains is the sponsor's equity cash-out—but only if the lender permits a cash-out at all. Some permanent loans restrict cash-out to a percentage of the sponsor's original equity or require that all net proceeds be applied to the property. [1] The sponsor should also account for any required reserves the lender will hold at closing, such as a replacement reserve, a tax and insurance escrow, or a leasing reserve. These reserves reduce the cash available for distribution or reinvestment, even though they remain on the sponsor's balance sheet.
Suggested workpaper line: Gross loan amount minus (existing debt payoff + transaction costs + reserves) = net cash to sponsor.
Reconcile the rent roll and trailing twelve-month income
A current rent roll is a snapshot of in-place leases as of today, while a trailing twelve-month (T-12) operating statement shows actual collected income over the past year on a cash or accrual basis, which should be specified. These two documents often report different numbers because of timing differences: a rent roll shows gross rent under lease, while a The T-12 reports historical income and expenses on its stated accounting basis after vacancy, concessions, and bad debt. [1] To separate gross refinance proceeds from available cash, the sponsor must reconcile these figures. First, record the total gross rent from the rent roll. Then, from the T-12, calculate the average monthly collected income. The difference reveals collection loss that the lender will underwrite. The sponsor should also identify any one-time or seasonal items in the T-12 that may not recur.
Suggested workpaper column: Rent roll gross rent, T-12 average collected income, difference, explanation of variance.
Build a debt service coverage test with your own NOI
Lenders size a permanent loan by testing net operating income against annual debt service. [1] The sponsor should prepare its own calculation of net operating income (NOI) by starting with effective gross income, subtracting operating expenses, and excluding debt service, capital expenditures, and depreciation. Then compare NOI to the proposed annual debt service according to the lender's actual underwriting test or the sponsor's documented assumption. If the coverage is below the lender's minimum, the loan amount may be reduced, which directly affects cash available to the sponsor. The OCC advises that banks should assess whether a borrower can meet current underwriting standards, including prevailing interest rates, for similar loans. The sponsor should test multiple interest rate scenarios to see how rising rates affect coverage and cash-out.
Suggested workpaper table: NOI, proposed annual debt service at three rate scenarios, resulting debt service coverage ratio.
Distinguish net operating income from cash flow available for distribution
NOI is a property-level metric, but sponsor cash flow includes additional items. After NOI, the sponsor must subtract capital expenditures, leasing commissions, tenant improvements, and any lender-required reserves to arrive at cash flow available for debt service and equity distributions. [1] This distinction matters because a lender may underwrite NOI that includes a vacancy and collection loss factor, while the sponsor's actual cash flow may be higher or lower than underwritten NOI. The sponsor should prepare a side-by-side comparison of underwritten NOI and actual cash flow to identify gaps that could reduce the loan amount.
Suggested workpaper line: Underwritten NOI minus (capex + leasing costs + reserves) = cash flow available for debt service and equity.
Prepare a refinance gap analysis checklist
The following checklist summarizes the evidence a sponsor should gather before requesting a permanent loan quote. Each item supports the separation of gross proceeds from net cash.
- Existing debt payoff statements from each current lender, including per diem interest and prepayment penalties
- Good-faith estimates of closing costs from lender, appraiser, environmental consultant, surveyor, title company, and attorneys
- Lender's reserve requirements for replacement, tax and insurance, and leasing
- Current rent roll dated within 30 days
- Trailing twelve-month operating statement showing collected income by month
- Reconciliation of rent roll gross rent to T-12 collected income
- Sponsor's own NOI calculation and debt service coverage test at multiple interest rates
- Side-by-side comparison of underwritten NOI and actual cash flow
FAQs
What is the difference between gross refinance proceeds and net cash to sponsor?
Gross refinance proceeds are the total loan amount the lender commits. Net cash to sponsor is what remains after paying off existing debt, transaction costs, and any required reserves. The sponsor should prepare a simple waterfall calculation to see the gap.
Does a permanent loan always allow a cash-out?
No. Some permanent loans restrict cash-out according to the lender's policy or require that all net proceeds be applied to the property. The sponsor should ask the lender about cash-out policy before applying. [1]
How does the rent roll differ from the trailing twelve-month income?
The rent roll is a current snapshot of gross rent under lease, while the trailing twelve-month statement shows actual collected income over the past year. The difference reveals collection loss that the lender will underwrite. [1] The sponsor should reconcile these two documents to avoid surprises in the loan sizing.
If you are preparing a refinance and want to separate gross proceeds from cash available, send us the property, the business plan, the amount you need, and your target timing. We will tell you how we would approach it.
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).