Financial Mgmt Problem

1754 views 2 replies
Hi,
Can anyone hlep me with this problem in Financial Mgmt.

XYZ Ltd has a current ratio of 1.75 accompanied with a liquid ratio of 1.25. It works on a 20% gross margin and has affected sales of Rs.15 lakhs in the year ending March 2004. Other details on closing day are as follows
Stock Turnover Ratio (Closing st)           6 times
Debt Collection period                          2 months
Reserve to Capital Ratio                       0.6
Fixed asset turnover ratio
(on cost of goods sold)                         1.2
Capital Gearing Ratio                            0.0625
Fixed Asset to Networth                         1.25
You are required to prepare the balance sheet as on 31st March 2004

Any help will be highly appreciated. Tks.
Pls also let me know which text I should follow for Fin Mgmt.

Tks again.
Lucy
Replies (2)
Seems you are in Pe2 . hence you can refer Khan and Jains Book which is good
As regards your solution:
I have Partly worked out your solution I am not giving complete solution because I am not sure after a certain point

Solution:

See The trick is Start from the figure which is given in this case sales is given
Hence we now proceed as follows

Sales 15 lakhs and GP ratio is 20%
This Cost of Goods sold is Rs 12 Lakhs (80%)

Stock Turnover Ratio:
Formula is Cost of Goods Sold/Avg Inventory
Since Closing Stock is specified in brackets
Modified Formula is
CGS/Cl Stock
Thus 6 times = 12lakhs/cl stock
Thus Closing Stock is 2 lakhs

Debtor Turnover ratio
Formula is
Net Credit Sales/Avg Debtors
Assume all Sales are on Credit
2 months =  15 Lakhs/Avg Debtors
Thus Debtors is 7.5 Lakhs

Fixed Asset Turnover Ratio
CGS/Avg Fixed Assets
1.2 = 12 Lakhs/FA

Thus Fixed Assets = 10 Lakhs

Fixed Assets To networth Ratio
 FA/Networth

1.25 = 10Lakhs/NetWorth

Net Worth = Rs 800000

Now Net Worth is Current Assets – Current Liabilities
              0.75       = 1.75 – 1.00
(Current Ratio is 1.75 this means Current Liabilities is 1.00)

I feel I am 100% right upto here.
Now i am not sure after this . I will work it out when I am free. Thanks for reading


Hi Skanka,

Tks. so much for at least working half out. I hope u will be able to complete it for me.

Tks. again. God bless.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
26 May 2026
CA / MBA (Finance) / CMA / M.Com (Finance)

Sri Aurobindo Gnostic Centre of Education

New Delhi

CA

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
22 May 2026
U.S. Financial Reporting & Consolidation Manager

Karia Overseas

Ahmedabad

CA

View Details
Company
12 June 2026
Accounts & Taxation Executive

Winshine Financial Services

Mumbai

CA Inter

View Details
Company
21 May 2026
Associate

PWC

Kolkata

CA

View Details
Company
10 June 2026
Senior Account Executive

JDS Advisory LLP

Ahmedabad

CA Inter

View Details
Company
24 May 2026
Accounts & Tax Executive

PARAS KHURANA AND CO

New Delhi

B.Com

View Details
Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details