Company ratio analysis- case study of Tesco.

Authors Avatar by jingxi (student)


Table of Contents        

Profitability Ratios        

Liquidity Ratios        

Gearing Ratio        

Tesco-ROCE        

Sainsbury for ROCE        

Comparison between Tesco and Sainsbury        

Profitability Rations        

Liquidity Ratio        

Gearing Ratio        

Conclusion and Recommendation        

References        

Appendix        

Profitability Ratios        

Liquidity Ratios        

ROCE (Rate on the capital employed)        

Gearing Ratios        

Profitability Ratios

The below table shows the company of Tesco’s profitability rations between year ended 26th February, 2010 and year ended 27th February, 2011.

Let us put rations in the below table.

It can be seen from the table that in 2010, the turnover of Tesco was £56,910m, compared to 2011, it was £60,931m. In the first year of Tesco’s financial period, the company had a total of £41,57m expenses and a final profit of £2336.0m while in 2011 they had a total expense of £42,21m and a profit of £2671.0m. This meaning that they made a profit, as the total profit the company made was greater than their expenses, which also increased in the following year, 2011. It was observed that the more money they spent in the running of the company, the more profit they made at the end of the year.

It was found that from the estimated gross profit that, for every £1 of turnover the company made a profit. This can be seen as the gross profit for the year 2010, came to 8.10% while that of 2011 came up to 8.30%. The difference between the two years is 0.20%; hence, the difference is not much meaning that the company is being managed well and is in a stable financial state.

The net profit margin showed that for every £1 of turnover, the company made a profit. This is seen as, in the year 2010 the company had a net profit margin of 5.58%, while in year 2011, and the net profit margin was 5.80%. Therefore, the difference between the net profit margin for 2010 and 2011 was 0.22%. In conclusion, the company made a profit increase or 0.22% in 2011, from the previous year, hence it is performing well.

Liquidity Ratios

Below table shows the Tesco’ liquidity rations between 2010 and 2011

Join now!

(See the formulas of calculations in appendix)

It can be seen from the above table that Tesco’s current ratio is greater than 1(both year 2010 and 2011), indicating that the company has a healthy financial condition, which means the company has the ability to pay its bills. Comparing two years in 2010 and in 2011, the current liquidity ratio for Tesco decreased a little in 2011, which was 2.31:1.

Gearing Ratio

Table below shows the gearing ratio of Tesco

The liability represents more than 50% of capital employed (14,596*100%/2616.0 = 56%), ...

This is a preview of the whole essay