Debt Structuring and Modeling

Many FP&A models show debt as a single line on the balance sheet. But if you've ever modeled a restructuring or acquisition, that approach collapses. The consequences are more severe than getting other line items wrong. Because if you model debt ratios and balances wrong, chances are greater that the company may trip a covenant. It also means less confidence in the management of cash to pay interest and principal. That’s why how you model debt matters. FP&As benefit from breaking that single line item on the balance sheet down into supporting roll forwards or schedules. In this example, you can see that I have a "Debt Breakdown". Each individual element of debt is captured up at the top. It's almost all blue font (exception of the existing credit facility) which means you can edit the inputs, remove retired debt, and insert new raises. Everything in the debt breakdown influences the dynamic forecasts below. When building or audit models, here’s what to look for: • Transparency in assumptions: Interest rates, timing conventions, and repayment terms should be obvious and centralized. There is no hunting through hundreds of lines of formulas. In this example, I've listed them all at the top so that the CFO or Controller can update them as needed.    • Traceability to source schedules: If debt ties to an acquisition or to capex, it should be clear how those schedules feed into debt drawdowns and repayments. In fact, you've probably seen in some of my modeling examples how the debt triggers on/off depending on whether the capex decision is green-lighted.    • Consistency of logic: The order of calculations (beginning balance → draws → repayments → ending balance) should follow a natural flow. It's not remarkably different than what you'd see in other line items. For example, accounts receivable looks like beginning balance → sales → collections → ending balance). This makes the math easy to analyze and audit. Remember: If you're going to bake all financing into one line item, you risk overlooking the details of each debt instrument that makes it up. And if you ignore the details, that's bad FP&A.

Do you even realize just how powerful a well-built Three-Statement Model can be? When you truly understand how the Income Statement, Balance Sheet, and Cash-Flow Statement flow into one another, and how the supporting schedules knit everything together, you unlock a toolkit that scales far beyond “textbook” budgeting. Here’s why those connections matter: ⨠Cause & effect comes to life. Change revenue recognition and you instantly feel the ripple in working capital, taxes, and cash. ⨠Checks & balances are built-in. The model’s dynamic logic forces every schedule (revenue, cost, capex, debt, equity, taxes, working capital) to reconcile, highlighting errors before they can hide in the numbers. ⨠Storytelling becomes sharper. A single assumption tweak tells a cohesive story across all three statements, exactly what boards, investors, and lenders want to see. 🔍 Master the foundations first, then level-up to tackle bigger questions like: ⁕ Full DCF valuations & sensitivity trees (equity or project finance) ⁕ Scenario-based cash runway planning for startups or high-growth SaaS ⁕ Debt-capacity & covenant headroom analysis in leveraged deals ⁕ LBO and recap structures with complex waterfall returns ⁕ Working-capital optimization and financing strategies (DSO/DIO/DPO) ⁕ Integrated stress testing & reverse stress cases for risk management ⁕ M&A accretion/dilution and synergy tracking ⁕ Tax-efficient structuring & NOL utilization ⁕ Capital allocation frameworks (dividends vs. buybacks vs. reinvestment) ⁕ Operational driver dashboards that tie KPIs directly to cash flow Whether you’re an analyst building your first model or a CFO steering strategic decisions, the Three-Statement backbone is the launchpad. Nail the linkages and those basic schedules will scale with every “what-if” the real world throws at you. I’m curious how you are leveraging your models for next-level insights! Drop a comment. Let’s compare notes! 👇 #Finance #FinancialModeling #ThreeStatementModel #FPandA #CorporateFinance #LinkedInLearning

I've reviewed hundreds of financial models across 100+ clients. Most of them fail in the first 30 seconds. https://lnkd.in/eHYUr9Jc The numbers might be fine. But I open the file and see 47 tabs with names like "Sheet2_final_v3" and I already know what I'm dealing with. Assumptions buried in random cells. No flow. No structure. If I can't follow your model, nobody else will either. This is the same 9-part structure I use at my firm and teach to every fractional CFO I work with. → Drivers TabThis is the most important tab in your entire model. One place for every assumption. Revenue growth, headcount, tax rates. Change one input and the entire model updates. No hunting through tabs. → Source Data TabsRaw exports from QBO or your ERP. Keep them separate from your calculations. One formula pulls from here to populate everything else. → Error Check TabValidates that data made it from source to destination. Assets equal liabilities plus equity. Revenue ties across statements. Green means fine, red means stop. → Instructions TabMost people skip this. Don't. Which cells are editable, which tabs are read-only, what each color means. Your model will get passed around. Make it easy to audit. → Three Financial StatementsIncome statement, balance sheet, cash flow. All pulling from the drivers tab. Historicals and projections in one place. → Revenue TabYour most important forecast. Build it separately, link it back to drivers. Every business is different here, but the connection to the model stays the same. → Headcount TabYour largest expense needs its own schedule. Start dates, salaries, departments, prorated amounts. One mistake here and your cash forecast is off by six figures. → Balance Sheet SchedulesAR, AP, CapEx, debt. Waterfalls that show how balances move over time. These connect your P&L to your cash flow. → DashboardsThe view your board actually sees. KPIs, summary financials, budget vs actual. Everything else feeds into this. You can build your own following this structure, or grab a free template here: https://lnkd.in/eHYUr9Jc What does your model structure look like?

Struggling with cash flow despite steady revenue? Read this. Most businesses focus on revenue growth, but forget that timing matters more than total numbers. Your debt structure might be strangling your operations. During my years restructuring finances for MSMEs, I've seen countless profitable businesses gasping for air simply because their loan repayments peaked when their cash reserves ebbed. Remember when I helped that manufacturing client switch from monthly fixed payments to a seasonal repayment schedule? Their stress vanished overnight. Their revenue always spiked in Q4, yet their heaviest loan payments fell in Q2. We realigned their amortization schedule to match their natural business cycle. Smart debt structuring considers your unique operational rhythm. Consider bullet loans that allow interest-only payments until you can handle the principal. Explore graduated payment structures that start small and grow with your business. Investigate seasonal amortization that mirrors your cash flow patterns. Your business deserves a repayment schedule that respects its natural ebb and flow. The right structure preserves working capital during lean periods while capitalizing on abundance during peak seasons. Think beyond interest rates. The structure of how and when you repay matters just as much. After restructuring debt for hundreds of businesses, I can tell you with certainty: cash flow preservation through thoughtful amortization scheduling might be the most underutilized financial strategy. What financial structure is holding your business back today? Share your challenge below, and perhaps we can uncover a solution together. #CashFlowManagement #AmortizationSchedule #FinancialPlanning #BusinessFinance

💰 𝗠𝗼𝗿𝗲 𝗰𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀 𝗱𝗶𝗲 𝗳𝗿𝗼𝗺 𝗺𝗶𝘀𝗺𝗮𝗻𝗮𝗴𝗲𝗱 𝗱𝗲𝗯𝘁 𝘁𝗵𝗮𝗻 𝗳𝗿𝗼𝗺 𝗹𝗮𝗰𝗸 𝗼𝗳 𝗳𝘂𝗻𝗱𝗶𝗻𝗴. 𝗧𝗵𝗲 𝗿𝗲𝗮𝗹 𝗽𝗿𝗼𝗯𝗹𝗲𝗺? 𝗜𝘁’𝘀 𝗻𝗼𝘁 𝘁𝗵𝗲 𝗹𝗼𝗮𝗻—𝗶𝘁’𝘀 𝘁𝗵𝗲 𝘀𝘁𝗿𝘂𝗰𝘁𝘂𝗿𝗲. In debt syndication, beyond securing funds, we craft capital structures. Yet, many businesses still falter quickly after obtaining syndicated loans. Over 50% of corporate loan defaults are due to poor debt structuring, not revenue issues. 𝗧𝗵𝗲 𝗥𝗲𝗮𝗹 𝗣𝗿𝗼𝗯𝗹𝗲𝗺: 𝗪𝗵𝗲𝗻 𝗗𝗲𝗯𝘁 𝗕𝗲𝗰𝗼𝗺𝗲𝘀 𝗮 𝗧𝗿𝗮𝗽 Companies often make expensive mistakes by hurrying to obtain financing. 🔹 A manufacturer uses short-term loans for long-term projects, causing liquidity issues. 🔹A startup takes on restrictive covenants for lower interest, limiting future funding. 🔹 A real estate developer faces downfall with rigid repayment terms in a market slowdown. These aren’t just bad decisions. They’re structural failures. 𝗧𝗵𝗲 𝗔𝗻𝗮𝘁𝗼𝗺𝘆 𝗼𝗳 𝗦𝗺𝗮𝗿𝘁 𝗗𝗲𝗯𝘁 𝗦𝘁𝗿𝘂𝗰𝘁𝘂𝗿𝗶𝗻𝗴 What makes a syndicated loan secure instead of risky? 🔹 Term Loans vs. Revolving Credit – Flexibility matters; choose based on cash flow cycles. 🔹 Mezzanine Financing – Useful for confident growth but risky for unstable revenues. 🔹 Structured Finance & SPVs – Special Purpose Vehicles (SPVs) protect parent companies from distress. 🔹 Hybrid Models – The future is in blending traditional bank loans with private credit solutions. Successful deals focus on sustaining businesses, not just securing funds. The Leadership Mindset: Debt Is a Strategy, Not Just a Transaction Smart leaders don’t just borrow money. They engineer capital. ✅ They ensure debt structure aligns with cash flow realities. ✅ They negotiate terms that offer breathing space. ✅ They prepare for economic shifts, interest rate hikes, and industry cycles. 💡 Debt isn’t the problem. Poor debt structuring is. 𝗧𝗵𝗲 𝗠𝗼𝘀𝘁 𝗖𝗼𝗺𝗺𝗼𝗻 𝗠𝗶𝘀𝘁𝗮𝗸𝗲𝘀 𝗶𝗻 𝗗𝗲𝗯𝘁 𝗦𝘆𝗻𝗱𝗶𝗰𝗮𝘁𝗶𝗼𝗻 🚫 𝗠𝗶𝘀𝗮𝗹𝗶𝗴𝗻𝗲𝗱 𝗗𝗲𝗯𝘁 𝗧𝗲𝗻𝘂𝗿𝗲 – Short-term loans for long-term projects create liquidity nightmares. 🚫 𝗨𝗻𝗱𝗲𝗿𝗲𝘀𝘁𝗶𝗺𝗮𝘁𝗶𝗻𝗴 𝗖𝗼𝘃𝗲𝗻𝗮𝗻𝘁𝘀 – Restrictive clauses can strangle future financing. 🚫 𝗟𝗮𝗰𝗸 𝗼𝗳 𝗙𝗶𝗻𝗮𝗻𝗰𝗶𝗮𝗹 𝗔𝗴𝗶𝗹𝗶𝘁𝘆 – Rigid repayment structures kill flexibility in downturns. 🚫 𝗜𝗴𝗻𝗼𝗿𝗶𝗻𝗴 𝗔𝗹𝘁𝗲𝗿𝗻𝗮𝘁𝗶𝘃𝗲 𝗗𝗲𝗯𝘁 𝗦𝘁𝗿𝘂𝗰𝘁𝘂𝗿𝗲𝘀 – Private credit and hybrid models often offer better long-term sustainability. 𝗙𝗶𝗻𝗮𝗹 𝗧𝗵𝗼𝘂𝗴𝗵𝘁: 𝗧𝗵𝗲 𝗙𝘂𝘁𝘂𝗿𝗲 𝗼𝗳 𝗗𝗲𝗯𝘁 𝗦𝘆𝗻𝗱𝗶𝗰𝗮𝘁𝗶𝗼𝗻 The market is shifting; traditional syndicated lending now integrates with private credit, structured finance, and hybrid models. Top syndication experts design lasting financial strategies. 📢 𝗬𝗼𝘂𝗿 𝗧𝗮𝗸𝗲: Every finance professional has seen a debt deal fail. What's your key lesson from structured financing? Let's exchange insights and create smarter strategies!💬👇

Inside an LBO Process: What the Analyst Is Really DoingYou 1) Start With Cash Flow Stability Before touching Excel, you build a view on the business. • how predictable are revenues • how volatile are margins • how the business behaved in downcycles Because leverage only works if cash flows hold under pressure. 2) You Translate EBITDA Into Real Cash EBITDA is not enough. You break it down into: • working capital movements • maintenance vs growth capex • cash taxes The focus is simple: “How much cash is actually available for debt repayment?” 3) You Build a Quick First Cut The first model is rough. • base case growth • stable margins • simple debt structure The objective is not precision. It is to test feasibility: “Does this deal work at all?” 4) Then You Start Breaking the Model This is where most of the work happens. You stress key assumptions: • revenue slowdown • margin compression • higher capex • weaker exit multiple You are identifying: “At what point does the return fall below threshold?” 5) You Work the Capital Structure You test different structures: • total leverage possible • mix of debt instruments • repayment schedules You observe: • how quickly debt reduces • how sensitive IRR is to leverage Small changes here can shift returns meaningfully. 6) You Decompose Returns You track IRR and MOIC. But more importantly, you break them down: • how much comes from growth • how much from deleveraging • how much from exit multiple Because returns driven only by leverage are fragile. 7) You Align the Model With Investment View The model is not built in isolation. It connects back to: • business quality • downside risk • exit visibility You are effectively asking: “Is this a risk we are willing to underwrite at this price?” 8) You Iterate Constantly Assumptions keep changing. • new information from diligence • updated management inputs • changing financing terms The model evolves with each discussion. It is not built once. It is refined repeatedly. Next Live Batch Starts from April 12th. EB till April 5th

The DSCR has three threshold levels. Before financial close, only one matters for modelling (almost true). Afterwards, only the other two do (actually true). The DSCR is, of course, the debt service cover ratio, and it measures how much wiggle room a project has before it cannot afford to pay its senior lenders. A DSCR of 1.3 means that the project is generating 30% more cash from operations than it must give to lenders in the relevant calculation period. Financial close (or "FC") is the point in time where the documents are signed and the lenders are committed to lending to the project at the negotiated terms and the swaps are executed. The three threshold levels are: 1. The Base Case (or "condition precedent" or "CP") ratio. This is the ratio that must be achieved in the model when the debt is sized at financial close. The level this is set to correlates with the perceived riskiness of your cashflows - lower risk cashflows will allow a lower base case ratio. 2. The lock up ratio. If the ratio falls below this level in a given calculation period then your project may not give cash to shareholders in that period (cash is "locked up" in the project). 3. The default ratio. If the ratio falls below this level then the bank has the right to step in and take over the project (rather like if you were to default on your mortgage). Obviously*: Base case > Lock up > Default Therefore, if your pre financial close model meets the base case ratio requirement, you don't need to worry about the other two! Well, almost - the almost is because they will be relevant for downside sensitivity analysis. You will want your model to have the capacity to simulate lock ups and report breaches of default. After FC, the original base case ratio is almost always** no longer relevant. Nothing depends on it in the documentation after that date. Therefore, if you are building an operating model, it is the lock up and default ratios that you need to be focused on. Since (one way or another) reality will be different from the prediction at FC they plausibly will become relevant as the base case evolves. -------------- *I'm simplifying here as I haven't discussed the situation where there is a separate debt sizing case with very conservative assumptions, or situations with different risk cashflows with different base case ratio levels. **I can't actually call to mind an actual example where it could be relevant for something but I dislike absolute statements.

How I build 𝗖𝗼𝘃𝗲𝗻𝗮𝗻𝘁𝘀 in Financial Models 👇 First, what are "Covenants" and where do they come from? Covenants come from a Credit Agreement: a contract between lender and borrower that outlines the terms and conditions of a loan, including the amount, interest rate, repayment schedule, and covenants. I personally like to think of Covenants as a "financial health check." In other words, just like your doctor takes your vitals with every visit, the Covenants are a way to check the "business vitals," usually every quarter. ~~~ There are a bunch of different Covenants in Credit Agreements, such as: 1. Financial Covenants: Requirements around financial performance and reporting, such as debt service coverage ratios, leverage ratios, and restrictions on additional debt. 2. Negative Covenants: Restrictions on actions that could harm the lender's security, such as restrictions on mergers, acquisitions, or asset sales. 3. Affirmative Covenants: Positive obligations placed on the borrower, such as maintaining insurance coverage, keeping accurate books and records, and paying taxes. 4. Reporting Covenants: Requirements for regular financial reporting to the lender, such as providing periodic balance sheets and income statements. ~~~ The image I have below is an example of Financial Covenants -- specifically, the Fixed Charge Coverage Ratio (FCCR) and Leverage Ratio. (two of the most common types of Financial Covenants) ~~~ Fixed Charge Coverage Ratio: Designed to see if the company can cover its "Fixed Charges" like principal and interest, capital expenditures, taxes, and distributions. And as you can see in the picture it usually starts Adjusted EBITDA (😈), which is then modified to complete the calculation. ~~~ Leverage Ratio: Ensures the business doesn't have too much debt relative to its profitability, which puts the lender at risk of recovering the loan if the business is sold. A simpler calculation, the Leverage Ratio typically compares the total debt to Adjusted EBITDA (or similar baseline profitability metric). ~~~ Modeling: While Covenants are normally calculated quarterly for compliance purposes, I prefer to build them monthly in Financial Models. It's just math, so I'd rather calculate it every month just to make sure everything looks good (or doesn't). If I see some "headwinds," then best practice is generally to notify the lender and work together as a team. I've worked with tons of lenders that view the business as a partnership, and they will sometimes be amenable to covenant "holidays" or other exceptions if the long-term view of the business is solid. Lastly, every deal (and Credit Agreement) is different, so you would build your model to match the document. ~~~ 👋 Hey, I'm Chris Reilly, and I teach Financial Modeling based on real Private Equity and FP&A experience. 📌 See Financial Modeling Courses 👉 https://lnkd.in/eG_uVhsE