module 4 case
docx
keyboard_arrow_up
School
Baker College *
*We aren’t endorsed by this school
Course
3110
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
4
Uploaded by ColonelInternetStarling35
Brian Nieves
Baker College
BUS3110-C1
Module 4: Case Application
ATC 9-1 pg. 360
a. Compute the following ratios for the companies’ 2014 fiscal year.
1. Current ratio:
Current ratio = Current assets
current liabilities
The Kroger Company
Whole Foods Market Inc.
$
8
,
911.00
$
11,403.00
$
1,756.00
$
1,257.00
Current ratio = 0.78
Current ratio = 1.40
2. Average Days to sell inventory:
The Kroger Company
Whole Foods Market Inc.
Average inventory
= 7,951.00
+
8,178.00
2
= $8,064.50
Average inventory
= 414.00
+
441.00
2
= $427.50
Inventory turnover
= $
85,512.00
$
8,064.00
= 10.60
Inventory turnover
= $
9,150.00
$
427
.
50
= 21.40
Average days to sell inventory
= 365
10.60
= 34.43
Average days to sell inventory
= 365
21.40
= 17.06
3. Debt asset ratio:
Debt to assets = totalliabilities
totalassets
The Kroger Company
Whole Foods Market Inc.
$
25,114.00
$
30,556.00
$
1,931.00
$
5,744.00
= 0.822
Current ratio = 0.336
4. Return on investment:
The Kroger Company
Whole Foods Market Inc.
Average total asset
= $
2,981.00
+
30,556.00
2
= $16,768.50
Average total asset
= $
5,744.00
+
$
5,538.00
2
= $5,641.00
ROI = $
2,649.00
$
16,768
.
50
= 15.8%
ROI = $
946.00
$
5,641.00
= 16.8%
5. Gross margin percentage:
Gross margin profit = gross profit
revenue
The Kroger Company
Whole Foods Market Inc.
= $
22,953.00
$
108,465.00
= 21.2%
= $
5,044.00
$
14,194.00
= 35.5%
6. Asset turnover:
Asset turnover = revenue
averagetotal assets
The Kroger Company
Whole Foods Market Inc.
= $
108,465.00
$
16,768.50
= 6.47
= $
14,194.00
$
5,641.00
= 2.52
7. Net margin:
Net margin= earnings
¿
continuing operations
¿
revenues
The Kroger Company
Whole Foods Market Inc.
= $
2
,
649.00
$
108,465.00
= 2.44%
= $
946.00
$
14,194.00
= 6.66%
8. Plant asset to long-term debt ratio:
Plant assets to long-term liabilities= property
∧
equipment net of Depreciation
totallong
−
termliabilities
The Kroger Company
Whole Foods Market Inc.
= $
17,912.00
$
13,711.00
= 1.31
= $
923.00
$
67 4.00
= 1.37
b.
Whole Foods Market Inc. seems to be more profitable. Wholes foods has higher return on investment (16.8%), gross margin (35.5%), and plant asset (1.37).
c. The Kroger Company would appear to have the higher level of financial risk. This is based on reviewing the average days to sell inventory and debt to asset ratio. Kroger has a higher debt to asset ratio (0.822) and average days to sell inventory (34.43).
d. Whole Foods Market Inc. appears to charge a higher price for its goods. This is based on the gross margin percentage and net margins being higher than Kroger. e. Kroger has a higher asset turnover which would imply that it is operating efficiently. ATC 9-2 pg. 361
A
B
C
D
sales
###
### $38,226.00
###
cost of goods sold
### $7,787.50
$7,532.00
###
net income
$484.20 $2,759.30
$9,938.00 $2,102.00
inventory
### $1,306.40
$314.00 $9,700.00
accounts receivables
$195.20
$719.00
$5,618.00
###
total assets
###
###
###
###
A
B
C
D
gross margin
### $7,409.80 $30,694.00
###
gross margin %
59.70%
48.76%
80.30%
28.23%
net income
$484.20 $2,759.30
$9,938.00 $2,102.00
net income %
11.39%
18.16%
26.00%
4.47%
inventory
### $1,306.40
$314.00 $9,700.00
inventory turnover
1.80
11.63
121.74
4.85
accounts receivables
$195.20
$719.00
$5,618.00
###
AR % to sales
4.59%
4.73%
14.70%
33.37%
(1) Based on the above ratios Company D has the least in the gross margin and lowest inventory turnover. I would assume this is Caterpillar since it is a heavy machinery company with a large inventory and high cost of goods sold. One last item to point out would be, that company D has the highest accounts receivable to sales. I would assume this is due to the high value construction
equipment being purchased with lines of credit. (2) Since Oracle is a software company, I believe Company C’s financial best represent the company. Company C has a lower cost of goods sold since the company doesn’t require having an actual inventory of products. Most of those cost are salary and administration. The extremely high gross margin also supports my answer. I would believe that software development and continuing services for companies is costly so most sales would be done on account giving them a high accounts receivable to sales. (3) Company B’s financials would best represent Starbucks. Starbucks is a multiservice and manufacturer in the coffee market. Coffee is a relatively low costing product in the agriculture market so a gross margin of nearly 50% makes sense. Most of the company’s day-to-day sales are cash transactions so a lower accounts receivable also makes sense.
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
(4) The last company on the list is Company A. Tiffany’s is a high-end jewelry retailer. The company must maintain a fairly high inventory of high value products. I would assume this is why Company A has a low turnover. Tiffany’s is a cash business but also opens lines od credit for its consumers. So, the company would have a low accounts receivable to sales.
Related Questions
please answer do not image format
arrow_forward
Problem 17-2A (Algo) Ratios, common-size statements, and trend percents LO P1,
[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
2021
Sales:
Cost of goods sold
Gross profit
Selling expenses
Administrative expenses
Total expenses
Income before taxes
Income tax expense
Net income
Assets
Current assets
2020
$436,580 $ 334,456
262,821
173,759
61,994
39,292
Long-term investments
Plant assets, net
Total assets
KORBIN COMPANY
Comparative Balance Sheets
December 31
Liabilities and Equity
Current liabilities
Common stock
Other paid-in capital
Retained earnings
Total liabilities and equity
212,045
122,411
46, 155
101,286
72,473
13,480
$ 58,993 $ 37,225
29,432
75,587
46,824
9,599
2021
$ 54,789
0
100, 200
$154,989
$ 22,628
72,000
9,000
51,361
2019
$ 232,100
148,544
83,556
30,637
19,264
49,901
33,655
6,832
$ 26,823
2020
$36,670
900
91,178…
arrow_forward
!
Required information
Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3
[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
2021
2019
$ 279,900
179, 136
Sales
Cost of goods sold
$ 526,492
316,948
2020
$ 403,336
252,892
Gross profit
209,544
150,444
100,764
Selling expenses
74,762
55,660
36,947
Administrative expenses
47,384
35,494
23,232
Total expenses
122,146
91,154
60,179
Income before taxes
87,398
59,290
40,585
Income tax expense
16,256
12,155
8,239
Net income
$ 71,142
$ 47,135
$ 32,346
KORBIN COMPANY
Comparative Balance Sheets
December 31
Assets
Current assets
Long-term investments
Plant assets, net
Current liabilities
Total assets
Liabilities and Equity
Common stock
Other paid-in capital
Retained earnings
8,750
66,994
2021
2020
$ 60,926
0
109,735
$ 40,778
1,000
99,989
$ 170,661
$ 141,767
$…
arrow_forward
QUESTION 7
Р18.3А
P18.ЗА (LO 3)
Jergan Corporation are presented here.
Perform ratio analysis, and discuss changes in financial position and operating results.
Jergan Corporation
Condensed balance sheet and income statement data for
Balance Sheets
December 31
2020
2019
2018
Cash
$ 30,000
$ 20,000
$ 18,000
Accounts receivable (net)
50,000
45,000
48,000
Other current assets
90,000
95,000
64,000
Investments
55,000
70,000
45,000
Plant and equipment (net)
500,000
370,000
358,000
$725,000
$600,000
$533,000
Current liabilities
$ 85,000
$ 80,000
$ 70,000
Long-term debt
Common stock, $10 par
145,000
85,000
50,000
320,000
310,000
300,000
Retained earnings
175,000
125,000
113,000
$725,000
$600,000
$533,000
Jergan Corporation
Income Statements
For the Years Ended December 31
2020
2019
Sales revenue
$740,000
$600,000
Less: Sales returns and allowances
40,000
30,000
Net sales
700,000
570,000
Cost of goods sold
Gross profit
425,000
350,000
275,000
220,000
Operating expenses (including income taxes)…
arrow_forward
QUESTION 8
P18-5A
P14.5A (LO 3)
are presented here (in millions).
Compute selected ratios, and compare liquidity, profitability, and solvency for two
сотрanies.
Suppose selected financial data of Target and Wal-Mart for 2020
Wal-Mart
Target
Corporation Stores, Inc.
Income Statement Data for Year
Net sales
$65,357
$408,214
Cost of goods sold
45,583
304,657
Selling and administrative expenses
15,101
79,607
L
Wal-Mart
Target
Corporation Stores, Inc.
Interest expense
707
2,065
Other income (expense)
(94)
(411)
Income tax eхрense
1,384
7,139
$ 2,488
Balance Sheet Data (End of Year)
Net income
$ 14,335
Current assets
$18,424
$ 48,331
Noncurrent assets
26,109
122,375
Total assets
$44,533
$170,706
Current liabilities
$11,327
$ 55,561
Long-term debt
Total stockholders' equity
17,859
44,089
15,347
71,056
Total liabilities and stockholders' equity
$44,533
$170,706
Beginning-of-Year Balances
Total assets
$44,106
$163,429
Total stockholders' equity
13,712
65,682
Current liabilities
10,512
55,390…
arrow_forward
jDL Coroproation Selected Financial Data as at december 21,2016
Current asset 2,50,000$
Current Liabilities 1,50,000$
Inventories 60,000$
Accounts Receivable 45,000$
Revenue 9,50,000$
Cost of Good Sold 6,75,000$
Note: Ignore averaging for this question
JDL's Quick ratio is:
1
0.8
2.45
1.27
JDL's average collection period is:
8 days
11 days
17 days
20 days
JDL's inventory turnover is:
9.50 times
11.25 times
4.50 times
5.43 times
JDL's receivables turnover is:
24.34 times
22.56 times
21.11 times
20.11 times
arrow_forward
Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3
[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
2021
2020
2019
Sales
Cost of goods sold
$ 402,346 $ 308,230
242,212
$ 213,900
194,493
136,896
Gross profit
160,134
113,737
77,004
Selling expenses
57,133
42,536
28,235
Administrative expenses
36,211
27,124
17,754
Total expenses
93,344
69,660
45,989
Income before taxes
Income tax expense
66,790
44,077
31,015
12,423
9,036
6,296
Net income
$ 54,367
$ 35,041
$ 24,719
KORBIN COMPANY
Comparative Balance Sheets
December 31
Assets
Current assets
Long-term investments
Plant assets, net
Total assets
Current liabilities
Liabilities and Equity
Common stock
Other paid-in capital
Retained earnings
Total liabilities and equity
$ 180,932
2021
$ 63,959
116,973
0
2020
$ 42,808
800
106,691
$ 180,932
$ 150,299
$…
arrow_forward
Solve the general accounting issue
arrow_forward
What advice would you give to Juirgen
PROBLEM 17-19 Incomplete Statements; Analysis of Ratios [LO2, LO3, L04]
Incomplete financial statements for Tanner Company are given below:
Tanner Company
Income Statement
For the Year Ended December 31
Revenue.
$2,700,000
Cost of goods sold..
Gross margin.
Selling and administrative expenses . .
?
Net operating income
Interest expense
45,000
Net income before taxes
?
Income taxes, 40%.
?
Net income
2$
?
Scanned by CamScanı
Financial Staterment Analysis
923
Tanner Company
Balance Sheet.
December 31
Non-current Assets:
Plant and equipment, net
Current assets:
Accounts receivable, net . .
Inventory..
Cash and cash equivalents.
Total current assets
$ ?
Total assets
$ ?
Equity:
Common stock, $2.50 par value
Retained earnings
Total equity . . ..
Bonds payable, 10%
Current liabilities
?
$250,000
Total liabilities.
?
Total equity and liabilities
$ ?
The following additional information is available about the company:
Selected financial ratios computed…
arrow_forward
Question Content Area
Hsu Company reported the following on its income statement:
Income before income taxes
$325,364
Income tax expense
97,609
Net income
$227,755
Interest expense was $73,540. Hsu Company's times interest earned ratio (rounded to two decimal places) is
a.4.42 times
b.3.1 times
c.2.1 times
d.5.42 times
arrow_forward
Abhaliya
arrow_forward
How can i figure the problem out
arrow_forward
Need help with this question
arrow_forward
Hi expert please help me this question
arrow_forward
sd
arrow_forward
devrat
arrow_forward
Can you help me with accounting questions
arrow_forward
General accounting question
arrow_forward
Required Information
Problem 17-5A (Algo) Comparative ratio analysis LO P3
[The following information applies to the questions displayed below.]
Summary information from the financial statements of two companies competing in the same industry follows.
Barco
Kyan
Company
Company
Barco
Company
Kyan Company
Data from the current year-end
balance sheets
Data from the current year's income
statement
Assets
Sales
Prepaid expenses
Cash
$ 22,500
$ 34,000
Accounts receivable, net
40,400
59,400
Merchandise inventory
84,743
130,500
Plant assets, net
5,700
330,000
312,400
Basic earnings per share
Total assets
$ 483,348
$ 544,180
Cash dividends per share
Current liabilities
Liabilities and Equity
Long-term notes payable.
Common stock, $5 par value
Retained earnings
Total liabilities and equity
$ 483,343 $ 544,100
$ 64,340
$ 94,300
Accounts receivable, net
83,800
190,000
103,000
206,000
Beginning-of-year balance sheet data
Merchandise inventory
Total assets
145,200
140,800
Common stock, $5 par value…
arrow_forward
GE MINDTAP
omework
5065600.
6500550
36055055
f6
Complete the balance sheet and sales information using the following financial data:
6
Total assets turnover: 1.1x
Days sales outstanding: 73.0 daysa
Inventory turnover ratio: 4x
Fixed assets turnover: 3.0x
Current ratio: 2.0x
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales
Calculation is based on a 365-day year.
Do not round intermediate calculations. Round your answers to the nearest dollar.
Balance Sheet
Cash
Accounts receivable
Inventories
Fixed assets
Total assets
Sales
Q Search
80000
eBook
f7
&
7
f8
*
4+
8
$
$240,000
fg
@MO
hp
IAA
9
ISBN 9780357517642&nbld-3626933&snap... ✰
f10
Current liabilities
Long-term debt
Common stock
Retained earnings
Total liabilities and equity
Cost of goods sold
▶II
O
99+
f11
O
f12
S
$
B
+
g
ins
60,000
84,000
prt sc
@ 0
delete
Q
Check My Wo
backspace
Check
hor
arrow_forward
expert of general account answer
arrow_forward
Subject: financial accounting
arrow_forward
Need help with this question solution general accounting
arrow_forward
Abc
arrow_forward
How can I write out this equation
arrow_forward
I want to correct answer general accounting
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Related Questions
- please answer do not image formatarrow_forwardProblem 17-2A (Algo) Ratios, common-size statements, and trend percents LO P1, [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 2021 Sales: Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets 2020 $436,580 $ 334,456 262,821 173,759 61,994 39,292 Long-term investments Plant assets, net Total assets KORBIN COMPANY Comparative Balance Sheets December 31 Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity 212,045 122,411 46, 155 101,286 72,473 13,480 $ 58,993 $ 37,225 29,432 75,587 46,824 9,599 2021 $ 54,789 0 100, 200 $154,989 $ 22,628 72,000 9,000 51,361 2019 $ 232,100 148,544 83,556 30,637 19,264 49,901 33,655 6,832 $ 26,823 2020 $36,670 900 91,178…arrow_forward! Required information Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 [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 2021 2019 $ 279,900 179, 136 Sales Cost of goods sold $ 526,492 316,948 2020 $ 403,336 252,892 Gross profit 209,544 150,444 100,764 Selling expenses 74,762 55,660 36,947 Administrative expenses 47,384 35,494 23,232 Total expenses 122,146 91,154 60,179 Income before taxes 87,398 59,290 40,585 Income tax expense 16,256 12,155 8,239 Net income $ 71,142 $ 47,135 $ 32,346 KORBIN COMPANY Comparative Balance Sheets December 31 Assets Current assets Long-term investments Plant assets, net Current liabilities Total assets Liabilities and Equity Common stock Other paid-in capital Retained earnings 8,750 66,994 2021 2020 $ 60,926 0 109,735 $ 40,778 1,000 99,989 $ 170,661 $ 141,767 $…arrow_forward
- QUESTION 7 Р18.3А P18.ЗА (LO 3) Jergan Corporation are presented here. Perform ratio analysis, and discuss changes in financial position and operating results. Jergan Corporation Condensed balance sheet and income statement data for Balance Sheets December 31 2020 2019 2018 Cash $ 30,000 $ 20,000 $ 18,000 Accounts receivable (net) 50,000 45,000 48,000 Other current assets 90,000 95,000 64,000 Investments 55,000 70,000 45,000 Plant and equipment (net) 500,000 370,000 358,000 $725,000 $600,000 $533,000 Current liabilities $ 85,000 $ 80,000 $ 70,000 Long-term debt Common stock, $10 par 145,000 85,000 50,000 320,000 310,000 300,000 Retained earnings 175,000 125,000 113,000 $725,000 $600,000 $533,000 Jergan Corporation Income Statements For the Years Ended December 31 2020 2019 Sales revenue $740,000 $600,000 Less: Sales returns and allowances 40,000 30,000 Net sales 700,000 570,000 Cost of goods sold Gross profit 425,000 350,000 275,000 220,000 Operating expenses (including income taxes)…arrow_forwardQUESTION 8 P18-5A P14.5A (LO 3) are presented here (in millions). Compute selected ratios, and compare liquidity, profitability, and solvency for two сотрanies. Suppose selected financial data of Target and Wal-Mart for 2020 Wal-Mart Target Corporation Stores, Inc. Income Statement Data for Year Net sales $65,357 $408,214 Cost of goods sold 45,583 304,657 Selling and administrative expenses 15,101 79,607 L Wal-Mart Target Corporation Stores, Inc. Interest expense 707 2,065 Other income (expense) (94) (411) Income tax eхрense 1,384 7,139 $ 2,488 Balance Sheet Data (End of Year) Net income $ 14,335 Current assets $18,424 $ 48,331 Noncurrent assets 26,109 122,375 Total assets $44,533 $170,706 Current liabilities $11,327 $ 55,561 Long-term debt Total stockholders' equity 17,859 44,089 15,347 71,056 Total liabilities and stockholders' equity $44,533 $170,706 Beginning-of-Year Balances Total assets $44,106 $163,429 Total stockholders' equity 13,712 65,682 Current liabilities 10,512 55,390…arrow_forwardjDL Coroproation Selected Financial Data as at december 21,2016 Current asset 2,50,000$ Current Liabilities 1,50,000$ Inventories 60,000$ Accounts Receivable 45,000$ Revenue 9,50,000$ Cost of Good Sold 6,75,000$ Note: Ignore averaging for this question JDL's Quick ratio is: 1 0.8 2.45 1.27 JDL's average collection period is: 8 days 11 days 17 days 20 days JDL's inventory turnover is: 9.50 times 11.25 times 4.50 times 5.43 times JDL's receivables turnover is: 24.34 times 22.56 times 21.11 times 20.11 timesarrow_forward
- Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 [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 2021 2020 2019 Sales Cost of goods sold $ 402,346 $ 308,230 242,212 $ 213,900 194,493 136,896 Gross profit 160,134 113,737 77,004 Selling expenses 57,133 42,536 28,235 Administrative expenses 36,211 27,124 17,754 Total expenses 93,344 69,660 45,989 Income before taxes Income tax expense 66,790 44,077 31,015 12,423 9,036 6,296 Net income $ 54,367 $ 35,041 $ 24,719 KORBIN COMPANY Comparative Balance Sheets December 31 Assets Current assets Long-term investments Plant assets, net Total assets Current liabilities Liabilities and Equity Common stock Other paid-in capital Retained earnings Total liabilities and equity $ 180,932 2021 $ 63,959 116,973 0 2020 $ 42,808 800 106,691 $ 180,932 $ 150,299 $…arrow_forwardSolve the general accounting issuearrow_forwardWhat advice would you give to Juirgen PROBLEM 17-19 Incomplete Statements; Analysis of Ratios [LO2, LO3, L04] Incomplete financial statements for Tanner Company are given below: Tanner Company Income Statement For the Year Ended December 31 Revenue. $2,700,000 Cost of goods sold.. Gross margin. Selling and administrative expenses . . ? Net operating income Interest expense 45,000 Net income before taxes ? Income taxes, 40%. ? Net income 2$ ? Scanned by CamScanı Financial Staterment Analysis 923 Tanner Company Balance Sheet. December 31 Non-current Assets: Plant and equipment, net Current assets: Accounts receivable, net . . Inventory.. Cash and cash equivalents. Total current assets $ ? Total assets $ ? Equity: Common stock, $2.50 par value Retained earnings Total equity . . .. Bonds payable, 10% Current liabilities ? $250,000 Total liabilities. ? Total equity and liabilities $ ? The following additional information is available about the company: Selected financial ratios computed…arrow_forward
- Question Content Area Hsu Company reported the following on its income statement: Income before income taxes $325,364 Income tax expense 97,609 Net income $227,755 Interest expense was $73,540. Hsu Company's times interest earned ratio (rounded to two decimal places) is a.4.42 times b.3.1 times c.2.1 times d.5.42 timesarrow_forwardAbhaliyaarrow_forwardHow can i figure the problem outarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning

Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning