module 4 case

docx

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

Report
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.