Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories. Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel: 1. Inventory turnover 2. Average days in inventory In a Word file, include the following: 1. Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio. 2. Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet. Pepsico Annual Inventory (Millions of US $) 2019 $3,338 2018 $3,128 2017 $2,947 2016 $2,723 2015 $2,720 2014 $3,143 2013 $3,409 2012 $3,581 2011 $3,827 2010 $3,372 2009 $2,618 2008 $2,522 2007 $2,290 Pepsico Annual Cost of Goods Sold (Millions of US $) 2019 $30,132 2018 $29,381 2017 $28,796 2016 $28,222 2015 $28,731 2014 $31,238 2013 $31,243 2012 $31,291 2011 $31,593 2010 $26,575 2009 $20,099 2008 $20,351 2007 $18,038 Coca-Cola Annual Cost of Goods Sold (Millions of US $) 2019 $14,619 2018 $13,067 2017 $13,721 2016 $16,465 2015 $17,482 2014 $17,889 2013 $18,421 2012 $19,053 2011 $18,215 2010 $12,693 2009 $11,088 2008 $11,374 2007 $10,406 Coca-Cola Annual Inventory (Millions of US $) 2019 $3,379 2018 $3,071 2017 $2,655 2016 $2,675 2015 $2,902 2014 $3,100 2013 $3,277 2012 $3,264 2011 $3,092 2010 $2,650 2009 $2,354 2008 $2,187 2007 $2,220 Computation of inventory turnover ratio of Pepsi Particulars 2019 2018 Cost of goods sold $30,132 $29,381 Average inventory Inventory turnover ratio $3,338 $3,128 9.027 9.393 Computation of Average Days in Inventory of Pepsi Particulars 2019 2018 Number of Days 365 365 Inventory Turnover ratio 9.027 9.393 Average days in Inventory 40.434 38.859 Computation of Inventory turnover ratio of Coca Cola Particulars 2019 2018 Cost of goods sold Average inventory Inventory turnover ratio $14,619 $3,379 $13,067 $3,071 4.326 4.255 Computation of Average Days in Inventory of Coca Cola Particulars Number of Days 2019 2018 365 365 Inventory Turnover ratio Average days in Inventory 4.326 4.255 84.374 85.781 Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories. Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel: 1. Inventory turnover 2. Average days in inventory In a Word file, include the following: 1. Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio. 2. Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet. Pepsico Annual Inventory (Millions of US $) 2019 $3,338 2018 $3,128 2017 $2,947 2016 $2,723 2015 $2,720 2014 $3,143 2013 $3,409 2012 $3,581 2011 $3,827 2010 $3,372 2009 $2,618 2008 $2,522 2007 $2,290 Pepsico Annual Cost of Goods Sold (Millions of US $) 2019 $30,132 2018 $29,381 2017 $28,796 2016 $28,222 2015 $28,731 2014 $31,238 2013 $31,243 2012 $31,291 2011 $31,593 2010 $26,575 2009 $20,099 2008 $20,351 2007 $18,038 Coca-Cola Annual Cost of Goods Sold (Millions of US $) 2019 $14,619 2018 $13,067 2017 $13,721 2016 $16,465 2015 $17,482 2014 $17,889 2013 $18,421 2012 $19,053 2011 $18,215 2010 $12,693 2009 $11,088 2008 $11,374 2007 $10,406 Coca-Cola Annual Inventory (Millions of US $) 2019 $3,379 2018 $3,071 2017 $2,655 2016 $2,675 2015 $2,902 2014 $3,100 2013 $3,277 2012 $3,264 2011 $3,092 2010 $2,650 2009 $2,354 2008 $2,187 2007 $2,220 Computation of inventory turnover ratio of Pepsi Particulars 2019 2018 Cost of goods sold $30,132 $29,381 Average inventory Inventory turnover ratio $3,338 $3,128 9.027 9.393 Computation of Average Days in Inventory of Pepsi Particulars 2019 2018 Number of Days 365 365 Inventory Turnover ratio 9.027 9.393 Average days in Inventory 40.434 38.859 Computation of Inventory turnover ratio of Coca Cola Particulars 2019 2018 Cost of goods sold Average inventory Inventory turnover ratio $14,619 $3,379 $13,067 $3,071 4.326 4.255 Computation of Average Days in Inventory of Coca Cola Particulars Number of Days 2019 2018 365 365 Inventory Turnover ratio Average days in Inventory 4.326 4.255 84.374 85.781 Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories. Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel: 1. Inventory turnover 2. Average days in inventory In a Word file, include the following: 1. Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio. 2. Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet. Pepsico Annual Inventory (Millions of US $) 2019 $3,338 2018 $3,128 2017 $2,947 2016 $2,723 2015 $2,720 2014 $3,143 2013 $3,409 2012 $3,581 2011 $3,827 2010 $3,372 2009 $2,618 2008 $2,522 2007 $2,290 Pepsico Annual Cost of Goods Sold (Millions of US $) 2019 $30,132 2018 $29,381 2017 $28,796 2016 $28,222 2015 $28,731 2014 $31,238 2013 $31,243 2012 $31,291 2011 $31,593 2010 $26,575 2009 $20,099 2008 $20,351 2007 $18,038 Coca-Cola Annual Cost of Goods Sold (Millions of US $) 2019 $14,619 2018 $13,067 2017 $13,721 2016 $16,465 2015 $17,482 2014 $17,889 2013 $18,421 2012 $19,053 2011 $18,215 2010 $12,693 2009 $11,088 2008 $11,374 2007 $10,406 Coca-Cola Annual Inventory (Millions of US $) 2019 $3,379 2018 $3,071 2017 $2,655 2016 $2,675 2015 $2,902 2014 $3,100 2013 $3,277 2012 $3,264 2011 $3,092 2010 $2,650 2009 $2,354 2008 $2,187 2007 $2,220 Computation of inventory turnover ratio of Pepsi Particulars 2019 2018 Cost of goods sold $30,132 $29,381 Average inventory Inventory turnover ratio $3,338 $3,128 9.027 9.393 Computation of Average Days in Inventory of Pepsi Particulars 2019 2018 Number of Days 365 365 Inventory Turnover ratio 9.027 9.393 Average days in Inventory 40.434 38.859 Computation of Inventory turnover ratio of Coca Cola Particulars 2019 2018 Cost of goods sold Average inventory Inventory turnover ratio $14,619 $3,379 $13,067 $3,071 4.326 4.255 Computation of Average Days in Inventory of Coca Cola Particulars Number of Days 2019 2018 365 365 Inventory Turnover ratio Average days in Inventory 4.326 4.255 84.374 85.781 Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories. Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel: 1. Inventory turnover 2. Average days in inventory In a Word file, include the following: 1. Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio. 2. Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet. Pepsico Annual Inventory (Millions of US $) 2019 $3,338 2018 $3,128 2017 $2,947 2016 $2,723 2015 $2,720 2014 $3,143 2013 $3,409 2012 $3,581 2011 $3,827 2010 $3,372 2009 $2,618 2008 $2,522 2007 $2,290 Pepsico Annual Cost of Goods Sold (Millions of US $) 2019 $30,132 2018 $29,381 2017 $28,796 2016 $28,222 2015 $28,731 2014 $31,238 2013 $31,243 2012 $31,291 2011 $31,593 2010 $26,575 2009 $20,099 2008 $20,351 2007 $18,038 Coca-Cola Annual Cost of Goods Sold (Millions of US $) 2019 $14,619 2018 $13,067 2017 $13,721 2016 $16,465 2015 $17,482 2014 $17,889 2013 $18,421 2012 $19,053 2011 $18,215 2010 $12,693 2009 $11,088 2008 $11,374 2007 $10,406 Coca-Cola Annual Inventory (Millions of US $) 2019 $3,379 2018 $3,071 2017 $2,655 2016 $2,675 2015 $2,902 2014 $3,100 2013 $3,277 2012 $3,264 2011 $3,092 2010 $2,650 2009 $2,354 2008 $2,187 2007 $2,220 Computation of inventory turnover ratio of Pepsi Particulars 2019 2018 Cost of goods sold $30,132 $29,381 Average inventory Inventory turnover ratio $3,338 $3,128 9.027 9.393 Computation of Average Days in Inventory of Pepsi Particulars 2019 2018 Number of Days 365 365 Inventory Turnover ratio 9.027 9.393 Average days in Inventory 40.434 38.859 Computation of Inventory turnover ratio of Coca Cola Particulars 2019 2018 Cost of goods sold Average inventory Inventory turnover ratio $14,619 $3,379 $13,067 $3,071 4.326 4.255 Computation of Average Days in Inventory of Coca Cola Particulars Number of Days 2019 2018 365 365 Inventory Turnover ratio Average days in Inventory 4.326 4.255 84.374 85.781 Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories. Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel: 1. Inventory turnover 2. Average days in inventory In a Word file, include the following: 1. Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio. 2. Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet. Pepsico Annual Inventory (Millions of US $) 2019 $3,338 2018 $3,128 2017 $2,947 2016 $2,723 2015 $2,720 2014 $3,143 2013 $3,409 2012 $3,581 2011 $3,827 2010 $3,372 2009 $2,618 2008 $2,522 2007 $2,290 Pepsico Annual Cost of Goods Sold (Millions of US $) 2019 $30,132 2018 $29,381 2017 $28,796 2016 $28,222 2015 $28,731 2014 $31,238 2013 $31,243 2012 $31,291 2011 $31,593 2010 $26,575 2009 $20,099 2008 $20,351 2007 $18,038 Coca-Cola Annual Cost of Goods Sold (Millions of US $) 2019 $14,619 2018 $13,067 2017 $13,721 2016 $16,465 2015 $17,482 2014 $17,889 2013 $18,421 2012 $19,053 2011 $18,215 2010 $12,693 2009 $11,088 2008 $11,374 2007 $10,406 Coca-Cola Annual Inventory (Millions of US $) 2019 $3,379 2018 $3,071 2017 $2,655 2016 $2,675 2015 $2,902 2014 $3,100 2013 $3,277 2012 $3,264 2011 $3,092 2010 $2,650 2009 $2,354 2008 $2,187 2007 $2,220 Computation of inventory turnover ratio of Pepsi Particulars 2019 2018 Cost of goods sold $30,132 $29,381 Average inventory Inventory turnover ratio $3,338 $3,128 9.027 9.393 Computation of Average Days in Inventory of Pepsi Particulars 2019 2018 Number of Days 365 365 Inventory Turnover ratio 9.027 9.393 Average days in Inventory 40.434 38.859 Computation of Inventory turnover ratio of Coca Cola Particulars 2019 2018 Cost of goods sold Average inventory Inventory turnover ratio $14,619 $3,379 $13,067 $3,071 4.326 4.255 Computation of Average Days in Inventory of Coca Cola Particulars Number of Days 2019 2018 365 365 Inventory Turnover ratio Average days in Inventory 4.326 4.255 84.374 85.781 Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories. Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel: 1. Inventory turnover 2. Average days in inventory In a Word file, include the following: 1. Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio. 2. Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet. Pepsico Annual Inventory (Millions of US $) 2019 $3,338 2018 $3,128 2017 $2,947 2016 $2,723 2015 $2,720 2014 $3,143 2013 $3,409 2012 $3,581 2011 $3,827 2010 $3,372 2009 $2,618 2008 $2,522 2007 $2,290 Pepsico Annual Cost of Goods Sold (Millions of US $) 2019 $30,132 2018 $29,381 2017 $28,796 2016 $28,222 2015 $28,731 2014 $31,238 2013 $31,243 2012 $31,291 2011 $31,593 2010 $26,575 2009 $20,099 2008 $20,351 2007 $18,038 Coca-Cola Annual Cost of Goods Sold (Millions of US $) 2019 $14,619 2018 $13,067 2017 $13,721 2016 $16,465 2015 $17,482 2014 $17,889 2013 $18,421 2012 $19,053 2011 $18,215 2010 $12,693 2009 $11,088 2008 $11,374 2007 $10,406 Coca-Cola Annual Inventory (Millions of US $) 2019 $3,379 2018 $3,071 2017 $2,655 2016 $2,675 2015 $2,902 2014 $3,100 2013 $3,277 2012 $3,264 2011 $3,092 2010 $2,650 2009 $2,354 2008 $2,187 2007 $2,220 Computation of inventory turnover ratio of Pepsi Particulars 2019 2018 Cost of goods sold $30,132 $29,381 Average inventory Inventory turnover ratio $3,338 $3,128 9.027 9.393 Computation of Average Days in Inventory of Pepsi Particulars 2019 2018 Number of Days 365 365 Inventory Turnover ratio 9.027 9.393 Average days in Inventory 40.434 38.859 Computation of Inventory turnover ratio of Coca Cola Particulars 2019 2018 Cost of goods sold Average inventory Inventory turnover ratio $14,619 $3,379 $13,067 $3,071 4.326 4.255 Computation of Average Days in Inventory of Coca Cola Particulars Number of Days 2019 2018 365 365 Inventory Turnover ratio Average days in Inventory 4.326 4.255 84.374 85.781 Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories. Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel: 1. Inventory turnover 2. Average days in inventory In a Word file, include the following: 1. Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio. 2. Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet. Pepsico Annual Inventory (Millions of US $) 2019 $3,338 2018 $3,128 2017 $2,947 2016 $2,723 2015 $2,720 2014 $3,143 2013 $3,409 2012 $3,581 2011 $3,827 2010 $3,372 2009 $2,618 2008 $2,522 2007 $2,290 Pepsico Annual Cost of Goods Sold (Millions of US $) 2019 $30,132 2018 $29,381 2017 $28,796 2016 $28,222 2015 $28,731 2014 $31,238 2013 $31,243 2012 $31,291 2011 $31,593 2010 $26,575 2009 $20,099 2008 $20,351 2007 $18,038 Coca-Cola Annual Cost of Goods Sold (Millions of US $) 2019 $14,619 2018 $13,067 2017 $13,721 2016 $16,465 2015 $17,482 2014 $17,889 2013 $18,421 2012 $19,053 2011 $18,215 2010 $12,693 2009 $11,088 2008 $11,374 2007 $10,406 Coca-Cola Annual Inventory (Millions of US $) 2019 $3,379 2018 $3,071 2017 $2,655 2016 $2,675 2015 $2,902 2014 $3,100 2013 $3,277 2012 $3,264 2011 $3,092 2010 $2,650 2009 $2,354 2008 $2,187 2007 $2,220 Computation of inventory turnover ratio of Pepsi Particulars 2019 2018 Cost of goods sold $30,132 $29,381 Average inventory Inventory turnover ratio $3,338 $3,128 9.027 9.393 Computation of Average Days in Inventory of Pepsi Particulars 2019 2018 Number of Days 365 365 Inventory Turnover ratio 9.027 9.393 Average days in Inventory 40.434 38.859 Computation of Inventory turnover ratio of Coca Cola Particulars 2019 2018 Cost of goods sold Average inventory Inventory turnover ratio $14,619 $3,379 $13,067 $3,071 4.326 4.255 Computation of Average Days in Inventory of Coca Cola Particulars Number of Days 2019 2018 365 365 Inventory Turnover ratio Average days in Inventory 4.326 4.255 84.374 85.781 Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories. Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel: 1. Inventory turnover 2. Average days in inventory In a Word file, include the following: 1. Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio. 2. Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet. Pepsico Annual Inventory (Millions of US $) 2019 $3,338 2018 $3,128 2017 $2,947 2016 $2,723 2015 $2,720 2014 $3,143 2013 $3,409 2012 $3,581 2011 $3,827 2010 $3,372 2009 $2,618 2008 $2,522 2007 $2,290 Pepsico Annual Cost of Goods Sold (Millions of US $) 2019 $30,132 2018 $29,381 2017 $28,796 2016 $28,222 2015 $28,731 2014 $31,238 2013 $31,243 2012 $31,291 2011 $31,593 2010 $26,575 2009 $20,099 2008 $20,351 2007 $18,038 Coca-Cola Annual Cost of Goods Sold (Millions of US $) 2019 $14,619 2018 $13,067 2017 $13,721 2016 $16,465 2015 $17,482 2014 $17,889 2013 $18,421 2012 $19,053 2011 $18,215 2010 $12,693 2009 $11,088 2008 $11,374 2007 $10,406 Coca-Cola Annual Inventory (Millions of US $) 2019 $3,379 2018 $3,071 2017 $2,655 2016 $2,675 2015 $2,902 2014 $3,100 2013 $3,277 2012 $3,264 2011 $3,092 2010 $2,650 2009 $2,354 2008 $2,187 2007 $2,220 Computation of inventory turnover ratio of Pepsi Particulars 2019 2018 Cost of goods sold $30,132 $29,381 Average inventory Inventory turnover ratio $3,338 $3,128 9.027 9.393 Computation of Average Days in Inventory of Pepsi Particulars 2019 2018 Number of Days 365 365 Inventory Turnover ratio 9.027 9.393 Average days in Inventory 40.434 38.859 Computation of Inventory turnover ratio of Coca Cola Particulars 2019 2018 Cost of goods sold Average inventory Inventory turnover ratio $14,619 $3,379 $13,067 $3,071 4.326 4.255 Computation of Average Days in Inventory of Coca Cola Particulars Number of Days 2019 2018 365 365 Inventory Turnover ratio Average days in Inventory 4.326 4.255 84.374 85.781 Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories. Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel: 1. Inventory turnover 2. Average days in inventory In a Word file, include the following: 1. Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio. 2. Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet. Pepsico Annual Inventory (Millions of US $) 2019 $3,338 2018 $3,128 2017 $2,947 2016 $2,723 2015 $2,720 2014 $3,143 2013 $3,409 2012 $3,581 2011 $3,827 2010 $3,372 2009 $2,618 2008 $2,522 2007 $2,290 Pepsico Annual Cost of Goods Sold (Millions of US $) 2019 $30,132 2018 $29,381 2017 $28,796 2016 $28,222 2015 $28,731 2014 $31,238 2013 $31,243 2012 $31,291 2011 $31,593 2010 $26,575 2009 $20,099 2008 $20,351 2007 $18,038 Coca-Cola Annual Cost of Goods Sold (Millions of US $) 2019 $14,619 2018 $13,067 2017 $13,721 2016 $16,465 2015 $17,482 2014 $17,889 2013 $18,421 2012 $19,053 2011 $18,215 2010 $12,693 2009 $11,088 2008 $11,374 2007 $10,406 Coca-Cola Annual Inventory (Millions of US $) 2019 $3,379 2018 $3,071 2017 $2,655 2016 $2,675 2015 $2,902 2014 $3,100 2013 $3,277 2012 $3,264 2011 $3,092 2010 $2,650 2009 $2,354 2008 $2,187 2007 $2,220 Computation of inventory turnover ratio of Pepsi Particulars 2019 2018 Cost of goods sold $30,132 $29,381 Average inventory Inventory turnover ratio $3,338 $3,128 9.027 9.393 Computation of Average Days in Inventory of Pepsi Particulars 2019 2018 Number of Days 365 365 Inventory Turnover ratio 9.027 9.393 Average days in Inventory 40.434 38.859 Computation of Inventory turnover ratio of Coca Cola Particulars 2019 2018 Cost of goods sold Average inventory Inventory turnover ratio $14,619 $3,379 $13,067 $3,071 4.326 4.255 Computation of Average Days in Inventory of Coca Cola Particulars Number of Days 2019 2018 365 365 Inventory Turnover ratio Average days in Inventory 4.326 4.255 84.374 85.781 Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories. Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel: 1. Inventory turnover 2. Average days in inventory In a Word file, include the following: 1. Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio. 2. Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet. Pepsico Annual Inventory (Millions of US $) 2019 $3,338 2018 $3,128 2017 $2,947 2016 $2,723 2015 $2,720 2014 $3,143 2013 $3,409 2012 $3,581 2011 $3,827 2010 $3,372 2009 $2,618 2008 $2,522 2007 $2,290 Pepsico Annual Cost of Goods Sold (Millions of US $) 2019 $30,132 2018 $29,381 2017 $28,796 2016 $28,222 2015 $28,731 2014 $31,238 2013 $31,243 2012 $31,291 2011 $31,593 2010 $26,575 2009 $20,099 2008 $20,351 2007 $18,038 Coca-Cola Annual Cost of Goods Sold (Millions of US $) 2019 $14,619 2018 $13,067 2017 $13,721 2016 $16,465 2015 $17,482 2014 $17,889 2013 $18,421 2012 $19,053 2011 $18,215 2010 $12,693 2009 $11,088 2008 $11,374 2007 $10,406 Coca-Cola Annual Inventory (Millions of US $) 2019 $3,379 2018 $3,071 2017 $2,655 2016 $2,675 2015 $2,902 2014 $3,100 2013 $3,277 2012 $3,264 2011 $3,092 2010 $2,650 2009 $2,354 2008 $2,187 2007 $2,220 Computation of inventory turnover ratio of Pepsi Particulars 2019 2018 Cost of goods sold $30,132 $29,381 Average inventory Inventory turnover ratio $3,338 $3,128 9.027 9.393 Computation of Average Days in Inventory of Pepsi Particulars 2019 2018 Number of Days 365 365 Inventory Turnover ratio 9.027 9.393 Average days in Inventory 40.434 38.859 Computation of Inventory turnover ratio of Coca Cola Particulars 2019 2018 Cost of goods sold Average inventory Inventory turnover ratio $14,619 $3,379 $13,067 $3,071 4.326 4.255 Computation of Average Days in Inventory of Coca Cola Particulars Number of Days 2019 2018 365 365 Inventory Turnover ratio Average days in Inventory 4.326 4.255 84.374 85.781 Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories. Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel: 1. Inventory turnover 2. Average days in inventory In a Word file, include the following: 1. Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio. 2. Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet. Pepsico Annual Inventory (Millions of US $) 2019 $3,338 2018 $3,128 2017 $2,947 2016 $2,723 2015 $2,720 2014 $3,143 2013 $3,409 2012 $3,581 2011 $3,827 2010 $3,372 2009 $2,618 2008 $2,522 2007 $2,290 Pepsico Annual Cost of Goods Sold (Millions of US $) 2019 $30,132 2018 $29,381 2017 $28,796 2016 $28,222 2015 $28,731 2014 $31,238 2013 $31,243 2012 $31,291 2011 $31,593 2010 $26,575 2009 $20,099 2008 $20,351 2007 $18,038 Coca-Cola Annual Cost of Goods Sold (Millions of US $) 2019 $14,619 2018 $13,067 2017 $13,721 2016 $16,465 2015 $17,482 2014 $17,889 2013 $18,421 2012 $19,053 2011 $18,215 2010 $12,693 2009 $11,088 2008 $11,374 2007 $10,406 Coca-Cola Annual Inventory (Millions of US $) 2019 $3,379 2018 $3,071 2017 $2,655 2016 $2,675 2015 $2,902 2014 $3,100 2013 $3,277 2012 $3,264 2011 $3,092 2010 $2,650 2009 $2,354 2008 $2,187 2007 $2,220 Computation of inventory turnover ratio of Pepsi Particulars 2019 2018 Cost of goods sold $30,132 $29,381 Average inventory Inventory turnover ratio $3,338 $3,128 9.027 9.393 Computation of Average Days in Inventory of Pepsi Particulars 2019 2018 Number of Days 365 365 Inventory Turnover ratio 9.027 9.393 Average days in Inventory 40.434 38.859 Computation of Inventory turnover ratio of Coca Cola Particulars 2019 2018 Cost of goods sold Average inventory Inventory turnover ratio $14,619 $3,379 $13,067 $3,071 4.326 4.255 Computation of Average Days in Inventory of Coca Cola Particulars Number of Days 2019 2018 365 365 Inventory Turnover ratio Average days in Inventory 4.326 4.255 84.374 85.781 Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories. Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel: 1. Inventory turnover 2. Average days in inventory In a Word file, include the following: 1. Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio. 2. Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet. Pepsico Annual Inventory (Millions of US $) 2019 $3,338 2018 $3,128 2017 $2,947 2016 $2,723 2015 $2,720 2014 $3,143 2013 $3,409 2012 $3,581 2011 $3,827 2010 $3,372 2009 $2,618 2008 $2,522 2007 $2,290 Pepsico Annual Cost of Goods Sold (Millions of US $) 2019 $30,132 2018 $29,381 2017 $28,796 2016 $28,222 2015 $28,731 2014 $31,238 2013 $31,243 2012 $31,291 2011 $31,593 2010 $26,575 2009 $20,099 2008 $20,351 2007 $18,038 Coca-Cola Annual Cost of Goods Sold (Millions of US $) 2019 $14,619 2018 $13,067 2017 $13,721 2016 $16,465 2015 $17,482 2014 $17,889 2013 $18,421 2012 $19,053 2011 $18,215 2010 $12,693 2009 $11,088 2008 $11,374 2007 $10,406 Coca-Cola Annual Inventory (Millions of US $) 2019 $3,379 2018 $3,071 2017 $2,655 2016 $2,675 2015 $2,902 2014 $3,100 2013 $3,277 2012 $3,264 2011 $3,092 2010 $2,650 2009 $2,354 2008 $2,187 2007 $2,220 Computation of inventory turnover ratio of Pepsi Particulars 2019 2018 Cost of goods sold $30,132 $29,381 Average inventory Inventory turnover ratio $3,338 $3,128 9.027 9.393 Computation of Average Days in Inventory of Pepsi Particulars 2019 2018 Number of Days 365 365 Inventory Turnover ratio 9.027 9.393 Average days in Inventory 40.434 38.859 Computation of Inventory turnover ratio of Coca Cola Particulars 2019 2018 Cost of goods sold Average inventory Inventory turnover ratio $14,619 $3,379 $13,067 $3,071 4.326 4.255 Computation of Average Days in Inventory of Coca Cola Particulars Number of Days 2019 2018 365 365 Inventory Turnover ratio Average days in Inventory 4.326 4.255 84.374 85.781
Expert Answer:
Answer rating: 100% (QA)
TURNOVER RATIO INVENTORY COST OF Products SOLD AVG INVENTORIES AVERAGE DAYS IN I... View the full answer
Related Book For
Managerial Accounting A Focus on Ethical Decision Making
ISBN: 978-0324663853
5th edition
Authors: Steve Jackson, Roby Sawyers, Greg Jenkins
Posted Date:
Students also viewed these finance questions
-
A Quality Circle leader is confused about the seven basic quality tools, and approaches you to help him in using a tool for identifying the root cause of the problem. Discuss with example what tool...
-
The purpose of this assignment is to make sure that the students can work with the fork, pipe, and dup system calls. It should also grant some insight into how the shell makes input/output...
-
Write a blog post of no more than 800 words . The blog post should include five elements; particularly, it should -have a title and an image -have a logical structure and be targeted for a specific...
-
If you sign up for a savings account with an annual interest rate of 12% (1% per month) that you will receive 4 million won in 2 years, what is the monthly amount you have to pay? However, suppose...
-
Explain the purpose of the chisquare test for independence. Provide some practical examples where this test might be used in business.
-
A 2-cm by 3-cm waveguide is filled with a dielectric material with r = 4. If the waveguide operates at 20 GHz with TMU mode, find: (a) Cutoff frequency, (b) The phase constant, (c) The phase velocity.
-
Petitioner Atlantic Marine Company was a contractor located in Virginia. It entered into a subcontract with J-Crew Management, Inc., a Texas corporation, that contained a forum-selection clause...
-
Danny Spurlock and Tracy Wilson decided to form a partnership on July 1, 20-1. Spurlock invested $100,000 and Wilson invested $25,000. For the fiscal year ended June 30, 20-2, a net income of $80,000...
-
Before boarding her flight to Zurich, Switzerland, Mary purchased CHF850 from her bank when the exchange rate was C$1 = CHF0.9651. However, Mary had to cancel the trip. Mary returned to the bank to...
-
Find the Norton equivalent at terminals a-b of the circuit in Fig. 4.119 . Vo- +. 10 20 2 V.
-
Discuss why each one of the following is good legal advice: 1. Employers should adopt workplace privacy policies. 2. Searches should be no more extensive or intrusive than necessary.
-
As price falls, quantity demanded ________.
-
If a fi rms total revenue is $5 billion, its fi xed costs are $3 billion, and its variable costs are $1.5 billion, what does it do (a) in the short run and (b) in the long run?
-
If price is above ATC, the firm will ______. a) shut down in the short run and go out of business in the long run b) shut down in the short run and stay in business in the long run c) operate in the...
-
Equilibrium price is $ _________; equilibrium quantity is _______.
-
Practical Application: Lets say that you wanted to go into business for yourself. Your rich uncle offered to invest $100,000 in this business, but he had one provisionthat it must be a monopoly. What...
-
A major utility company, PowerGrid, is considering investing in renewable energy power plants to diversify its energy portfolio and meet the increasing demand for clean energy. However, they are...
-
Provide a draft/outline of legal research involving an indigenous Canadian woman charged with assault causing bodily harm under (Sec 267b) of the Criminal Code, where the crown wants a 12-month jail...
-
Define strategic and operational planning.
-
Describe the basic elements of a job cost sheet.
-
Hammonds Hammocks produces and sells top-of-the-line Brazilian-style hammocks. The company prepared a production budget for the second quarter of the year that revealed that required production is...
-
Why is it important to synchronize data and process models?
-
Create the use-case descriptions and diagram(s) for the system in problems 1 and 2. Be sure to create your use cases so that they are complete and clear. Remember, in real life, the system...
-
Conduct a technical feasibility study. What would you recommend the company use in the creation and maintenance of their site (e.g. languages, speciific host, encryption)? Why does your choice affect...
Study smarter with the SolutionInn App