Skip to main content

How to calculate Working Capital Cycle or Cash Conversion Cycle and Operating Cycle?

Example 1: Find out the working capital cycle or cash conversion cycle and operating cycle with the help of following information:
Cost of goods sold at Rs. 2, 60,000 and opening stock of raw material is Rs. 10, 000. Company XYZ sale 40% goods on credit and the total sales is Rs. 6, 70,000. The opening and closing balance of finished goods are Rs. 40, 000 and Rs. 20, 000 respectively. Company takes 6 days to convert work in progress into finished goods. The average debtors is Rs. 45, 000 and the closing balance of accounts payable is Rs. 38, 000. The credit purchase is Rs. 2, 90,000.

Solution: average raw material = (10, 000+0)/2 
= Rs. 5, 000
 Raw material holding period = 365/cost of goods sold/average raw material
= 365/2, 60,000/5, 000 = 365/ 52
= 7 days
Average finished goods = opening finished goods +closing finished goods)/2
=(40, 000+20, 000)/2 
= 30, 000
Finished goods holding period = 365/2, 60,000/30, 000
365/8.66
= 42 days
Credit sales = 0.40*6, 70,000 = Rs. 2, 68,000
Accounts Receivable period= 365/2, 68,000/45, 000
= 365/5.95
= 61 days
Average creditors = (opening creditors + closing creditors)/2
= (0+38, 000)/2
= 19, 000
Accounts payable period = 365/credit purchase/average creditors
= 365/2, 90,000/19, 000
= 365/15.26
= 24 days

Working capital cycle or cash conversion cycle: raw material holding period + work in progress holding period + finished goods holding period + accounts receivable period - accounts payable
= 7 + 6 + 42 + 61 -24
= 92 days

Company XYZ takes 92 days to convert its raw material into cash.

Example 2: Find out the operating cycle of Company A and B and compare with cash conversion cycle with the help of given information:

Particulars
Company A’s Ratio
Company B’s Ratio
Inventory turnover ratio
8:1
17:4
Debtors turnover ratio
10:3
6:1
Creditors turnover ratio
9:2
14:3
 Inventory includes raw material,work in progress and finished goods.

Solution: Inventory holding period = 365 / inventory turnover ratio
= 365 / 8
= 46 days
Accounts Receivable period = 365 / debtors turnover ratio
= 365 / 3.33
=110 days
Accounts payable period = 365 / creditors turnover ratio
= 365 / 4.5
= 81 days
Operating cycle = Inventory holding period + Accounts receivable period
= 46 + 110
= 156 days

Company A takes 156 days to convert its inventory into credit sales to debtors.

Cash conversion cycle of company A = Operating cycle – Accounts payable period
= 156 – 81
= 75 days
 Company A takes 75 days to convert operating cycle into cash.

Inventory holding period of company B = 365 / 4.25
= 86 days
Accounts receivable period = 365 / 6
= 61 days
Accounts payable period = 365 / 4.66
= 78 days
Operating Cycle = 86 + 61
= 147 days
Cash conversion cycle = 147 – 78
= 69 days

Company B takes 147 days to convert its material into debtors and 69 days to convert its operating cycle into cash through sales.
So, The cash conversion cycle of company B has taken 6 days less than company Y which proves that company B has better liquidity in comparison to company A.


Comments

  1. Justin DrewMarch 21, 2019 12:57 pm

    Thanks for ahsring this awesome tips with us. I hope this is very helpful to know more about the working capital in details and also for more advance information on it, then full information is here.
    https://shorttermcredits.com/working-capital.php

    ReplyDelete

Post a Comment

Popular posts from this blog

How to calculate Cost of Preference Share Capital?

Cost of Preference Share Capital:  An amount paid by company as dividend to preference shareholder is known as Cost of Preference Share Capital. Preference share is a small unit of a company’s capital which bears fixed rate of dividend and holder of it gets dividend when company earn profit. Dividend payable is not a tax deductible amount. So, there is no tax adjustments required for comparing with cost of debt. Formula for Cost of Preference Share: Irredeemable Preference Share Redeemable Preference Share K p  = Dp/NP K p  = D p +((RV-NP)/n )/ (RV+NP)/2 Where, K p  = Cost of Preference Share D p  = Dividend on preference share NP = Net proceeds from issue of preference share (Issue price – Flotation cost) RV = Redemption Value N = Period of preference share Example:  A company issues 20,000 irredeemable preference share at 8% whose face value is Rs.50 each at 4% discount. Find out the Cost of Preference Share Capital.
88 comments
Read more

What is the difference between Cheque book and Pass book?

 Cheque book is issued by bank in customers / account holder request. With the help of this book account holder can withdraw cash from his/her account. Bank does not charge any fee to issued cheque book to its customer. But afterward bank charges some amount for using bank facility like cheque book, Debit card etc.So, Automatic some definite amount deducted from customer bank account. Pass book is  also issued by bank to its customer. It helps to record all the bank related activity according to date that is withdrawal and deposit. It is recorded by bank but the book is kept by customer to know the current balance of  his /her account.  Point of difference Pass book Cheque book What is the meaning of pass book and cheque book? Passbook is a book in which all withdrawal and deposit against customer account is recorded.   Cheque book is a book of cheques which are used to withdrawal the money to bank account.
Post a Comment
Read more

How to calculate interest on Hire Purchase System?

Interest on hire purchase:  Interest is calculated on Cash value of goods not in instalment value which includes cash value of goods and interest amount. It is calculated on yearly, quarterly and yearly basis. Interest is not calculated on down payment which is paid at delivery of goods. Depreciation is also charged on the hire purchase goods at the end of financial year. The method applies for depreciation is based on the contract between the parties.   Example:  Company V purchased a machine of Rs.70, 000 and paid Rs.5, 000 as down payment. The interest charged @6% and 8% depreciation annually. The instalment value for each year is Rs. 10,000. Find out the interest amount for 5 years. Solution: Interest calculated on Rs. Interest Instalment Cash Value 65, 000 65, 000*0.06 = 3, 900 12, 500 8, 600 56, 400 56, 400*0.06 = 3, 384 12, 500 9, 116 47, 284 47, 284*0.06 = 2, 837 12, 500 9, 6
3 comments
Read more