It's Sunday and a good day to improve your understanding of cash flows of the co.
As they say, ‘Revenue is vanity, profit is sanity and cash is reality’
In this small 🧵 we will share with you 4 cash flow ratios that every investor should look at while analyzing any co. (1/n)
As they say, ‘Revenue is vanity, profit is sanity and cash is reality’
In this small 🧵 we will share with you 4 cash flow ratios that every investor should look at while analyzing any co. (1/n)
In our view, no fundamental analysis on any company can ever be complete without understanding the cash flows of the company
(2/n)
(2/n)
To understand the ratios easily, for the next 10 minutes assume yourself to be a businessman with a business wherein your annual sales are Rs 120 crore.
For the same you consumed Rs 60 crore of raw material and finished goods (3/n)
For the same you consumed Rs 60 crore of raw material and finished goods (3/n)
To ensure your sales are not disrupted for the coming year, you have Rs 30 crore of inventory and Rs 10 crore is pending in terms of payment to suppliers (payables).
Further, out of Rs 120 crore sales, you are yet to receive Rs 20 crore from your customers (debtors).
(4/n)
Further, out of Rs 120 crore sales, you are yet to receive Rs 20 crore from your customers (debtors).
(4/n)
Debtor days – Debtor days is used to calculate the credit period that the company gives its clients.
Ideally, you would want your customer to pay in advance or as early as possible. At the same time, the customer in general would like to defer his payments.
(5/n)
Ideally, you would want your customer to pay in advance or as early as possible. At the same time, the customer in general would like to defer his payments.
(5/n)
So, in the above example, you are doing sales of Rs 10 crore per month and as you are yet to receive Rs 20 crore from your customers, the debtor days for your business are 60 or 2 months; which means on an average you give 60 days to your customers to make the payment.
(6/n)
(6/n)
Formula = [Accounts receivable/ Annual Sales] * 365 days
Why rising debtor days can be a cause for concern – cash is reality and till you get the money from the customer, there remains a possibility that for some or the other reason the customer might default.
(7/n)
Why rising debtor days can be a cause for concern – cash is reality and till you get the money from the customer, there remains a possibility that for some or the other reason the customer might default.
(7/n)
Also, rising debtor days could indicate that the business is getting extremely competitive and in order to realize sales, you are offering higher credit period to customers which again increases the risk of bad debts
(8/n)
(8/n)
Inventory days – Inventory days calculation is again as simple as debtor days
The idea behind calculating inventory days is to determine how long the raw material/finished goods remain stuck in the factory/warehouse/store before you are able to convert them to sales
(9/n)
The idea behind calculating inventory days is to determine how long the raw material/finished goods remain stuck in the factory/warehouse/store before you are able to convert them to sales
(9/n)
in general you would want to sell off your products asap and realize cash from sales
Unless, you deal in products (liquor, rice, etc) where ageing can help you charge a premium or where holding additional inventory gives you some competitive advantage with your customer
(10/n)
Unless, you deal in products (liquor, rice, etc) where ageing can help you charge a premium or where holding additional inventory gives you some competitive advantage with your customer
(10/n)
In the above example, as you are holding Rs 30 crore of inventory against an annual requirement of Rs 60 crore, the inventory days for your business are 183 or 6 months.
Formula = [Inventory/ Cost of goods sold] * 365 days
(11/n)
Formula = [Inventory/ Cost of goods sold] * 365 days
(11/n)
One can also calculate Inventory days on the basis of sales and the formula would change to [Inventory/ Annual Sales] * 365 days
(12/n)
(12/n)
Why high or rising inventory days can be a cause for concern – Unless there’s a specific business requirement that leads to competitive advantage, you would want your inventory days to be on the lower side, because otherwise you run the risk of obsolescence, ruin, etc
(13/n)
(13/n)
Similarly, rising inventory days could potentially mean that the product isn’t moving fast enough or lack of demand.
A lot of companies work on the concept of just-in-time inventory so as to not block their own capital and ensure a very strong supply chain
(14/n)
A lot of companies work on the concept of just-in-time inventory so as to not block their own capital and ensure a very strong supply chain
(14/n)
Payable days – Payable days help determine the time you are taking as a businessman to make payments to your supplier.
In the above example, you consumed Rs 60 crore of goods for the whole year and your outstanding payment to suppliers is Rs 10 crore.
(15/n)
In the above example, you consumed Rs 60 crore of goods for the whole year and your outstanding payment to suppliers is Rs 10 crore.
(15/n)
So, payable days will be 61 or 2 mnths
Formula = [Accounts payable/ Cost of goods sold] * 365 days
Depending on nature of the biz, competitive positioning in the industry and supply chain, high payable days could indicate that you have bargaining power with suppliers
(16/n)
Formula = [Accounts payable/ Cost of goods sold] * 365 days
Depending on nature of the biz, competitive positioning in the industry and supply chain, high payable days could indicate that you have bargaining power with suppliers
(16/n)
At the same time, if the business positioning is not good, rising payable days could mean that the business is facing issues in making payments to the supplier and the supply may soon cut off
(17/n)
(17/n)
Cash conversion cycle – CCC helps us determine the number of days it takes a co. to convert cash into inventory, and then back into cash via the sales process.
Formula = Debtor days + Inventory days – Payable days
(18/n)
Formula = Debtor days + Inventory days – Payable days
(18/n)
To understand better, an FMCG company with major brands may probably have a negative cash conversion cycle
(19/n)
(19/n)
How – There’s a strong pull for brands so distributors may pay in advance (-ve debtor days). Company may not maintain very high inventory because of its strong supplier base and at the same time it may also have some leverage in terms of higher credit days with its suppliers
end
end
Loading suggestions...