How you Build your cash flow with a spreadsheet
I'm going to show you how you build your own cash flow forecast by tapping into the most powerful resource in your financial toolbox, the spreadsheet. In this week’s episode of I Hate Numbers I'm going to look at
- your initial steps, the first thing you should do
- I'm then going to be looking at the principles or spreadsheet building
- general considerations
- the business Lego bricks approach
Cash is the commodity that keeps your business going, your business lines burning. Spreadsheets are not the preserve of the accountants, the finance people or at least it shouldn't be.
Using spreadsheets to tell your business and cash story
Spreadsheets are a powerful tool in your business toolbox. They take the heavy lifting out of number crunching and are a practical help in the world of finance and numbers. Above all we need to think about the look and feel of our spreadsheet. You don't need to be an IT or math’s genius to build a good workable spreadsheet, but take care with its look, design, and use.
My I Hate Numbers Food Palace business will be used to show you how you build your cash flow forecast with a spreadsheet. The business prepares and delivers delicious food to corporate clients. And your business may not be a food business, but that's okay. Because the knowledge and approach is very transferable. Check out my video to see a visual demonstration.
Think about what you want your spreadsheet to show you.
Above all I want to see the financial outcome of my planned activity for the next 12 months? What does that mean in terms of
- Cash contribution
- The cash left over after paying for your overheads and cash commitments
- How much money I left in your bank at the end of each month?
- Will you be clenching your buttocks or relaxing as the cash depletes or piles up
Putting information into your spreadsheet
When you build your cash forecast do not edit as you go along. Do not stop yourself and say I can't afford to do that. The key thing is, is to get the story, get the numbers in the spreadsheet, see what the spreadsheet is telling us.
Your cash flow spreadsheet reflects your wish list, aspirations, and how you see your business unfolding. It's the story of what you're trying to do with your company. You have the option and power to change it.
Your numbers are telling a story about what you want for yourself and for your company – don't let them tell a different one !
Listen to find out more.
Above all, how you build your cash flow forecast with a spreadsheet is good to know. It keeps you closer to your business numbers, and a key business tool, the spreadsheet! This week’s podcast tells you this, plus calculations, tips, and advice.
Listen to find out more.
My mission is to inform, inspire and educate you to get closer to your numbers. You can make more profits, save tax and time, improve your well-being and your money mindset.
Help me to help you and others by subscribing and sharing this episode in your network. . Listen now and subscribe to I Hate Numbers, so I can send it straight to your inbox every week with all the latest updates from I Hate Numbers podcast! are