Carrillo_Christian_Pepsi vs. Kroger Project
xlsx
keyboard_arrow_up
School
Santa Monica College *
*We aren’t endorsed by this school
Course
2
Subject
Finance
Date
Jan 9, 2024
Type
xlsx
Pages
23
Uploaded by DrFangParrot18
Consolidated Balance Sheet:
PepsiCo, Inc and Subsidiaires:
December 25, 2021 and december 26 2020:
(in Millions Except per share amounts)
(2021:)
(2020:)
2021 - 2020: Dollar Change: ($):
2021 - 2020: Percent Change: (%):
Common Size Consolidated Balance Sheet:
Assets:
Current Assets:
Horitonal Analysis:
Horizontal Analysis:
Vertical Analysis (Per Individual Year):
(Current Analysis - Base Period Amount)
(Current Analysis - Base Period)/(Base Period) x 100%
(Independent Variable / Total Assets)
Cash and Equivalents:
$
5,596.00
$
8,185.00
$
(2,589.00)
-31.6%
6.06%
8.81%
Short-Term Investments:
$
392.00
$
1,366.00
$
(974.00)
-71.3%
0.42%
1.47%
Accounts and Notes Receivable, Net:
$
8,680.00
$
8,404.00
$
276.00
3.3%
9.40%
9.04%
Inventories:
$
4,347.00
$
4,172.00
$
175.00
4.2%
4.71%
4.49%
Prepaid expenses and other current assets:
$
980.00
$
874.00
$
106.00
12.1%
1.06%
0.94%
Assets held for Sale:
$
1,788.00
$
-
$
1,788.00
#DIV/0!
1.94%
0.00%
Total Current Assets:
$
21,783.00
$
23,001.00
$
(1,218.00)
-5.3%
23.58%
24.75%
Property, Plant and Equipment, net:
$
22,407.00
$
21,369.00
$
1,038.00
4.9%
24.26%
23.00%
Amortizable Intangible Assets, Net:
$
1,538.00
$
1,703.00
$
(165.00)
-9.7%
1.66%
1.83%
Goodwill:
$
18,381.00
$
18,757.00
$
(376.00)
-2.0%
19.90%
20.19%
other Indefinite-Lived Intangible Assets:
$
17,127.00
$
17,612.00
$
(485.00)
-2.8%
18.54%
18.95%
Investments in NonControlled Affiliates:
$
2,627.00
$
2,792.00
$
(165.00)
-5.9%
2.84%
3.00%
Deferred Income Taxes:
$
4,310.00
$
4,372.00
$
(62.00)
-1.4%
4.67%
4.71%
Other Assets:
$
4,204.00
$
3,312.00
$
892.00
26.9%
4.55%
3.56%
Total Assets:
$
92,377.00
$
92,918.00
$
(541.00)
-0.6%
100.00%
100.00%
Liabilities and Equity:
(2021-2020)
(2021-2020)
2021
2020
Current Liabilities:
Short-term
debt obligations:
$
4,308.00
$
3,780.00
$
528.00
14.0%
4.66%
4.07%
Accounts payable and other current liabilities:
$
21,159.00
$
19,592.00
$
1,567.00
8.0%
22.91%
21.09%
Liabilities held for Sale:
$
753.00
$
-
$
753.00
#DIV/0!
0.82%
0.00%
Total Current Liabilities:
$
26,220.00
$
23,372.00
$
2,848.00
12.2%
28.38%
25.15%
Long-Term Debt Obligations:
$
36,026.00
$
40,370.00
$
(4,344.00)
-10.8%
39.00%
43.45%
Deferred Income Taxes:
$
4,826.00
$
4,284.00
$
542.00
12.7%
5.22%
4.61%
Other Liabilities:
$
9,154.00
$
11,340.00
$
(2,186.00)
-19.3%
9.91%
12.20%
Total Liabilities:
$
76,226.00
$
79,366.00
$
(3,140.00)
-4.0%
82.52%
85.42%
Commitments and contingencies:
PepsiCo Common Shareholders' Equity:
(2021-2020)
(2021-2020)
2021
2020
Common Stock, Par value 1/(2/3) per share
$
23.00
$
23.00
$
-
0.0%
0.02%
0.02%
(484 and 487 shares, resepctively):
$
4,001.00
$
3,910.00
$
91.00
2.3%
4.33%
4.21%
Capital in excess of par value:
$
65,165.00
$
63,443.00
$
1,722.00
2.7%
70.54%
68.28%
Retained earnings:
$
(14,898.00)
$
(15,476.00)
$
578.00
-3.7%
-16.13%
-16.66%
Accumulated common stock, in excess of par value
$
(38,248.00)
$
(38,446.00)
$
198.00
-0.5%
-41.40%
-41.38%
(484 and 487 shares, respectively):
Total PepsiCo Common Shareholders' Equity:
$
16,043.00
$
13,454.00
$
2,589.00
19.2%
17.37%
14.48%
NonControlling interests:
$
108.00
$
98.00
$
10.00
10.2%
0.12%
0.11%
Total Equity:
$
16,151.00
$
13,552.00
$
2,599.00
19.2%
17.48%
14.58%
Total Liabilities and Equity:
$
92,377.00
$
92,918.00
$
(541.00)
-0.6%
100.00%
100.00%
Consolidated Statement of Income:
PepsiCo. Inc, and Subisdiaries:
Fiscal years ended December 25, 2021, December 26, 2020 and December 28, 2019:
(in millions except per share amounts)
Income Statement (2021,2020,2019) (10-K):
(Current Period - Base Period)
(Current Period - Base Peirod)/(Base Period) x 100%
(Current Peirod / Base Period)
($): Change (2021 - 2019):
(%): Change (2021 -2019):
Trend Analysis (%): (2021,2020,2019):
Year:
2021 (Current):
2020
2019 (Base Period):
(2021-2019)
(2020-2019) if needed
(2021-2019)
(2020-2019) if needed
2021
2020
2019
Net Revenue:
$
79,474.00 $
70,372.00 $
67,161.00
$
12,313.00
$
3,211.00
18.33%
4.78%
118.33%
104.78%
100.00%
Cost of Sales:
$
37,075.00 $
31,797.00 $
30,132.00
$
6,943.00
$
1,665.00
23.04%
5.53%
123.04%
105.53%
100.00%
Gross Profit:
$
42,399.00 $
38,575.00 $
37,029.00
$
5,370.00
$
1,546.00
14.50%
4.18%
114.50%
104.18%
100.00%
Selling, General and administrative expenses:
$
31,237.00 $
28,495.00 $
26,738.00
$
4,499.00
$
1,757.00
16.83%
6.57%
116.83%
106.57%
100.00%
Operating Profit:
$
11,162.00
$
10,080.00
$
10,291.00
$
871.00
$
(211.00)
8.46%
-2.05%
108.46%
97.95%
100.00%
Other pension and retiree medical benefits income/(expense)
$
522.00 $
117.00 $
(44.00)
$
566.00
$
161.00
-1186.36%
-265.91%
100.00%
Net Interest and other:
$
(1,863.00)
$
(1,128.00) $
(935.00)
$
(928.00)
$
(193.00)
99.25%
20.64%
199.25%
120.64%
100.00%
Income before Income taxes:
$
9,821.00 $
9,069.00 $
9,312.00
$
509.00
$
(243.00)
5.47%
-2.61%
105.47%
97.39%
100.00%
Provision for Income Taxes:
$
2,142.00 $
1,894.00 $
1,959.00
$
183.00
$
(65.00)
9.34%
-3.32%
109.34%
96.68%
100.00%
Net Income:
$
7,679.00
$
7,175.00
$
7,353.00
$
326.00
$
(178.00)
4.43%
-2.42%
104.43%
97.58%
100.00%
Less: Net Income attributable to non controlling interests:
$
61.00 $
55.00 $
39.00
$
22.00
$
16.00
56.41%
41.03%
156.41%
141.03%
100.00%
Net Income Attrributable to PepsiCo:
$
7,618.00 $
7,120.00 $
7,314.00
$
304.00
$
(194.00)
4.16%
-2.65%
104.16%
97.35%
100.00%
Net Income Attributable to PepsiCo per Common Share:
Basic:
$
5.51 $
5.14 $
5.23
$
0.28
$
(0.09)
5.35%
-1.72%
105.35%
98.28%
100.00%
Diluted:
$
5.49 $
5.12 $
5.20
$
0.29
$
(0.08)
5.58%
-1.54%
105.58%
98.46%
100.00%
Weighted-average common shares outstanding:
Basic:
$
1,382.00 $
1,385.00 $
1,399.00
$
(17.00)
$
(14.00)
-1.22%
-1.00%
98.78%
99.00%
100.00%
Diluted:
$
1,389.00 $
1,392.00 $
1,407.00
$
(18.00)
$
(15.00)
-1.28%
-1.07%
98.72%
98.93%
100.00%
Common Size (Consilidated Statement of Income):
(Vertical Analysis):
Year:
2021
2020
2019
Net Revenue:
100.00%
100.00%
100.00%
Cost of Sales:
46.65%
45.18%
44.87%
Gross Profit:
53.35%
54.82%
55.13%
Selling, General and administrative expenses:
39.30%
40.49%
39.81%
Operating Profit:
14.04%
14.32%
15.32%
Other pension and retiree medical benefits income/(expense)
0.66%
0.17%
-0.07%
Net Interest and other:
-2.34%
-1.60%
-1.39%
Income before Income taxes:
12.36%
12.89%
13.87%
Provision for Income Taxes:
2.70%
2.69%
2.92%
Net Income:
9.66%
10.20%
10.95%
Less: Net Income attributable to non controlling interests:
0.08%
0.08%
0.06%
Net Income Attrributable to PepsiCo:
9.59%
10.12%
10.89%
Net Income Attributable to PepsiCo per Common Share:
Basic:
0.01%
0.01%
0.01%
Diluted:
0.01%
0.01%
0.01%
Weighted-average common shares outstanding:
Basic:
1.74%
1.97%
2.08%
Diluted:
1.75%
1.98%
2.09%
PepsiCo. Analysis:
(2021:)
(2020:)
Ratio Analysis:
Ratio Analysis:
Assets:
2021 Period:
2020 Period:
2019 Period: (Income Statement):
Consolidated Balance Sheet:
Current Assets:
Consolidated Income Statement:
Consolidated Balance Sheet:
Cash and Equivalents:
$
5,596.00
$
8,185.00
Current Ratio:
0.830778032036613
0.984126304980319
(N/A)
Short-Term Investments:
$
392.00
$
1,366.00
Accounts and Notes Receivable, Net:
$
8,680.00
$
8,404.00
Inventories:
$
4,347.00
$
4,172.00
Formulas:
Prepaid expenses and other current assets:
$
980.00
$
874.00
Working Capital:
$
(4,437.00)
$
(371.00)
(N/A)
Assets held for Sale:
$
1,788.00
$
-
Total Current Assets:
$
21,783.00
$
23,001.00
Debt Ratio:
0.825162107450989
0.85415097182462
(N/A)
Property, Plant and Equipment, net:
$
22,407.00
$
21,369.00
Amortizable Intangible Assets, Net:
$
1,538.00
$
1,703.00
Goodwill:
$
18,381.00
$
18,757.00
other Indefinite-Lived Intangible Assets:
$
17,127.00
$
17,612.00
Equity Ratio:
0.174837892549011
0.14584902817538
(N/A)
Investments in NonControlled Affiliates:
$
2,627.00
$
2,792.00
Deferred Income Taxes:
$
4,310.00
$
4,372.00
Other Assets:
$
4,204.00
$
3,312.00
Gross Margin:
0.533495231144777
0.548158358438015
0.551346763746817
Income Statement (2021,2020,2019) (10-K):
Total Assets:
$
92,377.00
$
92,918.00
Income Statement:
Section
Year:
2021 (Current):
2020
2019 (Base Period):
Liabilities and Equity:
Net Revenue:
$
79,474.00 $
70,372.00 $
67,161.00
Current Liabilities:
Profit Margin:
0.096622794876312
0.101958165179333
0.109483182203958
Cost of Sales:
$
37,075.00 $
31,797.00 $
30,132.00
Gross Profit:
$
42,399.00 $
38,575.00 $
37,029.00
Short-term
debt obligations:
$
4,308.00
$
3,780.00
Selling, General and administrative expenses:
$
31,237.00 $
28,495.00 $
26,738.00
Accounts payable and other current liabilities:
$
21,159.00
$
19,592.00
Liabilities held for Sale:
$
753.00
$
-
Price Earnings Ratio:
Operating Profit:
$
11,162.00
$
10,080.00
$
10,291.00
Total Current Liabilities:
$
26,220.00
$
23,372.00
Other pension and retiree medical benefits income/(expense)
$
522.00 $
117.00 $
(44.00)
Net Interest and other:
$
(1,863.00)
$
(1,128.00)
$
(935.00)
Long-Term Debt Obligations:
$
36,026.00
$
40,370.00
(AR) Turnover:
9.30391009131351
8.23835167408101
7.86244439241395
Income before Income taxes:
$
9,821.00 $
9,069.00 $
9,312.00
Deferred Income Taxes:
$
4,826.00
$
4,284.00
Provision for Income Taxes:
$
2,142.00 $
1,894.00 $
1,959.00
Other Liabilities:
$
9,154.00
$
11,340.00
Net Income:
$
7,679.00
$
7,175.00
$
7,353.00
Total Liabilities:
$
76,226.00
$
79,366.00
Inventory Turnover:
8.70407324803381
7.4649606761357
7.07406972649372
Commitments and contingencies:
Less: Net Income attributable to non controlling interests:
$
61.00 $
55.00 $
39.00
Net Income Attrributable to PepsiCo:
$
7,618.00 $
7,120.00 $
7,314.00
PepsiCo Common Shareholders' Equity:
Net Income Attributable to PepsiCo per Common Share:
Common Stock, Par value 1/(2/3) per share
$
23.00
$
23.00
Basic:
$
5.51 $
5.14 $
5.23
(484 and 487 shares, resepctively):
$
4,001.00
$
3,910.00
Diluted:
$
5.49 $
5.12 $
5.20
Capital in excess of par value:
$
65,165.00
$
63,443.00
Weighted-average common shares outstanding:
Retained earnings:
$
(14,898.00)
$
(15,476.00)
Basic:
$
1,382.00 $
1,385.00 $
1,399.00
Accumulated common stock, in excess of par value
$
(38,248.00)
$
(38,446.00)
Diluted:
$
1,389.00 $
1,392.00 $
1,407.00
(484 and 487 shares, respectively):
Total PepsiCo Common Shareholders' Equity:
$
16,043.00
$
13,454.00
NonControlling interests:
$
108.00
$
98.00
Total Equity:
$
16,151.00
$
13,552.00
Total Liabilities and Equity:
$
92,377.00
$
92,918.00
Current Ratio
= (Current Assets / Current Liabilities)
Working Capital
= (Current Assets - Current Liabilities)
Debt Ratio
= (Total Liabilities / Total Assets)
Equity Ratio
= (Total Equity / Total Assets)
Gross Margin
= (Net Sales - Cost of Goods Sold) / (Net Sales)
Profit Margin
= (Net Income / Net Sales)
(PE) Price Earnings Ratio
= (Market Price Per Common Share / Earnings Per Share)
(AR) Accounts Receivable
= (Net Sales / averge accounts receivable, Net)
Inventory Turnover
= (Cost of Goods Sold / Average Inventory)
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
PepsiCo. Statement of Cash Flows:
PepsiCo., Inc. and Subisidiaries:
Fiscal Years ended December 25, 2021, December 26, 2020 adnd December 28, 2019
(in millions)
Statement of Cash Flows:
2021
Operating Activities:
Net Income:
$
7,679.00
Depreciation and amortization:
$
2,710.00
Operating lease right-of-use asset amortization:
$
505.00
Share-based lease right-of-use asset amortization:
$
301.00
Restructuring and impairment charges:
$
247.00
Cash payments for restructuring charges:
$
(256.00)
Acquisition and diverstiture-related charges:
$
(4.00)
Cash payments
for Aquisitionand and diversiture-related charges:
$
(176.00)
Pension and retiree medical plam expenses:
$
123.00
Pension and retir medical plan contributions:
$
(785.00)
Deferred income taxe
0
$
298.00
Tax expense/ (benefit) related to the TCJ Act:
$
190.00
Tax payments related to the TCJ Act:
$
(309.00)
Change in assets and liabilities:
Accounts and Notes Receivable:
$
(651.00)
Inventories:
$
(582.00)
Prepaid expenses and other current assets:
$
159.00
Accounts payable and other current liabilities:
$
1,762.00
Income Taxes Payable:
$
30.00
Other, net:
$
375.00
Net Cash Provided by Operating Activities:
$
11,616.00
Investing Activities:
Capital Spending:
$
(4,625.00)
Sales of property, plant and equipment:
$
166.00
Acquisitions, net of cash ascquired, and investments in noncontorlled affiliates:
$
(61.00)
Divestitures and sales of investments in noncontrolled affiliates:
$
169.00
short-term investmens, by original maturity:
More than three months - purchases:
$
-
More than three months - maturities:
$
1,135.00
More than three months - sales:
$
-
Three months or less, net:
$
(58.00)
Other investing, net:
$
5.00
Net Cash Used for Investing Activities:
$
(3,269.00)
Financing Activities:
Proceeds from issuances of long-term debt:
$
4,122.00
Payments of long-term debt:
$
(3,455.00)
Cas hTender offers/debt redemption:
$
(4,844.00)
Short-term borrowings, by original maturity:
More than three months - proceeds:
$
8.00
More than three months - payments:
$
(397.00)
Three months or less, net:
$
434.00
Payments of acquisition-related contingent consideration:
$
(773.00)
Cash dividends paid:
$
(5,815.00)
Share repurchases - common:
$
(106.00)
Proceeds from exercises of stock options:
$
185.00
Withholding tax payments on restricted stock units (RSUs) and performance stock unit
$
(92.00)
Other financing:
$
(47.00)
Net Cash (Used for)/Provided by financing activities:
$
(10,780.00)
Effect of exchange rate changes on cash and cash equivalents and restricted cash:
$
(114.00)
Net (Decrease)/ Increase in Cash and Cash Equivalents and Restricted Cash:
$
(2,547.00)
Cash and Cash Equivalents and Restricted Cash, Beginning of Year:
$
8,254.00
Cash and Cash Equivalents and Restricted Cash, End of Year:
$
5,707.00
2020
2019
2021
2020
Dollar Change
$
7,175.00
$
7,353.00
$
326.00
$
(178.00)
$
2,548.00
$
2,432.00
$
278.00
$
116.00
$
478.00
$
412.00
$
93.00
$
66.00
$
264.00
$
237.00
$
64.00
$
27.00
$
289.00
$
370.00
$
(123.00)
$
(81.00)
$
(255.00)
$
(350.00)
$
94.00
$
95.00
$
255.00
$
55.00
$
(59.00)
$
200.00
$
(131.00)
$
(10.00)
$
(166.00)
$
(121.00)
$
408.00
$
519.00
$
(396.00)
$
(111.00)
$
(562.00)
$
(716.00)
$
(69.00)
$
154.00
$
361.00
$
453.00
$
(155.00)
$
(92.00)
$
-
$
(8.00)
$
198.00
$
8.00
$
(78.00)
$
(423.00)
$
114.00
$
345.00
$
-
$
-
$
(420.00)
$
(650.00)
$
(1.00)
$
230.00
$
(516.00)
$
(190.00)
$
(392.00)
$
(326.00)
$
26.00
$
(87.00)
$
246.00
$
113.00
$
766.00
$
735.00
$
1,027.00
$
31.00
$
(159.00)
$
(287.00)
$
317.00
$
128.00
$
164.00
$
(196.00)
$
571.00
$
360.00
$
-
$
-
$
10,613.00
$
9,649.00
$
1,967.00
$
964.00
$
-
$
-
$
-
$
-
$
(4,240.00)
$
(4,232.00)
$
(393.00)
$
(8.00)
$
55.00
$
170.00
$
(4.00)
$
(115.00)
$
(6,372.00)
$
(2,717.00)
$
2,656.00
$
(3,655.00)
$
6.00
$
253.00
$
(84.00)
$
(247.00)
$
-
$
-
$
(1,135.00)
$
-
$
-
$
(1,135.00)
$
-
$
16.00
$
1,119.00
$
(16.00)
$
-
$
62.00
$
(62.00)
$
(62.00)
$
27.00
$
19.00
$
(77.00)
$
8.00
$
40.00
$
(8.00)
$
13.00
$
48.00
$
(11,619.00)
$
(6,437.00)
$
3,168.00
$
(5,182.00)
$
-
$
-
$
-
$
-
$
13,809.00
$
4,621.00
$
(499.00)
$
9,188.00
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
$
(1,830.00)
$
(3,970.00)
$
515.00
$
2,140.00
$
(1,100.00)
$
(1,007.00)
$
(3,837.00)
$
(93.00)
$
-
$
-
$
4,077.00
$
6.00
$
2.00
$
4,071.00
$
(3,554.00)
$
(2.00)
$
(395.00)
$
(3,552.00)
$
(109.00)
$
(3.00)
$
437.00
$
(106.00)
$
-
$
-
$
(773.00)
$
-
$
(5,509.00)
$
(5,304.00)
$
(511.00)
$
(205.00)
$
(2,000.00)
$
(3,000.00)
$
2,894.00
$
1,000.00
$
179.00
$
329.00
$
(144.00)
$
(150.00)
$
(96.00)
$
(114.00)
$
22.00
$
18.00
$
(48.00)
$
(45.00)
$
(2.00)
$
(3.00)
$
-
$
-
$
3,819.00
$
(8,489.00)
$
(2,291.00)
$
12,308.00
$
(129.00)
$
78.00
$
(192.00)
$
(207.00)
$
2,684.00
$
(5,199.00)
$
2,652.00
$
7,883.00
$
5,570.00
$
10,769.00
$
(2,515.00)
$
(5,199.00)
$
8,254.00
$
5,570.00
$
137.00
$
2,684.00
2019
$
-
$
-
Inter Company Analysis:
$
-
Cash provided (used) by operating activities:
$
-
Cash provided (used) by investing activities:
$
-
Proceeds from sale of plant assets:
$
-
Purchase of plant assets:
$
-
Cash provided from issuance of debt:
$
-
proceeds of issuance of long-term debt:
$
-
Repayment of long term debt:
$
-
$
-
Net increase (decrease) in cash:
$
-
$
-
$
-
$
-
Company
$
-
PepsiCo.
$
-
$
-
$
-
$
-
$
-
Kroger:
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
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
Cash Flows of Competing Companies (in millions):
PepsiCo. Cash F
2021 Period
$
11,616.00
$
(3,269.00)
$
166.00
$
-
$
-
$
4,122.00
$
(3,455.00)
$
9,180.00
Cash Flow on Total Assets for Two Competitors:
Figure ($) millions:
2021 Period
2020 Period
2019 Period
Operating Cash Flows:
$
11,616.00 $
10,613.00 $
9,649.00
Average Total Assets:
$
92,647.50 $
92,647.50 (N/A)
If Applicable
Cash Flow on Total Assets:
13%
11%
#VALUE!
Operating Cash Flows:
$
6,190.00 $
6,815.00 $
4,664.00
Average total assets:
$
48,874.00 $
48,874.00 (N/A)
If Applicable
Cash Flow on Total Assets:
13%
14%
#VALUE!
Flow Oprtng Sum
Kroger:
2020 Period
2021 Period
2020 Period
$
10,613.00
$
6,190.00 $
6,815.00
$
(11,619.00)
$
(2,611.00) $
(2,814.00)
$
55.00
$
153.00 $
165.00
$
(1,135.00)
$
(2,614.00) $
(2,865.00)
$
-
$
-
$
-
$
13,809.00
$
56.00 $
1,049.00
$
(1,830.00)
$
(1,442.00) $
(747.00)
$
9,893.00
$
(268.00)
$
1,603.00
The Kroger Company:
Consolidated Balance Sheets:
(in millions, except par amounts)
Saturday, January 29, 2022
Saturday, January 30, 2021
($) Dollar Change:
(%) Percent Change:
Common Size (Vertical Analysis):
Assets:
(Current Period - Base Period):
(Current Period - Base Period)/(Base Period)x100%:
(Variable Needed / Asset) x 100%
Current Assets:
2022-2021
2022-2021
2022
2021
Cash and Temporary cash investments:
$
1,821.00 $
1,687.00
$
134.00
7.94%
3.71%
3.47%
Store deposits in-transit:
$
1,082.00 $
1,096.00
$
(14.00)
-1.28%
2.20%
2.25%
Receivables:
$
1,828.00 $
1,781.00
$
47.00
2.64%
3.72%
3.66%
FIFO Inventory :
$
8,353.00 $
8,436.00
$
(83.00)
-0.98%
17.02%
17.34%
LIFO Reserve:
$
(1,570.00) $
(1,373.00)
$
(197.00)
14.35%
-3.20%
-2.82%
Prepaid and other current assets:
$
660.00 $
876.00
$
(216.00)
-24.66%
1.34%
1.80%
Total current Assets:
$
12,174.00 $
12,503.00
$
(329.00)
-2.63%
24.80%
25.69%
Property, plant and equipment, net:
$
23,789.00 $
22,386.00
$
1,403.00
6.27%
48.46%
46.00%
Operating lease assets:
$
6,695.00 $
6,796.00
$
(101.00)
-1.49%
13.64%
13.97%
Intangibles, net:
$
942.00 $
997.00
$
(55.00)
-5.52%
1.92%
2.05%
Goodwill:
$
3,076.00 $
3,076.00
$
-
0.00%
6.27%
6.32%
Other Assets:
$
2,410.00 $
2,904.00
$
(494.00)
-17.01%
4.91%
5.97%
Total Assets:
$
49,086.00 $
48,662.00
$
424.00
0.87%
100.00%
100.00%
Liabilities:
Current Liabilities:
Current portion of long-term debt including obligations under finance leases:
$
555.00 $
911.00
$
(356.00)
-39.08%
1.13%
1.87%
Current portion of operating lease liabilities:
$
650.00 $
667.00
$
(17.00)
-2.55%
1.32%
1.37%
Trade Accounts payable:
$
7,117.00 $
6,679.00
$
438.00
6.56%
14.50%
13.73%
Accrued salaries and wages:
$
1,736.00 $
1,413.00
$
323.00
22.86%
3.54%
2.90%
other current liabilities:
$
6,265.00 $
5,696.00
$
569.00
9.99%
12.76%
11.71%
Total current liabilities:
$
16,323.00 $
15,366.00
$
957.00
6.23%
33.25%
31.58%
Long-term debt including obligations under finance leases:
$
12,809.00 $
12,502.00
$
307.00
2.46%
26.10%
25.69%
Noncurrent operating lease liabilities:
$
6,426.00 $
6,507.00
$
(81.00)
-1.24%
13.09%
13.37%
Deferred income taxes:
$
1,562.00 $
1,542.00
$
20.00
1.30%
3.18%
3.17%
Pension and postretirrement benefit obligations:
$
478.00 $
535.00
$
(57.00)
-10.65%
0.97%
1.10%
Other long-term liabilities:
$
2,059.00 $
2,660.00
$
(601.00)
-22.59%
4.19%
5.47%
Total laiabilities:
$
39,657.00 $
39,112.00
$
545.00
1.39%
80.79%
80.37%
.
commitments and contingencies see Note 12:
Shareholders' Equity:
Preferred shares, $100 par per share, 5 shares authorized and unissued:
$
-
$
-
$
-
#DIV/0!
0.00%
0.00%
Comon shares, $ par per share, 2000 share authorized, 1.918 shares issued in 2021 nad 2020:
$
1,918.00 $
1,918.00
$
-
0.00%
3.91%
3.94%
Additional paid-in Capital:
$
3,657.00 $
3,461.00
$
196.00
5.66%
7.45%
7.11%
Accumulated other comprehensive loss:
$
(467.00) $
(630.00)
$
163.00
-25.87%
-0.95%
-1.29%
Accumulated Earnings:
$
24,066.00 $
23,018.00
$
1,048.00
4.55%
49.03%
47.30%
Common shares in treasury, at cost, 1,191 shares in 2021 and 1,160 shares in 2020:
$
(19,722.00) $
(18,191.00)
$
(1,531.00)
8.42%
-40.18%
-37.38%
Total Shareholders' Equity - The Kroger Co:
$
9,452.00 $
9,576.00
$
(124.00)
-1.29%
19.26%
19.68%
NonControlling interests:
$
(23.00) $
(26.00)
$
3.00
-11.54%
-0.05%
-0.05%
Total Equity:
$
9,429.00 $
9,550.00
$
(121.00)
-1.27%
19.21%
19.63%
Tota Liabilities and Equity:
$
49,086.00 $
48,662.00
$
424.00
0.87%
100.00%
100.00%
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
The Kroger Company:
Consolidated Statements of Operations:
Years Ended January 29, 2022, January 30, 2021, and February 1, 2020:
(In millions, except per share amounts):
($) Dollar Change: (Current Period - Base Period):
(%) Change: (Current Period - Base period)/(Base Period):
(%) Trend Analysis: (Current Period/ Base Period):
Revenue:
(2021: 52 weeks)
(2020: 52 weeks)
(2019: 52 weeks)
2021-2019
2020-2019 if needed
2021-2019
2020-2019 if needed
2021
2020
2019
Sales:
$
137,888.00
$
132,498.00
$
122,286.00
$
15,602.00
$
10,212.00
12.76%
8.35%
112.76%
108.35%
100.00%
Operating expenses:
Merchandise Costs, including advertising, warehousing, and transportation,
excluding items shown seperately below:
$
107,539.00
$
101,597.00
$
95,294.00
$
12,245.00
$
6,303.00
12.85%
6.61%
112.85%
106.61%
100.00%
Operating, general and administrative:
$
23,203.00
$
24,500.00
$
21,208.00
$
1,995.00
$
3,292.00
9.41%
15.52%
109.41%
115.52%
100.00%
Rent:
$
845.00
$
874.00
$
884.00
$
(39.00)
$
(10.00)
-4.41%
-1.13%
95.59%
98.87%
100.00%
Depreciation and amortization:
$
2,824.00
$
2,747.00
$
2,649.00
$
175.00
$
98.00
6.61%
3.70%
106.61%
103.70%
100.00%
Operating profit:
$
3,477.00
$
2,780.00
$
2,251.00
$
1,226.00
$
529.00
54.46%
23.50%
154.46%
123.50%
100.00%
Other income (expense):
Interest expense:
$
(571.00)
$
(544.00)
$
(603.00)
$
32.00
$
59.00
-5.31%
-9.78%
94.69%
90.22%
100.00%
Non-service component of company-sponsored pension plan (costs)
benefits:
$
(34.00)
$
29.00
$
-
$
(34.00)
$
29.00
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
(Loss) gain on investments:
$
(821.00)
$
1,105.00
$
157.00
$
(978.00)
$
948.00
-622.93%
603.82%
-522.93%
703.82%
100.00%
Gain on saloe of businesses:
$
-
$
-
$
176.00
$
(176.00)
$
(176.00)
-100.00%
-100.00%
0.00%
0.00%
100.00%
Net earnings before income tax expense:
$
2,051.00
$
3,370.00
$
1,981.00
$
70.00
$
1,389.00
3.53%
70.12%
103.53%
170.12%
100.00%
Income tax expense:
$
385.00
$
782.00
$
469.00
$
(84.00)
$
313.00
-17.91%
66.74%
82.09%
166.74%
100.00%
Net earnings including noncontrolling interests:
$
1,666.00
$
2,588.00
$
1,512.00
$
154.00
$
1,076.00
10.19%
71.16%
110.19%
171.16%
100.00%
Net income (loss) attributable to noncontrolling interests:
$
11.00
$
3.00
$
(147.00)
$
158.00
$
150.00
-107.48%
-102.04%
-7.48%
-2.04%
100.00%
Net earnings attributable to The Kroger Co:
$
1,655.00
$
2,585.00
$
1,659.00
$
(4.00)
$
926.00
-0.24%
55.82%
99.76%
155.82%
100.00%
Net earnings attributable to The Kroger Co. per basic common share:
$
2.20
$
3.31
$
2.05
$
0.15
$
1.26
7.32%
61.46%
107.32%
161.46%
100.00%
Average number of common shares used in basic calculation:
$
744.00
$
773.00
$
799.00
$
(55.00)
$
(26.00)
-6.88%
-3.25%
93.12%
96.75%
100.00%
Net earnings attributable to The Kroger Co. per diluted common share:
$
2.17
$
3.27
$
2.04
$
0.13
$
1.23
6.37%
60.29%
106.37%
160.29%
100.00%
Average number of common shares used in diluted calculation:
$
754.00
$
781.00
$
805.00
$
(51.00)
$
(24.00)
-6.34%
-2.98%
93.66%
97.02%
100.00%
Revenue:
Common Size Statements of Operations: (Vertical Analysis):
Sales:
100.00%
100.00%
100.00%
Operating expenses:
Merchandise Costs, including advertising, warehousing, and transportation,
excluding items shown seperately below:
77.99%
76.68%
77.93%
Operating, general and administrative:
16.83%
18.49%
17.34%
Rent:
0.61%
0.66%
0.72%
Depreciation and amortization:
2.05%
2.07%
2.17%
Operating profit:
2.52%
2.10%
1.84%
Other income (expense):
Interest expense:
-0.41%
-0.41%
-0.49%
Non-service component of company-sponsored pension plan (costs)
benefits:
-0.02%
0.02%
0.00%
(Loss) gain on investments:
-0.60%
0.83%
0.13%
Gain on saloe of businesses:
0.00%
0.00%
0.14%
Net earnings before income tax expense:
1.49%
2.54%
1.62%
Income tax expense:
0.28%
0.59%
0.38%
Net earnings including noncontrolling interests:
1.21%
1.95%
1.24%
Net income (loss) attributable to noncontrolling interests:
0.01%
0.00%
-0.12%
Net earnings attributable to The Kroger Co:
1.20%
1.95%
1.36%
Net earnings attributable to The Kroger Co. per basic common share:
0.00%
0.00%
0.00%
Average number of common shares used in basic calculation:
0.54%
0.58%
0.65%
Net earnings attributable to The Kroger Co. per diluted common share:
0.00%
0.00%
0.00%
Average number of common shares used in diluted calculation:
0.55%
0.59%
0.66%
Kroger Analysis:
Saturday, January 29, 2022
Saturday, January 30, 2021
Ratio Analysis:
Assets:
Revenue:
Consolidated Balance Sheet:
Current Assets:
Sales:
Consolidated Income Statement:
Cash and Temporary cash investments:
$
1,821.00 $
1,687.00
Store deposits in-transit:
$
1,082.00 $
1,096.00 Operating expenses:
Receivables:
$
1,828.00 $
1,781.00 Merchandise Costs, including advertising, warehousing, and transportation,
FIFO Inventory :
$
8,353.00 $
8,436.00 excluding items shown seperately below:
LIFO Reserve:
$
(1,570.00)
$
(1,373.00) Operating, general and administrative:
Formulas:
Prepaid and other current assets:
$
660.00 $
876.00 Rent:
Total current Assets:
$
12,174.00 $
12,503.00
Depreciation and amortization:
Property, plant and equipment, net:
$
23,789.00 $
22,386.00
Operating profit:
Operating lease assets:
$
6,695.00 $
6,796.00
Intangibles, net:
$
942.00 $
997.00 Other income (expense):
Goodwill:
$
3,076.00 $
3,076.00 Interest expense:
Other Assets:
$
2,410.00 $
2,904.00 Non-service component of company-sponsored pension plan (costs)
Total Assets:
$
49,086.00 $
48,662.00
benefits:
(Loss) gain on investments:
Liabilities:
Gain on saloe of businesses:
Current Liabilities:
Current portion of long-term debt including obligations under finance leases:
$
555.00 $
911.00
Net earnings before income tax expense:
Current portion of operating lease liabilities:
$
650.00 $
667.00
Trade Accounts payable:
$
7,117.00 $
6,679.00 Income tax expense:
Accrued salaries and wages:
$
1,736.00 $
1,413.00
other current liabilities:
$
6,265.00 $
5,696.00
Net earnings including noncontrolling interests:
Total current liabilities:
$
16,323.00 $
15,366.00
Net income (loss) attributable to noncontrolling interests:
Long-term debt including obligations under finance leases:
$
12,809.00 $
12,502.00
Noncurrent operating lease liabilities:
$
6,426.00 $
6,507.00
Net earnings attributable to The Kroger Co:
Deferred income taxes:
$
1,562.00 $
1,542.00
Pension and postretirrement benefit obligations:
$
478.00 $
535.00 Net earnings attributable to The Kroger Co. per basic common share:
Other long-term liabilities:
$
2,059.00 $
2,660.00
Average number of common shares used in basic calculation:
Total laiabilities:
$
39,657.00 $
39,112.00
.
Net earnings attributable to The Kroger Co. per diluted common share:
commitments and contingencies see Note 12:
Average number of common shares used in diluted calculation:
Shareholders' Equity:
Preferred shares, $100 par per share, 5 shares authorized and unissued:
$
-
$
-
2022 Period:
2
Common shares, $1 par per share, 2000 share authorized, 1,918 shares issued in 2021 nad 2020:
$
1,918.00 $
1,918.00
Additional paid-in Capital:
$
3,657.00 $
3,461.00
Accumulated other comprehensive loss:
$
(467.00)
$
(630.00)
Current Ratio:
0.745818783311891
0.813
Accumulated Earnings:
$
24,066.00 $
23,018.00
Common shares in treasury, at cost, 1,191 shares in 2021 and 1,160 shares in 2020:
$
(19,722.00)
$
(18,191.00)
Total Shareholders' Equity - The Kroger Co:
$
9,452.00 $
9,576.00
Working Capital:
$
(4,149.00)
$
NonControlling interests:
$
(23.00)
$
(26.00)
Total Equity:
$
9,429.00 $
9,550.00
Debt Ratio:
0.807908568634641
0.803
Tota Liabilities and Equity:
$
49,086.00 $
48,662.00
Equity Ratio:
0.192091431365359
0.196
Gross Margin:
(N/A)
0.220
Income Statement:
Section
Profit Margin:
(N/A)
0.012
Price Earnings Ratio:
871.
(AR) Turnover:
(N/A)
76.4
Inventory Turnover:
(N/A)
12.8
Current Ratio
= (Current Assets / Current Liabilities)
Working Capital
= (Current Assets - Current Liabilities)
Debt Ratio
= (Total Liabilities / Total Assets)
Equity Ratio
= (Total Equity / Total Assets)
Gross Margin
= (Net Sales - Cost of Goods Sold) / (Net Sales)
Profit Margin
= (Net Income / Net Sales)
(PE) Price Earnings Ratio
= (Market Price Per Common Share / Earnings Per Share)
(AR) Accounts Receivable
= (Net Sales / averge accounts receivable, Net)
Inventory Turnover
= (Cost of Goods Sold / Average Inventory)
(2021: 52 weeks)
(2020: 52 weeks)
(2019: 52 weeks)
$
137,888.00
$
132,498.00
$
122,286.00
$
107,539.00
$
101,597.00
$
95,294.00
$
23,203.00
$
24,500.00
$
21,208.00
$
845.00
$
874.00
$
884.00
$
2,824.00
$
2,747.00
$
2,649.00
$
3,477.00
$
2,780.00
$
2,251.00
$
(571.00)
$
(544.00)
$
(603.00)
$
(34.00)
$
29.00
$
-
$
(821.00)
$
1,105.00
$
157.00
$
-
$
-
$
176.00
$
2,051.00
$
3,370.00
$
1,981.00
$
385.00
$
782.00
$
469.00
$
1,666.00
$
2,588.00
$
1,512.00
$
11.00
$
3.00
$
(147.00)
$
1,655.00
$
2,585.00
$
1,659.00
$
2.20
$
3.31
$
2.05
$
744.00
$
773.00
$
799.00
$
2.17
$
3.27
$
2.04
$
754.00
$
781.00
$
805.00
Ratio Analysis:
021 Period:
2020 Period:
2019 Period: (Income Statement):
3679552258232
(N/A)
(N/A)
(2,863.00)
(N/A)
(N/A)
3748304631951
(N/A)
(N/A)
6251695368049
(N/A)
(N/A)
0098920863309
0.233218614620598
0.220728456241925
2082269668137
0.019532370299929
0.01236445709239
.818181818182
579.456193353474
935.609756097561
4134109171516
73.426433915212
67.7672485453034
810649830246
12.1028054083031
11.3519566382751
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
The Kroger Company:
Consolidated Satatements of Cash Flows:
Years Ended January 29, 2022, January 30, 2021 and February 1, 2020:
(In millions)
Cash Flow form Operating noncontrolling Activites:
Net earnings including noncontrolling interests:
Adjustments to reconcile net earnings including noncontrolling interests to net cash provid
Depreciation and Amortization:
Asset Impairment Charges:
Operating lease asset amortization:
LIFO charge (credit)
Share-based employee compensation:
Company-Sponsored pension plans expense (benefits)
Deferred income Taxes:
Gain on ale of businesses:
Gain on the sale of assets:
Loss (gain) on investments:
Loss on deconsolidation and impairment of Lucky's market:
Other:
Changes in operating assets and liabilities net of effects from mergers and disposals of bus
Store deposits:
Receivables:
Inventories:
Prepaid and other current assetsL
Trade accounts payable:
Accrued expenses:
Omcp,e Taxes receivable and payable:
Operating lease liabilities:
Proceeds from contract associated with sale of business:
Other:
Net Cash provided by operating activities:
Cash Flows from Investing Activities:
Payments for property and equipment, including payments for leave buyouts:
Proceeds from sale of assets:
Net proceeds from sale of business:
Other:
Net Cash used by investing activities:
Cash Flows from Financing Activities:
Proceeds from isuance of long-term debt:
Payments on long-term debt including obligations under finance leases:
Net (payments) proceeds on commercial paper:Dividends paid:
Proceeds from issuance of capital stock
Treasury Stock purchases:
Proceeds from financing arrangement:
Other:
Net Cash used by financing activities:
Net increase (decrease) in cash and temporary cash investments:
Cash and temporary cash investments:
Beginning of year:
End of year:
Reconciliation of capital investments:
Payments for property nad equipment, including payments for lease buyouts:
Payments for lease buyouts:
Changes in construction-in-progress payables:
Total capital investments, excluding lease buyouts:
Disclosure of cash flow information:
Cash paid during the year for interest:
Cash paid during the year for income taxes:
Cash Flows of Competing Companies:
PepsiCo. Cash Flow Oprtm
Inter Company Analysis:
2021
2020
Cash provided (used) by operating activities:
Cash provided (used) by investing activities:
Proceeds from sale of plant assets:
Purchase of plant assets:
Cash provided from issuance of debt:
proceeds of issuance of debt:
Repayment of debt:
Net increase (decrease) in cash:
2021
2020
$
1,666.00
$
2,588.00
ded by operating activities:
$
2,824.00
$
2,747.00
$
64.00
$
70.00
$
605.00
$
626.00
$
197.00
$
(7.00)
$
203.00
$
185.00
$
50.00
$
(9.00)
$
(31.00)
$
73.00
$
-
$
-
$
(44.00)
$
(59.00)
$
821.00
$
(1,105.00)
$
-
$
-
$
64.00
$
165.00
siness:
$
13.00
$
83.00
$
(61.00)
$
(90.00)
$
80.00
$
7.00
$
232.00
$
(342.00)
$
438.00
$
330.00
$
331.00
$
1,382.00
$
16.00
$
24.00
$
(618.00)
$
(552.00)
$
-
$
-
$
(660.00)
$
699.00
$
6,190.00
$
6,815.00
$
(2,614.00)
$
(2,865.00)
$
153.00
$
165.00
$
-
$
-
$
(150.00)
$
(114.00)
$
(2,611.00)
$
(2,814.00)
$
56.00
$
1,049.00
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
$
(1,442.00)
$
(747.00)
$
-
$
(1,150.00)
$
(589.00)
$
(534.00)
$
172.00
$
127.00
$
(1,647.00)
$
(1,324.00)
$
166.00
$
-
$
(161.00)
$
(134.00)
$
(3,445.00)
$
(2,713.00)
$
134.00
$
1,288.00
$
1,687.00
$
399.00
$
1,821.00
$
1,687.00
$
(2,614.00)
$
(2,865.00)
$
-
$
58.00
$
(542.00)
$
(359.00)
$
(3,156.00)
$
(3,166.00)
$
607.00
$
564.00
$
513.00
$
659.00
mg Sum
Kroger:
2021
2020
$
6,190.00 $
6,815.00
$
(2,611.00)
$
(2,814.00)
$
153.00 $
165.00
$
-
$
-
$
-
$
-
$
(1,442.00)
$
(747.00)
$
-
$
(1,150.00)
$
2,290.00
$
2,269.00
2019
2021 - Base
2020 - Base (if needed)
$
1,512.00
$
154.00
$
1,076.00
$
2,649.00
$
175.00
$
98.00
$
120.00
$
(56.00)
$
(50.00)
$
640.00
$
(35.00)
$
(14.00)
$
105.00
$
92.00
$
(112.00)
$
155.00
$
48.00
$
30.00
$
39.00
$
11.00
$
(48.00)
$
(56.00)
$
25.00
$
129.00
$
(176.00)
$
176.00
$
176.00
$
(158.00)
$
114.00
$
99.00
$
(157.00)
$
978.00
$
(948.00)
$
412.00
$
(412.00)
$
(412.00)
$
(109.00)
$
173.00
$
274.00
$
3.00
$
10.00
$
80.00
$
(36.00)
$
(25.00)
$
(54.00)
$
(351.00)
$
431.00
$
358.00
$
(33.00)
$
265.00
$
(309.00)
$
342.00
$
96.00
$
(12.00)
$
302.00
$
29.00
$
1,080.00
$
(142.00)
$
158.00
$
166.00
$
(639.00)
$
21.00
$
87.00
$
295.00
$
(295.00)
$
(295.00)
$
(53.00)
$
(607.00)
$
752.00
$
-
$
-
$
4,664.00
$
1,526.00
$
2,151.00
$
-
$
-
$
(3,128.00)
$
514.00
$
263.00
$
273.00
$
(120.00)
$
(108.00)
$
327.00
$
(327.00)
$
(327.00)
$
(83.00)
$
(67.00)
$
(31.00)
$
(2,611.00)
$
-
$
(203.00)
$
813.00
$
(757.00)
$
236.00
$
(2,304.00)
$
862.00
$
1,557.00
$
350.00
$
(350.00)
$
(1,500.00)
$
(486.00)
$
(103.00)
$
(48.00)
$
55.00
$
117.00
$
72.00
$
(465.00)
$
(1,182.00)
$
(859.00)
$
-
$
166.00
$
-
$
(46.00)
$
(115.00)
$
(88.00)
$
(2,083.00)
$
(1,362.00)
$
(630.00)
$
(30.00)
$
164.00
$
1,318.00
$
-
$
-
$
-
$
-
$
429.00
$
1,258.00
$
(30.00)
$
399.00
$
1,422.00
$
1,288.00
$
-
$
-
$
(3,128.00)
$
514.00
$
263.00
$
82.00
$
(82.00)
$
(24.00)
$
2.00
$
(544.00)
$
(361.00)
$
(3,044.00)
$
(112.00)
$
(122.00)
$
-
$
-
$
523.00
$
84.00
$
41.00
$
706.00
$
(193.00)
$
(47.00)
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
2019 (Base)
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
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
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
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 Documents
Related Questions
A comparative balance sheet for Gena Company appears below:GENA COMPANYComparative Balance SheetDec. 31, 2021 Dec. 31, 2020AssetsCash $ 34,000 $11,000Accounts receivable 21,000 13,000Inventory 35,000 17,000Prepaid expenses 6,000 9,000Long-term investments -0- 17,000Equipment 60,000 33,000Accumulated depreciation—equipment (20,000) (15,000)Total assets $136,000 $85,000Liabilities and Stockholders' EquityAccounts payable $ 17,000 $ 7,000Bonds payable 36,000 45,000Common stock 53,000 23,000Retained earnings 30,000 10,000Total liabilities and stockholders' equity $136,000 $85,000Additional information:1. Net income for the year ending December 31, 2021 was $35,000.2. Cash dividends of $15,000 were declared and paid during the year.3. Long-term investments that had a cost of $17,000 were sold for $14,000.4. Depreciation expense for the year was $5,000.InstructionsPrepare a full statement of cash flows for the year ended December 31, 2021, using the indirectmethod.
arrow_forward
Selected 2020 balance sheet and income statement information for Vkusno & Tochka Corporation and Tasty Treats, Inc., follows.
($ millions)
Vkusno & Tochka
Tasty Treats
Sales Revenue Interest Expense Net Income Average Total Assets
$96,040
$6,090
$27,786
$294,060
28,260
2,715
5,309
32,549
a. Compute the return on assets (ROA) for each company. Use the 25% statutory tax rate.
Note: Round your answers to the nearest million dollars.
Numerator ($ millions) + Denominator ($ millions)
0+ $
0+$
Vkusno & Tochka's ROA $
Tasty Treats' ROA $
Vkusno & Tochka's PM $
Tasty Treats' PM
Vkusno & Tochka's ROA
Tasty Treats' ROA
b. Disaggregate ROA into profit margin (PM) and asset turnover (AT) for each company.
• Note: Round your answers to the nearest million dollars.
$
Vkusno & Tochka's AT $
Tasty Treats' AT
$
Numerator ($ millions) + Denominator ($ millions)
0$
05
0+$
0+ $
PM
X
% x
% X
0
AT
c. Discuss any differences in these ratios for each company.
has the lower ROA ratio.
has the higher PM ratio.…
arrow_forward
view Policies
Current Attempt in Progress
Using these data from the comparative balance sheet of Cullumber Company, perform vertical analysis. (Round percentages to 1 decimal
place, e.g. 12.5%.)
Dec. 31, 2022
Dec. 31, 2021
Amount
Percentage
Amount
Percentage
Accounts receivable
$ 467,400
$ 410,000
Inventory
$ 785,400
%
$ 660,000
%
Total assets
$3,197,900
%
$2,830,000
%
eTextbook and Media
Save for Later
Attempts: 0 of 3 used
Submit Answer
arrow_forward
Required:a. Calculate the following ratios for Sweets plc for 2021 and 2020, showing the formulas and workings:1- ROCE2- ROE3- Earnings per share4- Net profit margin5- Asset turnover6- Stock holding days7- Debtors collection period8- Current ratio9- Gearing ratio10- Interest cover
arrow_forward
From the French Instrument Corporation second-quarter report ended 2020, do a vertical analysis for the second quarter of 2020. (Input all answers as positive values except other (income) which should be indicated by a minus sign. Round your answers to the nearest hundredth percent.)
FRENCH INSTRUMENT CORPORATION AND SUBSIDIARIES
Consolidated Statements of Operation
(Unaudited) (In thousands of dollars, except share data)
Second Quarter
2020
2019
Percent of net
Net sales
$6,698
$6,951
Cost of sales
4,089
4,462
Gross margin
2,609
2,489
Expenses:
Selling, general and administrative
1,845
1,783
Product development
175
165
Interest expense
98
123
Other (income), net
(172)
(99)
Total expenses
1,946
1,972
Income before income taxes
663
517
Provision for income taxes
265
209
Net income
$398
$308
Net income per common share*
$0.05
$0.03
Weighted average number of common shares and equivalents
6,673,673…
arrow_forward
Problem 17-2A (Algo) Ratios, common-size statements, and trend percer
[The following information applies to the questions displayed below.]
Selected comparative financial statements of Korbin Company follow.
KORBIN COMPANY
Comparative Income Statements
For Years Ended December 31
Sales
Cost of goods sold
Gross profit
Selling expenses
Administrative expenses
Total expenses
Income before taxes
Income tax expense
Net income
Assets
Current assets
Long-term investments
Plant assets, net
Total assets
Liabilities and Equity
Current liabilities
Common stock
Other paid-in capital
Retained earnings
Total liabilities and equity
2021
$546,242
328,838
217,404
77,566
49,162
126,728
90,676
16,866
$ 73,810
Sales
Cost of goods sold
Gross profit
Selling expenses
Administrative expenses
Total expenses
Income before taxes
Income tax expense
Net income
KORBIN COMPANY
Comparative Balance Sheets
December 31
2020
$ 418,466
263,634
2021
%
154,832
57,748
36,825
94,573
60, 259
12,353
$ 47,906
%
$61,141
0
113,547…
arrow_forward
2. Calculate each ratio for Company A using the 2020 information from the balance sheets and income
statements given below.
Current Ratio
Quick Ratio
Debt/Equity
Times Interest Earned
Inventory Turnover
Return on Assets (ROA)
Return on Equity (ROE)
Market-to-book Ratio
Company A Consolidated Balance Sheet (in thousands)
December 31
2020
2019
Assets
Current Assets:
Cash and Cash Equivalents
$380,626
$349,953
Accounts Receivable, net
$80,545
$62,312
Inventory
$30,096
$21,555
Prepaid Expenses and other current assets
$57,076
$54,129
Total Current Assets
$548,343
$914,794
Property and Equipment
$1,458,690
$1,379,254
Operating Lease Assets
$2,800,222
$1,258,293
arrow_forward
Suppose the following financial data were reported by 3M Company for 2019 and 2020 (dollars in millions).
3M CompanyBalance Sheets (partial)
2020
2019Current assets
Cash and cash equivalents
$3,180
$1,836Accounts receivable, net
3,600
3,180Inventories
2,738
3,019Other current assets
1,932
1,590Total current assets
$11,450
$9,625Current liabilities
$4,830
$5,887
Calculate the current ratio and working capital for 3M for 2019 and 2020. (Round current ratio to 2 decimal places, e.g. 1.25 : 1. Enter working capital answers to million.)
Current ratio
2019
:12020
:1
Working capital
2019
$
million2020
$
million
Link to Text
arrow_forward
Pharoah Corporation’s comparative balance sheet is presented below.
PHAROAH CORPORATIONBalance SheetDecember 31
Assets
2021
2020
Cash
$12,010
$8,980
Accounts receivable
17,810
19,660
Land
16,800
21,840
Buildings
58,800
58,800
Accumulated depreciation—buildings
(12,600
)
(8,400
)
Total
$92,820
$100,880
Liabilities and Shareholders’ Equity
Accounts payable
$10,390
$26,120
Common shares
63,000
57,960
Retained earnings
19,430
16,800
Total
$92,820
$100,880
Additional information:
1.
Profit was $19,010. Dividends declared and paid were $16,380.
2.
No noncash investing and financing activities occurred during 2021.
3.
The land was sold for cash of $4,120 resulting in a loss of $920 on the sale of the land.
Prepare a cash flow statement for 2021 using the indirect method. Lu…
arrow_forward
Use the Ulta annual report to calculate profit margin, total debt ratio, and cash ratio for the year ending in 2021.
arrow_forward
The current ratio including transaction c. is
The debt ratio including transaction c is
screenshots attached thank you
arrow_forward
Ch: Analyzing Financial Statements
The current year financial statement for sand and Juffair companies are presented below.
Balance sheet at 31 Dec 2019
Item
Cash
Account receivable (net)
Inventory
Property & equipment (net)
Other assets
Total assets
Current liabilities
Long-term debt (interest rate: 10%)
Capital stock ($10 par value)
Additional paid-in capital
Retained earnings
Total liabilities and stockholders' equity
Income statement at 31 Dec 2019
item
Sales revenue (1/3 on credit)
(-) Cost of goods sold
(-) Operating expenses
Net income
Other data
item
Per share stock price at end of current year
Average income tax rate
Dividends declared and paid in current year
Sand
45000
45000
95000
160000
90000
435000
95000
75000
155000
40000
70000
435000
Sand
440000
230000
159000
51000
Sand
23
30%
34000
Juffair
22000
35000
45000
415000
320000
837000
65000
65000
522000
110000
75000
837000
Juffair
800000
399000
315000
86000
Juffair
25
30%
153000
Both companies are in the fish catching and…
arrow_forward
Suppose the following financial data were reported by 3M Company for 2019 and 2020 (dollars in millions).
3M CompanyBalance Sheets (partial)
2020
2019Current assets
Cash and cash equivalents
$3,200
$1,845Accounts receivable, net
3,450
3,180Inventories
2,639
3,042Other current assets
1,872
1,549Total current assets
$11,161
$9,616Current liabilities
$4,853
$5,893
(a)Calculate the current ratio and working capital for 3M for 2019 and 2020. (Round current ratio to 2 decimal places, e.g. 1.25 : 1. Enter working capital answers to million.)
Current ratio
2019
:12020
:1
Working capital
2019
$
million2020
$
million
(b)The parts of this question must be completed in order. This part will be available when you complete the part above.
arrow_forward
Current Attempt in Progress
Suppose selected comparative statement data for the giant bookseller Barnes & Noble are as follows. All balance sheet data are as of
the end of the fiscal year (in millions).
Net sales
Cost of goods sold
Net income
Accounts receivable
Inventory
Total assets
Total common stockholders' equity
2022
$5,050.3
3,700.7
65.1
65.0
1,250.1
2,950.1
940.6
2021
$5,800.9
3,200.1
190.9
106.6
1,350.1
3,250.1
1,100.5
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
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Related Questions
- A comparative balance sheet for Gena Company appears below:GENA COMPANYComparative Balance SheetDec. 31, 2021 Dec. 31, 2020AssetsCash $ 34,000 $11,000Accounts receivable 21,000 13,000Inventory 35,000 17,000Prepaid expenses 6,000 9,000Long-term investments -0- 17,000Equipment 60,000 33,000Accumulated depreciation—equipment (20,000) (15,000)Total assets $136,000 $85,000Liabilities and Stockholders' EquityAccounts payable $ 17,000 $ 7,000Bonds payable 36,000 45,000Common stock 53,000 23,000Retained earnings 30,000 10,000Total liabilities and stockholders' equity $136,000 $85,000Additional information:1. Net income for the year ending December 31, 2021 was $35,000.2. Cash dividends of $15,000 were declared and paid during the year.3. Long-term investments that had a cost of $17,000 were sold for $14,000.4. Depreciation expense for the year was $5,000.InstructionsPrepare a full statement of cash flows for the year ended December 31, 2021, using the indirectmethod.arrow_forwardSelected 2020 balance sheet and income statement information for Vkusno & Tochka Corporation and Tasty Treats, Inc., follows. ($ millions) Vkusno & Tochka Tasty Treats Sales Revenue Interest Expense Net Income Average Total Assets $96,040 $6,090 $27,786 $294,060 28,260 2,715 5,309 32,549 a. Compute the return on assets (ROA) for each company. Use the 25% statutory tax rate. Note: Round your answers to the nearest million dollars. Numerator ($ millions) + Denominator ($ millions) 0+ $ 0+$ Vkusno & Tochka's ROA $ Tasty Treats' ROA $ Vkusno & Tochka's PM $ Tasty Treats' PM Vkusno & Tochka's ROA Tasty Treats' ROA b. Disaggregate ROA into profit margin (PM) and asset turnover (AT) for each company. • Note: Round your answers to the nearest million dollars. $ Vkusno & Tochka's AT $ Tasty Treats' AT $ Numerator ($ millions) + Denominator ($ millions) 0$ 05 0+$ 0+ $ PM X % x % X 0 AT c. Discuss any differences in these ratios for each company. has the lower ROA ratio. has the higher PM ratio.…arrow_forwardview Policies Current Attempt in Progress Using these data from the comparative balance sheet of Cullumber Company, perform vertical analysis. (Round percentages to 1 decimal place, e.g. 12.5%.) Dec. 31, 2022 Dec. 31, 2021 Amount Percentage Amount Percentage Accounts receivable $ 467,400 $ 410,000 Inventory $ 785,400 % $ 660,000 % Total assets $3,197,900 % $2,830,000 % eTextbook and Media Save for Later Attempts: 0 of 3 used Submit Answerarrow_forward
- Required:a. Calculate the following ratios for Sweets plc for 2021 and 2020, showing the formulas and workings:1- ROCE2- ROE3- Earnings per share4- Net profit margin5- Asset turnover6- Stock holding days7- Debtors collection period8- Current ratio9- Gearing ratio10- Interest coverarrow_forwardFrom the French Instrument Corporation second-quarter report ended 2020, do a vertical analysis for the second quarter of 2020. (Input all answers as positive values except other (income) which should be indicated by a minus sign. Round your answers to the nearest hundredth percent.) FRENCH INSTRUMENT CORPORATION AND SUBSIDIARIES Consolidated Statements of Operation (Unaudited) (In thousands of dollars, except share data) Second Quarter 2020 2019 Percent of net Net sales $6,698 $6,951 Cost of sales 4,089 4,462 Gross margin 2,609 2,489 Expenses: Selling, general and administrative 1,845 1,783 Product development 175 165 Interest expense 98 123 Other (income), net (172) (99) Total expenses 1,946 1,972 Income before income taxes 663 517 Provision for income taxes 265 209 Net income $398 $308 Net income per common share* $0.05 $0.03 Weighted average number of common shares and equivalents 6,673,673…arrow_forwardProblem 17-2A (Algo) Ratios, common-size statements, and trend percer [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets Long-term investments Plant assets, net Total assets Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity 2021 $546,242 328,838 217,404 77,566 49,162 126,728 90,676 16,866 $ 73,810 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income KORBIN COMPANY Comparative Balance Sheets December 31 2020 $ 418,466 263,634 2021 % 154,832 57,748 36,825 94,573 60, 259 12,353 $ 47,906 % $61,141 0 113,547…arrow_forward
- 2. Calculate each ratio for Company A using the 2020 information from the balance sheets and income statements given below. Current Ratio Quick Ratio Debt/Equity Times Interest Earned Inventory Turnover Return on Assets (ROA) Return on Equity (ROE) Market-to-book Ratio Company A Consolidated Balance Sheet (in thousands) December 31 2020 2019 Assets Current Assets: Cash and Cash Equivalents $380,626 $349,953 Accounts Receivable, net $80,545 $62,312 Inventory $30,096 $21,555 Prepaid Expenses and other current assets $57,076 $54,129 Total Current Assets $548,343 $914,794 Property and Equipment $1,458,690 $1,379,254 Operating Lease Assets $2,800,222 $1,258,293arrow_forwardSuppose the following financial data were reported by 3M Company for 2019 and 2020 (dollars in millions). 3M CompanyBalance Sheets (partial) 2020 2019Current assets Cash and cash equivalents $3,180 $1,836Accounts receivable, net 3,600 3,180Inventories 2,738 3,019Other current assets 1,932 1,590Total current assets $11,450 $9,625Current liabilities $4,830 $5,887 Calculate the current ratio and working capital for 3M for 2019 and 2020. (Round current ratio to 2 decimal places, e.g. 1.25 : 1. Enter working capital answers to million.) Current ratio 2019 :12020 :1 Working capital 2019 $ million2020 $ million Link to Textarrow_forwardPharoah Corporation’s comparative balance sheet is presented below. PHAROAH CORPORATIONBalance SheetDecember 31 Assets 2021 2020 Cash $12,010 $8,980 Accounts receivable 17,810 19,660 Land 16,800 21,840 Buildings 58,800 58,800 Accumulated depreciation—buildings (12,600 ) (8,400 ) Total $92,820 $100,880 Liabilities and Shareholders’ Equity Accounts payable $10,390 $26,120 Common shares 63,000 57,960 Retained earnings 19,430 16,800 Total $92,820 $100,880 Additional information: 1. Profit was $19,010. Dividends declared and paid were $16,380. 2. No noncash investing and financing activities occurred during 2021. 3. The land was sold for cash of $4,120 resulting in a loss of $920 on the sale of the land. Prepare a cash flow statement for 2021 using the indirect method. Lu…arrow_forward
- Use the Ulta annual report to calculate profit margin, total debt ratio, and cash ratio for the year ending in 2021.arrow_forwardThe current ratio including transaction c. is The debt ratio including transaction c is screenshots attached thank youarrow_forwardCh: Analyzing Financial Statements The current year financial statement for sand and Juffair companies are presented below. Balance sheet at 31 Dec 2019 Item Cash Account receivable (net) Inventory Property & equipment (net) Other assets Total assets Current liabilities Long-term debt (interest rate: 10%) Capital stock ($10 par value) Additional paid-in capital Retained earnings Total liabilities and stockholders' equity Income statement at 31 Dec 2019 item Sales revenue (1/3 on credit) (-) Cost of goods sold (-) Operating expenses Net income Other data item Per share stock price at end of current year Average income tax rate Dividends declared and paid in current year Sand 45000 45000 95000 160000 90000 435000 95000 75000 155000 40000 70000 435000 Sand 440000 230000 159000 51000 Sand 23 30% 34000 Juffair 22000 35000 45000 415000 320000 837000 65000 65000 522000 110000 75000 837000 Juffair 800000 399000 315000 86000 Juffair 25 30% 153000 Both companies are in the fish catching and…arrow_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 LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning