Profitability Analysis Mini DashBoard

Rapid Profitability Analysis of Your Business 
and
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.

1. It shows you what has changed in the last two years in your business so you can see weaknesses
2. You can experiment with proposed changes and see the results.
3. 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

Comprehensive instructions on how to use this Board for Diagnostic and Predictive purposes 

Playtime

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

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.

Data Entry

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