Working Capital requirements 

1. From the following information find out the working capital requirements of P Ltd 

Projected annual sales Rs.650000 

%of N.P to Cost of Sales 25% 

Average credit allowed to debtors _10weeks 

Average credit allowed to creditors-4weeks 

Average Stock carrying (in terms of Sales requirements)-8weeks 

Add 20% to allow Contingencies

Solution:

Forecasting Working Capital Requirements:

Projected Annual Sales - Rs. 65,00,000

- Projected sales per week - 65,00,000/52 = Rs. 1,25,000

Projected Cost per week : 

Projected sales per week - Net profit

Net Profit: 25% on Cost or 20% on sales = 125000*20/100 = Rs. 25,000.

Therefore, Projected Cost per week = Projected sales per week  - Net Profit

125000 - 25000 = Rs. 1,00,000.

WORKING CAPITAL REQUIREMENT FORECAST STATEMENT:

 

 

Rs. (Inner cl)

Rs. (Outer cl)

Current Assets:

 

 

 

Stock ( 8 weeks):

1,00,000 X 8 =

 

8,00,000

Debtors (10 weeks)

1,00,000 X 10 =

10,00,000

 

+ Add Profit @ 25% on cost

10,00,000 X 25%

2,50,000

 

12,50,000

 CURRENT ASSETS

 

A

20,50,000 (A)

Less : Current Liabilities:

 

 

 

Creditors (4 weeks)

1,00,000 X 4

B

4,00,000 (B)

 

 

Working Capital

(A – B)

16,50,000

Add: 20% for contingencies

16,50,000 X 20%

 

3,30,000

TOTAL REQUIREMENT OF WC

 

 

19,80,000