How To Plan Your Business Without Excel
Chapters 2 and 3
Check the Financial Dashboard
The Dashboard is broken into 3 sections:
Within each section, you can explore many different views of your data.
Dashboard > Profit & Loss
The sub-menu Dashboard > Profit & Loss shows a combined profit and loss and a cash flow statement. Here you find all summary data in one place - Revenues, COGS, CAC, operating expenses for headcounts and expenses.
You can drill down into each total and see the data by revenue stream.
At the same time, the P&L report serves as a simple simulation dashboard – you can select which revenues streams, teams and expense groups you want to include in the numbers.
Answer questions 3 + 4: When are you profitable? What are your funding requirements?
With the Profit & Loss Report, you can also answer business questions 3 and 4 on business profitability and funding requirements. The key metrics show:
You might wonder why this P&L doesn't show the typical hockey stick for cash-requirements and why the time to get the investment back is even before the break even. Well, remember - we changed the Billing Period of the Enterprise revenue stream from Monthly to Yearly Billing so that we collect all cash yearly in advance.
Impact of Monthly vs Yearly Cash-Flow
Let's check the impact on Cash Flow Requirements if we set the Billing Period of the Enterprise revenue stream back to Monthly Billing. We find very similar results for the number of customers, revenues and EBITDA and the Time-to-Break even, but
Dashboard > Insights
The submenu Dashboard > Insights has several tabs. You can check results of assumptions which you entered in the revenue, headcount, expense and capital menu.
The tab Number Customers shows results of revenue streams in terms of number of new customers and total customers.
The tab Revenue shows results of revenue streams in terms of revenues per revenue stream and revenue growth.
The tab Headcount shows results for headcounts teams in terms of cost and headcount numbers.
The tab Expenses shows results for expense groups in terms of expenses and expense growth by different cost types and categories.
The tab Capital shows results for funding and investments.
The profitability tab combines all this data and shows how profitability margins develop over time...
The cash flow tabs also adds cash flow from financing and investments to the data and shows how cash-flow develops over time
You can browse through all charts and even export them.
Dashboard > Key Metrics
The menu Dashboard > Key Metrics is identical with the menu Revenue > Manage which you have seen before. It shows