MS- 41 Working Capital Management

1. Discuss the various factors that you would take into consideration before assessing the working capital requirements.

2. You are required to prepare a Cash Budget of XYZ Ltd. for the months April, 2023 to July, 2023 (four months) from the details given below:

(a) Estimated sale during 2023 (Rs.)

Feb.

12,00,000

March

12,00,000

April

16,00,000

May

20,00,000

June

18,00,000

July

16,00,000

Aug.

14,00,000

b) On an average 20% of sales are cash sales. The credit sales are realized in the third month (January sales in March).

c) Purchases amount to 60% of sales.

d) Variable expenses (other than sales commission) constitute 10% of sales and there is a time lag of half a month in these payments.

e) Commission on sales is paid at 5% of sales value and payment is made in the third month.

f) Fixed expenses per month amount to Rs. 75,000 approximately.

g) Other items anticipated: Due

Interest payable on deposits Rs. 1,60,000 (April, 2023)

Sales of old assets Rs. 1,25,000 (May, 2023)

Payments of tax Rs. 80,000 (June, 2023)

Purchase of fixed assets Rs. 6,50,000 (July, 2023)

h) Opening cash balance Rs. 1,50,000

3. As a Finance Manager, which sources you would prefer to raise short term loans from the money market for meeting working capital needs of your business and why?

4. The Balance Sheet of Alpha Co. Ltd. is as given below.

Balance Sheet of Alpha Co. Ltd. as on 31 st March 2023

Assets Rs. lakhs Liabilities Rs. lakhs

Fixed assets 1,000 Equity shares of Rs.

10 each

400

Current assets:

Raw materials

Work-in-progress

Finished goods

Debtors

Cash at bank

200

300

150

200

110 960

Retained earnings

11% Debentures

Public deposits

Trade Creditors

Bills payable

400

600

200

160

200

Total 1,960 Total 1,960

You are required to calculate the amount of maximum permissible bank finance by all three methods for working capital as per Tandon Committee Norms. Assume the level of core current assets to be Rs. 60 lakhs. Calculate the current ratios as recommended by the committee, assuming that the bank has granted MPBF.

5. If you are finance manager of an MNC, what circumstances would you consider using Eurocurrency markets? Also explain why you have selected these markets instead of borrowing from domestic markets.