1. Calculate the vertical analysis of the following data.

Income Statement

	2018	2019
Sales	$ 800,000	$950,000
Cost of Goods Sold	350,000	600,000
Gross Margin	450,000	350,000
Operating Expenses	250,000	280,000
Net Income	$200,000	$ 70,000

2. From the following Balance sheet of A Co. Ltd., you are required to prepare a Schedule of Changes in Working Capital

Liabilities	2011	2012	Assets	2011	2012
Share Capital	200000	210000	Cash at bank	105000	106000
Profit & loss A/c	20000	23000	Debtors	18000	28000
Creditors	5000	8000	Stock	20000	25000
Long term	-	10000	Plant & Machinery	35000	45000
Short Term Loan	15000	14000	Furniture	60000	60000
			Bills receivable	2000	1000
	240000	265000		240000	265000

3. The following is the Balance Sheet of a company as on 31st March:

Liabilities	Amount	Assets	Amount
Share Capital	800000	Machine	800000
Profit & loss	150000	Stock	4500000
General Reserve	50000	Debtors	200000
15% Debentures	700000	Cash in hand	300000
Creditors	200000	Land	200000
Total	1950,000		1950,000

Calculate

1. Current Assets Ratio
2. Quick Ratio
3. Inventory to Working capital
4. Debt to Equity Ratio

4. Ali, Rehman and Zara are partners sharing profits and losses in the ratio of 7:4:2. They admit Mariam into partnership and give him 1/6th share of profits. Find the new profit-sharing ratio

Note: Answers kindly in word or excel format for the 4 Questions