please provide in a excel sheet if possible

Q.3 From the following balance sheet you are required to calculate: i. Debt-equity ratio ii. Current ratio. [4 Marks] [4 Marks] [4 Marks] Net profit ratio Note: Formula, Significance, and conclusion to be written for each of the above sub questions. Also mention what all components have you included under a particular heading for calculating ratios. Balance sheet: Particulars As at 31.03.2019 As at 31.03.2018 (Rs in 000's) (Rs in 000's) 30,000 20.000 Equity and liabilities Equity share capital Preference share capital Reserves and surplus 20,000 15,000 540 720 15,000 20,000 15% Long term loans 10% Debentures 7,000 6,000 Trade payables 60 80 Cash credit facility 30 65 Total 72,630 61,865 Assets Land and Building 25,000 23.500 Machinery 16,175 11.355 20,000 18,000 Office equipment Goodwill 10,000 8,000 Other intangible assets 500 400 Long term investments 300 200 Capital Work in progress 150 100 Other non-current assets 250 150 Marketable securities 100 50 Trade receivables 80 70 Short term loans and advances 20 10 Cash and cash equivalents 15 Inventories 25 15 Other current assets Total 72,630 Rs in 000's 250 30 50 170 150 Other information: Particulars Sales Sales returns Gross profit Indirect incomes Indirect expenses 5 15 10 61,865 Rs in 000's 200 20 40 160 140 CO 6