Case AD vs T Excel answers 20240403-final
.xlsx
keyboard_arrow_up
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
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
Related Questions
Calculate the cost efficiency - profit margin ratios
arrow_forward
The following data were taken from the records of Skysong Company for the fiscal year ended June 30, 2022.
Raw Materials Inventory 7/1/21
Raw Materials Inventory 6/30/22
Finished Goods Inventory 7/1/21
Finished Goods Inventory 6/30/22
Work in Process Inventory 7/1/21
Work in Process Inventory 6/30/22
Direct Labor
Indirect Labor
$51,600
45,500
99,100
22,300
29,600
28,100
145,750
26,660
Accounts Receivable
Factory Insurance
Factory Machinery Depreciation
Factory Utilities
Office Utilities Expense
Sales Revenue
Sales Discounts
Factory Manager's Salary
Factory Property Taxes
Factory Repairs
Raw Materials Purchases
Cash
$35,400
5,200
17,900
31,100
9,450
557,100
5,000
65,300
9,710
2,200
99,000
39,400
arrow_forward
Q2
Lautaro & Lukaku's provided the following accounting information for 2021:
Jan. 1, 2021
Dec 31, 2021
$65,000
Finished goods inventory........
• Cost Of Goods Manufactured COGM = $320,000
Sales revenues = $740,000
Selling & adm. expenses = $72,000
Tax rate 30%
$80,000
Required:
1. Prepare a schedule to calculate the cost of goods sold.
2. Prepare the income statement of this company for 2021
arrow_forward
calculate this account questions profit ratio
arrow_forward
The following relates to a single sale of goods made by Spurs in 2023:
Selling price P500,000Freight costs 5,000Terms 3/15, n/30Shipping Date December 28, 2023Date goods received by the customer January 3, 2024Date payment is received by Spurs January 5, 2024
Question:9. If the term is FOB destination, how much sales should be recorded by Spurs for the year ended December 31, 2023?
a. P0b. P490,000c. P495,000d. P500,000
arrow_forward
Spot rate
A$1.00 = £0.37
Date
Event
Order £300,000 of inventory
Purchase takes place as inventory shipped to Fujitsu Ltd | A$1.00 = £0.41
(FOB)
End of financial year
Inventory arrives at warehouse
Payment of £300,000 to supplier
15 March 2019
11 May 2019
30 June 2019
A$1.00 = £0.43
02 July 2019
14 August 2019
A$1.00 = £0.42
A$1.00 = £0.39
Required:
a) Prepare appropriate journal entries for each relevant event.
nearest dollar). Show your working.
b) What is a qualifying asset? Provide two (2) examples.
(Round amounts to the
arrow_forward
Find the On Balance Volume(photo)
1. What is the OBV on 10 May?2. What is the OBV on 05 May?
arrow_forward
QUESTION 1
a. Kpogo Ltd has the following products in inventory at the end of 2019:
Units
Cost per unit GH¢
XYZ (completed)
540
22
ABC (part complete)
280
26
Each product normally sells at GH¢34 per unit. Due to the difficult trading conditions, Kpogo Ltd
intends to offer a discount of 15% per unit and expects to incur GH¢4 per unit in selling costs.
GH¢10 per unit is expected to be incurred to complete each unit of ABC.
Required:
In accordance with IAS 2 Inventories, at what amount should inventory be stated in the financial
statements of Kpogo Ltd as at 31 December 2019?
b. According to IAS 8 Accounting Policies, Changes in Accounting Estimates and Errors,
an entity must select and apply its accounting policies consistently from one period to the
next and among various items in the financial statements. However, an entity may change
its accounting policies under certain conditions.
Required:
Identify the circumstances under which it may be appropriate to change accounting policy
in…
arrow_forward
Natal Company provided the following information:
Pro
Problem 10-2 (IAA)
1,400,000
200,000
650,000
60,000
150,000
2,000,000
Sum
beg
of 9
yea
Materiale
Advance for materials ordered
Goods in process
Unexpired insurance on inventories
Advertising catalogs and ehipping cartona
Finished gooda in factory
Finished goods in company-owned retail store,
including 50% profit on cost
Pinished goods in hands of consignees including
40% profit on sales
Finished goods in tranait to customers, shipped FOB
deatination at cost
Finished gooda out on approval, at cost
Unsalable fininhed gooda, at cost
Office supplies
Materials in transit shipped FOB nhipping point,
excluding freight of P30,000
Goods held on consignment, at sales price, cost P150,000
1.
2.
750,000
3.
4.
400,000
250,000
100,000
50,000
40,000
330,000
200,000
Required:
Compute the correct amount of inventory.
arrow_forward
Hi, can you please help me to compare and contrast the company's performance for the year 2019 and 2020?
Thanks in advance
arrow_forward
help
arrow_forward
question
O C.
Work in Progress
Finished Product
48
Given the following data; TOTAL SALES OMR 250000 CASH SALES OMR 125000 SALES RETURN OMR 5000
OPENING SUNDRY DEBTORS OMR 20000 CLOSING SUNDRY DEBTORS OMR 10000 What will be the average
debtors?
ut of
O a.
OMR 15000
uestion
O b. OMR 7500
O c. OMR 30000
O d. OMR 10000
pe here to search
Pa
lenovo
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Problem 12-2A (Algo) Perform horizontal analysis (LO12-2)
The income statements for Anything Outdoors for the years ending December 31, 2024 and 2023, are provided below.
Required:
1. Complete the "Amount" and "%" columns to be used in a horizontal analysis of the income statements for Anything
Outdoors. (Decreases should be indicated by a minus sign. Round your percentage answers to 1 decimal place.)
Net sales
Cost of goods sold
Gross profit
Operating expenses
Operating income
Other income (expense)
Income before tax
Income tax expense
Net income
ANYTHING OUTDOORS
Income Statements
For the Years Ended December 31
2024
2023
$ 3,350,000 $2,520,000 $
2,100,000
1,250,000
785,000
465,000
9,000
474,000
97,500
376,500 $
$
1,355,000
1,165,000
610,000
555,000
5,500
560,500
135,000
425,500 $
Increase (Decrease)
Amount
830,000
745,000
85,000
175,000
(90,000)
3,500
(86,500)
(37,500)
(49,000)
%
32.9
arrow_forward
Find the On Balance Volume(photo)
1. What is the OBV on 09 May?
2. What is the OBV on 08 May?
arrow_forward
Chapter 1 - Inventories
The December 31, 2019 inventory of Hope Company consisted of
four products, for which certain information is provided below.
Estimated
Unit Number disposal cost selling price
TITTTT
Estimated
Normal
profit
on sales
20%
25%
30%
10%
Product Cost of units
H
per unit
6.50
12.00
25.00
3.00
per unit
40
25
42
120
18
1,000
2,000
3,000
4,000
48
P
190
E
26
Hope Company measures its inventory at the lower of cost and net
realizable value on an item-by-item basis.
How much is the total inventory value at December 31, 2019?
P692,500
P541,000
P529,000
P469,000
a.
b.
с.
d.
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Q7
What amount will Music, Inc. report as ending inventory on its December 31, 2021 balance sheet?
arrow_forward
Answer ALL FOUR Questions
Question 12
Total Pop's data show the following information of January, February, March, April,
May 2022 (respectively):
♦
+
Additional information
Finished goods inventory is required to be 20% of the next month's
.
Jan.
Feb. Mar. Apr. May
Estimated sales (units) 15,000 14,500 16,000 15,500 15,800
Sales price per unit $ 45 $ 45 $ 45 S
45 $
45
Direct labor per unit $ 3 $ 3 $2.25 S 2 $
Labor rate per hour $ 18 $ 18 S 21 $ 21 S
2
21
requirements.
The ending inventory required for direct materials is 15% of the next month's
needs.
Direct material requires 2 pounds per unit at a cost of $3 per pound.
In January, the beginning inventory is 3,000 units of finished goods and 4,470
pounds of material.
Required:
Prepare the below budgets for the company:
(a) a production budget for the first quarter of the year.
(b) direct materials budget for the first quarter of the year.
X
arrow_forward
Sh11
arrow_forward
1. What is sales overview of sales report above.
2. What is reporting of sales report above.
arrow_forward
<
Cost Flow Methods
The following three identical units of Item JC07 are purchased during April:
Units Cost
April 2
April 15
April 20
Total
Item Beta
Purchase
Purchase
Purchase
a. First-in, first-out (FIFO)
b. Last-in, first-out (LIFO)
c. Weighted average cost
1
1
1
3
$94
97
Gross Profit
100
$291
Average cost per unit
($291 + 3 units)
Assume that one unit is sold on April 27 for $120. Determine the gross profit for April and ending inventory on April 30 using the (a) first-in, first-out (FIFO); (b) last-in,
first-out (LIFO); and (c) weighted average cost method.
$97
Ending Inventory
$
arrow_forward
Question 1The Alpha Manufacturing Co. present the following information for the year ended 31st December 2019 Sales: $ 252000 Commission: 2500Sales Returns and Allowances: 2000 Advertising: 4000 Purchases of Raw Material: 96200Depreciation of Sales Office: 2200 Carriage In: 300 Traveling Expense: 1800 Direct Labour: 40000 Bad Debts : 700 Purchases Return: 1200 Salaries: 2000 Indirect Material: 4300Stationery Used: 1125Indirect Labour : 4700Rent of Office: 1500 Rent of Factory: 3500Interest Received: 1110 Factory Taxes: 1150 Interest Paid: 275 Insurance of Factory Building: 1500Depreciation of Plant and Machinery: 3425 Heat, Light and Power: 2225INVENTORIES January 1 Dec. 31Finished Goods …………………….. $ 17600 $15300Work in Progress ……………………. 16100 13900Materials ……………………………… 9000 15300
Required:Cost of goods sold StatementIncome Statement.
arrow_forward
hello, help please
arrow_forward
Date
Date
1/9/18
10/9/18
Dollar Rate
Dollar Rate
1,16
Price in Euros Price in Dollars Price in Dollars Difference
1,18
Model
300 VRG
625 RTM
475 GRM
200 GRM
650 MTY
600 RTM
500 MTY
46.900 €
$55.342
$54.404
$938
66.700 €
$78.706
$77.372
$1.334
96.100 €
122.600 €
164.900 €
214.400 €
247.300 €
$113.398
$111.476
$1.922
$144.668
$142.216
$2.452
$194.582
$191.284
$3.298
$252.992
$291.814
$248.704
$286.868
$4.288
$4.946
1) Most of your exports to the US belong to the
model 600 RTM. The experience shows that, if the
price of this product rises over 215000 dollars, the
exported units will be reduced. If this product is
priced in euros, and assuming the trend shown in
question 1 continues, what would be the
consequences for your company's exports?
arrow_forward
5.3 please a and b
arrow_forward
Question:
Jones Company was formed on December 1, 2021. The following information is available from Jones's inventory record for Product X.
Units Unit Cost
January 1, 2022 (beginning inventory) 1,600 £18.00
Purchases:
January 5, 2022 2,600 £20.00
January 25, 2022 2,400 £21.00
February 16, 2022 1,000 £22.00
March 15, 2022 1,800 £23.00
A physical inventory on March 31, 2022, shows 2,500 units on…
arrow_forward
Help please
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Related Questions
- Calculate the cost efficiency - profit margin ratiosarrow_forwardThe following data were taken from the records of Skysong Company for the fiscal year ended June 30, 2022. Raw Materials Inventory 7/1/21 Raw Materials Inventory 6/30/22 Finished Goods Inventory 7/1/21 Finished Goods Inventory 6/30/22 Work in Process Inventory 7/1/21 Work in Process Inventory 6/30/22 Direct Labor Indirect Labor $51,600 45,500 99,100 22,300 29,600 28,100 145,750 26,660 Accounts Receivable Factory Insurance Factory Machinery Depreciation Factory Utilities Office Utilities Expense Sales Revenue Sales Discounts Factory Manager's Salary Factory Property Taxes Factory Repairs Raw Materials Purchases Cash $35,400 5,200 17,900 31,100 9,450 557,100 5,000 65,300 9,710 2,200 99,000 39,400arrow_forwardQ2 Lautaro & Lukaku's provided the following accounting information for 2021: Jan. 1, 2021 Dec 31, 2021 $65,000 Finished goods inventory........ • Cost Of Goods Manufactured COGM = $320,000 Sales revenues = $740,000 Selling & adm. expenses = $72,000 Tax rate 30% $80,000 Required: 1. Prepare a schedule to calculate the cost of goods sold. 2. Prepare the income statement of this company for 2021arrow_forward
- calculate this account questions profit ratioarrow_forwardThe following relates to a single sale of goods made by Spurs in 2023: Selling price P500,000Freight costs 5,000Terms 3/15, n/30Shipping Date December 28, 2023Date goods received by the customer January 3, 2024Date payment is received by Spurs January 5, 2024 Question:9. If the term is FOB destination, how much sales should be recorded by Spurs for the year ended December 31, 2023? a. P0b. P490,000c. P495,000d. P500,000arrow_forwardSpot rate A$1.00 = £0.37 Date Event Order £300,000 of inventory Purchase takes place as inventory shipped to Fujitsu Ltd | A$1.00 = £0.41 (FOB) End of financial year Inventory arrives at warehouse Payment of £300,000 to supplier 15 March 2019 11 May 2019 30 June 2019 A$1.00 = £0.43 02 July 2019 14 August 2019 A$1.00 = £0.42 A$1.00 = £0.39 Required: a) Prepare appropriate journal entries for each relevant event. nearest dollar). Show your working. b) What is a qualifying asset? Provide two (2) examples. (Round amounts to thearrow_forward
- Find the On Balance Volume(photo) 1. What is the OBV on 10 May?2. What is the OBV on 05 May?arrow_forwardQUESTION 1 a. Kpogo Ltd has the following products in inventory at the end of 2019: Units Cost per unit GH¢ XYZ (completed) 540 22 ABC (part complete) 280 26 Each product normally sells at GH¢34 per unit. Due to the difficult trading conditions, Kpogo Ltd intends to offer a discount of 15% per unit and expects to incur GH¢4 per unit in selling costs. GH¢10 per unit is expected to be incurred to complete each unit of ABC. Required: In accordance with IAS 2 Inventories, at what amount should inventory be stated in the financial statements of Kpogo Ltd as at 31 December 2019? b. According to IAS 8 Accounting Policies, Changes in Accounting Estimates and Errors, an entity must select and apply its accounting policies consistently from one period to the next and among various items in the financial statements. However, an entity may change its accounting policies under certain conditions. Required: Identify the circumstances under which it may be appropriate to change accounting policy in…arrow_forwardNatal Company provided the following information: Pro Problem 10-2 (IAA) 1,400,000 200,000 650,000 60,000 150,000 2,000,000 Sum beg of 9 yea Materiale Advance for materials ordered Goods in process Unexpired insurance on inventories Advertising catalogs and ehipping cartona Finished gooda in factory Finished goods in company-owned retail store, including 50% profit on cost Pinished goods in hands of consignees including 40% profit on sales Finished goods in tranait to customers, shipped FOB deatination at cost Finished gooda out on approval, at cost Unsalable fininhed gooda, at cost Office supplies Materials in transit shipped FOB nhipping point, excluding freight of P30,000 Goods held on consignment, at sales price, cost P150,000 1. 2. 750,000 3. 4. 400,000 250,000 100,000 50,000 40,000 330,000 200,000 Required: Compute the correct amount of inventory.arrow_forward
- Hi, can you please help me to compare and contrast the company's performance for the year 2019 and 2020? Thanks in advancearrow_forwardhelparrow_forwardquestion O C. Work in Progress Finished Product 48 Given the following data; TOTAL SALES OMR 250000 CASH SALES OMR 125000 SALES RETURN OMR 5000 OPENING SUNDRY DEBTORS OMR 20000 CLOSING SUNDRY DEBTORS OMR 10000 What will be the average debtors? ut of O a. OMR 15000 uestion O b. OMR 7500 O c. OMR 30000 O d. OMR 10000 pe here to search Pa lenovoarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning