CPA Firm South Florida

Modeling a Business Debt Refinance Before Signing New Terms

A business debt refinance can reduce the payment due each month without reducing the total cost of borrowing. Before signing, model the existing loan and the proposed loan from the same decision date, reconcile the closing funds, and identify every balance still owed at the comparison date. Then test whether the business can meet the payments, covenants, and final maturity under a weaker cash-flow scenario.

This article is part of our guide to cash flow forecasting and financial planning.

The example below shows why a lower rate and a lower payment are not enough to decide. It separates monthly liquidity, nominal cash paid, discounted value, and tax treatment so each measure answers a specific question.

Business owner reviewing a refinancing model
A refinance model should reconcile loan balances, closing costs, payment dates, and the amount due at maturity.

Start with a dated payoff and a complete term sheet

Collect the existing note, latest statement, amortization schedule, amendments, and a payoff quote valid for the expected closing date. A statement principal balance may exclude accrued interest, a prepayment charge, release fees, or other amounts needed to discharge the debt. Identify any daily interest added if closing moves.

For the replacement loan, record the amount advanced, fees paid in cash, fees financed, rate, payment frequency, amortization period, maturity, and payment start date. A ten-year amortization with a seven-year maturity does not repay the debt over ten years unless the agreement actually permits that: the remaining balance comes due at seven years.

Also identify collateral, guarantees, financial reporting requirements, cash restrictions, covenants, and prepayment terms. Confirm the process for releasing old liens and guarantees in writing. A new advance does not by itself establish that every prior obligation or guarantee has been released.

A consistent refinancing example

Assume the business starts today with a $400,000 loan balance, a fixed annual nominal rate of 9%, and 60 monthly payments remaining. Payments occur at month-end, with monthly interest equal to the annual nominal rate divided by 12. The business considers refinancing immediately after making payment 24.

The new loan carries a fixed 7.5% annual nominal rate, uses 120 months to calculate the regular payment, and matures after 84 monthly payments. A $6,000 charge for paying off the existing loan is financed. Another $9,000 of closing costs is paid from business cash. Assume no additional accrued interest at the exact refinance date and no other charges. These are hypothetical terms, not a lending quote.

Loan terms and calculated balances
MeasureKeep existing loanRefinance after payment 24
Balance at the decision date$261,113.58$267,113.58 new principal, including the $6,000 financed charge
Regular monthly payment after that date$8,303.34$3,170.69
Payments remaining after that date3684, plus the remaining principal at maturity
Maturity measured from todayMonth 60, or year 5Month 108, or year 9
Balance after the final regular payment$0.00$101,930.92 balloon
Cash closing costs at refinancing$0.00$9,000.00

The calculation uses payment = principal × monthly rate ÷ [1 − (1 + monthly rate)−number of amortization payments]. Each month, interest equals the opening balance times the monthly rate; the payment less interest reduces principal. Carrying that schedule through 24 payments produces the $261,113.58 existing balance. Calculations retain full precision internally and display cents, so an actual lender’s rounded-payment schedule can have small final-payment differences.

The refinance lowers the regular monthly payment by $5,132.66. However, it moves final maturity four years beyond the existing loan’s maturity. At the new maturity, the example requires the regular $3,170.69 payment plus the $101,930.92 remaining balance, approximately $105,101.61 in total.

Reconcile closing sources and uses

The new lender advances $267,113.58 and the business contributes $9,000.00, providing $276,113.58 altogether. Uses are the old principal payoff of $261,113.58, the $6,000.00 financed charge, and $9,000.00 of other closing costs. Both sides agree.

This reconciliation prevents a common modeling error: counting the old principal payoff as an additional business cash payment while also counting all repayments of the new loan that funded it. A complete closing cash-flow schedule shows both the new borrowing and the payoff. In a comparison of cash the business must supply, their financed portion offsets at closing; the new debt payments and any cash contribution remain in the forecast.

Likewise, do not add the financed $6,000 charge a second time to the future payment total. It is already included in the new principal and therefore affects both the payment and the balloon.

Compare cash paid from the same decision date

The first 24 payments are common to both paths. At the refinancing decision date, keeping the original loan requires 36 further payments totaling $298,920.32. Refinancing requires $9,000 in cash costs, 84 regular payments, and the final balloon, totaling $377,268.50. The refinance therefore requires $78,348.19 more nominal future cash under these assumptions.

If reporting totals from today’s starting point, add the same first 24 payments, $199,280.21, to both options. The full totals become $498,200.53 for keeping the loan and $576,548.71 for refinancing. Do not compare one option from today with another beginning two years later.

Nominal totals do not account for the time value of money, taxes, or the business value of cash retained earlier. They do show that the $5,132.66 monthly payment reduction is liquidity relief, not automatically a reduction in total borrowing cost. Dividing the cash fee by that payment reduction is not a reliable economic break-even calculation because the loan balances and repayment periods differ.

Use a common exit date or a discounted comparison

If the owner expects to sell the business at the original loan’s maturity, compare both options at month 60 from today. The existing loan will be repaid. The new loan will have received only 36 payments and will still owe $206,717.20. Include that terminal payoff; stopping the model at the last projected monthly payment would omit a substantial liability.

Assuming the new loan can be paid off then without an additional charge, the refinance path requires $9,000 in closing cash, 36 new payments, and that remaining balance: $329,861.88 from the decision date through the common exit date. That is $30,941.56 more than the $298,920.32 baseline. Add any actual early-payoff charge or release cost required by the new agreement.

A present-value comparison instead discounts each dated cash outflow to the decision date. For illustration only, use an 8% effective annual discount rate, converted to a monthly rate as (1.08)1/12 − 1. Over the 84 months following refinancing, the old loan has payments in months 1–36 and none thereafter; the new loan has the cash closing costs at time zero, 84 payments, and its balloon in month 84.

On that explicitly pre-tax basis, the present value is approximately $266,066.74 for keeping the loan and $273,731.35 for refinancing. The refinance costs $7,664.61 more in present-value terms at this assumed discount rate. Use a rate appropriate to the decision and test alternatives; 8% is an illustration, not a forecast or recommendation.

Keep tax treatment separate from cash and book entries

A principal repayment reduces debt; it is not an interest deduction. For tax purposes, interest allocation generally follows the use of borrowed funds. Replacement borrowing used to repay existing debt generally carries forward the allocation of the repaid debt under Treasury Regulation §1.163-8T. Separately trace any additional proceeds used for other purposes.

Business interest can be subject to deduction limits and exceptions. Before assuming an immediate tax benefit from every dollar of interest, review the entity’s circumstances and the IRS guidance on the business-interest limitation. A deduction that cannot be used currently does not create the same current cash-tax benefit as an immediately usable deduction.

Classify each refinancing charge. Qualifying debt issuance costs generally must be capitalized and recovered over the debt term using the applicable rules in Treasury Regulation §1.446-5. Do not treat every lender fee, third-party cost, or prepayment charge as interchangeable, or assume that financing a charge establishes when it is deductible.

Book accounting also depends on whether the transaction is a modification or extinguishment and on the type and recipient of each fee. Under the debt accounting guidance discussed in FASB’s amendments addressing debt arrangements, creditor fees and third-party costs can receive different treatment. Review old unamortized costs instead of automatically writing all of them off.

The tax analysis of a significant debt modification under Treasury Regulation §1.1001-3 is a separate determination from book modification or extinguishment accounting. An after-tax model should add the actual projected cash-tax effects and timing for each option, including applicable deduction limits and cost recovery. Do not simply multiply every fee and principal payment by an assumed tax rate.

Test repayment capacity and the maturity plan

Build the debt payments into a cash forecast that also includes payroll, taxes, working capital, equipment spending, and owner distributions where applicable. Test delayed collections, a weaker margin, higher necessary spending, and reduced access to credit. For a variable-rate proposal, model the contractual index, margin, reset dates, floors, caps, and whether a rate change alters the payment or the remaining balance.

Calculate covenants using the definitions and measurement periods in the proposed agreement. Accounting earnings and a lender’s defined coverage numerator are not necessarily cash available to pay debt. Lower payments may improve one ratio while a new cash restriction, guarantee, or balloon creates another constraint.

Document how the balloon would be paid: accumulated unrestricted cash, a supported asset-sale plan, or replacement financing subject to approval and future market conditions. Refinancing at maturity is one possible funding source, not an assured outcome. The final decision package should include the reconciled amortization schedules, closing sources and uses, common-date comparison, tax assumptions, downside forecast, and proposed contract terms.

If you need help reviewing the accounting and tax assumptions, contact CPA Firm South Florida to confirm the scope of the requested work. Have counsel review contractual obligations and lender documentation as appropriate before signing.

We break down Debt-Service Coverage separately in “Debt-Service Coverage: What Lenders and Owners Should Monitor.”

Frequently asked questions

Does a lower monthly payment mean the refinance costs less?

No. A longer repayment schedule can lower monthly payments while increasing total payments and leaving a balloon. Compare fees, balances, maturity dates, and discounted cash flows as well as monthly cash relief.

Should the old loan payoff be added to the new loan payments?

In a cash-outflow comparison for the business, show the new borrowing and old payoff together at closing. If the new loan funds the payoff, adding that payoff again to later new-loan payments double counts the financed amount. Include any separate cash contribution.

Is a balloon included in the last regular payment?

Usually the remaining principal is due in addition to the scheduled payment, but the agreement controls. In this example, the balance after the 84th new-loan payment is $101,930.92, so maturity requires that balance plus the regular $3,170.69 payment.

Are refinancing fees immediately deductible?

Not necessarily. Classify each charge separately. Qualifying debt issuance costs generally are capitalized and recovered over the debt term under the tax rules; other charges and old unamortized costs require their own analysis. Book treatment may differ.

Scroll to Top