Profitability Analysis Mini DashBoardScott Williams
Rapid Profitability Analysis of Your Business
Impact of Proposed Changes
12Faces offers a range of diagnostic Boards that identify structural weaknesses in your business and demonstrate the impact of changes you can make on repairing those structural weaknesses. The Mini DashBoard focuses on Profitability Analysis.
This Profit Mini DashBoard is part of a larger TrendBoard family. It has three powerful tools.
- It shows you what has changed in the last two years in your business so you can see weaknesses
- You can experiment with proposed changes and see the results.
- You can budget for a desired profit or revenue and see what has to change in your present business to make this possible.
Instructions on entering information are below the MiniBoard.
IMPORTANT: We do not know the specifics of your business. These results are general in nature. Always consult a specialist for specific advice
Profitability Analysis Instructions
The MiniBoard comes loaded with sample data. Feel free to do your own Profitability Analysis by changing this data and learn the effect of the changes you make.
Then, load your own data into the ‘sand’ coloured cells on the “Annual” tab.
WARNING: Once you close this page, your information will be erased for your privacy. To use again, you will need to renter.
We suggest you open this page in one browser tag and open a second tab for other 12Faces content. Then you can jump back and forward between the two browser tabs.
Alternatively, the full sized Boards will allow you to store your information.
Load your data into the ‘sand’ coloured cells on the “Annual” tab.
Then enter information from two recent accounting Profit & Loss reports. Ideally use a full 12 months of data for each to allow for seasonal effects life holiday periods. They don’t have to be tax or calendar years.
Try to remove any unusual income (e.g. grants) or expenses (e.g. a car) from the figures. We want to work on your “normal-state” business rather than something effected by unusual events.
If your accountant provides you with a figure for EBITDA, use that instead of Operating Profit.
Your accountant may use different accounting terms to what are in this spreadsheet. See our Accounting Terminology Translator here