Every Board wants a cash flow forecast.
But do they trust it? Nope, sorry.
Only your finance team trusts the forecast.
So why your CEO and the Board are skeptical.
The reason is simple.
Your data is a mess.
You don’t have a single source of truth.
It’s more like garbage in, garbage out.
We are live in uncertain times. Revenue is not cash.
The assumptions are lost. Scenarios are terrible. Your trail is weak. You can’t connect back to the real truth. When a number moves, you don’t know why it moved.
But you’re lucky.
We have Claude that we can use to figure it all out faster.
I used Claude to build a full 13-week cash flow forecast.
Do you know that you can keep the Excel model as the source of truth and yet build an interactive storytelling dashboard.
Every finance person must use Claude and make your life easier.
The great thing is you can stress-test.
It’s just not a pretty dashboard.
This is the dashboard that tells you the truth about your numbers.
While building this, I had a lot of fun… The dashboard gives you a complete overview of the weak spots. Exactly what a CFO need to see before making a hard call.
Okay, enough talking.
In today’s letter I’ll show you how to build the cash flow forecast with Claude.
I used the cash flow model builder skill (.md) and Cash flow scenario dashboard skill (.md)
You can download both of these skill files and all the prompts.
This is the real AI in finance work.
Let’s dive in.
How to build a full 13-week cash flow forecast with Claude
Step 1: Install the cash flow model builder skill
You’ll get 2 skills and test files.
Cash flow model builder skill
Cash flow scenario dashboard skill
Download the skills below, then copy/paste the prompt to build a cash flow model.