Q.#1 Using Excel Format

The data below show a summary of three major international companies financial statements.

	Company
	A	B	C
Financial statements	GBPm	GBPm	GBPm
Income statements
Revenue	5268.00	4646.25	13411.88
Profit before interest and taxation (EBIT)	1012.80	880.00	1863.22
Net interest payable	(96.00)	(122.50)	(221.84)
Taxation	(223.20)	(260.00)	(683.22)
Minorities	(112.80)	(131.25)	(197.06)
Profit for the year	580.80	366.25	761.10
Balance sheets
Fixed assets	4352.40	5614.44	13779.60
Current asset investments, cash at bank and in hand	391.84	342.20	818.40
Other current assets	691.92	758.74	1960.80
Total assets	5436.16	6715.38	16558.80
Interest bearing debt (long term)	(746.48)	(1811.30)	(4448.40)
Other creditors and provisions (current)	(1516.52)	(1300.36)	(3729.60)
Total liabilities	(2263.00)	(3111.66)	(8178.00)
Net assets	3173.16	3603.72	8380.80
Shareholders' funds	2679.64	2724.62	7398.00
Equity minority interests	493.52	879.10	982.80
Capital employed	3173.16	3603.72	8380.80
Cash flow
Working capital movements	(65.72)	83.78	128.40
Net cash inflow from operating activities	1036.80	1218.75	2704.56

Required:

1. Complete the following table:

	Company
	A	B	C
Debt Management Analysis (solvency)
Debt ratio
Debt to Equity Ratio
Times-Interest-Earned Ratio
Liquidity Analysis
Current Ratio
Asset Management Analysis
Total Asset Turnover
Profitability Analysis
Return on Equity
Net Margin

2. Perform a comparison analysis between the three companies based on following ratios:
   1. Debt ratio
   2. Total Asset Turnover
   3. Net Margin

Explain your full conclusion for part b