Financial Analysis



Financial Analysis

DELL PLC

Dell provides a range of technology products, including mobility products, desktop personal computers, software and peripherals, servers and networking products, services, and storage. Co. sells its products and services directly to customers through sales representatives, telephone-based sales, and online at its www.dell.com website, as well as through a variety of indirect sales channels. Co.'s customers include corporate, government, healthcare, and education accounts, as well as small and medium businesses and individual consumers. Co. conducts its businesses through four reportable segments: Large Enterprise; Public; Small and Medium Business; and Consumer.

Financial Highlights (In USD as of 01/30/2009)

Total Revenue

61,101,000,000

EBITDA

4,186,000,000

Operating Income

3,190,000,000

Net Income

2,478,000,000

Total Assets

26,500,000,000

Current Assets

20,151,000,000

Total Liabilities

22,229,000,000

Current Liabilities

14,859,000,000

Long Term Debt

1,898,000,000

Stockholders' Equity

4,271,000,000

Profitability Ratios

1/30/2009

2/1/2008

2/2/2007

ROA % (Net)

9.19

11.11

10.63

ROE % (Net)

61.35

71.48

60.46

ROI % (Operating)

59.8

71.77

62.64

EBITDA Margin %

6.85

7.37

6.76

Calculated Tax Rate %

25.45

22.82

22.62

Revenue per Employee

776,538

695,022

636,218

Liquidity Indicators

1/30/2009

2/1/2008

2/2/2007

Quick Ratio

1

0.83

0.88

Current Ratio

1.36

1.07

1.12

Net Current Assets % TA

19.97

4.91

8.38

Debt Management

1/30/2009

2/1/2008

2/2/2007

LT Debt to Equity

0.44

0.09

0.13

Total Debt to Equity

0.47

0.15

0.17

Interest Coverage

34.3

76.44

68.22

Asset Management

1/30/2009

2/1/2008

2/2/2007

Total Asset Turnover

2.27

2.3

2.36

Receivables Turnover

8.67

8.86

9.92

Inventory Turnover

48.99

53.76

77.51

Accounts Payable Turnover

6.19

5.59

5.68

Accrued Expenses Turnover

35.37

26.14

25.66

Property Plant & Equip Turnover

24.78

24.15

26.09

Cash & Equivalents Turnover

7.6

7.08

6.94

Per Share

1/30/2009

2/1/2008

2/2/2007

Cash Flow per Share

0.96

1.78

1.76

Book Value per Share

2.2

1.86

1.99

1/30/2009

2/1/2008

Variance

10/30/2009

5/1/2009

Variance

Compound Annual Growth Rate

Item

USD

USD

USD

%

USD

USD

USD

%

3 Year

5 Year

Revenues

61,101,000,000

61,133,000,000

-32,000,000

-0.05

12,896,000,000

12,342,000,000

554,000,000

4.49

0.02

0.04

Direct Costs

50,144,000,000

49,462,000,000

682,000,000

1.38

10,663,000,000

10,174,000,000

489,000,000

4.81

0.02

0.05

Gross Profit

10,957,000,000

11,671,000,000

-714,000,000

-6.12

2,233,000,000

2,168,000,000

65,000,000

3

0.05

0.04

Taxation

846,000,000

880,000,000

-34,000,000

-3.86

177,000,000

122,000,000

55,000,000

45.08

0.04

-0.1

Net Income

2,478,000,000

2,947,000,000

-469,000,000

-15.91

337,000,000

290,000,000

47,000,000

16.21

-0.01

-0.04

EPS Continuing Basic

1.25

1.33

-0.08

-6.02

0.17

0.15

0.02

13.33

0.03

0.01

EPS Net Basic

1.25

1.33

-0.08

-6.02

0.17

0.15

0.02

13.33

0.03

0.01

EPS Continuing Diluted

1.25

1.31

-0.06

-4.58

0.17

0.15

0.02

13.33

0.03

0.01

EPS Net Diluted

1.25

1.31

-0.06

-4.58

0.17

0.15

0.02

13.33

0.03

0.01

1/30/2009

2/1/2008

Variance

10/30/2009

5/1/2009

Variance

Compound Annual Growth Rate

Item

USD

USD

USD

%

USD

USD

USD

%

3 Year

5 Year

Cash & Equivalents

8,352,000,000

7,764,000,000

588,000,000

7.57

12,795,000,000

9,691,000,000

3,104,000,000

32.03

-0.04

0.12

Receivables (ST)

6,443,000,000

7,693,000,000

-1,250,000,000

-16.25

7,597,000,000

6,053,000,000

1,544,000,000

25.51

0.02

0.08

Inventories

867,000,000

1,180,000,000

-313,000,000

-26.53

952,000,000

842,000,000

110,000,000

13.06

0.1

0.14

Current Assets

20,151,000,000

19,880,000,000

271,000,000

1.36

24,871,000,000

19,910,000,000

4,961,000,000

24.92

0

0.04

Long Term Investments

454,000,000

1,560,000,000

-1,106,000,000

-70.9

828,000,000

568,000,000

260,000,000

45.77

-0.4

-0.36

Net Property Plant & Equip

2,277,000,000

2,668,000,000

-391,000,000

-14.66

1,978,000,000

2,181,000,000

-203,000,000

-9.31

-0.02

0.06

Total Assets

26,500,000,000

27,561,000,000

-1,061,000,000

-3.85

31,025,000,000

26,189,000,000

4,836,000,000

18.47

0.01

0.03

Accounts Payable

8,309,000,000

11,492,000,000

-3,183,000,000

-27.7

9,947,000,000

7,844,000,000

2,103,000,000

26.81

-0.07

-0.01

Current Liabilities

14,859,000,000

18,526,000,000

-3,667,000,000

-19.79

16,861,000,000

14,141,000,000

2,720,000,000

19.23

-0.06

0.01

LT Debt & Leases

1,898,000,000

362,000,000

1,536,000,000

424.31

3,442,000,000

2,396,000,000

1,046,000,000

43.66

0.49

0.3

Total Liabilities

22,229,000,000

23,732,000,000

-1,503,000,000

-6.33

26,000,000,000

21,959,000,000

4,041,000,000

18.4

0.02

0.06

Preferred Share Capital

-

-

-

-

-

-

-

-

-

-

Common Share Capital

-

-

-

-

-

-

-

-

-

-

Total Equity

4,271,000,000

3,829,000,000

442,000,000

11.54

5,025,000,000

4,230,000,000

795,000,000

18.79

-0.01

-0.08

TESCO PLC

Tesco is engaged in operating food stores and associated activities in the UK, Republic of Ireland, Hungary, Poland, Czech Republic, Slovakia, Thailand, South Korea, Taiwan, Turkey, Malaysia, Japan and China. Co. offers branded and own label products. Co. offers the following store formats in the UK: Extra, very large stores including a range of non-food products; Superstores, large stores offering a full food range and many non-food products; Compact Superstores; Other stores, mainly selling food ranges and household goods; Metro, city-center stores serving the needs of a busy working population; and Express, petrol station court shops selling a range of everyday products.

Financial Highlights (In GBP as of 02/28/2009)

Total Revenue

54,327,000,000

EBITDA

3,506,000,000

Operating Income

2,970,000,000

Net Income

2,161,000,000

Total Assets

46,053,000,000

Current Assets

14,045,000,000

Total Liabilities

33,058,000,000

Current Liabilities

18,040,000,000

Long Term Debt

12,391,000,000

Stockholders' Equity

12,995,000,000

Profitability Ratios

2/28/2009

2/23/2008

2/24/2007

ROA % (Net)

5.58

7.75

8.04

ROE % (Net)

17.08

18.95

19.03

ROI % (Operating)

11.83

14.41

16.93

EBITDA Margin %

6.45

6.67

6.18

Calculated Tax Rate %

26.68

24.01

29.1

Liquidity Indicators

2/28/2009

2/23/2008

2/24/2007

Quick Ratio

0.28

0.28

0.26

Current Ratio

0.78

0.61

0.56

Net Current Assets % TA

-8.67

-13.14

-14.42

Debt Management

2/28/2009

2/23/2008

2/24/2007

LT Debt to Equity

0.95

0.5

0.39

Total Debt to Equity

1.27

0.68

0.54

Interest Coverage

6.44

9.94

343.07

Asset Management

2/28/2009

2/23/2008

2/24/2007

Total Asset Turnover

1.4

1.73

1.82

Receivables Turnover

40.78

43.55

43.65

Inventory Turnover

20.96

21.75

25.34

Accounts Payable Turnover

12.31

-

-

Property Plant & Equip Turnover

2.49

2.58

2.62

Cash & Equivalents Turnover

20.18

33.52

36.35

Per Share

2/28/2009

2/23/2008

2/24/2007

Cash Flow per Share

0.5

0.43

0.33

Book Value per Share

1.65

1.51

1.33

2/28/2009

2/23/2008

Variance

Compound Annual Growth Rate

Item

GBP

GBP

GBP

%

3 Year

5 Year

Revenues

54,327,000,000

47,298,000,000

7,029,000,000

14.86

-

-

-

-

0.08

0.1

Direct Costs

50,109,000,000

43,668,000,000

6,441,000,000

14.75

-

-

-

-

0.08

0.1

Gross Profit

4,218,000,000

3,630,000,000

588,000,000

16.2

-

-

-

-

0.06

0.1

Taxation

788,000,000

673,000,000

115,000,000

17.09

-

-

-

-

0.01

0.08

Net Income

2,161,000,000

2,124,000,000

37,000,000

1.74

-

-

-

-

0.04

0.1

EPS Net Basic

0.28

0.27

0.01

3.7

-

-

-

-

0.05

0.1

EPS Net Diluted

0.27

0.27

0

0

-

-

-

-

0.04

0.1

2/28/2009

2/23/2008

Variance

Compound Annual Growth Rate

Item

GBP

GBP

GBP

%

3 Year

5 Year

Cash & Equivalents

3,509,000,000

1,788,000,000

1,721,000,000

96.25

-

-

-

-

0.5

0.25

Receivables (ST)

1,522,000,000

1,099,000,000

423,000,000

38.49

-

-

-

-

0.12

0.15

Inventories

2,669,000,000

2,430,000,000

239,000,000

9.84

-

-

-

-

0.11

0.15

Current Assets

14,045,000,000

6,300,000,000

7,745,000,000

122.94

-

-

-

-

0.45

0.34

Long Term Investments

1,791,000,000

309,000,000

1,482,000,000

479.61

-

-

-

-

0.77

0.33

Net Property Plant & Equip

23,152,000,000

19,787,000,000

3,365,000,000

17.01

-

-

-

-

0.11

0.1

Total Assets

46,053,000,000

30,164,000,000

15,889,000,000

52.68

-

-

-

-

0.23

0.18

Accounts Payable

4,748,000,000

3,936,000,000

812,000,000

20.63

-

-

-

-

-

-

Current Liabilities

18,040,000,000

10,263,000,000

7,777,000,000

75.78

-

-

-

-

0.3

0.26

LT Debt & Leases

12,391,000,000

5,972,000,000

6,419,000,000

107.48

-

-

-

-

0.44

0.22

Total Liabilities

33,058,000,000

18,262,000,000

14,796,000,000

81.02

-

-

-

-

0.32

0.24

Common Share Capital

395,000,000

393,000,000

2,000,000

0.51

-

-

-

-

0

0

Total Equity

12,995,000,000

11,902,000,000

1,093,000,000

9.18

-

-

-

-

0.07

0.08

Bibliography

Dell Plc Annual Report 2009

Tesco PLC Annual Report ...