Goffney

.xlsx

School

Grand Canyon University *

*We aren’t endorsed by this school

Course

502

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

3

Uploaded by SuperPenguin4164 on coursehero.com

ACC-502 Topic 3 Kevin Goffney 1. Calculate Inventory Turnover Ratio for Coca Cola Name of Ratio: Inventory Turnover Ratio Formula is: Cost of Goods Sold/Average Inventory Coca Cola Co. 2023 2022 Cost of Goods Sold $18,500 $18,000 Average Inventory $4,424 $4,433 Inventory Turnover 4.181736 4.060456 2. Calculate Average Days in Inventory Name of Ratio: Average Days in Inventory Ratio Forula is: 365 Days/Inventory Turnover Coca Cola Co. 2023 2022 Number of Days 365 365 Inventory Turnover 4.181736 4.060456 Average Days in Inventory 87.284324 89.89138 References: https://investors.coca-colacompany.com/filings-reports/annual-filings-10-k A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
ACC-502 Topic 3 Kevin Goffney 1. Calculate Inventory Turnover Ratio for PepsiCo Name of Ratio: Inventory Turnover Ratio Formula is: Cost of Goods Sold/Average Inventory PepsiCo 2023 2022 Cost of Goods Sold $41,881 $40,576 Average Inventory $5,334 $5,222 Inventory Turnover 7.851706 7.770203 2. Calculate Average Days in Inventory for PepsiCo Name of Ratio: Average Days in Inventory Ratio Forula is: 365 Days/Inventory Turnover PepsiCo 2023 2022 Number of Days 365 365 Inventory Turnover 7.85106 7.77203 Average Days in Inventory 46.49054 46.96328 References: PepsiCo, Inc. (2024). Form 10-k annual report for the fiscal year ended December 30, 20
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