Financial Statement Analysis

- Ratio Analysis of Financial Statements (Formula, Types, Excel)
- Ratio Analysis
- Liquidity Ratios
- Turnover Ratios
- Profitability Ratios
- Profit Margin
- Gross Profit Margin Formula
- Operating Profit Margin Formula
- Net Profit Margin Formula
- EBIDTA Margin
- Earnings Per Share
- Basic EPS
- Diluted EPS
- Basic EPS vs Diluted EPS
- Return on Equity (ROE)
- Return on Capital Employed (ROCE)
- Return on Invested Capital (ROIC)
- Return on Total Assets (ROA)
- Return on Average Capital Employed
- Capital employed Employed
- Return on Average Assets (ROAA)
- Return on Average Equity (ROAE)
- Return on Assets Formula
- Return on Equity Formula
- DuPont Formula
- Net Interest Margin Formula
- Earnings Per Share Formula
- Diluted EPS Formula
- Contribution Margin Formula
- Revenue Per Employee Ratio
- Operating Leverage
- EBIT vs EBITDA
- EBITDAR
- Capital Gains Yield
- Tax Equivalent Yield
- LTM Revenue
- Operating Expense Ratio Formula
- Overhead Ratio Formula
- Capacity Utilization Rate Formula
- Total Expense Ratio Formula

- Efficiency Ratios
- Dividend Ratios
- Debt Ratios
- Debt to Equity Ratio
- Debt Coverage Ratio
- Debt Ratio
- Debt to Income Ratio Formula (DTI)
- Capital Gearing Ratio
- Capitalization Ratio
- Interest Coverage Ratio
- Times Interest Earned Ratio
- Debt Service Coverage Ratio (DSCR)
- Financial Leverage Ratio
- Net Debt Formula
- Leverage Ratios
- Operating Leverage vs Financial Leverage
- Current Yield
- Debt Yield Ratio

**Defensive Interval Ratio** (DIR) is one of the most important ratios in judging the liquidity of the company. Defensive Interval Ratio is a ratio which explains how many days a company can operate without using its noncurrent assets, any long term asset or any other financial resources. Let us look at the above chart. Apple has a Defensive interval ratio of 4.048 Years, while Walmarts Defensive Interval Ratio is 0.579 years. Why there is such a big difference between the two? Does this mean that Apple is better placed from the liquidity point of view?

In this article, we will look at Defensive Interval Ratio (DIR) in detail.

- What is Defensive Interval Ratio?
- Defensive Interval Ratio Formula
- Interpretation of Defensive Interval Ratio (DIR)
- Defensive Interval Ratio Example
- Colgate – Calculating Defensive Interval Ratio
- Sector Defensive Interval Ratio
- Limitations of Defensive Interval Ratio
- In the final analysis

## What is Defensive Interval Ratio?

Defensive Interval Ratio (DIR) is an interesting ratio to be considered. If you, as an investor, would ever want to know how a company is doing in terms of liquidity, Defensive Interval Ratio should be the one ratio you should rely upon.

Defensive Interval Ratio is a ratio which explains how many days a company can operate without using its noncurrent assets, any long term asset or any other financial resources. For example, if ABC Company has a DIR of 45 days, that means ABC Company can operate for 45 days without touching the noncurrent assets or long terms assets or any other financial resources. Many call Defensive Interval Ratio (DIR) as financial efficiency ratio, but it is commonly considered as “liquidity ratio”.

Defensive Interval Ratio (DIR) is a variation of quick ratio. Through DIR the company and its stakeholders get to know for many days it can use its liquid assets to pay its bills. As an investor, you need to have a glance at the DIR of a company for a long period of time. If it’s gradually increasing, it means the company is able to generate more liquid assets to pay for day to day activities. And if it’s gradually declining, that means the buffer of liquid assets of the company is gradually declining too.

To compute Defensive Interval Ratio (DIR), all we need to do is to take out the liquid assets (that are easily convertible into cash) and then divide it by average expenditure per day. In the denominator, we cannot include every average expense as that may not be getting used in the day to day activities. And on the numerator, we can only put items that are easily convertible in cash in short term.

In simple terms, go to the balance sheet. Look at the current assets. Select the items that can easily be converted into cash. Add them up. And then divide it by the average daily expenditure.

**Recommended Courses**

## Defensive Interval Ratio Formula

Let’s look at the Defensive Interval Ratio (DIR) formula.

There are two parts of this formula. First, we need to look at the numerator and then we will see how to compute the denominator.

Here’s the formula –

**Defensive Interval Ratio (DIR) = Current Assets / Average Daily Expenditures**

Now the question is what we would include in the current assets.

We need to take only those items that are easily converted into cash or equivalent. There are three things we would generally include in the numerator –

**Current Assets (that can be converted into liquidity easily) = Cash + Marketable Securities + Trade Accounts Receivable**

Other Liquidity Ratios Related articles – Current Ratio, Cash Ratio, Current Ratio vs Quick Ratio

We have included these three because they can be easily converted into cash.

Also, checkout these articles on Current Assets – Cash & Cash Equivalents, Marketable Securities, Accounts Receivables

Now let’s look at the denominator.

The easy way to find out average daily expenditures is to first note the costs of goods sold and annual operating expenses. Then we need to deduct any non-cash charges like depreciation, amortization etc. Then finally we will divide the figure by 365 days to get the average daily expenditures.

**Average Daily Expenditures = (Cost of Goods Sold + Annual Operating Expenses – Noncash Charges) / 365**

Defensive Interval Ratio is considered to be the best liquidity ratio by many financial analysts. Most of the liquidity ratios like quick ratio, current ratio assess the current assets with current liabilities. And thus, they are unable to produce an accurate result about liquidity. In the case of Defensive Interval Ratio (DIR), the current assets are not compared to current liabilities; rather they are compared to expenses. Thus, DIR is able to produce almost an accurate result about the liquidity position of the company.

But there are few limitations as well which we will discuss at the end of this article. So the idea is to compute DIR along with quick ratio and current ratio. It will give the investor a holistic picture of how a company is doing in terms of liquidity. For example, if Company MNC has huge expenses and almost no liabilities whatsoever, then the DIR value would be drastically different than the value of quick ratio or current ratio.

## Interpretation of Defensive Interval Ratio (DIR)

While interpreting the result you get out of DIR calculation, here’s what you should consider going forward –

- Even if Defensive Interval Ratio (DIR) is the most accurate liquidity ratio you would ever find, there is one thing that is not being noted by DIR. If as an investor, you are looking at DIR to judge the liquidity of the company; it would be important to know that DIR doesn’t take into account the financial difficulty the company faces over the period. Thus, even if the liquid assets are enough to pay off the expenses, it doesn’t mean the company is always in a good position. As an investor, you need to look deeper to know more.
- While computing the average daily expenses, you should also consider taking into account the cost of goods sold as part of the expenses. Many investors don’t include it as part of the average daily expense which ushers in a different resultant figure than the accurate one.
- If the DIR is more in terms of days, it is considered healthy for the company and if the DIR is less, than it needs to improve its liquidity.
- The best way to find out liquidity about a company may not be Defensive Interval Ratio. Because in any company, every day the expenditure is not similar. It may so happen that for few days there are no expenses in the company and suddenly one day the company can incur a huge expense and then for a while, there would be no expense again. So to find out the average, we need to even out the expenses for all the days even if there are no expenses incurred on those days. The ideal thing to do is to take a note of every expense per day and find out a trend function where these expenses are repeatedly incurred. This will help to understand the liquidity scenario of a company.

## Defensive Interval Ratio Example

We will look at few examples so that we can understand DIR from all angles. Let’s get started with the first example.

**Defensive Interval Ratio **Example # 1

**Mr A has been investing in businesses for a while. He wants to understand how Company P is doing in terms of liquidity. So he looks at Company P’s financial statements and discovers the following information – **

**Particulars of P Company at the end of 2016**

Details |
2016 (In US $) |

Cash | 30,00,000 |

Trade Receivables | 900,000 |

Marketable Securities | 21,00,000 |

Average Daily Expenditure | 200,000 |

How would he find almost an accurate picture of Company P’s liquidity?

This is a simple example. Here we need to compute Defensive Interval Ratio (DIR) by applying the formula straight since all the information is already given.

The formula of DIR is –

**Defensive Interval Ratio (DIR) = Current Assets / Average Daily Expenditures**

Current Assets include –

**Current Assets (that can be converted into liquidity easily) = Cash + Marketable Securities + Trade Accounts Receivable**

Let’s calculate the DIR now –

Details |
2016 (In US $) |

Cash (1) | 30,00,000 |

Trade Receivables (2) | 900,000 |

Marketable Securities (3) | 21,00,000 |

Current Assets (4 = 1+2+3) | 60,00,000 |

Average Daily Expenditure (5) | 200,000 |

Defensive Interval Ratio (4/5) |
30 days |

After the calculation, Mr A finds that the liquidity position of Company P is not good enough and he decides to look into other aspects of the company.

**Defensive Interval Ratio **Example # 2

**Mr B isn’t able to find the Balance Sheet of Company M. But he has the following information available with him – **

Details |
2016 (In US $) |

Cost of Goods Sold (COGS) | 30,00,000 |

Operating expenses for the year | 900,000 |

Depreciation Charges | 100,000 |

Defensive Interval Ratio | 25 days |

Mr. B needs to find the current assets of Company M which are easily convertible into cash.

We have been given the information for computing average daily expenditure and we know how to compute defensive interval ratio. By applying the information given above, we can find out the current assets of Company M which are easily convertible.

We will start with computing the average daily expenditure.

Here’s the formula –

**Average Daily Expenditures = (Cost of Goods Sold + Annual Operating Expenses – Non cash Charges) / 365**

So, let’s compute using the given information –

Details |
2016 (In US $) |

Cost of Goods Sold (COGS) (1) | 30,00,000 |

Operating expenses for the year (2) | 900,000 |

Depreciation Charges (3) | 100,000 |

Total expenses (4 = 1 + 2 – 3) | 38,00,000 |

Number of days in a year (5) | 365 days |

Average Daily Expenditure (4/5) |
10,411 |

Now we will use the formula of DIR to find out the current assets which can easily be converted into cash.

**Defensive Interval Ratio (DIR) = Current Assets / Average Daily Expenditures**

Details |
2016 (In US $) |

Average Daily Expenditure (A) | 10,411 |

Defensive Interval Ratio (B) | 25 days |

Current Assets (C = A * B) |
260,275 |

Now Mr. B has got to know how much current assets of Company M can be converted into cash in short term.

**Defensive Interval Ratio **Example # 3

**Mr. C wants to compare three companies’ liquidity position. He has furnished below the following information to his financial analyst to come to the right conclusion. Let’s have a look at the details below – **

Details |
Co. M (US $) |
Co. N (US $) |
Co. P (US $) |

Cash | 300,000 | 400,000 | 500,000 |

Trade Receivables | 90,000 | 100,000 | 120,000 |

Marketable Securities | 210,000 | 220,000 | 240,000 |

Cost of Goods Sold | 200,000 | 300,000 | 400,000 |

Operating Expenses | 100,000 | 90,000 | 110,000 |

Depreciation Charges | 40,000 | 50,000 | 45,000 |

The financial analyst needs to find out which company is in better position to pay off the bills without touching any long term assets or external financial resources.

This example is a comparison between which company is in better position.

We will go step by step.

First, we will ascertain the total current assets which can easily be converted into cash. Then we would compute the average daily expenditure. Finally, we will find out the Defensive Interval Ratio (DIR).

Let’s get started.

Details |
Co. M (US $) |
Co. N (US $) |
Co. P (US $ |

Cash (1) | 300,000 | 400,000 | 500,000 |

Trade Receivables (2) | 90,000 | 100,000 | 120,000 |

Marketable Securities (3) | 210,000 | 220,000 | 240,000 |

Current Assets (4 = 1+2+3) |
600,000 |
720,000 |
860,000 |

Now we will compute the annual daily expenditure.

Details |
Co. M (US $) |
Co. N (US $) |
Co. P (US $) |

Cost of Goods Sold (1) | 200,000 | 300,000 | 400,000 |

Operating Expenses (2) | 100,000 | 90,000 | 110,000 |

Depreciation Charges (3) | 40,000 | 50,000 | 45,000 |

Total Expenses (4 = 1 + 2 – 3) | 260,000 | 340,000 | 465,000 |

Number of days in a year (5) | 365 | 365 | 365 |

Average Daily Expenditure (4/5) |
712 |
932 |
1274 |

Now we can calculate the Defensive Interval Ratio and find out which company has better liquidity position.

Details |
Co. M (US $) |
Co. N (US $) |
Co. P (US $ |

Current Assets (1) | 600,000 | 720,000 | 860,000 |

Average Daily Expenditure (2) | 712 | 932 | 1274 |

Defensive Interval Ratio (1/2) |
843 days* |
773 days |
675 days |

*Note: All of these are hypothetical situations and only used to illustrate DIR.

From the above computation, it’s clear that Co. M has the most lucrative liquidity position among all three.

## Colgate – Calculating Defensive Interval Ratio

Now that we are familiar with the calculations of Defensive Interval Ratio of basic examples, let us calculate Defensive Interval Ratio for Colgate.

#### Step 1 – Calculate Current Assets that can be converted into cash easily.

- Current Assets (that can be converted into cash easily) = Cash + Marketable Securities + Trade Accounts Receivable
- Colgate’s Current Assets contain Cash & Cash Equivalents, Accounts Receivables, Inventories and Other current assets.
- Only two items out of these four can be readily converted to cash – a) Cash and Cash Equivalents b) Receivables.

source: Colgate 10K Filings

- Colgate Current Assets (that can be converedt to cash easily) = $1,315 + 1,411 = $2,726 million

#### Step 2 – Find the Average Daily Expenditures

In order to find the average daily expenditure, we can use the following formula

Average Daily Expenditures = (Cost of Goods Sold + Annual Operating Expenses – Noncash Charges) / 365.

Here it is a bit tricky as we are not spoon fed with all the necessary information.

- From the Income Statement, we get the two items a) Cost of Sales b) Selling General and Administrative Expenses.
- Other expense is not an operating expense and hence excluded from the expenditure calculations.
- Also, the charge for Venezuela accounting in not an operating expense and is excluded.

source: Colgate 10K Filings

In order to find the non-cash, we need to scan the annual report of Colgate.

There are two types of non-cash items are included in Cost of Sales or Selling General & Admin expense.

##### 2a) Depreciation & Amortization

- Depreciation and Amortization is a non-cash expense. As per Colgate’s filings, Depreciation attributable to manufacturing operations is included in Cost of sales.
- The remaining component of depreciation is included in Selling, general and administrative expenses.
- The total Depreciation and Amortization figures are provided in the cash flow statement.

source: Colgate 10K Filings

- Depreciation and Amortization (2016) = $443 million.

##### 2b) Stock-Based Compensation

- Colgate recognizes the cost of employee services received in exchange for awards of equity instruments, such as stock options and restricted stock units, based on the fair value of those awards at the date of grant over the requisite service period.
- These are called at Stock-Based Compensation. In Colgate, Stock-based compensation expense is recorded within Sel