Review Of Ratio Analysis Of Tesco Plc

Decent Essays
10. Appendix

Appendix 1.
Table 1. Income Statement - Tesco plc Note: Figures taken from individual financial reports 2009–2014 and not from 5-year summaries or following year reports which provide adjusted figures. This is to ensure comparability with Sainsbury’s who do not provide adjusted figures in their financial reports.

Appendix 1.
Table 3. Statement of Financial Position – Tesco plc Note: Figures taken from individual financial reports 2009–2014 and not from 5-year summaries or following year reports which provide adjusted figures. This is to ensure comparability with Sainsbury’s who do not provide adjusted figures in their financial reports.

Appendix 1.
Table 4. Statement of Financial Position – J Sainsbury plc

Appendix 2.
Table 5. Financial Ratio Analysis - Tesco plc Note: Figures taken from individual financial reports 2009–2014 and not from
…show more content…
Year J Sainsbury plc TESCO plc
2014 (1009/23949) *100 = 4.21% (2631/63557) *100 = 4.14%
2013 (887/23303) *100 = 3.81% (2188/64826) *100 = 3.38%
2012 (874/22294) *100 = 3.92% (3985/64539) *100 = 6.17%
2011 (851/21102) *100 = 4.03% (3811/60931) *100 = 6.25%
2010 (710/19964) *100 = 3.56% (3457/56910) *100 = 6.07%

Gross Profit Margin Ratio (GPM)
GPM measures the percentage of Sales Revenue to Gross Profit for the period. GPM is a measure of the relationship of the costs associated with the goods which a company produces, and the income derived from the sale of those goods.
The ratio (usually expressed as a percentage) is calculated as follows:
GPM = (Gross Profit/Sales Revenue) *100.
Year J Sainsbury plc TESCO plc
2014 (1387/23949) *100 = 5.80% (4010/63557) *100 = 6.31%
2013 (1277/23303) *100 = 5.48% (4089/64826) *100 = 6.31%
2012 (1211/22294) *100 = 5.43% (5261/64539) *100 = 8.15%
2011 (1160/21102) *100 = 5.49% (5060/60931) *100 = 8.30%
2010 (1082/19964) *100 = 5.42% (4607/56910) *100 =

Related Documents

  • Improved Essays

    What is the trend in profit margin over the three years? Profit margin is increased from -3% base year to current year 2%. Which shows PNK has made applied significant polices and it is achieved through tight control but it is very low as compare to sales. It must be improved otherwise it can be in negative if any unusual expense occurs.…

    • 464 Words
    • 2 Pages
    Improved Essays
  • Improved Essays

    Wesfarmers Annual Report

    • 1648 Words
    • 7 Pages

    Susan C. McGowan. Matthew Tilling. 2012. Contemporary Issues in Accounting. John Wiley and Sons Australia, Limited.…

    • 1648 Words
    • 7 Pages
    Improved Essays
  • Great Essays

    Net profit margin 27.32 25.91 24.89 1.813 4.10 Return on equity 30.45 35.72 36.39 29.16 -2.61 Return on assets 17.87 19.34 16.69 9.71 -0.65 Return on Capital 22.33 23.85 22.08 16.06 2.08 Income/Employee 960 1,043 934 655 -55 Revenue Employee 5,342 6,186 15,727 4,782 5,594 Revenue turn over 1.00 1.15 1.02 0.83 0.56 Inventory turnover 61.80…

    • 595 Words
    • 3 Pages
    Great Essays
  • Improved Essays

    2. The trend I noticed was that all three ratios: profit margin, return on assets, and return on equity had a good increase from 2001 to 2002. However, between 2002 and 2003 all three ratios take an even bigger down turn. This suggests to me that the common factor of these ratios, net income, has taken a sudden impact. Meanwhile, the one ratio that has held steady and even grew in 2003 was total asset turnover.…

    • 503 Words
    • 3 Pages
    Improved Essays
  • Superior Essays

    Case Study: Kroger Company

    • 1178 Words
    • 5 Pages

    FACTORS: Statement “The Risk Assessment Standards establish standards and provide guidance concerning the auditor’s assessment of the risks of material misstatement in a financial statement audit and the design and performance of audit procedures whose nature, timing, and extent are responsive to the assessed risks.” (Risk Assessment, 2017). An auditor doing a risk assessment would look at materiality, results from previous audits both internal and externa, data sources, among others and the auditor must look at the level of risk as well. Reviewing the income statement for Kroger Company there was an increase in Sales/Revenue for the year 2017 over 2016:…

    • 1178 Words
    • 5 Pages
    Superior Essays
  • Improved Essays

    One way these calculations have been developed and analyzed is through the use of ratios. Financial ratios produce a numerical value that can then be compared to other businesses or even to industry averages. The results following the financial statements for the Moserk Company produces interesting outcomes. When compared to the industry averages, there were a few that proved…

    • 709 Words
    • 3 Pages
    Improved Essays
  • Decent Essays

    Case Study: Selig Company

    • 208 Words
    • 1 Pages

    To: Chief Accountant Selig Company Memo on accounting treatment to be accorded Investment in Spoor Corporation: Selig Company should follow the equity method of accounting for its investment in Spoor Corporation because Selig Company is presumed to be able to exercise significant influence over the operating and financial policies of Spoor Corporation due to the size of its investment (40%). In 2012, Selig Company should report its interest in Spoor Corporation’s outstanding capital stock as a long-term investment. Following the equity method of accounting, Selig Company should record the cash purchase of 40 % of Spoor Corporation at acquisition cost. 40% of Spoor Corporation’s total net income from July 1, 2012, to December 31, 2012,…

    • 208 Words
    • 1 Pages
    Decent Essays
  • Decent Essays

    During the 2014 financial year, Gross transaction value was £2.8bn; revenue was £2.3bn; underlying profit before tax was £110.3m; basic earnings per share was…

    • 146 Words
    • 1 Pages
    Decent Essays
  • Decent Essays

    I will have to take a closer look. For some reason, I never thought to analyze it by using financial statements; that would have been a lot easier than making an excel sheet for all the different calculations. Seems like my estimate was a bit high, but I would have been able to draw more conclusions if they provided all that information.…

    • 62 Words
    • 1 Pages
    Decent Essays
  • Great Essays

    The below figure illustrate Tesco stores and revenue per…

    • 1345 Words
    • 6 Pages
    Great Essays
  • Improved Essays

    With this accounting equation, it is presented to give you an idea of a double entry accounting. And when a company borrows from the bank, a company 's cash account can increase and its liability account loans payable will increase. If the company pays for advertisement their cash flow will decrease but the account advertisements expenses can increase. Connections between an income statement and Balance sheet Each of the financial statements is on separate sheets for the annual financial report, here is a quick explanation how they working from the top to the bottom.…

    • 1042 Words
    • 5 Pages
    Improved Essays
  • Superior Essays

    In this report I will clarify about two contrasted businesses that are different in their ownership, Liability, expenditure, scale, the sector they are operating, scope of activities and size. The two businesses that I am researching about are Tesco and Nike which I thought they are really contrasting to each other. Nike is the world's largest supplier and manufacturer of athletic shoes, apparel and other sports equipment whereas Tesco is a British multinational grocery and general merchandise retailer with headquarters in UK. It also operates in 17 different countries which in USA have known as (Fresh and easy).…

    • 1437 Words
    • 6 Pages
    Superior Essays
  • Improved Essays

    A detailed financial analysis of Thomas Cook Group Analysis of Financial Statements Financial Analysis Lecturer: Student Number: Word count: Table of contents Introduction - About Thomas Cook Group PLC 5 Competitor’s comparison with TCG PLC with the help of Ratio Analysis 6 Liquidity Ratios 6 1) Current Ratio 6 2) Quick Ratio: 8 Leverage Ratios 9 1) Debt Equity ratio: 9 2) Debt Ratio: 11 3) Equity Ratio: 12 Profitability Ratios 14 1) Gross Profit Ratio 14 2) Net Profit Ratio: 15 3) Return on Assets (ROA): 16 4) Return on Equity (ROE): 17 Activity Ratios 19 1) Assets Turnover Ratio: 19 2) Trade Receivable Period 21 3) Trade payable Period 22 An Initiative the Company Will Take to Improve the Position…

    • 1544 Words
    • 7 Pages
    Improved Essays
  • Improved Essays

    Executive summary With the change in economic environment, technology is also changing. In the recent few years, the number of smart phone users has increased rapidly. The Smartphone has created a different image in the minds of people and became a part of their life. The Smartphone is not only the mode of communication, but also best medium of entertainment. Its different qualities and features have made it popular worldwide.…

    • 3878 Words
    • 16 Pages
    Improved Essays
  • Improved Essays

    Unilever is a multinational fast moving consumer goods (FMCG) company. It is a British-Dutch company which operates in four main categories; Health and personal care (HPC), Refreshments, Food and Home Care. It is the world’s third largest FMCG company operating in several companies. Unilever is the largest producer of food spreads eg. margarine and it’s products are available in around 190 countries.…

    • 1494 Words
    • 6 Pages
    Improved Essays