CHAPTER 4: WORKING CAPITAL & LIQUIDITY Flashcards
(52 cards)
Cash Conversion Cycle - Key Points
Business Operations Steps:
Acquiring raw materials
Producing inventory
Selling products to customers
Collecting cash
Operating Cycle:
Sequence of business activities
Can occur once or multiple times per year
Cash Flow Timing:
Cash outflows and inflows do not always match the timing of activities
Example: Raw materials bought on credit; payment to vendor later
Example: Finished goods sold; payment collected later
Financial Recording:
Future cash inflows: Short-term assets
Future cash outflows: Short-term liabilities
ST ASSETS & ST LIABILITIES
Short-Term ASSETS:
- Accounts Receivable: Amounts to be collected from customers for products/services sold
- Inventory: Cost of products produced or purchased for sale
Short-Term LIABILITIES:
Accounts Payable: Amounts owed to suppliers for products/services received
Recognition and Derecognition:
- Accounts Receivable:
Recognized when product/service is sold on credit
Derecognized when cash is received from customer - Inventory:
Recognized when issuer takes ownership of materials/goods/supplies
Derecognized when product is sold to customer - Accounts Payable:
Recognized when product/service is received and payment is deferred
Derecognized when cash is paid to supplier
Days Payable Outstanding (DPO):
Time taken to pay suppliers after receiving inventory
Represents cash outflow delay
Days of Inventory on Hand (DOH):
Time inventory is held before being sold
Represents the duration from receiving inventory to selling products
Days Sales Outstanding (DSO):
Time taken to collect cash from customers after selling inventory
Represents cash inflow delay
Cash Conversion Cycle (CCC):
Total time from paying suppliers to receiving cash from customers
Formula: CCC = DIO + DSO - DPO
DIO: Sell quicker
DSO: Collect faster
DPO: Negotiate longer
Indicates the efficiency of a company’s cash flow management
CCC Process Overview:
Receive Inventory from Suppliers
Cash Payment to Suppliers (after DPO period)
Inventory Sold to Customers (during DOH period)
Receive Cash from Customers (after DSO period)
CCC Visual Summary:
DPO: Time between receiving inventory and paying suppliers
DOH: Time inventory is held before sale
DSO: Time between selling inventory and receiving cash
CCC: DOH + DSO - DPO, indicating overall cash cycle duration
Cycle Duration:
Shorter cycle is better
Short cycle: Company converts inventory to cash quickly
Long cycle: Company converts inventory to cash slowly
Longer cycle increases working capital needs
Negative Cash Conversion Cycle:
Occurs when a company receives cash from customers before paying suppliers. DESIRABLE
This is based on Example 2 from the curriculum.
The following information is provided for five large US discount retailers Walmart Inc., Target
Corporation, Costco Wholesale Corporation, The TJX Companies, and Ross Stores for the 2021 calendar year.
Walmart: Target: Costco: TJX: Ross
DSO: 5:2:3:7:2
DIO: 48:68:29:63:61
DPO: 47:75:34:47:63
Which company has the shortest cash conversion cycle?
CCC= DIO+DSO-DPO
Walmart= (48+5)-47= 6
Target= (68+2)-75= -5
Costco= (29+3)-34= -2
TJX= (7+63)-47= 23
Ross= (2+61)-63= 0
Shortest= TARGET= -5
Reduce Days on Inventory on Hand:
Methods include discounting slow-moving products, implementing a ‘just in time’ inventory system, and using data analytics for better demand forecasting.
Reduce Days Sales Outstanding:
Offer prompt payment discounts to customers, apply late fees, and utilize third-party collection agencies to expedite payments.
Increase Days Payable Outstanding:
Negotiate longer payment terms with suppliers. Note that negotiation success depends on the company’s bargaining power relative to suppliers.
Supplier Discounts for Prompt Payments:
Suppliers typically offer discounts like “2/10 net 30,” meaning a 2% discount if paid within 10 days, otherwise full payment is due within 30 days.
Cost of Trade Credit Calculation:
Converting the discount to an annualized number
Cost of trade credit = (1 + discount / (1 - discount)) ^ n - 1
n= 365 / number of days beyond discount period
2/10 net 30
2/10: This means the buyer can take a 2% discount if they pay the invoice within 10 days of receiving it.
Net 30: If the discount isn’t taken, the full invoice amount is due within 30 days from the invoice date.
Example: Internal versus External Financing Decision. This is based on Example 1 from the curriculum.
A company is evaluating two options to fund its working capital needs:
Option1: Forgo the 2% discount offered by its supplier. The standard trade terms are 2/10 net 30.
Option 2: Borrow through its external line of credit. The effective annual rate for the line of credit is 7.7%
Which option should the company prefer?
Cost of Trade Credit= (1+ discount/1-discount)^n
n= 365/days beyond discount period
(1+(0.02/0.98)^365/20) - 1= 44.6%
n= 365/20 because net days= 30 & 2/10 structure
This is significantly higher than the 7.7% rate on the external credit line. Therefore, the company should prefer the credit line. It should borrow from the credit line and pay the supplier early to avail the discount
Apart from the cash conversion cycle, analysts also assess the amount of working
capital used by a company.
WORKING CAPITAL FORMULA
WORKING CAPITAL= Current Operating Assets - Current Operating Liabilities
COA (excluding cash & marketable securities)
COL (excluding ST & current debt)
COA: AR, inventory & prepaid expenses
COL: AP & accrued expenses
To compare across firms, total or net working capital is often expressed as a percentage of sales. The lower this ratio, the better.
Consider the following balance sheet for an issuer. Calculate the issuer’s net working capital.
Assets:
Cash: 100
Marketable securities: 20
Accounts receivable: 600
Inventory: 800
Prepaid expenses: 30
Property, plant, and equipment: 10,000
Intangibles: 500
Total Assets: 12,050
Liabilities and Equity:
Accounts payable: 980
Accrued expenses: 70
Short-term debt: 1,000
Long-term debt: 2,000
Shareholders’ equity: 8,000
Total Liabilities and Equity: 12,050
COA: AR, inventory & prepaid expenses
(investor’s money stuck up in the business)
COL: AP & accrued expenses: only non-interest bearing liabilities
(free money+pulling money from suppliers for your business)
COA: 600+800+30= 1430
COL: 980+70= 1050
WC: COA-COL= 1430-1050= 380
A company is evaluating two options to fund its working capital needs:
Option 1: Forgo the 2% discount offered by its supplier. The standard trade terms are 2/10 net 40.
Option 2: Borrow through its external line of credit. The effective annual rate for the line of credit is 11%.
The company would:
A prefer Option 1.
B prefer Option 2.
C would be indifferent between Options 1 and 2.
B is correct. The effective annual rate on the forgone trade credit can be calculated as:
[(1+(2/98))^(365/30)] – 1 = 27.86%
Take 2/98 first; then add one to it then ^365/30 then -1
This is significantly higher than the 11% rate on the external credit line.
Therefore, the company should prefer Option 2 i.e. the credit line.
All else equal, cash conversion cycle of a company will decrease if there is an increase in:
A Days of payables
B Days of inventory
C Days of receivables
A
A is correct. Cash conversion cycle is calculated using the following equation,
Cash conversion cycle = Days of inventory + Days of receivables – Days of payables
CCC= DIO+DSO-DPO
It will decrease if there is an increase in days of payables, all else equal.
A and B are not correct because an increase in days of inventory and days of receivables will result in an increase in cash conversion cycle.