The Skillery's free, downloadable financial spreadsheet is a simple template for calculating your break-even point and building a basic financial projection.
Making dollars. Making sense.
Your draw toward starting a business probably wasn’t purely money-spurred. You want to do something you love. You want to do something that inspires you. But, a business being a business, you also need — and want — to think about the dollar signs.
We've created a very simple financial spreadsheet for our hypothetical business (we're opening a coffee cart), and it's available for you to download, below. Use it to learn financial basics, or adapt the template to build your own financial spreadsheets for your business.
Instructions for use.
There's no need to be scared of spreadsheets. Ours is user friendly, and has tips and instructions built-in.
Gather your assumptions.
Any time you build a financial spreadsheet, we recommend making use of a separate tab for your assumptions. You’re doing so to give your break-even analysis and financial projections something to reference, rather than having to manually re-enter data another time. That way, as you change your assumptions in their own tab, your other tabs will automatically update.
Calculate your break-even point.
Understanding your break-even point means knowing how many products/services you need to sell in order to cover your monthly expenses. In our spreadsheet, you can walk through calculating your gross profit, as well as your break-even point for a business with one product (a cup of coffee) or two (coffee and a muffin). Need more guidance? We wrote a blog post about calculating your break-even point. (NEED LINK)
Create a basic financial projection.
It’s critical to be able to project into the future to see how much money you’ll have on hand at any given time. Depending on how much money you start with and how much you’re expecting to gain or lose each month, it’s possible to predict when you’ll break even, when you’ll have enough money to hire that new employee or — harsh possibility, but a possibility nonetheless — when you’ll go broke. The last two tabs of our spreadsheet will help you keep track of your assumptions, and create your first basic financial projection.