Leinster Logistics Group plc, a Dublin-headquartered freight and supply-chain operator with EUR 185 million in revenue and seven operating subsidiaries across Ireland and Benelux, is seeking a EUR 55 million syndicated revolving credit facility led by AIB Corporate Banking and Bank of Ireland. The lending syndicate requires a bank-ready integrated financial model covering three years of actuals and five years of projections. The group FP&A director has a standalone P&L spreadsheet and a separately maintained cash-flow workbook that disagree on net debt by EUR 2.3 million. She has five working days to deliver a single, fully linked three-statement model before the credit committee presentation.
Three-Statement Financial Model
A financial model in which the income statement, balance sheet and cash flow statement are fully and dynamically linked. Changes in any operating assumption propagate automatically: revenue growth drives the P&L; P&L net income feeds retained earnings on the balance sheet; balance-sheet movements drive the cash flow statement via the indirect method. The model is mechanically correct only when the balance sheet balances (assets = liabilities + equity) at every forecast period. For Irish companies preparing consolidated accounts, intercompany eliminations between Irish and non-Irish subsidiaries must be removed before the model is presented to any lender or investor.
IFRS 16 vs FRS 102 Section 20 (Lease Accounting in Ireland)
Irish companies listed on Euronext Dublin (or filing consolidated accounts above the thresholds in Companies Act 2014 Part 6) must apply IFRS 16, which capitalises all significant operating leases as right-of-use (ROU) assets with matching lease liabilities. Irish private companies below the statutory threshold apply FRS 102 Section 20, which retains a finance-lease / operating-lease distinction. For a logistics business with a large fleet, the choice of accounting standard materially affects reported leverage: IFRS 16 can raise gross debt by EUR 15-30 million on a EUR 185m revenue base. Irish lenders and the CBI supervisory framework reference both standards depending on the borrower type.
A frequent error in Irish group models is inconsistent treatment of the EURIBOR reference rate across the debt schedule. As at end-2024 the ECB deposit rate stood at 3.00% (following three consecutive ECB cuts in September, October and December 2024), with 3-month EURIBOR at approximately 2.65–2.75%. A model that uses a single average interest-rate assumption — rather than computing quarterly interest on average opening and closing debt balances using a live EURIBOR cell — will produce interest charges that diverge from the treasury department's actual projections, misleading both the lending syndicate and the board.
| Model sheet | Key outputs | Links to |
|---|---|---|
| Assumptions | Revenue growth, EBITDA margin, capex/rev, NWC days, EURIBOR + spread, tax rate | All sheets (single source of truth) |
| Income statement | Revenue, EBITDA, EBIT, finance costs, PBT, corporation tax, net income | Balance sheet (retained earnings), cash flow (net income + D&A) |
| Balance sheet | Net PP&E, ROU assets, net working capital, net debt, equity | Cash flow (ΔNWC, capex, lease payments), debt schedule (net debt) |
| Cash flow statement | Operating, investing, financing cash flows, closing cash | Balance sheet (cash), debt schedule (RCF drawings and repayments) |
| Debt & lease schedule | RCF balance, EURIBOR interest, IFRS 16 lease liability amortisation | P&L (finance costs), balance sheet (net debt + lease liabilities) |
The FP&A director introduces a dedicated debt and lease schedule. EURIBOR is sourced from a single assumption cell (3.50% + 210bp bank margin = 5.60% all-in), applied quarterly to the average of opening and closing RCF balances. IFRS 16 lease liabilities for 47 truck leases and three warehouse leases are amortised separately, with interest on lease liabilities (EUR 0.9m annually) isolated from bank interest (EUR 2.1m) in the P&L finance-cost note. The prior EUR 2.3m net-debt discrepancy is eliminated: it arose because the standalone cash-flow sheet had omitted lease principal repayments of EUR 2.3m from financing activities.
⚠️Hardcoding a single interest rate for the full RCF
→ Interest must be computed from average quarterly balances multiplied by the current EURIBOR cell plus the contracted margin. Hardcoding breaks the link whenever RCF drawings or ECB rate movements change, producing a model that cannot be sensitised to rate scenarios — a critical gap for any Irish lender working under ECB monetary policy uncertainty.
⚠️Ignoring IFRS 16 lease liabilities in the net-debt definition
→ For IFRS reporters, most Irish lenders define net debt to include IFRS 16 lease liabilities when testing leverage covenants. Presenting a headline 2.6x net debt/EBITDA that excludes lease liabilities may obscure a lease-adjusted leverage of 3.8x, which would breach the covenant. Always confirm the covenant net-debt definition with the facility agreement and model accordingly.
⚠️Failing to eliminate intercompany balances in a multi-entity Irish group
→ Irish group models must consolidate and eliminate intercompany sales, loans and dividends. Failing to eliminate an EUR 8m intercompany receivable between the Irish holding company and a Belgian subsidiary overstates current assets and distorts the net-working-capital calculation, inflating reported DSCR.
Under IFRS 16, how does capitalising an operating lease affect reported net debt/EBITDA for an Irish logistics company?
Poprawna odpowiedź : It increases both gross debt (lease liability) and EBITDA (lease rental replaced by depreciation + interest), so the net effect on the ratio depends on the lease term
Under IFRS 16, the operating lease rental disappears from EBITDA (improving EBITDA) and is replaced by depreciation (below EBITDA) and interest on the lease liability. Net debt rises by the full lease liability. The net-debt/EBITDA ratio can therefore rise or fall depending on the lease term and interest rate assumed. Irish lenders typically apply a lease-adjusted leverage definition in their facility agreements.
A model shows EUR 0 difference between asset and liability plus equity totals on the balance sheet — what does this confirm?
Poprawna odpowiedź : The balance sheet balances mechanically, indicating that all inter-statement links are arithmetically consistent — it does not confirm that assumptions are correct
A balancing balance sheet is a necessary but not sufficient condition for model correctness. It confirms that the accounting identity (assets = liabilities + equity) holds at every period, meaning all three statements are arithmetically linked. It does not validate the quality of assumptions, the treatment of IFRS 16, or the accuracy of covenant calculations — all of which require separate review.
financial analyst (Ireland)
Sugerowane pytania
Calculate Leinster Logistics Group's net working capital requirement using debtor days, creditor days and stock days, and sensitise the model to working-capital deterioration in a downside scenario.
Otworz kalkulator →