Understand what it's for
A model built for a bank looks different from one built for an investor. I start with who is going to read it and what they will push on.
Financial modelling and reporting
Most financial models are built to answer a question the business already has. The ones that matter are built to survive questions from someone else: a lender's credit team, an investor running diligence, or a buyer's accountants going through it line by line.
Those are different jobs. I build the second kind.
When owners call
A lender is asking for a borrowing base, covenant calculation or forecast you can't produce
The model doesn't balance and nobody still at the company knows why
You're raising equity and the projections won't survive an investor
You're preparing to sell and diligence will find what you haven't
A board or shareholder wants a real forecast rather than last year plus ten percent
You're considering an acquisition, expansion or major capital investment and need to understand the effect on cash, debt and covenants
How the process works
A model built for a bank looks different from one built for an investor. I start with who is going to read it and what they will push on.
Normalise the historicals so the starting point is defensible before a single assumption is layered on top.
The drivers that actually move the business, at the level of detail the reader needs. No hardcodes buried in the calculations.
Three statements that balance, covenant calculations built to your agreement's own definitions, and history that reconciles to your filed statements.
Scenario toggles and sensitivities on the assumptions that matter, so you find where the model breaks before someone else does. It also runs backwards: if you need to know what SG&A would have to do to hold a covenant, or what volume gets you to breakeven, the model answers that directly.
Your team runs it afterward. Formula driven, documented, with training included.
“We’re now able to forecast and analyze our financial performance at a much more granular level, without making the process overly complicated or time-consuming. The model gives us significantly better visibility while still being efficient and easy to work with.”
What makes a model credible
The income statement, balance sheet and cash flow are linked, so profit flows through to retained earnings and cash flow reconciles to the bank balance. If a model can't tell you what your cash and your debt look like in eighteen months, it's a revenue forecast, not a model.
Named and stated on their face.
Every number traces to a driver or an input.
It ties to your last filed financial statements.
Calculated the way your credit agreement defines them, not the way the textbook does.
Somebody at your company can update and maintain it after I leave.
What I don’t do
If a three-tab model answers the question, that is what you should get. A model your team abandons because nobody can follow it has cost more than it saved.
If the trial balances do not tie or the coding is inconsistent, that work has to happen first. I will tell you before you pay me to discover it.
I work from your records and management’s assumptions. I will flag a number that looks wrong, but a financial model is not an audit.
Relevant engagement
A cross-border group needed consolidated reporting its lender could rely on. I brought three entities and two currencies into one model, calculated the covenants to the credit agreement and trained the client’s finance team to maintain it in house.
Read the engagement →Three entities. Two currencies. One consolidated model.
Built for the bank. Handed over to the client’s finance team.Frequently asked questions
A fixed fee, priced to what's being built, with handover included. You get a written proposal before you commit, and the first conversation is free. What moves the number is structural complexity rather than hours. A single entity with clean records and a straightforward revenue model sits at one end. Multiple entities, more than one currency, acquisition or leveraged structures, covenant tests calculated to a specific credit agreement, or historicals that need consolidating before anything can be forecast all sit at the other. If it turns into running a debt financing process, that becomes a mandate, which is a work fee plus a fee payable on closing. Equity preparation and diligence support remain fixed-fee work.
Most run four to eight weeks from the point I have the historical data. The variable is rarely the modelling, it's how quickly the underlying records can be assembled and reconciled. If your recent year ends are clean and your trial balances export properly, it's the short end of that range.
Usually not. Most forecasts project revenue and expenses, so they tell you what profit might look like. A model links the income statement, balance sheet and cash flow together, so it also tells you what cash, receivables, inventory and debt are doing at the same time. That matters because lenders and investors underwrite cash and leverage, not profit. A forecast showing healthy margins and a model showing you breach a covenant in month nine can both be accurate. Only one of them is useful in the conversation you're about to have. If you're budgeting internally and not borrowing against it, a profit forecast may be all you need. If someone outside the business is going to test it, it isn't.
I'd start fresh. Patching a model whose logic is broken costs more than building a new one, and what you get back is a repaired version of something that was wrong to begin with. A new build gives you a model that holds together, built the way it should have been from the start. There's still value in what you have. It shows me what you already assume about the business, how revenue has been thought about, and which drivers you think matter. That's a real starting point, even if none of it survives into the new build.
That's the point. Everything is formula driven, the inputs are the only cells anyone types into, and I train whoever will be running it. A model that only works while I'm attached to it isn't finished.
Yes. Your lender, your accountant and your board all open Excel, and a model nobody else can audit is worth less than one they can. If you're moving to a different reporting system I'll work alongside it, but the model itself stays somewhere your counterparties can read it.
No. A formal valuation report is a defined engagement carried out by a qualified business valuator, usually for tax, litigation or a dispute. What I build is a supportable value range for a decision you're making, which is a different thing and shouldn't be confused with it. If you need the formal version I'll tell you and point you to someone who does them.
Start a confidential conversation
A first conversation costs nothing.