Financial ratio analysis is the technique of comparing the relationship (or ratio) between two or more items of financial data from a company’s financial statements. It is mainly used as a way of making fair comparisons across time and between different companies or industries. Show
Financial ratio analysis and interpretationFinancial ratio analysis is generally used in six main areas. These are:
It’s important to keep in mind that financial ratios can only be interpreted fairly if the financial statements on which they are based are prepared according to the same set of accounting standards. This ensures that the underlying general ledger accounts always relate to the same line items in the financial statements. An overview of key financial ratio analysisHere is a quick guide to the main types of financial ratio analysis and the key financial ratios used in them. LiquidityLiquidity analysis is used to analyse a company’s abilities to meet its immediate debt obligations out of its current assets. The two key financial ratios used to analyse liquidity are:
The current ratio is also known as the working capital ratio and the quick ratio is also known as the acid test ratio. CoverageCoverage analysis is used to analyse a company’s ability to pay interest, fees and charges on its debts but not the underlying capital obligations. The two key financial ratios used to analyse solvency are:
SolvencySolvency analysis is used to analyse a company’s ability to pay off all the debt it currently holds with its income, assets and divided by or equity. The two key financial ratios used to analyse solvency are:
ProfitabilityProfitability analysis is used to analyse a company’s ability to make money from its goods and divided by or services. The four key financial ratios used to analyse profitability are:
EfficiencyEfficiency analysis is used to analyse how hard a business is working its assets on behalf of its owners. The four key financial ratios used to analyse efficiency are:
Day-sales outstanding is also known as the average collection period. Market prospectsMarket prospects analysis is generally only undertaken for publicly traded companies. It is generally used to determine the likely prospects of different investment options. There are numerous financial ratios used to calculate market prospects. Key ones include:
Limitations of financial ratio analysisFinancial ratio analysis is quantitative rather than qualitative. It, therefore, does not address certain factors which can play a huge role in determining a company’s prospects. For example, it cannot analyse the quality of their management. This means that, although financial ratio analysis can be hugely useful, it only tells part of the story. We can helpFinancial ratio analysis can be applied in lots of other contexts too. For example, the accounts receivable days formula can help you to understand whether or not an accounts-receivable process is working efficiently. Find out how GoCardless can help you with ad hoc payments or recurring payments. Over 70,000 businesses use GoCardless to get paid on time. Learn more about how you can improve payment processing at your business today. Get StartedLearn More Did you know? You can earn our Financial Ratios Certificate of Achievement when you join PRO Plus. To help you master this topic and earn your certificate, you will also receive lifetime access to our premium financial ratios materials. These include our flashcards, cheat sheet, quick tests, quick test with coaching, and more. Note: You can earn any or all of our Certificates of Achievement for Financial Ratios, Debits and Credits, Adjusting Entries, Financial Statements, Balance Sheet, Income Statement, Cash Flow Statement, Working Capital and Liquidity, Bank Reconciliation, and Payroll Accounting when you upgrade your account to PRO Plus. Financial ratios relate or connect two amounts from a company's financial statements (balance sheet, income statement, statement of cash flows, etc.). The purpose of financial ratios is to enhance one's understanding of a company's operations, use of debt, etc. The use of financial ratios is also referred to as financial ratio analysis or ratio analysis. That along with vertical analysis and horizontal analysis (all of which we discuss) are part of what is known as financial statement analysis. A significant benefit of calculating a company's financial ratios is being able to make comparisons with the following: The comparisons may direct attention to areas within a company that need improvement or where competitors are more successful. Some of the limitations of financial ratios are: They are based on just a few amounts taken from the financial statements from a previous year. Current and future years could be different due to innovations, economic conditions, global competitors, etc. The comparison is useful only with companies in the same industry. This becomes difficult when other companies operate in several industries and their financial statements report only consolidated amounts. Companies may apply accounting principles differently. For instance, some U.S. companies use LIFO to assign costs to its inventory and cost of goods sold, while some use FIFO. Some companies will be more conservative when estimating the useful life of equipment, when recording an expenditure as an expense rather than as an asset, and more. Since financial statements reflect the historical cost principle, some of a company's most valuable assets (trade names, logos, unique reputation, etc. that were developed internally) are not reported on the company's balance sheet. They provide a minuscule amount of information compared to the information included in the five main financial statements and the publicly traded corporation's annual report to the U.S. Securities and Exchange Commission (SEC Form 10-K). Our explanation will involve the following 15 common financial ratios: Part 2: Financial ratios using balance sheet amounts Part 3: Financial ratios using income statement amounts Part 4: Financial ratios using amounts from the balance sheet and the income statement Part 5: Financial ratios using cash flow statement amounts Part 5 also includes a discussion of vertical analysis (resulting in common-size income statements and balance sheets) and horizontal analysis (resulting in comparative financial statements and trends over longer time periods). Part 6 will give you practice examples (with solutions) so you can test yourself to see if you understand what you have learned. Calculating the 15 financial ratios and reviewing your answers will improve your understanding and retention. Page 2We begin our discussion of financial ratios with five financial ratios that are calculated from amounts reported on a company's balance sheet. The following financial ratios are often labeled as liquidity ratios since they provide some indication of a company's ability to pay its obligations when they come due:
There are two additional financial ratios based on balance sheet amounts. These ratios provide information on a corporation's use of debt or financial leverage:
Ratio #1 Working CapitalWorking capital is defined as the amount remaining after subtracting a corporation's total amount of current liabilities from the total amount of its current assets. (In most industries, current assets include cash and assets that are expected to turn to cash within one year. Current liabilities are the obligations that will be due within one year.) The formula for determining the amount of working capital is: Working capital = current assets - current liabilities Generally, the larger the amount of working capital, the more likely a company will be able to pay its suppliers, lenders, employees, etc. when the amounts are due. It also means less stress when an unexpected problem arises. The amount of working capital that a company needs will vary by industry (and could vary by company within the same industry). Here are some factors that determine the amount needed:
Here are two examples that illustrate how to calculate the amount of a company's working capital: Example 1A Working capital = current assets - current liabilities Working capital = $4,200,000 - $4,000,000 Working capital = $200,000 ABC's working capital of $200,000 seems too little for a large manufacturer having $4,000,000 of current liabilities coming due within the next year. However, if the company has a standard product that it produces continuously for a customer that pays upon delivery, the $200,000 of working capital may be adequate. On the other hand, if this manufacturer must carry a huge amount of inventory of raw materials and finished products and the demand for the products varies from month to month, the $200,000 may be far short of the amount needed. Example 1B Working capital = current assets - current liabilities Working capital = $35,000 - $20,000 Working capital = $15,000 Since Beta Company is a service business, it is unlikely to have a large amount of inventory of goods as part of its current assets. Perhaps most of Beta's current assets are in cash. If these assumptions are correct, Beta might operate comfortably with less than $15,000 of working capital. Example 1A and Example 1B bring to light the difficulty in determining the amount of working capital needed by a specific business. For more insights, see our topic Working Capital and Liquidity. Ratio #2 Current RatioThe current ratio, which is sometimes referred to as the working capital ratio, is defined as a company's total amount of current assets divided by the company's total amount of current liabilities. Expressed as a formula, the current ratio is: Current ratio = current assets / current liabilities Generally, the larger the ratio of current assets to current liabilities the more likely the company will be able to pay its current liabilities when they come due. The following factors are relevant for determining the appropriate current ratio for a company as well as working capital (Ratio #1):
Since current assets divided by current liabilities results in a ratio (unlike the amount of working capital), the current ratio can be compared to a smaller company's current ratio or to a larger company's current ratio within the same industry. Example 2A Current ratio = current assets / current liabilities Current ratio = $4,200,000 / $4,000,000 Current ratio = 1.05 (or 1.05 to 1 or 1.05:1) ABC's current ratio of 1.05 seems small for a large manufacturer with $4,000,000 of current liabilities. In the past, many people believed that the ideal current ratio was 2 (having twice as many current assets as current liabilities). Today, we should consider many factors when attempting to find the optimum current ratio for a business. The factors for a manufacturer include:
Example 2B Current ratio = current assets / current liabilities Current ratio = $35,000 / $20,000 Current ratio = 1.75 (or 1.75 to 1 or 1.75:1) Since Beta Company is not a manufacturer or retailer, it will have little or no inventory. If its current assets consist mainly of cash and receivables from long-time customers who pay promptly, Beta may operate with a ratio of 1.00 (or even less) if its revenues are consistent. Ratio #3 Quick (Acid Test) RatioThe quick ratio is commonly known as the acid test ratio. The quick ratio is more conservative than the current ratio because the amounts of a company's inventory and prepaid expenses are not included. (It is assumed that inventory and prepaid expenses cannot be turned into cash quickly.) As a result, only the company's "quick" assets consisting of cash, cash equivalents, temporary investments, and accounts receivable are divided by the total amount of the company's current liabilities. For companies with inventory (manufacturers, retailers, distributors) the quick ratio is viewed as a better indicator (than the current ratio) of those companies' ability to pay their obligations when they come due. The formula for the quick ratio is: Quick ratio = (cash + cash equivalents + temp. investments + accounts receivable) / current liabilities Whether a company's quick ratio is sufficient will again depend on factors such as:
Example 3A Quick ratio = (cash + cash equivalents + temp. investments + accounts receivable) / current liabilities Quick ratio = $1,600,000 / $4,000,000 Quick ratio = 0.40 (or 0.40 to 1 or 0.40:1) Obviously, a manufacturer and retailer will have a quick ratio that is significantly smaller than its current ratio. This corporation's quick ratio of 0.40 will require the business to get its inventory items sold in time to collect the cash needed to pay its current liabilities when they come due. This may or may not be a problem depending on the customers and the demand for the corporation's goods. Example 3B Quick ratio = quick assets / current liabilities Quick ratio = $25,000 / $20,000 Quick ratio = 1.25 (or 1.25 to 1 or 1.25:1) If Beta's quick assets are mostly cash and temporary investments, it has a great quick ratio. This concludes our discussion of the three financial ratios using the current asset and current liability amounts from the balance sheet. As mentioned earlier, you can learn more about these financial ratios in our topic Working Capital and Liquidity. Next, we will look at two additional financial ratios that use balance sheet amounts. These financial ratios give us some insight on a corporation's use of financial leverage. Ratio #4 Debt to Equity RatioThe debt to equity ratio relates a corporation's total amount of liabilities to its total amount of stockholders' equity.
NOTE: Unless a financial ratio specifies "long-term debt", you should assume that "debt" means the total amount owed to creditors, or the total amount of liabilities. As a formula, debt is: Debt = the amount of current liabilities + the amount of noncurrent (long-term) liabilities The debt to equity ratio is calculated by dividing a company's total amount of liabilities by its total amount of stockholders' equity: Debt to equity ratio = total liabilities / total stockholders' equity A corporation's use of some debt is considered wise for the following reasons:
However, too much debt is risky because the corporation may not be able to obtain additional loans to cover the cost of unexpected problems. Example 4A Debt to equity ratio = total liabilities / total stockholders' equity Debt to equity ratio = $7,200,000 / $2,800,000 Debt to equity ratio = 2.57 (or 2.57 to 1 or 2.57:1) As ABC's debt to equity ratio of 2.57 indicates, the corporation is using a large amount of creditors' money in relation to its stockholders' money. We would say the company is highly leveraged and that could be a factor in whether the corporation can borrow more money if needed for an emergency or economic downturn. One should look at the average debt to equity ratio for the industry in which ABC operates as well as the debt to equity ratio of its competitors to gain more insights. Example 4B Debt to equity ratio = total liabilities / total stockholders' equity Debt to equity ratio = $45,000 / $55,000 Debt to equity ratio = 0.82 (or 0.82 to 1 or 0.82:1) Beta's debt to equity ratio looks good in that it has used less of its creditors' money than the amount of its owner's money. Ratio #5 Debt to Total AssetsThe debt to total assets ratio is also an indicator of financial leverage. This ratio shows the percentage of a business's assets that have been financed by debt/creditors. The remainder comes from the owners of the business. Generally, a lower ratio of debt to total assets is better since it is assumed that relatively less debt has less risk. [Our discussion of the debt to equity ratio (Ratio #4 above), highlighted some of the pros and cons of using debt instead of equity when purchasing business assets.] Recalling that debt means the company's total amount of liabilities or the total amount owed to creditors, the debt to total assets ratio is calculated by dividing a company's total amount of liabilities by its total amount of assets. Here is the formula for the debt to total assets ratio: Debt to total assets = total liabilities / total assets Example 5A Debt to total assets = total liabilities / total assets Debt to total assets = $7,200,000 / $10,000,000 Debt to total assets = 0.72 or 72% (or 0.72 to 1 or 0.72:1) This indicates that 72% of the cost of total assets reported on ABC's balance sheet assets were financed by its lenders and other creditors. The remaining 28% were financed by ABC's stockholders. Whether 72% is a good debt to total assets ratio depends on the assets, the cost of the debt, and lots of unknown factors in the future. A debt to total assets ratio of 72% may be acceptable at a growing company where long-term loans were needed to purchase labor saving equipment and construct more efficient facilities (instead of paying rent for inefficient facilities). On the other hand, when the debt resulted from operating losses caused by declining demand and poor management, a debt to total assets ratio of 72% may be risky and may prevent the company from obtaining additional loans. Example 5B Debt to total assets = total liabilities / total assets Debt to total assets = $45,000 / $100,000 Debt to total assets = 0.45 or 45% (or 0.45 to 1 or 0.45:1) Whether 45% is a good ratio of debt to total assets depends on future conditions. However, as a general rule, a lower ratio of debt to total assets is considered better since there is less risk of loss for a lender and the company may be able to obtain additional loans if needed. Page 3In this section we discuss the following financial ratios which involve amounts reported on a company's income statement:
These ratios, which are often based on transactions that occurred during the previous year, are most meaningful when they are compared to:
Ratio #6 Gross Margin (Gross Profit Percentage)In the context of financial ratios, the term gross margin is the percentage of net sales remaining after subtracting the cost of goods sold. In this context, gross margin means the same as the gross profit as a percentage of net sales.
NOTE: Net sales = gross sales – sales discounts – sales returns – sales allowances You should also be aware that some people will use the term gross margin to mean the dollars of gross profit. Example 6 Gross margin = gross profit / net sales Gross margin = $2,000,000 / $8,000,000 Gross margin = 0.25 or 25% Generally, net sales and the cost of goods sold are the two largest amounts on the income statements of companies that sell goods. Accordingly, a company's gross margin (as a percentage of net sales) is monitored closely by financial analysts who want to see if the company was able to increase selling prices when the company experienced increased costs, or if the company was able to maintain its gross margin when faced with increased competition. Even when comparing a company's gross margin to other companies in the same industry, some differences can be the result of how accounting principles are applied. For instance, some U.S. companies use the last-in, first-out (LIFO) method for assigning actual costs to inventory and to the cost of goods sold. Other companies in the same industry may be using the first-in, first-out (FIFO) method. During periods of inflation (or deflation), this will result in a difference in the companies' gross margins. (You can learn more about this in our topic Inventory and Cost of Goods Sold.) Gross margins (as a percent of net sales) can also vary within the same industry due to marketing strategies. For example, one retailer may sell goods at their full selling prices and provide extensive customer service. Its gross margins will be higher than another retailer who sells goods at discounted prices and provides a minimum of customer service. (However, the retailer providing the extensive customer service will likely experience higher selling expenses that offset some of its larger gross margins.) Ratio #7 Profit MarginA company's profit margin (as opposed to gross margin) is the percentage of net sales remaining after all expenses are subtracted from net sales. Expenses that are subtracted from net sales include the following: A company's profit margin can be calculated before income tax expense, and/or after income tax expense as shown in these formulas: Profit margin before tax = net income before tax / net sales Profit margin after tax = net income after tax / net sales Example 7 XYZ's profit margin before tax is calculated as follows:
Profit margin before tax = net income before tax / net sales XYZ's profit margin after tax is calculated as follows:
Profit margin after tax = net income after tax / net sales Whether the corporation's 9% pretax profit margin or its 7% after-tax profit margin is good depends on several factors, including:
NOTE: When comparing companies' profit margins, there can be a difference in the reporting of income tax expense. The income statement of a regular corporation includes the corporation's income tax expense. On the other hand, the income statement of a sole proprietorship or partnership does not report income tax expense. (The reason is that the income tax for the sole proprietorship or partnership is reported on the owner's personal income tax returns.) In summary, the regular corporation's income statement will have two expenses that do not appear on the income statement of a sole proprietorship or partnership:
Ratio #8 Earnings Per ShareCorporations with only common stock outstanding If a corporation has only common stock (no preferred stock, no securities convertible into common stock) and the corporation had the same number of shares of common stock outstanding throughout the entire accounting year, the calculation of the earnings per share is simple: Earnings per share = net income after tax / number of shares of common stock outstanding Example 8A Earnings per share = net income after tax / number of shares of common stock outstanding Earnings per share = $560,000 /100,000 shares Earnings per share = $5.60 Corporations with both common stock and preferred stock outstanding
Example 8B
The calculations of earnings per share will be more complicated when any of the following have occurred:
NOTE: Whenever a corporation purchases shares of its common stock, the number of outstanding shares of common stock will decrease. Hence, the corporation's net income after tax will be divided by a smaller number of outstanding shares of common stock. This will cause the corporation's earnings per share (EPS) to increase. This in turn often causes an increase in the market value of each share of common stock. The purchase of its own common stock may be an attractive option for a corporation with no lucrative investments available and its stockholders do not want to receive taxable dividends. However, purchasing shares of its own stock does reduce the corporation's cash available to meet future obligations including unforeseen problems. In terms of financial ratios, this use of cash will decrease the corporation's working capital, current ratio, and quick ratio. Whether a corporation's earnings per share (EPS) amount is good depends on many factors including the corporation's goals, the corporation's rate of growth in the EPS amount, the competitors' rate of growth in their EPS, stock market's expectation of the corporation's EPS, and more. Ratio #9 Times Interest Earned (Interest Coverage Ratio)Times interest earned, which is also known as the interest coverage ratio, is an indicator of a corporation's ability to pay the interest on its debt, such as loans payable and bonds payable. The times interest earned ratio is calculated by dividing a corporation's net income before income taxes and before interest expense for a recent year by the interest expense for the same year. The formula for the interest coverage ratio is: Times interest earned = net income before interest and income tax expense / interest expense Example #9
Times interest earned = net income before interest and income tax expenses / interest expense Times interest earned = 25 times A high times interest earned ratio gives the lender comfort that the borrower will be able to make the interest payments when they are due. Page 4In this section, we will discuss five financial ratios which use an amount from the balance sheet and an amount from the income statement. Specifically, we will discuss the following:
The first four of the above ratios inform us about a company's speed in:
The speed at which a company is able to convert its accounts receivable and inventory into cash is crucial for the company to meet its payroll, pay its suppliers, and pay other current liabilities when the amounts are due. In other words, a company could have a huge amount of working capital and an impressive current ratio, but it requires that the current assets be converted to cash to pay the bills. Therefore, a higher receivables turnover ratio (Ratio #10) and a higher inventory turnover ratio (Ratio #12) are better than lower ratios. These higher turnover ratios mean there will be less days' sales in receivables (Ratio #11) and less days' sales in inventory (Ratio #13). Having less days in receivables and inventory are better than a higher number of days. Recall that the amounts reported on the balance sheet are as of an instant or point in time, such as the final moment of an accounting year. Therefore, a balance sheet dated December 31 provides a "snapshot" of the pertinent general ledger account balances (assets, liabilities, equity) as of the final moment of December 31. Also recall that the income statement reports the cumulative amounts of revenues, expenses, gains, and losses that occurred during the entire 12 months that ended on December 31.
NOTE: Graphing the daily (or perhaps weekly) balances during the year and then computing an average of those many data points will provide a representative average. Unfortunately, people outside of the company do not have access to those details. As an alternative, outsiders often compute an average based on the end-of-the-year moment for the current year and the previous year. (They do this without regard to whether these end-of-the-year balances are much lower than the balances during the year.) Ratio #10 Receivables Turnover RatioThe receivables turnover ratio (or accounts receivable turnover ratio) relates a company's net credit sales from the most recent year to the amount the customers owed the company during that year.
NOTE: If a new startup company makes its first sale with credit terms of net 30 days, the company records the sale by increasing Accounts Receivable and increasing Sales on Credit. If the customer pays in 30 days, the company will increase Cash and will decrease Accounts Receivable. This means that the company will be turning over its receivables in 30 days. If that occurs with every sale, the receivables turnover ratio will be approximately 12.2 times per year (365 days / 30 days). However, if all customers take 40 days to pay the amount owed, the receivables turnover ratio will be approximately 9.1 times per year (365 days / 40 days). The higher the receivables turnover ratio, the faster the receivables are turning into cash (which is necessary for the company to pay its current liabilities on time). Therefore, a higher receivables turnover ratio is better than a lower ratio. Some people categorize the receivables turnover ratio as an efficiency ratio since it indicates the speed in which the company had collected its accounts receivables and turned them into cash. The receivables turnover ratio is calculated as follows: Receivables turnover ratio = net credit sales for the year / average amount in accounts receivable Example 10 Given this information, the company's receivables turnover ratio is: Receivables turnover ratio = net credit sales for the year / avg. amount of accounts receivable Receivables turnover ratio = $570,000 / $60,000 Receivables turnover ratio = 9.5 times To determine if this company's receivables turnover ratio of 9.5 is acceptable or not acceptable, you could do the following:
The larger the number of times that the receivables turn over during the year, the more often the company collects the cash it needs to pay its current liabilities.
NOTE:
Ratio #11 Days' Sales in Receivables (Average Collection Period)The days' sales in receivables (also known as the average collection period) indicates the average amount of time it took in the past year for a company to collect its accounts receivable. An easy way to determine the number of days' sales in receivables is to divide 365 (the days in a year) by the receivables turnover ratio, which was explained in Ratio #10. In other words, the formula for the days' sales in receivables is: Days' sales in receivables = 365 days / receivables turnover ratio Example 11 Since the company's receivables turnover ratio was determined to be 9.5, the days' sales in receivables is calculated as follows: Days' sales in receivables = 365 days / receivables turnover ratio Days' sales in receivables = 365 days / 9.5 Days' sales in receivables = 38.4 days To determine whether this company's days' sales in receivables of 38.4 days is acceptable (or not acceptable), you could do the following:
Having a smaller number of days' sales in receivables means that on average, the company is converting its receivables into the cash needed to pay its current liabilities.
NOTE: The days' sales in receivables (such as the 38.4 days we just calculated) was based on all customers' transactions and unpaid balances. It includes the credit sales made a few days ago, 25 days ago, 50 days ago, 75 days ago, etc. Therefore, the average of 38.4 could be concealing some slow-paying customers' accounts. Instead of using one of the receivables ratios, it would be better to have an aging of accounts receivable (which is readily available with accounting software). The aging of accounts receivable sorts each customer's unpaid balance into columns which have headings such as: Current, 1-30 days past, 31-60 days past due, 61-90 days past due, 91+ days past due. This aging report allows a company's personnel to see the exact amount(s) owed by each customer. As a result, the company can take action to collect the past due amounts. Ratio #12 Inventory Turnover RatioThe inventory turnover ratio indicates the speed at which a company's inventory of goods was sold during the past year. Since inventory is reported on a company's balance sheet at its cost (not selling prices), it is necessary to relate the inventory cost to the cost of goods sold (not sales) reported on the company's income statement. Since the cost of goods sold is the cumulative cost for all 365 days during the year, it is important to relate it to the average inventory cost throughout the year. Because a company's published balance sheet reports only the inventory cost at the final moment of the accounting year and the final moment of the prior accounting year, the average of these two data points may not be representative of the inventory levels throughout the 365 days of the year. (The reason is that many U.S. corporations end their accounting year at the lowest levels of activity.) In our examples, we will provide you with the company's average cost of inventory that is representative of the entire year. Here is the formula for the inventory turnover ratio: Inventory turnover ratio = cost of goods sold for the year / average cost of inventory during the year Since there are risks and costs associated with holding inventory, companies strive for a high inventory turnover ratio, so long as its inventory items are never out of stock. Example 12 Inventory turnover ratio = cost of goods sold for the year / avg. cost of inventory during the year Inventory turnover ratio = $280,000 / $70,000 Inventory turnover ratio = 4 times in the year To determine whether this company's inventory turnover ratio of 4 is acceptable or not acceptable, you could do the following:
The inventory turnover ratio is an average of perhaps hundreds of different products and component parts carried in inventory. Some items in inventory may not have had any sales in more than a year, some may not have had sales in six months, some may sell within weeks of arriving from the suppliers, etc. Ratio #13 Days' Sales in Inventory (Days to Sell)The days' sales in inventory (also known as days to sell) indicates the average number of days that it took for a company to sell its inventory. The goal is to have the fewest number of days of inventory on hand because of the high cost of carrying items in inventory (including the risk of items spoiling or becoming obsolete). Of course, there is also a cost for being out of stock. Therefore, managing inventory levels is important. An easy way to calculate the number of days' sales in inventory is to divide 365 (the days in a year) by the inventory turnover ratio (Ratio #12). Here is the formula for calculating the days' sales in inventory: Days' sales in inventory = 365 days / inventory turnover ratio Example 13 Given that the company's inventory turnover ratio was 4, the days' sales in inventory is calculated as follows: Days' sales in inventory = 365 days / inventory turnover ratio Days' sales in inventory = 365 days / 4 Days' sales in inventory = 91.25 days A smaller number of days' sales in inventory is preferred, since it indicates the company will be converting its inventory to cash sooner. (It may get cash immediately for cash sales, or it will get cash when the resulting receivables are collected.) The days' sales in inventory is an average of the many products that a company had in inventory. Some of the products may not have been sold in more than a year, some may not have been sold in 10 months, some were sold shortly after arriving from the suppliers, etc. Since we used the inventory turnover ratio to calculate the days' sales in inventory, a mistake in calculating the inventory turnover ratio will result in an incorrect number of days' sales in inventory. (For instance, if someone uses sales instead of the cost of goods sold to calculate the inventory turnover ratio, the days' sales in inventory will not be accurate.) Ratio #14 Return on Stockholders' EquityFor a corporation that has only common stock (no preferred stock) outstanding, the return on stockholders' equity is calculated by dividing its earnings (net income after tax) for a year by the average amount of stockholders' equity during the same year. The amount of stockholders' equity reported on a corporation's balance sheet is the amount as of the final moment of the accounting year. On the other hand, the net income after tax is the cumulative amount earned throughout the entire year. Therefore, the calculation of the return on stockholders' equity ratio should use the average amount of stockholders' equity throughout the year. The formula for the annual return on stockholders' equity for a corporation with only common stock is: Return on stockholders' equity = net income after tax / average stockholders' equity Example 14 Return on stockholders' equity = net income after tax / average stockholders' equity Return on stockholders' equity = $560,000 / $2,800,000 Return on stockholders' equity = 20% To determine whether a corporation's return on stockholders' equity is reasonable, you could do the following:
Page 5The cash flow statement, or statement of cash flows (SCF), is one of the five financial statements required by U.S. accounting rules. Since the income statement and balance sheet are prepared using the accrual method of accounting, the SCF provides the following desired information on a company's cash flows:
The SCF is organized into three main sections:
A commonly cited metric that is derived from the SCF is the amount of free cash flow. Ratio #15 Free Cash FlowFree cash flow is calculated from the following amounts reported on the statement of cash flows:
To arrive at the amount of free cash flow, the amount of capital expenditures is subtracted from the net cash provided by operating activities. Therefore, the formula for calculating a company's free cash flow is: Free cash flow = net cash provided by operating activities – capital expenditures Example 15 Free cash flow = net cash provided by operating activities – capital expenditures Free cash flow = $200,000 - $140,000 Free cash flow = $60,000 If a corporation considers its cash dividends paid to stockholders to be a requirement, the corporation could also subtract the required dividend amount. If the stockholders of the corporation in our example demand a constant dividend of $25,000 each year, the corporation's free cash flow will be $35,000 ($200,000 - $140,000 - $25,000). Whether the amount of the corporation's free cash flow is adequate depends on its plans for the near future.
NOTE: If a corporation's net cash provided by operating activities is less than its earnings, it raises some concern. The sophisticated investor or financial analyst will seek to find the reason. One possibility is that customers who purchased goods with credit terms have not remitted the amounts owed. Could the reason be that the goods were not acceptable? Another possibility is the corporation made large purchases of goods, but the goods have not sold. A good analyst would be curious why the goods could not be sold. To learn more about this important financial statement, see our topic Cash Flow Statement. Other Financial RatiosIncluded in our Business Forms (available to both AccountingCoach PRO and AccountingCoach PRO Plus members) are forms to assist in calculating the following 24 financial ratios:
Benefits and Limitations of Financial RatiosBenefits of Financial RatiosSome of the benefits of financial ratios include:
Limitations of Financial RatiosWhile financial ratios can be beneficial, it is important to consider their limitations:
Vertical AnalysisTypically, accounting software allows for a percentage to be printed next to all of the amounts on the company's financial statements. For instance, a company's internal income statement will contain more detail and often displays a percent next to each dollar amount. The percent is the result of dividing each amount by the amount of the company's net sales. The company's internal balance sheet will also show more detail and often displays a percent next to each dollar amount. The percent is the result of dividing each amount by the amount of the company's total assets. Expressing every income statement amount as a percent of net sales, and every balance sheet amount as a percent of total assets is referred to as vertical analysis. When the financial statements are presented as percentages, they are referred to as common-size financial statements. They are "common size" since the reported percentages can be compared to the percentages for other companies even when the companies' amounts are vastly different in size. Common-size income statement resulting from vertical analysisYou can immediately find on the following multiple-step, common-size income statement (with dollar amounts omitted) the company's gross margin of 24.0%, its profit margin before tax of 5.6%, and its profit margin after tax of 4.6%. Common-size balance sheet resulting from vertical analysisAs you can see from the following common-size balance sheet (with amounts omitted) each item is expressed as a percent of the company's total assets. The percentages on the common-size balance sheet (above) allow you to immediately see that the debt to total asset ratio is 62.5% (the amount of total liabilities was divided by the amount of total assets). You can also see that stockholders' equity provided 37.5% of the total asset amount, and that the reported amount of property, plant and equipment after deducting accumulated depreciation was 43.7% of the amount of the corporation's total assets. The percentages shown on a company's common-size balance sheet allows you to compare them to other companies' percentages even if the companies' amounts are vastly different in size. Horizontal AnalysisHorizontal analysis shows a financial statement amount over a minimum of two years. Comparative financial statementsCorporations' published financial statements are referred to as comparative financial statements since they are required to display not only the most recent year's amounts but must also display the corresponding amounts for the prior year or the prior two years. (It is rare for the external financial statements to display the percentages we discussed under vertical analysis.) When a corporation publishes its financial statements, the following financial statements should report three columns of amounts (such as the amounts for the year 2021 and the corresponding amounts for 2020, and 2019):
The published balance sheet of a corporation must also be comparative but requires only two columns of amounts (such as the amounts as of December 31, 2021 and the corresponding amounts for December 31, 2020). You can view comparative financial statements by doing an internet search for a corporation whose stock is publicly traded. For example, you could search for Apple form 10-K, Tootsie Roll form 10-K, etc., and then locate financial statements in the Form 10-K's table of contents. (Form 10-K is part of the corporation's annual filing with the SEC. The corporation's 10-K is also accessible by using the corporation's link entitled Investor Relations.) Trend analysis or time series analysisWhen horizontal analysis involves comparing amounts from more than two years, it may be referred to as trend analysis (or time series analysis). The following table is an example of a trend analysis in which the amounts for the most recent five years are compared: Page 6Now that you have learned about 15 of the more common financial ratios, we want you to experience calculating them by using the amounts in a corporation's financial statements. This will deepen your understanding and will help your retention for future use. The financial ratios to be calculated are arranged in the same order as they were discussed above:
Calculating the Ratios Using Amounts from the Balance SheetYou will be using the following balance sheet to calculate the first group of financial ratios: Calculations of Working Capital, Current Ratio, and Quick Ratio
You can check your answers using the following table: Calculations of Debt to Equity and Debt to Total Assets Ratios
You can check your answers using the following table: Calculating the Ratios Using Amounts from the Income StatementThe following income statement for Example Corporation should be used to calculate the four financial ratios which appear beneath it: Calculations of Gross Margin, Profit Margin, Earnings Per Share, and Times Interest Earned
You can check your answers using the following table: Calculating the Ratios Using an Amount from the Balance Sheet and the Income StatementFinancial ratios such as the "turnover" ratios and the "return on" ratios will need 1) an amount from the annual income statement, and 2) an average balance sheet amount. An average balance sheet amount is needed since the balance sheet reports the amount for only the final moment of the accounting year. For the required calculations that follow, we indicate the average balance sheet amount. Calculations of the Ratios: Receivables Turnover, Day's Sales in Receivables, Inventory Turnover, Days' Sales in Inventory, Return on Stockholders' Equity
*We are providing the average balance sheet amounts based on the corporation's internal records for all days in 2021. Using only the balance sheet amount from the final moment of 2021 (or the average of the final moment of 2020 and 2021) may not be typical of the balance sheet amount for all 365 days in the year. You can check your answers using the following table: Calculating a Ratio Using Amounts from the Statement of Cash FlowsUse the following statement of cash flows (SCF) for the related ratio calculation appearing after the SCF: Calculation of Free Cash Flow You can check your answer using the following table:
We recommend that you now take our free Practice Quiz for this topic so that you can...
Note: You can receive instant access to our PRO materials (visual tutorials, flashcards, quick tests, quick tests with coaching, cheat sheets, video training, bookkeeping and managerial guides, business forms, printable PDF files, and progress tracking) when you join AccountingCoach PRO.
You should consider our materials to be an introduction to selected accounting and bookkeeping topics, and realize that some complexities (including differences between financial statement reporting and income tax reporting) are not presented. Therefore, always consult with accounting and tax professionals for assistance with your specific circumstances. Page 7
|