3 ms·
Agreed! I swear by this type of cash-flow-pro-forma. It becomes a model for the business that you can share with anyone involved in the business (or would lik
by ynac 7y ago
Agreed!
I swear by this type of cash-flow-pro-forma. It becomes a model for the business that you can share with anyone involved in the business (or would like to be involved).
In some ways it becomes my simulation engine for the business. There are ways to alter the basic sheet for different purposes, but here are my basic add-ons or differences from the sendwithses.com version.
My sheet has:
* Metrics section at the top. This CAN be dollars or units, but it can also be non-accounting metrics that are key indicators of health or risk a project faces. Like foot traffic, downloads, hours of sleep...
* Assumptions at the BOTTOM of each month - that way you have room tell the story of the changes between months. If you plan to have radio / podcast interview in July on a particularly appropriate show with an audience that should LOVE your widget, then plan for it and note that in the assumptions for that month.
* Another column between months that expresses either formulaic or raw changes for that month. Meaning, 100 more widgets or 10% more widgets. If the change is exceptional, an explanation is written up in the assumption section at the bottom of the month - see above.
* A column for Month Actual. At a glance you know what is happening. You can go nuts and add a percentage difference or just a percentage difference and skip the Actual column.
* And a column for difference between Month Actual and Month Projected.
At first you'll want to hide the change (or delta) column and historical months, but depending which hat you are wearing when you use the sheet, you'll want to show and hide different things.
Everyone in the company / project should have their own, but there should be only one master sheet.
So glad atanpur shared this...in the thousands of clients I've had, this sheet had more impact than anything else. Whether they were kids or MBA smarty pants. Build one of these and you get to play out any scenario you like. You can share this with almost anyone - taking them on the tour for the first time is really fun.
- BayezLyfe 7y agoWould love to see your version... do you mind sharing?
- ynac 7y agoGood idea - I'll do a Show and Share within a week. I'm currently working two clients (one turnaround and one startup) through building this sheet, so I'll pay attention to the empty sheet and see how to make it more template-like.