🚀 Quick Summary
- Refinancing isn’t just swapping one loan for another – it’s a cash event with fees, break costs, and timing risk that can surprise even seasoned teams.
- The fix is a clean, scenario-ready business debt schedule that shows old vs new structures side by side, all the way down to cash.
- Model every fee type explicitly: upfront, arranger, legal, advisory, and ongoing margin or line fees. Don’t hide them in “other” lines.
- Treat break costs as separate, one-off cash items and make them highly visible in your debt schedule template and 13‑week cash view.
- Align interest methods and day-count conventions to your existing facilities so your debt financing work compares apples to apples.
- Compare refinancing not only with bank loans but also with vendor terms and bank debt alternatives such as vendor notes or extended payables.
- Build the model so you can flex dates, amounts, and structures quickly – then discuss trade‑offs with lenders and management from a single debt schedule view.
- If you’re short on time, remember this: model every refinancing cash impact explicitly before you sign; assumptions in heads of terms are not a cash forecast.
💡 Introduction: Why This Topic Matters
Most refinancing surprises aren’t about interest rates; they’re about cash. Arrangement fees drawn from the facility, legal costs paid upfront, unmodelled break fees, and gaps between old debt closing and new cash landing all erode headroom. When your financing and debt portfolio is already complex, it’s easy to miss a few lines and suddenly lose a month of runway. A robust refinancing model sits on top of your existing business debt schedule, showing old vs new, with every fee and timing impact visible. It’s how CFOs, treasurers, and deal teams turn term sheets into real cash scenarios rather than hopeful back-of-the-envelope math. This guide walks through a practical structure you can reuse for each transaction so that “no surprises” becomes the default outcome, not the exception.
🧩 A Simple Framework You Can Use
The framework is straightforward:
(1) Lock your baseline by freezing the current debt schedule.
(2) Create a mirrored structure for the proposed facility or facilities.
(3) Insert all fees, break costs and closing adjustments as explicit rows.
(4) Wire everything into a short‑term and long‑term cash view. Use consistent day-count conventions and timing rules so you don’t compare a 30/360 term loan with an ACT/365 revolver incorrectly.
Treat refinancing like a mini-transaction model that lives inside your broader financing and debt environment rather than a one-off spreadsheet. When the basics are standardised, your team can flex leverage, tenor, amortisation, and even lease vs loan alternatives quickly – and make decisions based on real cash, not headline rates.
🛠️ Step-by-Step Implementation
Step 1: Capture the “As-Is” Debt Position
Begin by snapshotting your current facilities into a clean debt schedule template. For each facility, capture principal outstanding, margin, base rate, remaining tenor, repayment profile, covenants, and all fee types. This becomes your baseline “As-Is” case for comparison. Ensure your business debt schedule matches lender statements and internal GL records – this is not the time for approximations. Then freeze this version and tag it as the reference scenario for your refinancing evaluation. If you have multiple entities, confirm consolidation rules so you understand how the refinancing affects group-level covenants and headroom, not just one borrower. With a solid baseline, every change you model is a deliberate, traceable decision rather than a guess.
Step 2 – Model the Proposed New Structure in Detail
Next, build the “To-Be” structure in parallel. Add new facilities – term loans, revolvers, vendor notes, or hybrids – with their specific pricing, tenors, and repayment rules. Insert all transaction-related fees as explicit lines: upfront facility fees, legal and advisory costs, ticking fees, and any commitment fees. Decide which are capitalised versus cash-out and reflect this treatment clearly in both your debt schedule and cash flow outputs. When you compare proposals, stick to identical timing assumptions across options so your financing and debt analysis are consistent. This is also where you consider whether elements of vendor terms and bank debt or extended supplier terms make sense as part of the package.
Step 3 – Layer in Break Costs, Prepayment, and Overlap Timing
Refinancing rarely happens instantaneously. There’s often an overlap where old and new debt co-exist for a period, and where break costs or prepayment penalties hit. Create a timeline of key dates – mandate signing, documentation, closing, and first repayment – and map cash flows to each. Add lines in your debt service schedule in Excel (or equivalent) for break fees, make-whole payments, capitalised interest, and any compensating balances. Make sure your 13‑week and 12‑month cash views reflect the period where the business may be, in effect, double-levered. This is where good debt financing work reveals whether the deal is genuinely accretive or just looks attractive on headline margin.
Step 4 – Compare Scenarios and Risk-Adjusted Outcomes
Once “As-Is” and “To-Be” structures are built, you can start asking meaningful questions. How does each option change your average cost of capital, but more importantly, your minimum cash headroom over the next 12-24 months? Use scenarios to flex base rates, EBITDA trajectories, and working capital needs. Summarise results into an executive comparison view: total fees paid, break costs, peak and trough cash, and covenant headroom for each scenario. Don’t forget to compare bank-led refinancing with combinations of vendor terms and bank debt, leases and lease vs loan structures when relevant. The right answer is often a blend, not a single instrument.
Step 5 – Turn the Model Into a Decision & Communication Tool
Finally, convert your technical model into a practical decision aid. Create a lender-ready summary that explains how your business debt schedule evolves post-refinancing: facility mix, covenants, headroom and usage plans. Build a management summary that highlights trade-offs: cash out today vs savings tomorrow, risk of double-leverage vs long-term flexibility, and how the refinancing supports strategic goals. Tie all this back to a single debt schedule template that updates automatically as transactions complete. When your board, lenders and operators are all looking at the same financing and debt picture, approvals move faster, and confidence rises.
📌 Real-World Examples
A regional services group needed to refinance a maturing revolver and term loan while funding a small acquisition. Initially, the team focused solely on rate and tenor, ignoring fees and timing. After rebuilding their debt schedule with separate “As-Is” and “To-Be” scenarios, they discovered that one bank’s “cheapest” proposal actually created a six-week double-leverage period plus significant break costs. Another offer, slightly more expensive on margin, minimised overlap and front-loaded savings in the first 18 months. The CFO used a simple scenario pack showing cash headroom across three cases. The board approved the second option, and the business retained a comfortable minimum cash and covenant coverage throughout, with no scrambling to plug gaps at close.
⚠️ Common Mistakes to Avoid
Many teams underestimate non-interest costs, treating fees and break costs as rounding errors. In reality, they can consume a meaningful chunk of the benefit from refinancing. Another mistake is not reconciling the refinancing model back to the underlying business debt schedule, leading to inconsistencies between board materials and lender reporting. Day-count conventions are frequently mishandled, skewing comparisons between structures. Teams also neglect working capital impacts – for example, tighter covenants may restrict future vendor terms and bank debt usage or limit dividends. Finally, some treat leases as entirely separate, even though lease vs loan decisions often determine how much headroom a refinancing really delivers. Making these elements explicit in your debt schedule template prevents nasty surprises.
❓ FAQs
Aim for enough detail that every cash movement tied to the deal has its own line: fees, break costs, capitalised interest, new facility drawdowns and old facility repayments. You don’t need a full LBO model, but you do need a robust business debt schedule with transparent assumptions. If a number could cause a surprise on closing day, it deserves its own row. A clean, reusable debt schedule template gives you this without turning the exercise into a monster
spreadsheet.
Standardise everything: same start dates, same base rate assumptions, and consistent treatment of fees and break costs in cash terms. Use your debt schedule to produce a simple comparison: total cash cost over the horizon, average headroom, and covenant buffers. Don’t just look at rate - consider flexibility, security, and operational constraints such as reporting demands. When you evaluate offers through one consistent
financing and debt lens, trade-offs become much clearer to boards and lenders alike.
Vendor notes and extended payables can be powerful complements to bank refinancing. In your debt financing work, model them as separate instruments with their own pricing, covenants and maturities. Compare them alongside bank facilities, not as afterthoughts. Sometimes
vendor terms and bank debt together deliver the right balance of cost and flexibility. Just ensure you reflect the impact on working capital and supplier relationships, not only cash cost. A combined view in your debt service schedule in Excel will make the trade-offs obvious.
Lock your model early, circulate it to advisers, and reconcile it line by line with term sheets and draft documentation. Use your business
debt schedule as the single source of truth for all numbers in presentations and memos. Before signing, walk through a “day of close” cash flow: which accounts move, when fees hit, and what balance remains afterwards [546]. If anything can’t be traced to a specific line in the model, fix it before you sign. That discipline is the best insurance against closing day surprises.
👉 Next Steps
You now have a practical structure for modeling refinancings without drama. The next step is to embed it into your standard financing and debt toolkit instead of treating each transaction as a bespoke exercise. Start by upgrading your core debt schedule template so it can accommodate “As-Is” vs “To-Be” views and explicit fee lines [520]. Then, for your next refinancing, insist that every proposal is evaluated through this model and summarised in a consistent scenario pack. Finally, connect the outputs to your broader budgeting and headroom dashboards so refinancing decisions are made in the context of strategy, not just interest savings. Over time, this turns refinancing from a stressful, one-off event into a repeatable, well-governed workflow.
Back