How you Build your cash flow with a spreadsheetI'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 atyour initial steps, the first thing you should doI'm then going to be looking at the principles or spreadsheet buildinggeneral considerationsthe business Lego bricks approachCash 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.The principles in this podcast will apply whether you use Microsoft Excel, Google Sheets, or any other package.Using spreadsheets to tell your business and cash storySpreadsheets 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 ofCash contributionThe cash left over after paying for your overheads and cash commitmentsHow 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 upPutting information into your spreadsheetWhen 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.ConclusionAbove 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

Ask this episode

“What did the council decide on item 42?” — answered with the speaker and the moment.

Transcript

Related