Critical Financials for Business Explained
Scott Williams2023-04-27T08:32:17+10:00Critical Business Financials Explained provides a commentary on Tips that appear in the 12Faces ScoreBoard family of analysis tools
You can access information in 3 ways:
- Blue coloured links in the spreadsheets connect to their specific topic for a quick study.
- Read the full article to get a more general understanding on the range of items covered.
- Click on any of the links in the Table of Contents below to go straight to that topic.
Accounting terminology differs between countries and even between accountants. Use our accounting terminology translator for unfamiliar terms
If you find the information generated by a particular Topic useful, and feel inspired to go further to optimise or grow your business, 12Faces has Campaigns that will step you through the process:
- Turnaround30 – designed to help you stabilise a troubled business in as little as 30 days.
- Optimise100 aims, over 100 days, to optimise the income and expenses in your business so that you create a stable, healthy business.
- Grow365 goes the next step. You want to grow your optimised business systematically to avoid the many pitfalls of unorganised growth.
To self-diagnose your business financials problems:
Go to the introduction: DIY Business Problems Diagnostics
Registration is required, but it is FREE.
When faced with a lot of information, it can be difficult to work out where to start. Corrective action is all too easily deferred.
Prioritising Alternatives can help to overcome this decision making roadblock.
Go to the article: Using Weights and Scores Prioritising Technique
All information generated by the 12Faces spreadsheets, and the information provided below, is indicative only. We don’t know the particular circumstances of your business. Consider our information as suggestions only. For specific advice on any of the issues raised in the spreadsheet, consult an appropriate professional.
Table of Contents:
- Interpreting ScoreBoard trends
- #1 Change in Price
- #2 Change in Cost of Goods Sold
- #3 Reduce Overhead Costs
- #4 EBITDA
- #5 Accounts Receivable and Payable
- #6 Profit Funnel Group
- #7 Inventory Measures
- #8 Return on Equity
- #9 Gross Margin Percentage
- #10 Labour Cost and Efficiency Measure
- #15 Liquidity Ratio
- #12 Working Capital
- #13 Interest Cover
- #14 Breakeven Sales
- #16 Safety Margins
ScoreBoard Trend Analysis
ScoreBoard is our tool for visualising trends in your performance data so you get an early warning of any problems (more on ScoreBoard trend analysis tool here).
ScoreBoard data analysis is grouped. Each Measurement in a group has (I) or (D) after the trend’s name. (I) means an Increase is good and (D) means a decrease is good.
Following are links to get you started on working out what a particular adverse trend means and some of the ways to fix the problem. Keep drilling down on the most likely options to narrow down your choice of how to fix the issue.
Success Group: Shows trends in the factors that determine your business’s success
- Falling Revenue: Revenue is the life blood of a business. Any fall is usually a concern. See more on possible causes and solutions for falling revenue
- Falling Gross Profit: GP is Revenue minus the Cost of Goods Sold which are the direct cost of producing items for sale. COGS does not include permanent labour. Learn more about reasons for Falling Gross Profit.
- Falling Operating Profit: Operating Profit is Gross Profit minus Overhead Costs. Learn more about why overheads are increasing faster than Gross Profit.
Efficiency Ratio Group: Shows changes in operating efficiency that can help track down why your business results might be falling. They can also help explain adverse trends in the “Success” Group
- Gross Margin%: This is Gross Profit divided by Revenue . It is a key to deciding if a fall in Gross Profit is due to revenue or to increase Cost of Goods Sold
- Labour/Revenue%: If this is growing, your labour costs are going up faster proportionally than your revenue; not a good trend
- Working Capital / Revenue%: If this is growing, your business is using more Working Capital per $ of Revenue; not a good trend
Cash Conversion Cycle: This group measures how efficiently you are managing your cashflow.
Sustainability Group: A goal of 12Faces is Sustainable Business Success. This group measures your sustainability. Any adverse trends are warning of weakening sustainability.
#1 Change in Price
A change in price is often one of the most impactful changes you can make in your business.
A study of some businesses several years ago indicated that a 1% change in Price led to an average of an 11% change in Net Profit.
For the impact of Price on your Revenue, and therefore your Profit, see the following links:
- Skills Module introduction: SM1.0 How 1% Price Change Gave 11% Profit Increase
- How to Feasibility Test Your Start Up
Scroll down to the heading “Testing Price”. - Maximise Customer’s Lifetime Value for Profit
Includes a case study on the impact of increased price. - I Don’t Know What is Wrong
This is a diagnostic menu which will assist with identifying the possible causes of the problem/s you are experiencing. - Price 12Faces search: Change in Price Impacts
Refresh your screen to update the list.
#2 Change in Cost of Goods Sold
The “Cost of Goods Sold” (COGS) refers to the cost of the inputs that go into producing the product that you sell.
Often referred to as “Variable Costs”.
If the expense disappears when you stop producing the product or service, then the expense belongs here.
- Do not include your permanent workforce in this. They are essentially a Fixed, or Overhead, Cost.
- Include any specialist contract or casual labour that would not stay in your business if you stopped producing this product.
Reducing the Cost of Goods Sold has a direct and immediate impact on your Profitability. That impact will continue as your Sales Volume increases or decreases.
The COGS is directly tied to your sales.
For more on COGS visit the following links:
- How to Reduce Variable Costs for Better Profit
A collection of short topics relating to Variable Costs (COGS). - How to Use Gross Margin Analysis
Diagnose problems caused by changes in Income and/or Variable Costs (COGS). - Skills Module introduction: C2.0 Optimise Your Business Enterprise in 100 Days (Optimise100)
- Cost of Goods Sold (COGS) 12Faces search: Change in Cost of Goods Sold
Refresh your screen to update the list.
#3 Reduce Overhead Costs
Learn more about Overhead Margin at the article: Overhead Margin Analysis Explained
“Overhead Margin” = Overhead Costs / Revenue x 100
#4 EBITDA
The EBITDA (Earnings Before Interest Tax Dividends and Amortisation) starts with the Operating Profit you submitted. It then adjusts to a Profit figure that better reflects where you want to be.
To do this add back or deduct the following to the Operating Profit figure to arrive at the EBITDA figure:
- Add back Depreciation if it has been charged.
Although this is a future cost you need to know, it can be distorted by, for example instant tax write-offs, to show greater cash cost than really occurred. - Add back Interest Paid.
The money to run your business can be drawn from many sources with different interest rates. Adding this back removes any bias. - Deduct any underpaid Salary to the owners.
Profit is being over-represented compared to a Profit with a realistic Owners salary deducted. - Deduct any Expenses being paid as a subsidy by the Owners.
These are, ideally, costs paid by the business if it was able.
Further information on EBITDA go to the following link:
- Earnings Before Interest Tax Dividends and Amortisation (EBITDA)
A Wikipedia article which goes into greater detail.
#5 Accounts Receivable and Payable
“Accounts Receivable” refers to money owed to you by your customers.
“Accounts Payable” refers to the money you are paying your Suppliers.
The speed at which you receive money owed to you from sales and pay money that you owe your suppliers doesn’t impact your Profit & Loss directly.
They do have an impact on your Cashflow. The slower you collect your debts, and/or the faster you pay your payables, the worse your cash availability will become.
Accounts Receivable:
Using the data you supplied, you can estimate how many days, on average, it is taking you to collect your Accounts Receivable.
This appears under the Performance Measures titled, “Days A/R Outstanding”.
This is the average number of days it is taking you to collect your Accounts Receivable.
To see the impact of 1 day change adjust:
- The “Days less A/c Receivable” value in the Change part of the spreadsheet.
- Change it from the starting point of 1 day to as many days you think you can reduce it by.
Accounts Payable:
The estimated days it takes you to pay your suppliers is listed under the Performance Measure titled, “Days A/P Outstanding”.
Again, you can see the impact of a 1 day improvement in Accounts Payable by adjusting the change:
- As you increase the change from 1 day, you are taking more days to pay your suppliers.
- Meaning that any difference between the speed at which you are recovering your money from your buyers and paying your suppliers is improving.
In the Performance Measures section:
If your Accounts Receivable takes longer to receive than the speed at which you are paying your suppliers, it will be shown in red.
This indicates that:
- You are using valuable Working Capital to pay suppliers rather than paying them with money received from your buyers.
- Working Capital is important.
- If it is low, it may have to be boosted by debt which incurs the cost of interest.
- Other times, Working Capital can be used to fund growth but not if it is in short supply.
For more on managing Accounts Receivable and Accounts Payable, visit the following links:
- How to Benefit From Cash Conversion Cycle (CCC)
The speed at which you can grow your business is dependant upon how well you convert your sales into cash-in-hand.
CCC assesses how you are going with this conversion. - How to Boost Your Accounts Receivable
This article goes through the process of collecting money your customers owe you. - Learn About Daily Sales Outstanding Metric
This will assist in answering the question “Is My Cashflow OK?”
Understand the relationship between Receivable Daily Sales Outstanding and Daily Accounts Payable Outstanding. - Accounts Receivable 12Faces search: Accounts Receivable Days Outstanding
Refresh your screen to update the list. - Accounts Payable 12Faces search: Accounts Payable Efficiency
Refresh your screen to update the list.
#6 Profit Funnel Group
The Profit Funnel Group measures the changes in the different levels of the items that make up your Profit Funnel.
- Trading Revenue (Sales Income) is tipped in at the top of the funnel.
- It passes through Cost of Goods Sold (COGS).
- Then Overhead Cost stages.
- Eventually leaving a Profit.
The final Profit will vary with the efficiency of each of the levels in the Profit Funnel.
For more on managing Accounts Receivable and Accounts Payable, visit the following links:
- How the Profit Flywheel Accelerates Your Business
Learn how to use a systematic approach to undertaking improvements in your business. - How to Reduce Variable Costs for Better Profit
A collection of short topics relating to Variable Cost reduction (COGS). - How to Use Our Business Tune-up Menu
The Tune-up Menu periodically reviews the state of your business with a view to streamlining and removing poor practices. - Profit 12Faces Search: Profit
Refresh your screen to update the list.
#7 Inventory Measures
Inventory represents:
- Raw materials that you have received from your supplier.
- Finished product that you are holding prior to selling to your buyers.
- All Work in Progress (WIP) that is partly completed product.
Inventory has an important effect on Cashflow but doesn’t directly impact Profit. Inventory appears in the Cashflow part of the spreadsheets.
The more money tied up in Inventory in your business, the less ready cash you will have available. You will have to consume your Working Capital to cover costs. Very often, Inventory is treated as an Asset in accounting books, but this is an “academic” notion. It doesn’t take into account that it is slowing down the flow of cash into your bank accounts.
- “Days less Inventory”
Shows how much cashflow is generated for each day less that you hold your inventory.
- “Inventory Turns”
Refers to how many times in a year you sell the equivalent of your entire Inventory. This will be influenced by the industry that you are in. There is no single figure that can be taken as “good”.
A web search might find a benchmark for your industry.
It is very clear that the more “turns” you have, the more product you have sold and therefore the greater your Revenue. Higher is better.
The other side of that coin is that, the faster you can turn over your Inventory, the less Inventory you will be holding at any point in time. Your cashflow will benefit from increased “Inventory Turns”.
- “Days Sales of Inventory”
Measures how many days it takes for Inventory to turn into Sales. There is no hard rule for what this figure should be. But the smaller it is, the faster your Inventory is being turned into cash. Your goal will be to reduce this figure.
The “Inventory Turns” and the “Days Sales of Inventory” are closely related. As you speed up one of them, the other will improve as well.
For more on Inventory, use the following links:
- Cost of Over and Under Stocking
Learn how inventory under and over stocking costs and how to reduce the damage.
This is applicable to all types of industries, not just manufacturing. - Inventory Re-order Management for Profit and Productivity
Inventory is an important aspect of any business that has a workflow process.
That is not only manufacturing. - How Dice Games Simulate Profit Generation
Now for some fun!!
This simulation game will demonstrate the relative strengths and weaknesses of the various models covered and their impact on your profit. - Inventory
A listing of further articles to assist you. - Inventory 12Faces search: Inventory Measures Explained
Refresh your screen to update the list.
#8 Return on Equity
The “Return on Equity (ROE)” measures how much Profit you are making for each dollar of Equity in the business.
Also known as Return on Investment (ROI).
You are comparing the return you are getting for operating your business to what you would get by investing the same amount of money in a bank account or the stock market.
You are taking more risk with your own business than money in an interest earning bank account. You will want a better return from your business than you get on the largely risk free bank deposit to compensate.
If your ROE is close to or lower than what you might get in these alternative investments:
- Give some thought to either improving the Return
or - Selling the business.
Some experts say, as a rule of thumb, that a 5% ROE is essentially no return at all. This is after allowing for some margin for the extra risk of running a business.
The higher this number, the better your business. In the spreadsheets, this will appear red if below 5% and yellow if below 10%.
For more information on ROE consult the following articles:
- Change Your Accounting Mindset with Throughput Accounting
Throughput Accounting will give you the tools to understand your current Return on Investment/Equity.
This will highlight the areas of your business that effect your ROI - I Don’t Know What is Wrong
Scroll through the Table of Contents, in particular business related links. - Return on Equity 12Faces search: Return on Investment
Refresh your screen to update the list.
#9 Gross Margin Percentage
Learn more about Gross Margin Percentage at the article: How Gross Margin Analysis Boosts Profit Explained
“Gross Margin Percentage” = Gross Profit / Revenue x 100
“Gross Profit” = Revenue – Cost of Goods Sold (COGS)
#10 Labour Cost and Efficiency Measures
Some Labour costs vary according to the volume of your production. This will mostly be outsourced or casual labour and belongs in COGS.
Most of your Labour is a Fixed Cost, since you don’t rapidly turn over your permanent staff. It is an Overhead Cost.
It follows that the most flexible Overhead Cost is likely to be Labour, if you have a workforce of any size.
Under the heading “Labour Reduction”, you can see the impact of a percentage reduction in your cost of Labour.
As you may have Labour at many different wage points, a percentage may be difficult to estimate. Instead, you may be able to calculate the savings from letting specific people or job descriptions go.
As an alternative, set the “Labour Reduction” to zero.
Then fill in the sand colour cell labelled “OR Estimated Wages Saved”.
Enter either:
A percentage change if you are playing around to see the results.
or
An actual estimated saved.
But not both.
For more on deciding which staff may be unnecessary, visit the links below:
- Benefit From Labour Efficiency Ratio Metric
The ratio explained in detail
Reduce/eliminate inefficiency in labour, which is one of the largest Overhead Costs.
Over time, Labour costs tend to blow out. You hire more Labour but don’t remove the less efficient, no longer required or less useful Labour.
This is especially true in growing businesses. You tend to employ Labour in advance of having Sales Revenue to pay for it. This consumes your valuable Working Capital. It can stunt your businesses growth or damage your liquidity.
It is therefore useful to see how much you are investing in your Labour and how well it tracks your Income.
If the “Labour to Revenue Ratio” gets bigger over time, you are spending more on Labour for every dollar of sales. This is a sign of Labour bloat and/or Labour inefficiencies.
Ideally, you want this number to get smaller. This means your use of Labour is becoming more efficient.
For suggestions on how to manage Fixed Labour Costs visit the following links:
- Secrets to Streamlining Organisation Charts
Does your organisation chart have a bad case of bloat?
Learn how to trim your management tree. - Secrets to Staffing Your Business Menu
Get the right people on the bus!
A menu of staff related articles - Redundancy Planning
How to reduce the staff head count efficiently. - Labour Cost 12Faces search: Labour Cost and Efficiency Measures
Refresh your screen to update the list. - Efficiency Measures 12Faces search: Labour to Revenue Ratio
Refresh your screen to update the list.
#15 Liquidity Ratio
It is possible to have a business that appears profitable but you never have enough money to pay your expenses. The availability of funds to pay expenses when they fall due is your “Liquidity”.
The number in the cell M12 (Liquidity) gives you an indication of how much padding you have to cover Expenses as and when they fall due.
Liquidity relies on the ratio between your Current Assets and your Current Liabilities.
It assumes that your Current Assets can be converted to cash relatively quickly to cover your Current Liabilities when necessary.
There is no hard and fast rule about what your Liquidity Ratio should be, but many experts think that any less than 1.5 is moving into dangerous territory.
This can be interpreted as:
- You have $1.50 in Current Assets to cover $1 in Current Liabilities.
The smaller this ratio becomes, the more difficult it will be for you to cover your expenses. This is especially true when you are not able to convert assets fast enough to cover pressing expenses.
A business with a Liquidity Ratio falling over time may be heading for bankruptcy or forced sale. This is one of those numbers that the bank and other lenders are likely to be looking at. They are very interested in your ability to cover debt payments.
The Liquidity Ratio is therefore important to monitor and important to try and improve.
For more on managing your Liquidity visit the following links:
- I Don’t Know What is Wrong
Click on the link under Table of Contents:
My Sales and Profit are OK but I keep running out of Money. - Skills Module introduction: SM6.0 Profit Autopilot – Introduction
Here conventional accounting is turned on its head by starting with a focus on Profit first.
Learn about “Piggy Banks” and never be worried about having sufficient funds to pay your debts, including tax. - Liquidity Ratio 12Faces search: Learn About Liquidity
Refresh your screen to update the list.
#12 Working Capital
“Working Capital” is another measure of your available funds.
It is the amount of money you have at your disposal to spend on growing your business in the future.
- The lower this figure is, the more funds you have available to fund your growth.
- The higher the figure the more money, that could otherwise go to cash, is tied up in funding the day-to-day business operations.
Current Assets minus Current Liabilities = Working Capital
If you don’t have a great deal of Working Capital, the only way you will be able to afford to grow your business is to borrow money. Any business that intends to grow should focus on ways of building up its Working Capital reserves to “self fund” proposed growth.
“Working Capital to Sales Ratio” is another useful figure.
- We want this figure to remain stable, or to grow, because it reflects how much cash has been generated by your sales.
- A disproportionate growth in Working Capital compared to growth in Revenue (Sales) is generally not a good trend.
If it begins to fall it indicates that your Revenue is growing but your Cashflow is worsening. This is common in a growing business drawing down on cash reserves.
This statistic is best used when compared over several time periods to make sure that it doesn’t deteriorate markedly. It is an early indicator that you are growing Sales at the expense of Cashflow.
For more on the importance of Working Capital visit the following articles:
- How to Measure Net Cashflow
Introduction of Net Cashflow and Marginal Cashflow/Current Ratio concepts
Be aware of any looming problems BEFORE they happen. - How to Benefit from Cash Conversion Cycle (CCC)
Determine how fast your business can grow, amongst other solutions. - Working Capital 12Faces search: What Funds to Grow Business
Refresh your screen to update the list.
#13 Interest Cover
“Interest Cover” refers to how much money you have available to cover the cost of your Interest on your Loans and other similar debt.
There is no hard and fast rule for a “safe” Interest Cover but experts say it would be wise to have an Interest Cover figure in the order of 5. In our spreadsheet, anything less than 5 will be highlighted in red.
Interest Cover is important, those who lend you money want to know that you have the ability to cover the Interest payments.
Ultimately, they want to know that you have the ability to repay the loan. Very likely, they will be monitoring this figure.
It is wise for you to track it yourself in order to see when it is moving unfavourably. Make any necessary changes yourself rather than get a rude shock when you hear from a nervous banker.
For more on Interest Cover read the following:
- I Don’t Know What is Wrong
Click on the link under Table of Contents:
My Sales and Profit are OK but I keep running out of Money. - DIY Business Problems Diagnostics
Registration is required, but it is FREE. - Interest Cover 12Faces search: Money Available to Cover Interest
Refresh your screen to update the list.
#14 Breakeven Sales
This figure is provided more for information than for management purposes.
It represents the amount of Sales you must make to cover both the cost of production (COGS) of those products you sell and your Fixed Overhead Costs.
If your Sales start to move downwards towards Breakeven:
- It is an indicator that your business is becoming distressed.
- Consider reducing your Overhead Costs.
If Sales fall below the Breakeven figure:
- Your business is financially distressed and you are living off your savings.
If your Sales have fallen below the Breakeven figure, the following will be of assistance:
- Sustainable Business Success Learning Resources
A list of Campaigns, Skills Modules and Leader’s Briefing articles.
In particular, Turnaround30 (T30) which will assist with rapidly stabilising your struggling business. - Breakeven 12Faces search: What is Breakeven Sales
Refresh your screen to update the list.
#16 Safety Margins
The two Safety Margins indicate how long you can trade if something adverse happens to your revenue and you don’t make any compensating changes to your operation. This might happen with some sort of emergency like fire, flood or Covid. In both cases, the larger the number, the more safety you have.
It is a management decision as to how much safety you feel is appropriate. There is no particular recommendation. You might set more or less safety depending how much of these types of risk your business faces.
You should watch the the Margin does not fall below what you consider to be a reasonable level.
Days Safety Margin: is how many days you could operate and cover your costs with no more income in the period and assuming you don’t take steps to reduce your expenses when the problem hits
Margin of Safety: is how far your revenue could fall before you are no longer covering your costs. The concept is especially useful when a significant proportion of sales are at risk of decline or elimination. This might be the case when a sales contract is coming to an end or a major customer stops using you. By knowing the amount of the margin of safety, management can gain a better understanding of the risk of loss to which a business is subjected by changes in sales. If you have a margin of 20% and you are about to lose a customer who is 40% of your trade, you are in trouble. The opposite situation may also arise, where the margin is so large that a business is well-protected from sales variations. The margin of safety concept does not work well when sales are strongly seasonal, since some months will yield catastrophically low results. In such cases, annualize the information in order to integrate all seasonal fluctuations into the outcome.
- Breakeven 12Faces search: Safety Margin
Refresh your screen to update the list.
Disclaimer
All information generated by the 12Faces TrendBoards and the discussion above is indicative only. We don’t know the particular circumstances of your business. All our recommendations must be considered as suggestions only. For specific advice on any of the issues raised in the spreadsheet, consult an appropriate professional.
Resources
Failing Business Turnaround: More information can be found in the article “DIY Failing Business Turnaround”
There are plenty of books on business ratio analysis, should you want to know more about any of the ratios listed here. Google a particular term and you will find an explanation.
These ratios are widely used in business.
Leave a Reply
You must be logged in to post a comment.