the first two pictures are the financial statements, while the last picture is decomposition of ROE, can anyone explain to me in detail, how did we get those numbers? where did we get the net profit margin? where did we get the asset turnover? etc... (explain it once for a year), thank you
1 INCOME STATEMENT 2 Revenue 3 Cost of Sales 4 SG&A 5 Operating profit 6 Net non-recurring income or expense 7 Pre-Tax Profit Tesco Bank 8 Investment and interest income 9 Interest expense 10 Profit before taxes 11 Tax expense 12 Profit after taxes 13 Profit/loss to non-controlling interest 14 Net profit to ordinary shareholders 15 2016 54,905.0 (51,417) (1,734) 1,754.0 (450.0) 77.0 (59.0) (1,177.0) 145.0 (87.0) 58.0 14.0 72.0 2015 52,978.0 (49,227) (1,836) 1,915.0 (564.0) 161.0 8.0 (1,318.0) 202.0 2014 61,260.0 (58,639) (1,827) 794.0 (6,112.0) 194.0 77.0 (1,329.0) (6,376.0) 657.0 (5,719.0) 25.0 (5,694.0) 2013 62,554.0 (57,239) (1,657) 3,658.0 (456.0) 194.0 192.0 (1,329.0) 2,259.0 (347.0) 1,912.0 4.0 1,916.0 54.0 256.0 9.0 265.0 16 BALANCE SHEET 2016 2015 2014 2013 25,475.0 1,615.0 668.0 385.0 2,478.0 707.0 1,589.0 32,917.0 17 ASSETS 18 Non-current tangible assets 19 Non-current intangible assets 20 Minority equity investments 21 Other non-operating investments 22 Net investment in Tesco Bank 23 Deferred tax asset 24 Derivatives 25 Total non-current assets 26 27 Inventories 28 Trade receivables 29 Other current assets 30 Cash and cash equivalents 31 Total current assets 32 33 Assets held for sale Financial Statements 25,636.0 1,700.0 709.0 430.0 2,374.0 49.0 1,708.0 32,606.0 30,051.0 2,548.0 860.0 312.6 2,241.0 514.0 1,699.0 38,225.0 34,308.0 2,542.0 209.0 392.0 2,168.0 73.0 1,576.0 41,268.0 1,963.0 1,475.0 21.0 6,548.0 10,007.0 2,116.0 1,406.0 13.0 6,545.0 10,080.0 2,722.0 2,121.0 11.0 2,758.0 7,612.0 3,402.0 2,190.0 12.0 3,494.0 9,098.0 344.0 01 Condensed Statements 236.0 139.0 2,487.0 2 Traditional decomnorition 344.0 236.0 139.0 2,487.0 43,268.0 42,922.0 45,976.0 52,853.0 6,438.0 -24.0 8,626.0 -10.0 7,071.0 0.0 14,715.0 7.0 23,373.0 74.0 668.0 324.0 24,439.0 21,331.0 103.0 951.0 275.0 22,660.0 25,256.0 158.0 1,035.0 0.0 26,449.0 22,486.0 570.0 869.0 0.0 23,925.0 -2 3 Assets held for sale 4 55 Total assets 36 37 LIABILITIES AND SHAREHOLDERS' EQUITY 38 Shareholders' equity 39 Non-controlling interest in equity 30 11 Non-current debt 42 Deferred tax liability 43 Derivatives 44 Other non-current liabilities 45 Non-current liabilities 46 47 Trade payables 48 Other current liabilities 49 Current debt 50 Current liabilities 51 52 Liabilities Held For Sale 53 54 Total Liabilities and Shareholders' Equity 55 56 57 SEGMENT INFORMATION 58 U.K. and Ireland 59 Store space (sq. ft. millions) 60 Revenue ( billion) 61 Operating profit (E millions) 62 Net operating assets (E billion) 63 64 International 65 Store space (sq. ft. millions) 66 Revenue ( billion) 67 Operating profit (6 billion) 68 Net operating assets ( billion) 69 4,672.0 5,012.0 2,560.0 12,244.0 4,293.0 4,527.0 2,826.0 11,646.0 4,831.0 5,612.0 2,008.0 12,451.0 5,595.0 5,508.0 1,910.0 13,013.0 171.0 0.0 5.0 1,193.0 43,268.0 42,922.0 45,976.0 52,853.0 2016 2015 2014 2013 43.40 43.52 519.0 9.71 45.07 43.08 597.0 9.88 45.84 42.93 467.0 8.67 45.29 43.06 2,191.0 10.80 45.34 11.38 421.0 4.72 45.85 9.90 314.0 4.75 66.75 18.33 729.0 9.75 67.26 19.50 930.0 10.70 ROE (including non-recurring expense) 2016 0.9% 2015 3.1% 2014 -82.4% 2013 14.2% Return on equity 2014 -9.3% 1.33 -12.4% 6.63 -82.4% 2013 3.1% 1.18 3.6% 3.94 14.2% Traditional decomposition of ROE (including non-recurring expense) 3 Ratio 2016 2015 Net profit margin (ROS) 0.1% 0.5% 10 * Asset turnover 1.27 1.23 11 = Return on assets (ROA) 0.1% 0.6% 12 x Financial leverage 6.93 5.12 13 = Return on equity (ROE) 0.9% 3.1% 14 15 16 ROE (excluding non-recurring expense) 17 2016 2015 18 Return on equity 6.796 8.4% 19 20. Traditional decomposition of ROE (excluding non-recurring expense) 21 Ratio 2016 2015 22 Net profit margin (ROS) 0.8% 1.3% 23 * Asset turnover 1.27 1.23 24 = Return on assets (ROA) 1.0% 1.6% 25 * Financial leverage 6.93 5.12 26 Return on equity (ROE) 6.796 8.4% 27 2014 -13.0% 2013 16.996 2014 -1.5% 1.33 -2.0% 6.63 - 13.0% 2013 3.6% 1.18 4.3% 3.94 16.996