Case AD vs T Excel answers 20240403-final

.xlsx

School

University Of Chicago *

*We aren’t endorsed by this school

Course

30130

Subject

Finance

Date

May 5, 2024

Type

xlsx

Pages

48

Uploaded by BaronElectron14141

Report
Fiscal year end 1/1/2017 12/31/2017 12/30/2018 12/29/2019 Fiscal year FY 2016 FY 2017 FY 2018 FY 2019 Page # in Annual Report p.111 p.123 p.89 p.120 # of pages in Annual Report 251 285 241 219 49,695 € 62,890 € 62,791 € 66,260 Cost of sales -36,317 -46,121 -45,839 -48,200 Gross profit 13,378 16,769 16,952 18,060 Other income 0 0 0 0 Selling expenses -9,876 -12,245 -12,236 -13,021 General and administrative expenses -1,918 -2,299 -2,321 -2,377 Operating income 1,584 2,225 2,395 2,662 Interest income 15 32 70 65 Interest expense -273 -294 -310 -175 Net interest expense on defined benefit pension plans -18 -22 -19 -18 Interest accretion to lease liability 0 0 0 -366 Other financial income (expense) -265 -13 13 -34 Net financial expenses -541 -297 -246 -528 Income before income taxes 1,043 1,928 2,149 2,134 Income taxes -247 -146 -372 -417 Share in income of joint ventures 34 35 32 50 Income from continuing operations 830 1,817 1,809 1,767 Income (loss) from discontinued operations 0 0 -16 -1 Net income 830 € 1,817 € 1,793 € 1,766 Attributable to: Common shareholders 830 1,817 1,793 1,766 Non-controlling interests 0 0 0 0 Net income 830 € 1,817 € 1,793 € 1,766 Earnings per share: Net income per share attributable to common shareholders: Basic 0.81 € 1.45 € 1.52 € 1.60 Diluted 0.81 € 1.43 € 1.50 € 1.59 Income from continuing operations per share attributable to common shareholders: Basic 0.81 € 1.45 € 1.54 € 1.60 Diluted 0.81 € 1.43 € 1.52 € 1.59 Table T2a.1 AHOLD DELHAIZE. As-reported Consolidated Income Statements from AD's <NOTE: AD's FYE 12/31/CalYr and T's FYE 2/28/CalYr+1. So AD_FY2022 ≈ Net sales (in Euros millions)
https://finance.yahoo.com/quote/AD.AS/history ==> Stock price per share a Tra Fiscal year end 2/25/2017 2/24/2018 2/23/2019 2/29/2020 Fiscal year FY 2017 FY 2018 FY 2019 FY 2020 Page # in Annual Report p.86 p.74 p.92 p.78 # of pages in Annual Report 180 160 190 176 £ 55,917 £ 57,491 £ 63,911 £ 64,760 Cost of sales -53,015 -54,141 -59,767 -60,180 Impairment reversal/(loss) on financial assets 0 0 0 0 Gross profit/(loss) 2,902 3,350 4,144 4,580 Administrative expenses -1,995 -1,633 -2,075 -2,062 Profits/(losses) arising on property-related items 110 120 84 0 Operating profit/(loss) 1,017 1,837 2,153 2,518 Share of post-tax profits/(losses) of JVs -107 -6 35 18 Finance income 109 98 22 23 Finance expense -874 -631 -536 -1244 Profit/(loss) before tax 145 1,298 1,674 1,315 Taxation -87 -306 -354 -380 Profit/(loss) for the year from continuing operations 58 992 1,320 935 Discontinued operations -112 216 0 38 Profit/(loss) for the year -54 1,208 1,320 973 Attributable to: Owners of the parent -40 1,206 1,322 971 Non-controlling interests -14 2 -2 2 Net income attributable to owners of the parent 54 £ 1,208 £ 1,320 £ 973 Earnings/(losses) per share from continuing and discontinued operations Basic 0.0049 £ 0.1477 £ 0.1365 £ 0.0999 Diluted 0.0049 £ 0.1472 £ 0.1355 £ 0.0993 Earnings/(losses) per share from continuing operations Basic £ 0.0081 £ 0.1212 £ 0.1365 £ 0.0960 Diluted £ 0.0081 £ 0.1208 £ 0.1355 £ 0.0954 https://finance.yahoo.com/quote/TSCO.L/history ==> Stock price per share a Tra Table T2a.2 TESCO. As-reported Group Income Statements from Tesco's 2017-2 <NOTE: AD's FYE ≈ 12/31/CalYr and T's FYE ≈ 2/28/CalYr+1. So AD_FY2022 ≈ Revenues (in GBP millions)
4/3/2024 1/3/2021 1/2/2022 1/1/2023 FY 2020 FY 2021 FY 2022 p.143 p.179 p.189 Notes: 253 290 317 74,736 € 75,601 € 86,984 -54,160 -54,916 -63,689 (e.g., NI_2018_as-rep = 1,793 vs. 1,780 from 2019) 20,576 20,685 23,295 470 531 663 2. AD Other income not broken out < FY 2020. Creates distortions -14,620 -14,929 -16,989 -4,235 -2,967 -3,201 2,191 3,320 3,768 35 29 69 -138 -181 -248 -16 -17 -17 -357 -337 -356 -9 -10 0 -485 -516 -552 1,706 2,804 3,216 -331 -591 -714 22 33 44 1,397 2,246 2,546 0 0 0 1,397 € 2,246 € 2,546 1,397 2,246 2,546 0 0 0 1,397 € 2,246 € 2,546 1.31 € 2.18 € 2.56 1.30 € 2.17 € 2.54 1.31 € 2.18 € 2.56 1.30 € 2.17 € 2.54 s 2016-2022 Annual Reports. ≈ Tesco_FY2023> 1. FY 2018 as-reported FY 2018 from FY 2019 P&L
at closing on 5/26/23 = € 30.42 ailing P/E on 5/26/23 = 11.9 2/27/2021 2/26/2022 2/25/2023 FY 2021 FY 2022 FY 2023 p.112 p.116 p.120 Notes: 220 220 220 £ 57,887 £ 61,344 £ 65,762 -53,538 -56,750 -62,034 -384 39 -67 3,965 4,633 3,661 -2,229 -2,073 -2,136 0 0 0 1,736 2,560 1,525 26 15 8 15 9 85 -952 -551 -618 825 2,033 1,000 -104 -510 -247 721 1,523 753 5,426 -40 -9 2. One-time profit from discontinued Malaysian + Thailand + Polan 6,147 1,483 744 6,143 1,481 745 4 2 -1 £ 6,147 £ 1,483 £ 744 £ 0.6183 £ 0.1934 £ 0.1005 £ 0.6166 £ 0.1912 £ 0.0996 £ 0.0560 £ 0.1986 £ 0.1017 £ 0.0558 £ 0.1964 £ 0.1008 at closing on 5/26/23 = £ 2.6380 ailing P/E on 5/26/23 = 26.2 2023 Annual Reports. ≈ Tesco_FY2023> 1. FY 2021 as-reported FY 2021 from FY 2022 P&L (e.g., NI_20
s in year-over-year comparisons. As FY 2020 Operating Income as-reported in FY 2020 = FY 2020 Oper
nd operations 021_as-rep = 6,147 vs. 5,948 from 2020)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help