There are numerous different financial ratios which can be used to monitor a business, however, in order to provide a simple and meaningful financial analysis, the financial projections template keeps them to a minimum and includes the following four key financial projection ratios, each of which aims to highlight a different aspect of the business.
- Profitability (Net income / Revenue)
- Efficiency (Revenue / Assets)
- Leverage (Assets / Equity)
- Liquidity (Current assets / Current liabilities)
Profitability is the ability of the business to generate profit from its revenue and is indicated in the financial projections template by the profit margin ratio.
Profit margin ratio = Net income / Revenue
The ratio is an indicator of how well a business can control its costs in relation to its revenue. The higher the profit margin ratio the more profit it earns from its revenue. A negative ratio indicates a loss making business.
When completed the financial projections should ideally show a positive profit margin ratio which increases year on year and is consistent with the industry in which the business operates.
The calculation and use of the ratio is more fully discussed in our profit margin ratio tutorial.
Efficiency is a term used to indicate the ability of the business to perform effectively and utilize its assets to generate revenue (which in turn generates profit).
The financial projection template indicates efficiency using the ratio of revenue to assets, sometimes referred to as the asset turnover ratio.
Asset turnover ratio = Revenue / Assets
The higher the asset turnover ratio the more efficient the business is at generating revenue from its asset base.
Note: From the accounting equation we have Assets = Debt (Liabilities) + Equity and so the ratio also measures how efficient the business is at generating revenue from the total debt and equity funding used in the business.
The calculation and use of the ratio is more fully discussed in our asset turnover ratio tutorial.
Leverage refers to the extent to which a business relies on liabilities including debt finance (as opposed to equity) to fund its operations.
The financial projection template indicates leverage using the ratio of assets to equity, sometimes referred to as the equity multiplier.
Equity multiplier = Assets / Equity
The higher the ratio, the higher the level of liabilities relative to equity in the business.
The equity multiplier is always greater than or equal to 1. When the ratio is 1 there no liabilities in the business, between 1 and 2 the liabilities are lower than the equity, when the ratio equals 2 liabilities and equity are the same, and above 2 the liabilities are greater than the equity.
The calculation and use of the ratio is more fully discussed in our equity multiplier ratio tutorial.
Liquidity is a measure of whether a business can utilize its current assets (cash, accounts receivable, and inventories) to pay its current liabilities (accounts payable and other) as and when they fall due.
The financial projection template indicates liquidity using the ratio of current assets to current liabilities, referred to as the current ratio.
Current ratio = Current assets / Current liabilities
The higher the ratio, the higher the level of liquidity the business has. It varies from industry to industry, but generally the ratio should be at least equal to 1, and nearer 2 to allow a margin of safety.
The calculation and use of the ratio is more fully discussed in our current ratio tutorial.
Financial Projection Ratios Calculation Example
The four financial projection ratios have been chosen as they highlight different aspects of the business (profitability, efficiency, leverage, and liquidity). The ratios are are easy to calculate from any published set of financial statements, and to demonstrate this, we have set out below the calculation of the four ratios using the Apple Inc. balance sheet and income statement for 2013.
Profitability (Net income / Revenue) = 37,037/170,910 = 21.7% Efficiency (Revenue / Assets) = 170,910 / 207,000 = 0.83 Leverage (Assets / Equity) = 207,000 / 123,549 = 1.68 Liquidity (Current assets / Current liabilities) = 73,286 / 43,658 = 1.68
For simplicity, all of the financial projection ratios used in the template are based on values at the year end. If there are significant changes in the balance sheet items during the financial period, it is best to average the assets over the period using the beginning and ending balances.
It is important to monitor the four financial projections ratios produced by the template in order to ensure that they are in line with industry norms. Any variation in either the absolute value or the trend in the ratio should be analysed and explained before finalizing the business plan financial projections.