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 on coursehero.com
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
Company XYZ it made sales of $230,000 during 2019 the fixed expenses were $90,000 and variable expense with $50,000 the cost of goods as sold was $35,000 calculate the gross margin for XYZ
arrow_forward
PROBLEM 14: MMM Company started operations in 2019. The following data are abstracted
from the company's production and sales records:
2019
2020
2021
of units
Number
produced
Number of units sold
Unit production cost
116,250
108,750
P 4.50 P 5.20 P 5.80
900,000
120,000
75,000
101,250
97,500
Sales revenue
600,000
975,000
19. Using the FIFO cost flow assumption, the gross profit for the year ended December 31,
2021 is:
PROBLEM 15: The following quarterly cost data have been accumulated for New DDD
Manufacturing, Inc.:
Raw materials, 1/1/2022
Purchases of raw materials
10,000 units at P6.00
8,500 units at P7.00
11,000 units at P7.50
Raw materials transferred to
work in process
Work in process, 1/1/2022
Direct labor
Manufacturing overhead
Work in process, 3/31/2022
21,500 units
5,600 units at P13.50
P 250,000
325,000
4,200 units at P13.75
20. If New Dehi uses the FIFO method for valuing raw materials inventories, compute for the
cost of goods manufactured for the quarter ended March 31,…
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
Problem 13-02A (Video)
The comparative statements of Cullumber Company are presented here:
Cullumber CompanyIncome StatementsFor the Years Ended December 31
2020
2019
Net sales
$1,891,640
$1,751,600
Cost of goods sold
1,059,640
1,007,100
Gross profit
832,000
744,500
Selling and administrative expenses
501,100
480,100
Income from operations
330,900
264,400
Other expenses and losses
Interest expense
23,700
21,700
Income before income taxes
307,200
242,700
Income tax expense
93,700
74,700
Net income
$213,500
$168,000
Cullumber CompanyBalance SheetsDecember 31
Assets
2020
2019
Current assets
Cash
$60,100
$64,200
Debt investments (short-term)
74,000
50,000
Accounts receivable
118,900
103,900
Inventory
127,700
117,200
Total current assets
380,700
335,300
Plant assets (net)…
arrow_forward
Customers
balance December 31, 2023
om customers
e balance, March 31, 2024:
cted in 2nd Ot
2024
Data table
Total sales
Budgeted purchases of direct matenal
Budgeted direct labor cost
Budgeted manufacturing overhead costs
Variable manufacturing overhead
Depreciation
Insurance and property taxes
Budgeted selling and administrative expenses
Salaries expense
Rent expense
Insurance experese
Depreciation experie
Supples expense
Print
Done
208.000
40,900
37,500
1,100
1.200
6,700
4,000
1,000
1,400
6.240
arrow_forward
2020
Percentage
2019
Percentage
Revenue
Cost of Goods Sold
Gross Profit
Selling and General Experses
Other Experses
|Net Inome
P1,939,500
900,000
1,039,500
445,500
37,575
P 556,425
P 1,674,675
843,975
830,700
409,725
30,825
P 390,150
Requirements:
Prepare a vertical aralysis for Q & A Tracing Compary.
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
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
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
Jorasmi Enterprise
Trial Balance as at 31 December 2020
Particulars
Debit
RM
Credit
RM
Inventory of raw materials 1 Jan 2020
21,000
Inventory of finished goods 1 Jan 2020
38,900
Work in progress 1 Jan 2020
13,500
Wages (direct RM180,000, factory indirect RM145,000)
325,000
Royalties
7,000
Carriage inwards (on raw materials)
3,500
Purchases of raw materials
370,000
Productive machinery (cost RM280,000)
230,000
Administration computers (cost RM20,000)
12,000
General factory expenses
31,000
Lighting
7,500
Factory power
13,700
Administration salaries
44,000
Sales representative salaries
30,000
Commission on sales
11,500
Rent
12,000
Insurance
4,200
General administration expenses
13,400
Bank charges
2,300
Discount allowed
4,800
Carriage outwards
5,900
Sales
1,000,000
Account…
arrow_forward
Jorasmi Enterprise
Trial Balance as at 31 December 2020
Particulars
Debit
RM
Credit
RM
Inventory of raw materials 1 Jan 2020
21,000
Inventory of finished goods 1 Jan 2020
38,900
Work in progress 1 Jan 2020
13,500
Wages (direct RM180,000, factory indirect RM145,000)
325,000
Royalties
7,000
Carriage inwards (on raw materials)
3,500
Purchases of raw materials
370,000
Productive machinery (cost RM280,000)
230,000
Administration computers (cost RM20,000)
12,000
General factory expenses
31,000
Lighting
7,500
Factory power
13,700
Administration salaries
44,000
Sales representative salaries
30,000
Commission on sales
11,500
Rent
12,000
Insurance
4,200
General administration expenses
13,400
Bank charges
2,300
Discount allowed
4,800
Carriage outwards
5,900
Sales
1,000,000
Account…
arrow_forward
Monaco manufacturing corp has the following account balances per ledger for the
period ending December 31, 2019
Representation exp
P10,000.00
Plant Supervision
P126,750.00
Delivery expense
P15,000.00
Purchase return
P3,580.00
Depreciation --
Purchases
P350,800.00
P62,800.00
Factory Building
Raw Materials
Depreciation office
P25,000.00
Inventory, Dec. 31,
P100,400.00
equipt
2019
Raw Materials
Depreciation-Factory
P9,460.00
Inventory, Jan 1,
P101,640.00
/ Equipment
2019
Repairs and
Direct Labor
P42,500.00
Maintenance -
P76,480.00
factory equipt
Salaries of office
P29,220.00
P60,000.00
Factory Insurance
and admin staff
P46,200.00
Sales
P1,100,000.00
Factory Utilities
Finished Goods
Sales return and
P24,910.00
P5,000.00
Inventory, Jan. 1,
allowances
2019
Selling and
Administrative
Indirect Labor
P8,100.00
P26,490.00
Expenses
arrow_forward
Assume the following data for Eim Alex Company for the years 2019, 2020, and 2021.
Year
Lifting.(Production) Costs (excluding DD&A)
DD&A
Production
bbl
2019
750,000
855,000
325,000
2020
685,000
787,000
297,000
2021
578,000
729,000
362,000
Compute the DD&A per BOE for 2019.
O 2.6308
2.6380
2.3680
arrow_forward
1.
Jorasmi Enterprise
Trial Balance as at 31 December 2020
Particulars
Debit
Credit
RM
RM
Inventory of raw materials 1 Jan 2020
Inventory of finished goods 1 Jan 2020
Work in progress 1 Jan 2020
Wages (direct RM180,000, factory indirect RM145,000)
Royalties
Carriage inwards (on raw materials)
21,000
38,900
13,500
325,000
7,000
3,500
370,000
230,000
12,000
31,000
7,500
13,700
44,000
30,000
11,500
12,000
4,200
13,400
2,300
4,800
5,900
Purchases of raw materials
Productive machinery (cost RM280,000)
Administration computers (cost RM20,000)
General factory expenses
Lighting
Factory power
Administration salaries
Sales representative salaries
Commission on sales
Rent
Insurance
General administration expenses
Bank charges
Discount allowed
Carriage outwards
Sales
Account receivable and accounts payable
1,000,000
64,000
142,300
16,800
1,500
60,000
Bank
Cash
Drawings
Capital as at 1 Jan 2020
357,800
ТОTAL
1,421,800 1,421,800
Prepared by: Puan Siti Nor Junita Mohd Radzi
Additional information:
i.…
arrow_forward
1.
Jorasmi Enterprise
Trial Balance as at 31 December 2020
Credit
RM
Particulars
Debit
RM
Inventory of raw materials 1 Jan 2020
Inventory of finished goods 1 Jan 2020
Work in progress 1 Jan 2020
Wages (direct RM180,000, factory indirect RM145,000)
Royalties
Carriage inwards (on raw materials)
Purchases of raw materials
Productive machinery (cost RM280,000)
21,000
38,900
13,500
325,000
7,000
3,500
370 000
230.000
12,000
31,000
7,500
13,700
44,000
Administration computers (cost RM20,000)
Coneral factory expenses
General
Lighting
actory power
Factory
Administration salaries
Sales
Sales representative salaries
Commission on sales
Rent
30,000
11,500
12,000
4,200
13,400
2,300
4,800
5,900
Insurance
General administration expenses
Bank charges
Discount allowed
Carriage outwards
Sales
1,000,000
64,000
Account receivable and accounts payable
Bank
Cash
Drawings
Capital as at 1 Jan 2020
142,300
16,800
1,500
60,000
357,800
1,421,800 1,421,800
ТОTAL
Prepared by: Puan Siti Nor Junita Mohd Radzi…
arrow_forward
2020
2021
Costs Incurred in
3,000
6,000
The Year
Estimated Costs
9,000
to Complete
Billings During
the Year
4,500
5,500
Cash Collections
3,500
6,000
Selling Price: $15,000
Calculate the revenue, cost of goods sold and
gross profit to be recognized in each year.
Calculate the ending balance in accounts
receivable in each year.
2020
2021
Revenue
Cost of Goods Sold
Gross Profit
Ending Accounts
Receivable
arrow_forward
A EXAMPLE 20.18
The following information relating to the third and last quarter of 2019-20 is furnished by a compan
which manufactures and sells a single product:
Third Quarter Last Quarter
(Actual)
76,24,000
(Estimate)
76,60,000
Sales
Inventory of raw material and finished goods:
Орening
Balance
Closing
Balance
Closing
Balance
Raw material A (kg)
Raw materialB (kg)
Finished goods (units)
25,000
23,500
25,000
15,000
12,650
13,400
670
700
1,000
Unit cost data:
Raw material A:
10 kg @ 33 = 730
5 kg @ 2 = 10
%3D
Raw material B:
%3D
Direct labour (Machine time 5 hrs @ 4): Machine shop = 20
Assembly 2 hrs. @ 75 (labour time) = 710
Production overheads:
%3D
Machine shop @ 12 per machine hr.
Assembly @10 per labour hr.
Selling and Administration O.H. : 20% of production cost
Profit margin
: 10% on selling price
Production and sales occur evenly during the budget period. You are required to prepare for the las
quarter of the year.
(a) Production budget (in units)
(b) Purchase budget (quantity…
arrow_forward
Calculate Swifty's gross profit percentage and percentage markup on cost for each fiscal year. (Round answers to 2 decimal places,
eg. 52.75.)
Percentage gross profit
Percentage markup on cost
Fiscal 2023
35.74 %
3.43
%
Fiscal 2022
36.13 %
5.67 %
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
Problem 11-5 (IAA)
Pro
Tragie Company provided the following data for purchases
and sales:
Sla
rela
Purchases
Unit cost
Sales
Revenue
Ja.
Ag
Units
Cost
Units
250,000
540,000
1,125,000
4,000
7,000
12,000
280,000
630,000
1,200,000
50
2018
2019
2020
5,000
9,000
15,000
75
Required:
Compute the gross income for 2020 assuming a FIFO cost
formula.
arrow_forward
solve
The Arc 95-9876556 Income Statement For the Year Ended December 31, 2021 Revenue: Gross Sales $144,000.00 Less: Sales Returns and Allowances - Net Sales $144,000.00 Cost of Goods Sold: Beginning Inventory $10,500.00 Add: Purchases 62,200.00 $72,700.00 Less: Ending Inventory 10,100.00 Cost of Goods Sold 62,600.00 Gross Profit (Loss) $81,400.00 Expenses: Dues and Subscriptions - Estimated Federal Tax Payments 4,000.00 Estimated State Tax Payments 3,900.00 Insurance 3,950.00 Meals and Entertainment 1,500.00 Miscellaneous - Payroll Taxes 3,800.00 Professional Fees 1,700.00 Rent 8,400.00 Travel 1,250.00 Utilities 1,300.00 Vehicle Expenses - Wages 25,000.00 Total Expenses 54,800.00 Net Operating Income $26,600.00 How to calculate capital gain step by step answer
arrow_forward
QUESTION
The following information is available for work compan for 2019:
Freigth-in
33,000
Purchase returns
65,000
Selling expenses
390,000
Ending inventory
180,000
the cost of goods sold is equal to 300% of selling expenses
instruction
what is the cost of goods available for sale?
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
A credit sale of $3800 is made on April 25, terms 1/10, n/30, on which a return of $300 is granted on April 28. What amount is received
as payment in full on May 4?
$3465
• $3800
• $3500
Ⓒ $3762
arrow_forward
1.
Jorasmi Enterprise
Trial Balance as at 31 December 2020
Particulars
Debit
RM
Credit
RM
Inventory of raw materials 1 Jan 2020
21,000
Inventory of finished goods 1 Jan 2020
38,900
Work in progress 1 Jan 2020
13,500
Wages (direct RM180,000, factory indirect RM145,000)
325,000
Royalties
7,000
Carriage inwards (on raw materials)
3,500
Purchases of raw materials
370,000
Productive machinery (cost RM280,000)
230,000
Administration computers (cost RM20,000)
12,000
General factory expenses
31,000
Lighting
7,500
Factory power
13,700
Administration salaries
44,000
Sales representative salaries
30,000
Commission on sales
11,500
Rent
12,000
Insurance
4,200
General administration expenses
13,400
Bank charges
2,300
Discount allowed
4,800
Carriage outwards
5,900
Sales…
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
Required information
For Year Ended December 31
Sales
Cost of goods sold
Other operating expenses
Current Year
$ 411, 225
209,550
12, 100
9,525
$ 673,500
642, 400
$31,100
$ 1.90
:. -. - == .......
9 US
Sa
M
arrow_forward
lal Acc
CO
ng-20201
am ACCT301 Fall 2020/2021 (Sections 1, 2, and 81)
19
Revenue has a credit balance of OMR 15,000 in Muscat Co. if the dosing entry will made at the year end,
ved
The entry to close Revenue is:
it of
Select one:
O a debit Income Summary OMR20,000, credit Revenue OMR20,000
Ob. debit Revenue OMR15,000, credit Ahmad Capital OMR15,000
Oc debit Revenue OMR15,000, credit Income Summary OMR15,000.
d. debit Income Summary OMR15,000, credit Revenue OMR15,000
Clear my choice
s page
arrow_forward
Prepare a gross profit variation analysis for two products. 2021. 2020 A. B. A. B Sales volume. 7,000 5,000. 9,000. 2,500Unit selling price. P 6.00. P. 4.00. P 7.00. P 5.00Unit cost. P. 4.00. 2.00 6.00 3.00Determine the following: a) Volume factor b) Price factor c) cost factor d) sales mix factor
arrow_forward
The products of ABC can be grouped into two major categories: products A1 and A2 are in Category A, while products B1 and B2 are in category B. Assume the following information regarding ABC's inventories for year 2021:
Product A1
Transaction
Number of Units
Unit Cost
Unit Price
Beginning inventory
400
€5
Purchase No. 1
400
€5
Sale No.1
600
€10
Sale No.2
100
€12
Purchase No. 2
1,000
€7
Sale No.3
700
€10
Purchase No. 3
1,000
€7
Sale No.4
600
€15
Sale No.5
600
€15
Purchase No. 4
1,200
€9
Selling price as at December 31, 2021
€14
Product A2
Transaction
Beginning inventory
Number of Units
500
Unit Cost
€8
Unit Price
Sale No.1
400
€12
Purchase No. 1
600
€8
Purchase No. 2
500
€7
Sale No.2
650
€12
Purchase No. 3
150
€9
Purchase No. 4
200
€8
Selling priceas at December 31,
€11
2021…
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
- Company XYZ it made sales of $230,000 during 2019 the fixed expenses were $90,000 and variable expense with $50,000 the cost of goods as sold was $35,000 calculate the gross margin for XYZarrow_forwardPROBLEM 14: MMM Company started operations in 2019. The following data are abstracted from the company's production and sales records: 2019 2020 2021 of units Number produced Number of units sold Unit production cost 116,250 108,750 P 4.50 P 5.20 P 5.80 900,000 120,000 75,000 101,250 97,500 Sales revenue 600,000 975,000 19. Using the FIFO cost flow assumption, the gross profit for the year ended December 31, 2021 is: PROBLEM 15: The following quarterly cost data have been accumulated for New DDD Manufacturing, Inc.: Raw materials, 1/1/2022 Purchases of raw materials 10,000 units at P6.00 8,500 units at P7.00 11,000 units at P7.50 Raw materials transferred to work in process Work in process, 1/1/2022 Direct labor Manufacturing overhead Work in process, 3/31/2022 21,500 units 5,600 units at P13.50 P 250,000 325,000 4,200 units at P13.75 20. If New Dehi uses the FIFO method for valuing raw materials inventories, compute for the cost of goods manufactured for the quarter ended March 31,…arrow_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_forward
- Problem 13-02A (Video) The comparative statements of Cullumber Company are presented here: Cullumber CompanyIncome StatementsFor the Years Ended December 31 2020 2019 Net sales $1,891,640 $1,751,600 Cost of goods sold 1,059,640 1,007,100 Gross profit 832,000 744,500 Selling and administrative expenses 501,100 480,100 Income from operations 330,900 264,400 Other expenses and losses Interest expense 23,700 21,700 Income before income taxes 307,200 242,700 Income tax expense 93,700 74,700 Net income $213,500 $168,000 Cullumber CompanyBalance SheetsDecember 31 Assets 2020 2019 Current assets Cash $60,100 $64,200 Debt investments (short-term) 74,000 50,000 Accounts receivable 118,900 103,900 Inventory 127,700 117,200 Total current assets 380,700 335,300 Plant assets (net)…arrow_forwardCustomers balance December 31, 2023 om customers e balance, March 31, 2024: cted in 2nd Ot 2024 Data table Total sales Budgeted purchases of direct matenal Budgeted direct labor cost Budgeted manufacturing overhead costs Variable manufacturing overhead Depreciation Insurance and property taxes Budgeted selling and administrative expenses Salaries expense Rent expense Insurance experese Depreciation experie Supples expense Print Done 208.000 40,900 37,500 1,100 1.200 6,700 4,000 1,000 1,400 6.240arrow_forward2020 Percentage 2019 Percentage Revenue Cost of Goods Sold Gross Profit Selling and General Experses Other Experses |Net Inome P1,939,500 900,000 1,039,500 445,500 37,575 P 556,425 P 1,674,675 843,975 830,700 409,725 30,825 P 390,150 Requirements: Prepare a vertical aralysis for Q & A Tracing Compary.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,000arrow_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_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
- Jorasmi Enterprise Trial Balance as at 31 December 2020 Particulars Debit RM Credit RM Inventory of raw materials 1 Jan 2020 21,000 Inventory of finished goods 1 Jan 2020 38,900 Work in progress 1 Jan 2020 13,500 Wages (direct RM180,000, factory indirect RM145,000) 325,000 Royalties 7,000 Carriage inwards (on raw materials) 3,500 Purchases of raw materials 370,000 Productive machinery (cost RM280,000) 230,000 Administration computers (cost RM20,000) 12,000 General factory expenses 31,000 Lighting 7,500 Factory power 13,700 Administration salaries 44,000 Sales representative salaries 30,000 Commission on sales 11,500 Rent 12,000 Insurance 4,200 General administration expenses 13,400 Bank charges 2,300 Discount allowed 4,800 Carriage outwards 5,900 Sales 1,000,000 Account…arrow_forwardJorasmi Enterprise Trial Balance as at 31 December 2020 Particulars Debit RM Credit RM Inventory of raw materials 1 Jan 2020 21,000 Inventory of finished goods 1 Jan 2020 38,900 Work in progress 1 Jan 2020 13,500 Wages (direct RM180,000, factory indirect RM145,000) 325,000 Royalties 7,000 Carriage inwards (on raw materials) 3,500 Purchases of raw materials 370,000 Productive machinery (cost RM280,000) 230,000 Administration computers (cost RM20,000) 12,000 General factory expenses 31,000 Lighting 7,500 Factory power 13,700 Administration salaries 44,000 Sales representative salaries 30,000 Commission on sales 11,500 Rent 12,000 Insurance 4,200 General administration expenses 13,400 Bank charges 2,300 Discount allowed 4,800 Carriage outwards 5,900 Sales 1,000,000 Account…arrow_forwardMonaco manufacturing corp has the following account balances per ledger for the period ending December 31, 2019 Representation exp P10,000.00 Plant Supervision P126,750.00 Delivery expense P15,000.00 Purchase return P3,580.00 Depreciation -- Purchases P350,800.00 P62,800.00 Factory Building Raw Materials Depreciation office P25,000.00 Inventory, Dec. 31, P100,400.00 equipt 2019 Raw Materials Depreciation-Factory P9,460.00 Inventory, Jan 1, P101,640.00 / Equipment 2019 Repairs and Direct Labor P42,500.00 Maintenance - P76,480.00 factory equipt Salaries of office P29,220.00 P60,000.00 Factory Insurance and admin staff P46,200.00 Sales P1,100,000.00 Factory Utilities Finished Goods Sales return and P24,910.00 P5,000.00 Inventory, Jan. 1, allowances 2019 Selling and Administrative Indirect Labor P8,100.00 P26,490.00 Expensesarrow_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