The projected financial information of M/s Bansiwala is as given below : Projected Annual Sales: ₹ 6,50,000 Percentage of net profit on sales: 25% Average credit period allowed to debtors: 10 weeks Average credit period
CS Professional · Corporate Funding & Listings in Stock Exchanges · PYQS · December 2022
The projected financial information of M/s Bansiwala is as given below : Projected Annual Sales: ₹ 6,50,000 Percentage of net profit on sales: 25% Average credit period allowed to debtors: 10 weeks Average credit period allowed by creditors: 4 weeks Average stock holding in terms of sales requirement: 8 weeks On the basis of above information, calculate the following: (i) Current Ratio and (ii) Working Capital.
Answer & Explanation:
Calculation of Working capital Working Notes: Sales - Net Profit = Cost of goods sold ₹ 6,50,000 - 25% on ₹ 6,50,000 = ₹ 4,87,500 CURRENT ASSETS (CA) Debtors (10 weeks) at cost (₹ 4,87,500 x 10 weeks)/ 52 Weeks = ₹ 93,750 Stock (8 Weeks) (₹ 4,87,500 x 8 Weeks)/ 52 Weeks = ₹ 75,000 Total Current Assets = ₹ 1,68,750 CURRENT LIABILITIES (CL) Creditors (₹ 4,87,500 x 4 Weeks)/ 52 Weeks = ₹ 37,500 (i) Current Ratio: CA/CL - (₹ 1,68,750 / ₹ 37,500) = 4.5:1 (ii) Working Capital (CA-CL): (₹ 1,68,750 - ₹ 37,500) = ₹ 1,31,250 **Some students may calculate the debtor at full value, in such case, the alternative solution would be as under: CURRENT ASSETS Debtors (10 weeks) at sales price (₹ 6,50,000 x 10 weeks)/52 Weeks = ₹ 1,25,000 Stock (8 Weeks) (₹ 4,87,500 x 8 Weeks)/ 52 Weeks = ₹ 75,000 Total Current Assets = ₹ 2,00,000 CURRENT LIABILITIES Creditors (₹ 4,87,500 x 4 Weeks)/ 52 Weeks = ₹ 37,500 (i) Current Ratio (₹ 2,00,000 / ₹ 37,500) = 5.33:1 (ii) Working Capital (₹ 2,00,000 / ₹ 37,500) = ₹ 1,62,500
Topics: Working Capital Management
Related Questions in this Topic
- DAL Ltd is in urgent need of funds and hence decides to discount its invoices worth ₹2 crore which are due in the next 2...
- From the latest CMA data of Vancouver Ltd., the projected figures are as under: Sales: ₹ 10 crore Total current asset...
- Following is the extract from the Balance Sheet of M/s YBL Ltd. as on 31 March, 2022 : Current Liabilities Amount (...
- The following data pertains to XYZ Ltd: Projected Sales ₹20,00,000, Creditors ₹3,00,000, Bank Borrowings ₹3,30,000, Curr...
- You are required to compute Maximum Permissible Bank Borrowings (MPBB) under three methods of Tandon Committee Norms per...