CH 11 Working Capital Management
CH 11 Working Capital Management
1. Introduction
Before devoting a lot of pages to the topic “working capital management”, I would like to present
some situations before you. Let us have a look:
1. In our houses, a minimum cash balance is always there;
2. Our mothers kneed some extra dough daily and prepare some extra chapattis more than the
requirement;
3. While going out our parents give us extra money other than the fare, staying charges, food
charges, etc.;
4. In businesses extra cash or inventory is always there;
In all the above instances there is a common point—either there is some quantity is locked in or we
have more quantity than the requirements.
Liquidity
Profitability/Liquidity
Profitability
Profitability/Liquidity
8. Nature of trade-off
In order to understand the nature of trade off we take some simple examples—
𝐷𝑒𝑐𝑟𝑒𝑎𝑠𝑒 𝑖𝑛 𝑐𝑢𝑟𝑟𝑒𝑛𝑡 𝑟𝑎𝑡𝑖𝑜 ⇒ 𝐷𝑒𝑐𝑟𝑒𝑎𝑠𝑒 𝑖𝑛 𝑙𝑖𝑞𝑢𝑖𝑑𝑖𝑡𝑦 ⇒ 𝐼𝑛𝑐𝑟𝑒𝑎𝑠𝑒 𝑖𝑛 𝑟𝑖𝑠𝑘
⇒ 𝐼𝑛𝑐𝑟𝑒𝑎𝑠𝑒 𝑖𝑛 𝑝𝑟𝑜𝑓𝑖𝑡𝑠
𝐼𝑛𝑐𝑟𝑒𝑎𝑠𝑒 𝑖𝑛 𝑐𝑢𝑟𝑟𝑒𝑛𝑡 𝑟𝑎𝑡𝑖𝑜 ⇒ 𝐼𝑛𝑐𝑟𝑒𝑎𝑠𝑒 𝑖𝑛 𝑙𝑖𝑞𝑢𝑖𝑑𝑖𝑡𝑦 ⇒ 𝐷𝑒𝑐𝑟𝑒𝑎𝑠𝑒 𝑖𝑛 𝑟𝑖𝑠𝑘
⇒ 𝐷𝑒𝑐𝑟𝑒𝑎𝑠𝑒 𝑖𝑛 𝑝𝑟𝑜𝑓𝑖𝑡𝑠
Let us take the following three assumptions—
(i) We are dealing with a manufacturing firm;
(ii) Current assets are less profitable than fixed assets; and
(iii) Short-term funds are less expensive than long-term funds.
Let us also assume that—
Current assets ₹5,400 Rate of return on current assets 2%
Fixed assets ₹8,600 Return on fixed assets 12%
Total assets ₹14,000
Current liabilities ₹3,200
Chapter 11, Working Capital Management: 2
8.1. Present position—
𝑊𝑜𝑟𝑘𝑖𝑛𝑔 𝑐𝑎𝑝𝑖𝑡𝑎𝑙=₹5,400−₹3,200=₹2,200
5,400
𝑅𝑎𝑡𝑖𝑜 𝑜𝑓 𝑐𝑢𝑟𝑟𝑒𝑛𝑡 𝑎𝑠𝑠𝑒𝑡𝑠 𝑡𝑜 𝑡𝑜𝑡𝑎𝑙 𝑎𝑠𝑠𝑒𝑡𝑠 = ⇒ 0.386
14,000
𝑅𝑒𝑡𝑢𝑟𝑛 ⇒ 𝐶𝑢𝑟𝑟𝑒𝑛𝑡 𝑎𝑠𝑠𝑒𝑡𝑠 = ₹5,400 × 2% = ₹0,108
𝐹𝑖𝑥𝑒𝑑 𝑎𝑠𝑠𝑒𝑡𝑠 = ₹8,600 × 12% = ₹1,032
₹1,140
8.4. Summary
Values after Values after increase
Particulars Values at base level decrease in current in current assets by
assets by ₹600 ₹600
Working capital ₹2,200 ₹1,600 ₹2,800
Ratio of current assets
0.386 0.343 0.429
to total assets
Return on total assets ₹1,140 ₹1,200 ₹1,080
From the perusal of the summary of the above table it is clear that a decrease in the level of current
assets (i.e. decrease in liquidity) increase the return of the firm. And if there is an increase in the
liquidity then there is a decrease in the return of the firm.
9.1. Hedging/matching
approach
Hedging is the process of matching Long-term Financing
9.2. Conservative
approach Total WC
Long-term Financing
This approach suggests that the
Time
Work-in-
Progress
Operating
Cycle
Note to the above diagram: Solid line represents the gap between various phases.
Example 1 (Example 1)
Calculate the operating cycle of a company which gives the following details relating to its
operations—
₹
Annual raw material consumption 8,42,000
Annual cost of production 14,25,000
Annual cost of sales 15,30,000
Annual sales 19,50,000
Average value of current assets held—
Raw materials 1,24,000
Work-in-progress 72,000
Finished goods 1,22,000
Debtors 2,60,000
The company gets 30 days credit from its suppliers. All sales made by firm are on credit basis. You
may take one year as equal to 365 days.
(ICWA Inter, 2002)
Solution
Statement showing estimation of operating cycle
Particulars Days
Raw material 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑟𝑎𝑤 𝑚𝑎𝑡𝑒𝑟𝑖𝑎𝑙 𝑠𝑡𝑜𝑐𝑘 ℎ𝑒𝑙𝑑 1,24,000
holding period × 365 ⇒ × 365 54
(R) 𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑜𝑛𝑠𝑢𝑚𝑝𝑡𝑖𝑜𝑛 𝑜𝑓 𝑟𝑎𝑤 𝑚𝑎𝑡𝑒𝑟𝑖𝑎𝑙 8,42,000
Work-in-
progress 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑤𝑜𝑟𝑘 − 𝑖𝑛 − 𝑝𝑟𝑜𝑔𝑟𝑒𝑠𝑠 𝑠𝑡𝑜𝑐𝑘 ℎ𝑒𝑙𝑑 72,000
× 365 ⇒ × 365 18
period 𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑜𝑠𝑡 𝑜𝑓 𝑝𝑟𝑜𝑑𝑢𝑐𝑡𝑖𝑜𝑛 𝑜𝑓 𝑔𝑜𝑜𝑑𝑠 14,25,000
(W)
Finished goods 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑓𝑖𝑛𝑖𝑠ℎ𝑒𝑑 𝑔𝑜𝑜𝑑𝑠 𝑠𝑡𝑜𝑐𝑘 ℎ𝑒𝑙𝑑 1,22,000
holding period × 365 ⇒ × 365 29
(F) 𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑜𝑠𝑡 𝑜𝑓 𝑠𝑎𝑙𝑒𝑠 𝑜𝑟 𝑔𝑜𝑜𝑑𝑠 𝑠𝑜𝑙𝑑 15,30,000
Receivables 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑎𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑟𝑒𝑐𝑒𝑖𝑣𝑎𝑏𝑙𝑒𝑠 2,60,000
collection × 365 ⇒ × 365 49
period (D) 𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑟𝑒𝑑𝑖𝑡 𝑠𝑎𝑙𝑒𝑠 19,50,000
GROSS OPERATING CYCLE 150
Less: Creditors 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑡𝑟𝑎𝑑𝑒 𝑐𝑟𝑒𝑑𝑖𝑡𝑜𝑟𝑠
payment × 365 (𝑔𝑖𝑣𝑒𝑛) -30
period (C) 𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑟𝑒𝑑𝑖𝑡 𝑝𝑢𝑟𝑐ℎ𝑎𝑠𝑒𝑠
NET OPERATING CYCLE (CASH CYCLE) 120
Hence, 𝑂 = 𝑅 + 𝑊 + 𝐹 + 𝐷 − 𝐶 ⇒ (54 + 18 + 29 + 49) − 30 = 120 𝑑𝑎𝑦𝑠
Solution
Statement showing estimation of operating cycle
Particulars Days
Raw material 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑟𝑎𝑤 𝑚𝑎𝑡𝑒𝑟𝑖𝑎𝑙 𝑠𝑡𝑜𝑐𝑘 ℎ𝑒𝑙𝑑 3,20,000
holding period × 365 ⇒ × 365 27
𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑜𝑛𝑠𝑢𝑚𝑝𝑡𝑖𝑜𝑛 𝑜𝑓 𝑟𝑎𝑤𝑚𝑎𝑡𝑒𝑟𝑖𝑎𝑙 44,00,000
(R)
𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑤𝑜𝑟𝑘 − 𝑖𝑛 − 𝑝𝑟𝑜𝑔𝑟𝑒𝑠𝑠 𝑠𝑡𝑜𝑐𝑘 ℎ𝑒𝑙𝑑
Work-in- × 365
𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑜𝑠𝑡 𝑜𝑓 𝑝𝑟𝑜𝑑𝑢𝑐𝑡𝑖𝑜𝑛 𝑜𝑓 𝑔𝑜𝑜𝑑𝑠
progress 13
3,50,000
period (W) ⇒ × 365
1,00,00,000
Finished goods 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑓𝑖𝑛𝑖𝑠ℎ𝑒𝑑 𝑔𝑜𝑜𝑑𝑠 𝑠𝑡𝑜𝑐𝑘 ℎ𝑒𝑙𝑑 2,60,000
holding period × 365 ⇒ × 365 9
(F) 𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑜𝑠𝑡 𝑜𝑓 𝑠𝑎𝑙𝑒𝑠 𝑜𝑟 𝑔𝑜𝑜𝑑𝑠 𝑠𝑜𝑙𝑑 1,05,00,000
Receivables 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑎𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑟𝑒𝑐𝑒𝑖𝑣𝑎𝑏𝑙𝑒𝑠 4,80,000
collection × 365 ⇒ × 365 11
period (D) 𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑟𝑒𝑑𝑖𝑡 𝑠𝑎𝑙𝑒𝑠 1,60,00,000
GROSS OPERATING CYCLE 60
Less: Creditors 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑡𝑟𝑎𝑑𝑒 𝑐𝑟𝑒𝑑𝑖𝑡𝑜𝑟𝑠
payment × 365 (𝑔𝑖𝑣𝑒𝑛) -16
period (C) 𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑟𝑒𝑑𝑖𝑡 𝑝𝑢𝑟𝑐ℎ𝑎𝑠𝑒𝑠
NET OPERATING CYCLE (CASH CYCLE) 44
Hence, 𝑂 = 𝑅 + 𝑊 + 𝐹 + 𝐷 − 𝐶 ⇒ (27 + 13 + 9 + 11) − 16 = 44 𝑑𝑎𝑦𝑠
Note: It is assumed that total sales in on credit.
Example 3 (Illustration 2)
The relevant information for XYZ Limited for the year ended 2009 are given below—
₹
Sales 80,000
Cost of goods sold 56,000
Particulars Opening Closing
Inventory 9,000 12,000
Accounts receivables 12,000 16,000
Accounts payables 7,000 10,000
What is the length of net operating cycle? Assume 365 days in a year.
(B. Com. Honors, Delhi University, 2010)
Solution
Statement showing estimation of operating cycle
Chapter 11, Working Capital Management: 10
Particulars Days
Inventory 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑓𝑖𝑛𝑖𝑠ℎ𝑒𝑑 𝑔𝑜𝑜𝑑𝑠 𝑠𝑡𝑜𝑐𝑘 ℎ𝑒𝑙𝑑 10,500
holding period × 365 ⇒ × 365 68.44
(F) 𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑜𝑠𝑡 𝑜𝑓 𝑠𝑎𝑙𝑒𝑠 𝑜𝑟 𝑔𝑜𝑜𝑑𝑠 𝑠𝑜𝑙𝑑 56,000
Accounts
receivables 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑎𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑟𝑒𝑐𝑒𝑖𝑣𝑎𝑏𝑙𝑒𝑠 14,000
× 365 ⇒ × 365 63.88
collection 𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑟𝑒𝑑𝑖𝑡 𝑠𝑎𝑙𝑒𝑠 80,000
period (D)
GROSS OPERATING CYCLE 132.32
Less: Creditors 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑡𝑟𝑎𝑑𝑒 𝑐𝑟𝑒𝑑𝑖𝑡𝑜𝑟𝑠 8,500
payment × 365 ⇒ × 365 -52.58
period (C) 𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑟𝑒𝑑𝑖𝑡 𝑝𝑢𝑟𝑐ℎ𝑎𝑠𝑒𝑠 59,000
NET OPERATING CYCLE (CASH CYCLE) 78.74
Hence, 𝑂 = 𝑅 + 𝑊 + 𝐹 + 𝐷 − 𝐶 ⇒ (27 + 13 + 9 + 11) − 16 = 44 𝑑𝑎𝑦𝑠
Notes:
1. It is assumed that total sales in on credit.
2. 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑖𝑛𝑣𝑒𝑛𝑡𝑜𝑟𝑦 = (𝑂𝑝𝑒𝑛𝑖𝑛𝑔 𝐼𝑛𝑣𝑒𝑛𝑡𝑜𝑟𝑦 + 𝐶𝑙𝑜𝑠𝑖𝑛𝑔 𝑖𝑛𝑣𝑒𝑛𝑡𝑜𝑟𝑦)/2
3. 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑎𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑟𝑒𝑐𝑒𝑖𝑣𝑎𝑏𝑙𝑒𝑠 = (𝑂𝑝𝑒𝑛𝑖𝑛𝑔 𝑟𝑒𝑐𝑒𝑖𝑣𝑎𝑏𝑙𝑒𝑠 + 𝐶𝑙𝑜𝑠𝑖𝑛𝑔 𝑟𝑒𝑐𝑒𝑖𝑣𝑎𝑏𝑙𝑒𝑠)/2
4. 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑎𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑝𝑎𝑦𝑎𝑏𝑙𝑒𝑠 = (𝑂𝑝𝑒𝑛𝑖𝑛𝑔 𝑝𝑎𝑦𝑎𝑏𝑙𝑒𝑠 + 𝐶𝑙𝑜𝑠𝑖𝑛𝑔 𝑝𝑎𝑦𝑎𝑏𝑙𝑒𝑠)/2
5. 𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑟𝑒𝑑𝑖𝑡 𝑝𝑢𝑟𝑐ℎ𝑎𝑠𝑒𝑠 = 𝐶𝑙𝑜𝑠𝑖𝑛𝑔 𝑖𝑛𝑣𝑒𝑛𝑡𝑜𝑟𝑦 + 𝐶𝑜𝑠𝑡 𝑜𝑓 𝑔𝑜𝑜𝑑𝑠 𝑠𝑜𝑙𝑑 − 𝑜𝑝. 𝑖𝑛𝑣𝑒𝑛𝑡𝑜𝑟𝑦
Example 4 (Illustration 3)
From the following data compute the duration of the operating cycle for each of the two years and
comment on the increase/decrease—
Year 1 Year 2
Particulars (₹ in thousands) (₹ in thousands)
Average stock:
Raw material 20 27
Work-in-progress 14 18
Finished goods 21 24
Purchase 96 135
Cost of goods sold 140 180
Sales 160 200
Debtors 32 50
Creditors 16 18
Assume 360 days per year for computational purposes.
(B. Com. Honors, Delhi University, 2014)
Solution
Statement showing estimation of operating cycle
Particulars Year 1 Year 2
Raw material 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑟𝑎𝑤 𝑚𝑎𝑡𝑒𝑟𝑖𝑎𝑙 𝑠𝑡𝑜𝑐𝑘 ℎ𝑒𝑙𝑑 20 27
holding × 360 × 360 × 360
𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑜𝑛𝑠𝑢𝑚𝑝𝑡𝑖𝑜𝑛 𝑜𝑓 𝑟𝑎𝑤𝑚𝑎𝑡𝑒𝑟𝑖𝑎𝑙 96 135
period (R) = 75 = 72
Work-in- 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑤𝑜𝑟𝑘 − 𝑖𝑛 − 𝑝𝑟𝑜𝑔𝑟𝑒𝑠𝑠 𝑠𝑡𝑜𝑐𝑘 ℎ𝑒𝑙𝑑 14 18
× 360 × 360
progress 𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑜𝑠𝑡 𝑜𝑓 𝑝𝑟𝑜𝑑𝑢𝑐𝑡𝑖𝑜𝑛 𝑜𝑓 𝑔𝑜𝑜𝑑𝑠 140 180
period (W) × 360 = 36 = 36
Finished 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑓𝑖𝑛𝑖𝑠ℎ𝑒𝑑 𝑔𝑜𝑜𝑑𝑠 𝑠𝑡𝑜𝑐𝑘 ℎ𝑒𝑙𝑑 21 24
goods holding × 360 × 360 × 360
𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑜𝑠𝑡 𝑜𝑓 𝑠𝑎𝑙𝑒𝑠 𝑜𝑟 𝑔𝑜𝑜𝑑𝑠 𝑠𝑜𝑙𝑑 140 180
period (F) = 54 = 48
Receivables 32 50
𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑎𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑟𝑒𝑐𝑒𝑖𝑣𝑎𝑏𝑙𝑒𝑠 × 360 × 360
collection × 360 160 200
period (D) 𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑟𝑒𝑑𝑖𝑡 𝑠𝑎𝑙𝑒𝑠 = 72 = 90
GROSS OPERATING CYCLE 237 246
Example 5
Bahar Company Limited expects its cost of goods sold for 2019-2020 to be ₹15,00,00,000. The
expected operating cycle is 60 days. Als**********o, the company wants to maintain cash balance of
₹1,00,00,000. What is the expected working capital requirement? Assume a year consisting of 360
days.
Solution
Example 6 (Illustration 4)
The following information for a particular year has been extracted from the books of a
manufacturing company—
Balance sheet data
Particulars Opening (₹) Closing (₹)
Raw material 2,00,000 3,00,000
Work-in-progress 1,00,000 2,00,000
Finished goods 3,00,000 4,00,000
Debtors 3,00,000 4,00,000
Creditors 2,00,000 3,00,000
Profit and loss account data
₹
Purchases 16,00,000
Consumption of raw material 15,00,000
Total production cost 25,00,000
Total cost of goods sold 28,00,000
Total cost of sales 30,00,000
Sales 36,00,000
Assuming 360 days in a year, you are required to calculate—
1. Operating cycle in days
2. Cash cycle in days
3. Working capital required for the year
Chapter 11, Working Capital Management: 12
(B. Com. Honors, Delhi University, 2017)
Solution
Solution
(iii) Amount of working capital required for the company on a cash cost
basis
𝑇𝑜𝑡𝑎𝑙 𝑜𝑝𝑒𝑟𝑎𝑡𝑖𝑛𝑔 𝑐𝑜𝑠𝑡 (𝐶𝑜𝑠𝑡 𝑜𝑓 𝑠𝑎𝑙𝑒𝑠)
𝐴𝑚𝑜𝑢𝑛𝑡 𝑜𝑓 𝑤𝑜𝑟𝑘𝑖𝑛𝑔 𝑐𝑎𝑝𝑖𝑡𝑎𝑙 𝑟𝑒𝑞𝑢𝑖𝑟𝑒𝑚𝑒𝑛𝑡 =
𝑁𝑢𝑚𝑏𝑒𝑟 𝑜𝑓 𝑜𝑝𝑒𝑟𝑎𝑡𝑖𝑛𝑔 𝑐𝑦𝑐𝑙𝑒𝑠 𝑖𝑛 𝑎 𝑦𝑒𝑎𝑟
21,00,000 − 2,10,000 (𝐷𝑒𝑝𝑟𝑒𝑐𝑖𝑎𝑡𝑖𝑜𝑛)
⇒ ⇒ ₹4,20,000
4.5 𝑐𝑦𝑐𝑙𝑒𝑠
Revised amount of working capital required for the company on a cash cost
basis
Solution
Example 9 (Illustration 7)
A proforma cost sheet of a company provides you the following particulars—
Estimated cost per unit
Cost elements Amount per unit (₹)
Raw material 100
Direct labor 40
Overheads 60
Total 200
Additional information—
(i) Selling price ₹250 per unit
(ii) Level of activity 1,04,000 units of production per annum
(iii) Raw material in stock Average 4 weeks
(iv) Work-in-progress Average 2 weeks
(v) Finished goods in stock Average 4 weeks
(vi) Credit allowed by suppliers Average 4 weeks
(vii) Credit allowed to debtors Average 8 weeks
(viii) Lag in payment of wages Average 2 weeks
(ix) Cash at bank is expected to be 10% of gross working capital.
Production is carried on evenly throughout the year (52 weeks) and wages and overheads accrue
similarly. 25% of sales are on cash basis. You are required to prepare a statement of working capital
requirement.
(B. Com. Honors, Delhi University, 2015)
Solution
Statement showing estimation of working capital requirement
Particulars ₹
4𝑊
Raw material 1,04,000 × 100 × 8,00,000
52𝑊
40 60 2𝑊
Work-in-progress 1,04,000 × (100 + + )× 6,00,000
2 2 52𝑊
4𝑊
Finished goods 1,04,000 × (100 + 40 + 60) × 16,00,000
52𝑊
75 8𝑊
Debtors 1,04,000 × (100 + 40 + 60) × × 24,00,000
100 52𝑊
Cash or bank balance to be maintained in the business
6,00,000
(See note)
Gross working capital/Total current assets (A) 60,00,000
4𝑊
Creditors 1,04,000 × 100 × 8,00,000
52𝑊
2𝑊
Wages 1,04,000 × 40 × 1,60,000
52𝑊
Total current liabilities (B) 9,60,000
WORKING CAPITAL (A-B) 50,40,000
Add: Margin/Contingency --
You can also check that the bank balance of ₹6,00,000 𝑖𝑠 10% 𝑜𝑓 𝑡ℎ𝑒 𝑡𝑜𝑡𝑎𝑙 𝑐𝑢𝑟𝑟𝑒𝑛𝑡 𝑎𝑠𝑠𝑒𝑡𝑠.
Example 10 (Illustration 8)
Estimate the working capital requirement from the following particulars—
Production for the year 69,000 units
Finished goods in store 3 months
Raw material in store 2 months
Production process 1 month
Credit allowed by suppliers 2 months
Credit allowed to debtors 3 months
Selling price per unit ₹50
Raw material cost 50% of selling price
Direct wages 10% of selling price
Manufacturing overheads 16% of selling price
Selling overheads 4% of selling price
There is a regular production and sales cycle and wages and overheads accrue uniformly. Wages are
paid with a lag of one month. Assume that full material is issued to the production in the beginning
of the production process.
(B. Com. Honors, Delhi University, 2007 and slightly modified in 2010; BBS Honors, Delhi University,
2014)
Solution
Let us calculate various components of the cost—
𝑅𝑎𝑤 𝑚𝑎𝑡𝑒𝑟𝑖𝑎𝑙 𝑐𝑜𝑠𝑡 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 = 𝑆𝑎𝑙𝑒𝑠 × 50% ⇒ ₹50 × 50% ₹25
𝑊𝑎𝑔𝑒𝑠 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 = 𝑆𝑎𝑙𝑒𝑠 × 10% ⇒ ₹50 × 10% ₹5
𝑀𝑎𝑛𝑢𝑓. 𝑜𝑣𝑒𝑟ℎ𝑒𝑎𝑑𝑠 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 = 𝑆𝑎𝑙𝑒𝑠 × 16% ⇒ ₹50 × 16% ₹8
𝑆𝑒𝑙𝑙𝑖𝑛𝑔 𝑜𝑣𝑒𝑟ℎ𝑒𝑎𝑑𝑠 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 = 𝑆𝑎𝑙𝑒𝑠 × 4% ⇒ ₹50 × 4% ₹2
Total cost ₹40
Profit ₹10
Selling price ₹50
Statement showing estimation of working capital requirement
Particulars ₹
2𝑀
Raw material 69,000 × 25 × 2,87,500
12𝑀
5 8 1𝑀
Work-in-progress 69,000 × (25 + + ) × 1,81,125
2 2 12𝑀
3𝑀
Finished goods 69,000 × (25 + 5 + 8) × 6,55,500
12𝑀
3𝑀
Debtors 69,000 × (25 + 5 + 8 + 2) × 6,90,000
12𝑀
Cash or bank balance to be maintained in the business --
Example 11 (Illustration 9)
From the following information prepare an estimate of working capital requirements—
(i) Projected annual sales 52,000 units
(ii) Selling price ₹60 per unit
(iii) Raw material cost 40% of selling price
(iv) Direct labor cost 30% of selling price
(v) Overheads 20% of selling price
Raw materials remain in stock on an average for 3 weeks. Goods remain in production process for 4
weeks on an average. 5 weeks are allowed to debtors to pay while firm gets 3 weeks credit from
suppliers.
Finished goods remain in stock for one month. Lag in payment of wages and overheads expenses is
two weeks. 50% sales are on cash basis. Assume that goods in process are 100% complete with
respect to materials but only 50% in conversion costs.
(B. Com. Honors, Delhi University, 2006, 2017)
Solution
1. In this question weeks and months both are given. In case weeks are given then divide by 52
weeks and multiply by weeks and in case months are given then divide by months and
multiply by months.
2. Conversion cost is (𝐹𝑎𝑐𝑡𝑜𝑟𝑦 𝑐𝑜𝑠𝑡 − 𝐶𝑜𝑠𝑡 𝑜𝑓 𝑟𝑎𝑤 𝑚𝑎𝑡𝑒𝑟𝑖𝑎𝑙) or (𝐷𝑖𝑟𝑒𝑐𝑡 𝑤𝑔𝑎𝑒𝑠 +
𝐷𝑖𝑟𝑒𝑐𝑡 𝑒𝑥𝑝𝑒𝑛𝑠𝑒𝑠 + 𝐹𝑎𝑐𝑡𝑜𝑟𝑦/𝑀𝑎𝑛𝑢𝑓𝑎𝑐𝑡𝑟𝑢𝑖𝑛𝑔 𝑜𝑣𝑒𝑟ℎ𝑒𝑎𝑑𝑠).
3. Various components of cost are—
𝑅𝑎𝑤 𝑚𝑎𝑡𝑒𝑟𝑖𝑎𝑙 𝑐𝑜𝑠𝑡 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 = 𝑆𝑎𝑙𝑒𝑠 × 40% ⇒ 𝑅𝑠. 60 × 40% ₹24
𝑊𝑎𝑔𝑒𝑠 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 = 𝑆𝑎𝑙𝑒𝑠 × 30% ⇒ 𝑅𝑠. 60 × 30% ₹18
𝑂𝑣𝑒𝑟ℎ𝑒𝑎𝑑𝑠 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 = 𝑆𝑎𝑙𝑒𝑠 × 20% ⇒ 𝑅𝑠. 60 × 20% ₹12
Total ₹54
Profit ₹6
Selling price ₹50
Statement showing estimation of working capital requirement
Particulars ₹
3𝑊
Raw material 52,000 × 24 × 72,000
52𝑊
18 12 4𝑊
Work-in-progress 52,000 × (24 + + )× 1,56,000
2 2 52𝑊
1𝑀
Finished goods 52,000 × (24 + 18 + 12) × 2,34,000
12𝑀
5𝑊
Debtors 52,000 × (24 + 18 + 12) × 50% × 1,35,000
52𝑊
Cash or bank balance to be maintained in the business --
Solution
Statement showing estimation of working capital requirement
Particulars ₹
4𝑊
Raw material 1,04,000 × 80 × 6,40,000
52𝑊
30 (70 − 10) 2𝑊
Work-in-progress 1,04,000 × (80 + + )× 5,00,000
2 2 52𝑊
4𝑊
Finished goods 1,04,000 × (80 + 30 + (70 − 10)) × 13,60,000
52𝑊
8𝑊
Debtors 1,04,000 × (80 + 30 + (70 − 10)) × 27,20,000
52𝑊
Cash or bank balance to be maintained in the business 20,000
4𝑊
Creditors 1,04,000 × 80 × 6,40,000
52𝑊
1.5𝑊
Wages 1,04,000 × 30 × 90,000
52𝑊
Total current liabilities (B) 7,30,000
Solution
Statement showing estimation of working capital requirement
Particulars ₹
1𝑀
Raw material 54,000 × 50 × 2,25,000
12𝑀
20 (40 − 10) 0.5𝑀
Work-in-progress 54,000 × (50 + + )× 1,68,750
2 2 12𝑀
1𝑀
Finished goods 54,000 × (50 + 20 + (40 − 10)) × 4,50,000
12𝑀
1𝑀
Debtors 54,000 × (50 + 20 + (40 − 10)) × 50% × 3,37,500
12𝑀
Cash or bank balance to be maintained in the business 1,00,000
Solution
Statement showing estimation of working capital requirement
Particulars ₹
2𝑀
Raw material 12,00,000 × 2,00,000
12𝑀
1.5𝑀
Finished goods 33,60,000 × (𝑆𝑒𝑒 𝑛𝑜𝑡𝑒 1) 4,20,000
12𝑀
3𝑀
Debtors 40,40,000 × (𝑆𝑒𝑒 𝑛𝑜𝑡𝑒 2) 10,10,000
12𝑀
Sales promotion 6𝑀
2,00,000 × 1,00,000
expenses 12𝑀
1𝑀
Creditors 12,00,000 × 1,00,000
12𝑀
0.5𝑀
Wages 9,60,000 × 40,000
12𝑀
Manufacturing 1𝑀
(13,00,000 − 1,00,000 (𝐷𝑒𝑝. )) × 1,00,000
expenses 12𝑀
Administrative 1𝑀
4,80,000 × 40,000
expenses 12𝑀
Example 15
Following information is extracted from last year’s annual accounts of XYZ Limited—
₹
Sales at 3 months credit 40,00,000
Raw material consumed 12,00,000
Wages paid (15 days in arrears) 9,60,000
Manufacturing expenses (1 month in arrears) 13,00,000
Administrative expenses (1 month in arrears) 4,80,000
Sales promotion expenses (Paid half yearly in advance) 2,00,000
The company enjoys one month’s credit from the suppliers of raw materials and maintains two
months’ stock of raw materials and one and half months’ finished goods. Manufacturing expenses
include depreciation of ₹1,00,000. Cash balance of ₹1,00,000 is maintained as a precautionary
measure. Due to increased scale of operations management is expecting an increase of 20% in
working capital requirement for the current year.
Also, the XYZ Limited have approached their bankers for their working capital requirement, who
have agreed to sanction the same by retaining the margins as under—
Raw material 20%
Finished goods 30%
Debtors 10%
Find out net working capital needed for the current year’s operations and the working capital limits
likely to be approved by bankers.
Solution
Statement showing estimation of working capital requirement
Particulars ₹
2𝑀
Raw material 12,00,000 × 2,00,000
12𝑀
1.5𝑀
Finished goods 33,60,000 × (𝑆𝑒𝑒 𝑛𝑜𝑡𝑒 1) 4,20,000
12𝑀
3𝑀
Debtors 40,40,000 × (𝑆𝑒𝑒 𝑛𝑜𝑡𝑒 2) 10,10,000
12𝑀
Sales promotion 6𝑀
2,00,000 × 1,00,000
expenses 12𝑀
1𝑀
Creditors 12,00,000 × 1,00,000
12𝑀
0.5𝑀
Wages 9,60,000 × 40,000
12𝑀
Manufacturing 1𝑀
12,00,000 × 1,00,000
expenses 12𝑀
Administrative 1𝑀
4,80,000 × 40,000
expenses 12𝑀
Example 16
Raju Brothers Private Limited sells goods at a gross profit of 25%. Depreciation is taken into
account as a part of the cost of production. The following are the annual figures given to you—
₹
Sales (two months’ credit) 18,00,000
Material consumed (one month credit) 4,50,000
Wages (one month lag in payment) 3,60,000
Cash manufacturing expenses (one month lag in payment) 4,80,000
Administrative expenses (one month lag in payment) 1,20,000
Sales promotion expenses (paid quarterly in advance) 60,000
Income tax payable in 4 installments of which one lies in next year 1,50,000
The company keeps one month’s stock each of raw material and finished goods. It also keeps
₹1,00,000 in cash. You are required to estimate the working capital requirements of the company
on cash cost basis assuming 15% safety margin. Ignore work-in-progress.
Solution
Statement showing estimation of working capital requirement
Particulars ₹
1𝑀
Raw material 4,50,000 × 37,500
12𝑀
1𝑀
Finished goods 12,90,000 × (𝑆𝑒𝑒 𝑛𝑜𝑡𝑒 2) 1,07,500
12𝑀
2𝑀
Debtors 14,70,000 × (𝑆𝑒𝑒 𝑛𝑜𝑡𝑒 3) 2,45,000
12𝑀
Creditors 37,500
1𝑀
Wages 3,60,000 × 30,000
12𝑀
Cash manufacturing 1𝑀
4,80,000 × 40,000
expenses 12𝑀
Administrative 1𝑀
1,20,000 × 10,000
expenses 12𝑀
Solution
Statement showing estimation of working capital requirement
Particulars ₹
1𝑀
Raw material 90,000 × 7,500
12𝑀
1𝑀
Finished goods 2,58,000 × (𝑆𝑒𝑒 𝑛𝑜𝑡𝑒 2) 21,500
12𝑀
2𝑀
Debtors 2,94,000 × (𝑆𝑒𝑒 𝑛𝑜𝑡𝑒 3) 49,000
12𝑀
Sales promotion 3𝑀
12,000 × 3,000
expenses 12𝑀
2𝑀
Creditors 90,000 × 15,000
12𝑀
1𝑀
Wages 72,000 × 6,000
12𝑀
Cash manufacturing
Given 8,000
expenses
Administrative 1𝑀
24,000 × 2,000
expenses 12𝑀
Solution
Statement showing estimation of working capital requirement
Particulars ₹
1𝑀
Raw material 22,50,000 × 1,87,500
12𝑀
2𝑀
Finished goods 64,50,000 × (𝑆𝑒𝑒 𝑛𝑜𝑡𝑒 2) 10,75,000
12𝑀
3𝑀
Debtors 82,50,000 × (𝑆𝑒𝑒 𝑛𝑜𝑡𝑒 3) 20,62,500
12𝑀
Sales promotion 3𝑀
12,00,000 × 3,00,000
expenses 12𝑀
1.5𝑀
Creditors 22,50,000 × 2,81,250
12𝑀
1𝑀
Wages 18,00,000 × 1,50,000
12𝑀
Manufacturing 1𝑀
24,00,000 × 2,00,000
expenses 12𝑀
Administrative 1𝑀
6,00,000 × 50,000
expenses 12𝑀
Solution
Statement showing estimation of working capital requirement
Particulars ₹
1𝑀
Raw material 6,75,000 × 56,250
12𝑀
1𝑀
Finished goods 19,35,000 × (𝑆𝑒𝑒 𝑛𝑜𝑡𝑒 2) 1,61,250
12𝑀
2𝑀
Debtors 22,05,000 × (𝑆𝑒𝑒 𝑛𝑜𝑡𝑒 3) 3,67,500
12𝑀
Sales promotion 3𝑀
90,000 × 22,500
expenses 12𝑀
Cash or bank balance to be maintained in the business
1,05,000
(𝑠𝑒𝑒 𝑛𝑜𝑡𝑒 4)
Solution
Statement showing estimation of working capital requirement
Chapter 11, Working Capital Management: 28
Particulars ₹
1𝑀
Raw material 6,75,000 × 56,250
12𝑀
1𝑀
Finished goods 19,35,000 × (𝑆𝑒𝑒 𝑛𝑜𝑡𝑒 2) 1,61,250
12𝑀
2𝑀
Debtors 22,05,000 × (𝑆𝑒𝑒 𝑛𝑜𝑡𝑒 3) 3,67,500
12𝑀
2𝑀
Creditors 6,75,000 × 1,12,500
12𝑀
0.5𝑀
Wages 5,40,000 × 22,500
12𝑀
Manufacturing 1𝑀
7,20,000 × 60,000
expenses 12𝑀
1𝑀
Selling expenses 90,000 × 7,500
12𝑀
Administrative 1𝑀
1,80,000 × 15,000
expenses 12𝑀
Total current liabilities (B) 2,17,500
Example 21
Estimated current assets ₹25,000; estimated current liabilities ₹8,000; Contingency/margin
safety is 15% of total working capital. Calculate total working capital requirement.
Solution
₹
Chapter 11, Working Capital Management: 29
Estimated current assets 25,000
Less: Estimated current liabilities -8,000
Net working capital 17,000
Add: Contingency/safety margin (See note) 3,000
Total working capital requirement 20,000
Note:
𝑁𝑒𝑡 𝑤𝑜𝑟𝑘𝑖𝑛𝑔 𝑐𝑎𝑝𝑖𝑡𝑎𝑙
𝐶𝑜𝑛𝑡𝑖𝑛𝑔𝑒𝑛𝑐𝑦 𝑜𝑟 𝑠𝑎𝑓𝑒𝑡𝑦 𝑚𝑎𝑟𝑔𝑖𝑛 = × % 𝑜𝑓 𝑠𝑎𝑓𝑒𝑡𝑦 𝑚𝑎𝑟𝑔𝑖𝑛
100 − 𝑃𝑒𝑟𝑐𝑒𝑛𝑡𝑎𝑔𝑒 𝑜𝑓 𝑠𝑎𝑓𝑒𝑡𝑦 𝑚𝑎𝑟𝑔𝑖𝑛
17,000
⇒ × 15 ⇒ ₹3,000
100 − 15
Verification: 𝑆𝑎𝑓𝑒𝑡𝑦 𝑚𝑎𝑟𝑔𝑖𝑛 = 𝑇𝑜𝑡𝑎𝑙 𝑤𝑜𝑟𝑘𝑖𝑛𝑔 𝑐𝑎𝑝𝑖𝑡𝑎𝑙 × 15% ⇒ ₹20,000 × 15% ⇒ ₹3,000
Example 22
The following information is extracted from last year’s annual accounts of ABC Limited—
Details Amount per unit (₹)
Raw material cost 100.00
Direct labor cost 37.50
Overhead cost 75.00
Total cost 212.50
Profit 37.50
Selling price 250.00
The company keeps raw material in stock on an average for four weeks, work-in-progress in stock
on an average for one week and finished goods in stock on an average for two weeks. The credit
period allowed by suppliers is three weeks and company allows four weeks credit to its debtors.
The lag in payment of wages is one week and lag in payment of overhead expenses is two weeks.
The company sells one-fifth of its output against the cash and maintains cash in hand and at bank
balance put together at ₹37,500.
You are required to prepare an estimate of working capital needed to finance an activity level of
1,30,000 units of production. Assume that production is carried on evenly throughout the year and
overheads and wages accrue similarly. Work-in-progress stock is 80% complete in all respects.
(B. Com. Honors, Delhi University, 2018)
Solution
Statement showing estimation of working capital requirement
Particulars ₹
4𝑊
Raw material 1,30,000 × 100 × 10,00,000
52𝑊
80 1𝑊
Work-in-progress 1,30,000 × (100 + 37.50 + 75) × × 4,25,000
100 52𝑊
2𝑊
Finished goods 1,30,000 × (100 + 37.50 + 75) × 10,62,500
52𝑊
4 4𝑊
Debtors 1,30,000 × (100 + 37.50 + 75) × × 17,00,000
5 52𝑊
Cash or bank balance to be maintained in the business 37,500
Example 23
A company provides you the following facts. Estimate the net working capital required for the
project—
Estimated cost per unit of production
Amount per unit (₹)
Raw material 80
Direct labor 30
Overheads (Including depreciation of ₹10 per unit) 70
Total 180
Additional information—
(i) Selling price: ₹200 per unit
(ii) Level of activity: 1,56,000 units of production per annum
(iii) Raw material in stock: Average 4 weeks
(iv) Work-in-progress (Assume 50% completion state in respect of conversion cost and
100% completion in respect of material): Average 2 weeks
(v) Finished goods in stock: Average 4 weeks
(vi) Credit allowed by suppliers: Average 4 weeks
(vii) Credit allowed to debtors: Average 8 weeks
(viii) Lag in payment of wages: Average 1.5 weeks
(ix) Cash at bank is expected to be: ₹25,000
You may assume that production is carried on evenly during the year. All sales are on credit basis.
Add 10% to your computed figure to allow for contingencies.
(B. Com. Honors, Delhi University, 2011)
Solution
Statement showing estimation of working capital requirement
Particulars ₹
4𝑊
Raw material 1,56,000 × 80 × 9,60,000
52𝑊
30 (70 − 10) 2𝑊
Work-in-progress 1,56,000 × (80 + + )× 7,50,000
2 2 52𝑊
4𝑊
Finished goods 1,56,000 × (80 + 30 + (70 − 10)) × 20,40,000
52𝑊
8𝑊
Debtors 1,56,000 × (80 + 30 + (70 − 10)) × 40,80,000
52𝑊
Cash or bank balance to be maintained in the business 25,000
Solution
Statement showing estimation of working capital requirement
Particulars ₹
2𝑀
Raw material 1,20,000 × 100 × 20,00,000
12𝑀
30 (25 − 5) 1𝑀
Work-in-progress 1,20,000 × (100 + + )× 12,50,000
2 2 12𝑀
0.5𝑀
Finished goods 1,20,000 × (100 + 30 + (25 − 5)) × 7,50,000
12𝑀
1𝑀
Debtors 1,20,000 × (100 + 30 + (25 − 5)) × 15,00,000
12𝑀
Cash or bank balance to be maintained in the business
2,89,474
(𝑠𝑒𝑒 𝑛𝑜𝑡𝑒)
Gross working capital/Total current assets 57,89,474
Note:
Cash at bank is expected to be 5% of the gross working capital and gross working means total
current assets. Current assets include bank balance also. Excluding bank balance, the total current
assets are ₹55,00,000 (𝑖. 𝑒. 20𝐿 + 12.50𝐿 + 7.50𝐿 + 15𝐿). If total current assets are 100% and bank
balance is 5% then remaining current assets are 95%. So, the bank balance would be—
𝐶𝑢𝑟𝑟𝑒𝑛𝑡 𝑎𝑠𝑠𝑒𝑡𝑠 𝑒𝑥𝑐𝑙𝑢𝑑𝑖𝑛𝑔 𝑏𝑎𝑛𝑎𝑘 𝑏𝑎𝑙𝑎𝑛𝑐𝑒 55,00,000
× 100 ⇒ × 5 ⇒ ₹2,89,474
100% − 5% = 95% 95
You can also see that the bank balance of ₹6,00,000 𝑖𝑠 10% 𝑜𝑓 𝑡ℎ𝑒 𝑡𝑜𝑡𝑎𝑙 𝑐𝑢𝑟𝑟𝑒𝑛𝑡 𝑎𝑠𝑠𝑒𝑡𝑠.
Example 25
XYZ Limited supplied the following information—
Sales and production for the year 69,000 units
Finished goods in store 3 months
Raw material in store 2 months consumption
Production process 1 month
Credit allowed by creditors 2 months
Selling price per unit ₹50
Raw material cost 50% of selling price
Direct wages 10% of selling price
Overheads 20% of selling price
20% sales are on cash basis and credit sales are allowed to its customers for 1 month. Overheads
include ₹5 as depreciation. There is a regular production and sales cycle and wages and overheads
Chapter 11, Working Capital Management: 32
accrue evenly. Wages are paid in the next month of accrual and overheads are paid 15 days in
arrears. Material is introduced in the beginning of the production cycle. You are required to find out
its working capital requirement on cash cost basis.
(B. Com. Honors, Delhi University, 2013)
Solution
Let us calculate various components of the cost—
𝑅𝑎𝑤 𝑚𝑎𝑡𝑒𝑟𝑖𝑎𝑙 𝑐𝑜𝑠𝑡 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 = 𝑆𝑎𝑙𝑒𝑠 × 50% ⇒ ₹50 × 50% ₹25
𝐷𝑖𝑟𝑒𝑐𝑡 𝑤𝑎𝑔𝑒𝑠 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 = 𝑆𝑎𝑙𝑒𝑠 × 10% ⇒ ₹50 × 10% ₹5
𝑂𝑣𝑒𝑟ℎ𝑒𝑎𝑑𝑠 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 = 𝑆𝑎𝑙𝑒𝑠 × 20% ⇒ ₹50 × 20% ₹10
Total ₹40
Profit ₹10
Selling price ₹50
Statement showing estimation of working capital requirement
Particulars ₹
2𝑀
Raw material 69,000 × 25 × 2,87,500
12𝑀
5 (10 − 5) 1𝑀
Work-in-progress 69,000 × (25 + + )× 1,72,500
2 2 12𝑀
3𝑀
Finished goods 69,000 × (25 + 5 + (10 − 5)) × 6,03,750
12𝑀
80 1𝑀
Debtors 69,000 × × (25 + 5 + (10 − 5)) × 1,61,000
100 12𝑀
Cash or bank balance to be maintained in the business --