Growth on hold: why your financial model may be undermining your funding case

Several of our projects have come from lenders. In each case, the funding offer to a prospective borrower was conditional on an independent, professionally built financial model. This was not a standard requirement imposed on every borrower. It arose because the existing models were unsuitable for the lenders’ purposes.

Each borrower already had a financial model that had served its internal purposes well. But the underlying workings had become so complex that anyone unfamiliar with them would struggle to trace the figures through the model and gain confidence in the results. The financial statements were there, but the lender could not readily verify how they had been reached or test them independently.

So each business had to commission a new model before the funding could proceed, to the lender’s timetable and at a cost it had not planned for. A refinancing that is pushed back means paying for the existing, often more expensive, debt for longer. An acquisition or merger that depends on the new funding has to wait as well.

Idle crane at an industrial site.

Why an internal model may not be enough

Most businesses build their forecasts for internal use: budgeting, financial planning, monthly and quarterly reporting, and decision-making. The finance team knows the business, the assumptions and where to look. Every finance team develops its own way of working, and most of the time it serves the business well.

Once a business approaches lenders, the model has to work for people outside the finance team. Lenders and their analysts, investors, corporate finance advisers and lawyers each read the model for their own purpose, often without the context the finance team takes for granted. A model’s structure makes a significant difference to how easily they can do that.

The numbers in the information memorandum will normally be reconciled to the model. But that only confirms that the outputs agree. It doesn’t tell a credit analyst whether the workings behind them can be followed. A lender-specific output sheet helps at a glance, but unless its links to the underlying workings are simple and the build-up can be traced, it shows the answer without showing how it was reached.

In a transaction model, every sheet is presentation. Even the calculation sheets need to make sense to someone who did not build them.

What lenders need to test

A lender’s central question is whether the business can meet its debt obligations, including when financial performance falls short of plan. To answer it, the credit team needs to see:

  • Sources and uses of funds: how the transaction is financed, including any refinancing of existing debt, equity from existing shareholders or a private equity investor, fees and the use of proceeds.
  • Cash flow and debt service: whether future cash flows are enough to meet interest and repay debt, not just whether the income statement shows a profit.
  • The facility mechanics: drawdowns, repayments, interest and, where they apply, revolving facilities and cash sweeps.
  • Covenant headroom: leverage, interest cover, debt service cover and other covenant ratios, tested on the agreed or proposed definitions, which often differ from the figures in the accounts.
  • A credible starting point: opening figures reconciled to the management or audited accounts.

Then comes the downside. A typical scenario a credit team might test: if revenue falls 10% below forecast and customers take 15 days longer to pay, can the business still maintain sufficient liquidity, meet its repayments and comply with its covenants? Answering it requires an integrated three-statement model, with working capital, cash flow, the balance sheet, the debt schedule and covenant tests all linked together. The analyst must be able to flex the assumptions and follow the results.

Why structure matters

Structure determines whether those questions can be answered, and checked, by someone else. A model built for external scrutiny:

  • is laid out consistently, so that understanding one part helps the reader follow the rest;
  • keeps inputs and outputs separate from the workings, and makes clear which inputs are source data and which are management judgements;
  • shows its checks, so a reviewer can see that it balances and reconciles;
  • keeps each calculation simple: however complex the business, the maths should simplify into steps a reviewer can check one at a time;
  • has scenarios built in, so the baseline and different scenarios can be run without reconstructing parts of the model.

A well-structured model won’t make an unrealistic forecast credible, but it will let a lender assess the business without first having to untangle the workings.

Addressing the problem early

Not every inadequate model needs to be rebuilt. Some can be improved, but even then, repeated lender questions and time spent explaining the model can delay the process.

Ideally, this assessment should happen before the information memorandum is drafted. By the time the credit team starts asking questions, making substantial changes to the model can become difficult and disruptive.

Questions to ask before approaching lenders

  1. Could someone outside the business follow how the key figures are built up, without a walkthrough?
  2. Can every input be traced to its source, or identified as a management judgement?
  3. Are the checks visible, and do they all pass?
  4. Are the financing and covenant schedules set out clearly enough for a credit analyst to test?
  5. Could you answer a lender’s downside question the same day?

Preparing to secure funding? If you already have a financial model in Excel, we can assess whether it is ready for lender review and identify what needs to change. Where a rebuild is needed, we build a model designed around the requirements of the transaction.
Model Review · Model Build · Request a call

Let’s discuss your financial modelling needs

Contact Us

Recommended resources