Advanced Financial Management – Mini Case 4 Isabella Arnold, 2665767
Mini Case 4
I hereby certify that the following is my own work and my work alone. I also certify that the
content in this document has not previously been submitted for any other assignment in this
course or any other course, and that I have not copied or otherwise plagiarized the work of
others.
Question 1a:
Done
Question 1b + 1c:
Coca Cola
Breakdown
TTM 12/30/2021 12/30/2020 12/30/2019 12/30/2018
Total Revenue 41,322,000 38,655,000 33,014,000 37,266,000 31,856,000
Cost of Revenue 16,986,000 15,357,000 13,433,000 14,619,000 11,770,000
Receivables 3,512,000 3,144,000 3,971,000 3,396,000
Inventory 3,414,000 3,266,000 3,379,000 2,766,000
Accounts Payable 4,602,000 3,517,000 3,804,000 2,498,000
Question 2a:
Done
Question 2b:
Pepsi Co
Breakdown
TTM 12/30/2021 12/30/2020 12/30/2019 12/30/2018
Total Revenue 81,862,000 79,474,000 70,372,000 67,161,000 64,661,000
Cost of Revenue 38,372,000 37,075,000 31,797,000 30,132,000 29,381,000
Receivables 8,680,000 8,404,000 7,822,000 7,142,000
Inventory 4,347,000 4,172,000 3,338,000 3,128,000
Accounts Payable 9,834,000 8,853,000 8,013,000 7,213,000
, Advanced Financial Management – Mini Case 4 Isabella Arnold, 2665767
Question 2c:
AB InBev
Breakdown
TTM 12/30/2021 12/30/2020 12/30/2019 12/30/2018
Total Revenue 56,499,000 54,304,000 46,881,000 52,329,000 54,619,000
Cost of Revenue 24,918,000 23,097,000 19,634,000 20,362,000 20,359,000
Receivables 5,077,000 5,134,000 6,250,000 6,503,000
Inventory 5,284,000 4,391,000 4,322,000 4,111,000
Accounts Payable 17,810,000 15,898,000 15,876,000 15,512,000
Question 3a:
𝐼𝑛𝑣𝑒𝑛𝑡𝑜𝑟𝑦
𝐼𝑛𝑣𝑒𝑛𝑡𝑜𝑟𝑦 𝑑𝑎𝑦𝑠 = ∗ 365
𝐶𝑂𝐺𝑆
3.4 𝑏𝑙𝑛
𝐼𝑛𝑣𝑒𝑛𝑡𝑜𝑟𝑦 𝑑𝑎𝑦𝑠 = ∗ 365 ≈ 81 𝑏𝑙𝑛
15.4 𝑏𝑙𝑛
Hence, the inventory days are approx.: 81 bln
Question 3b:
𝐴𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑟𝑒𝑐𝑒𝑖𝑣𝑎𝑏𝑙𝑒𝑠
𝐴𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑟𝑒𝑐𝑒𝑖𝑣𝑎𝑏𝑙𝑒 𝑑𝑎𝑦𝑠 = ∗ 365
𝑅𝑒𝑣𝑒𝑛𝑢𝑒
3.5
𝐴𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑟𝑒𝑐𝑒𝑖𝑣𝑎𝑏𝑙𝑒 𝑑𝑎𝑦𝑠 = ∗ 365 ≈ 33 𝑏𝑙𝑛
38.7
Hence, the accounts receivable days are approx.: 33 bln
Question 3c:
𝐴𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑝𝑎𝑦𝑎𝑏𝑙𝑒
𝐴𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑝𝑎𝑦𝑎𝑏𝑙𝑒 𝑑𝑎𝑦𝑠 = ∗ 365
𝐶𝑂𝐺𝑆
4.6
𝐴𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑝𝑎𝑦𝑎𝑏𝑙𝑒 𝑑𝑎𝑦𝑠 = ∗ 365 ≈ 109 𝑏𝑙𝑛
15.4
Hence, the accounts payable days are approx.: 109 bln
Question 3d:
𝑪𝒂𝒔𝒉 𝑪𝒐𝒏𝒗𝒆𝒓𝒔𝒊𝒐𝒏 𝑪𝒚𝒄𝒍𝒆
= 𝒊𝒏𝒗𝒆𝒏𝒕𝒐𝒓𝒚 𝒅𝒂𝒚𝒔 + 𝒂𝒄𝒄𝒐𝒖𝒏𝒕𝒔 𝒓𝒆𝒄𝒆𝒊𝒗𝒂𝒃𝒍𝒆 𝒅𝒂𝒚𝒔
− 𝒂𝒄𝒄𝒐𝒖𝒏𝒕𝒔 𝒑𝒂𝒚𝒂𝒃𝒍𝒆 𝒅𝒂𝒚𝒔
Mini Case 4
I hereby certify that the following is my own work and my work alone. I also certify that the
content in this document has not previously been submitted for any other assignment in this
course or any other course, and that I have not copied or otherwise plagiarized the work of
others.
Question 1a:
Done
Question 1b + 1c:
Coca Cola
Breakdown
TTM 12/30/2021 12/30/2020 12/30/2019 12/30/2018
Total Revenue 41,322,000 38,655,000 33,014,000 37,266,000 31,856,000
Cost of Revenue 16,986,000 15,357,000 13,433,000 14,619,000 11,770,000
Receivables 3,512,000 3,144,000 3,971,000 3,396,000
Inventory 3,414,000 3,266,000 3,379,000 2,766,000
Accounts Payable 4,602,000 3,517,000 3,804,000 2,498,000
Question 2a:
Done
Question 2b:
Pepsi Co
Breakdown
TTM 12/30/2021 12/30/2020 12/30/2019 12/30/2018
Total Revenue 81,862,000 79,474,000 70,372,000 67,161,000 64,661,000
Cost of Revenue 38,372,000 37,075,000 31,797,000 30,132,000 29,381,000
Receivables 8,680,000 8,404,000 7,822,000 7,142,000
Inventory 4,347,000 4,172,000 3,338,000 3,128,000
Accounts Payable 9,834,000 8,853,000 8,013,000 7,213,000
, Advanced Financial Management – Mini Case 4 Isabella Arnold, 2665767
Question 2c:
AB InBev
Breakdown
TTM 12/30/2021 12/30/2020 12/30/2019 12/30/2018
Total Revenue 56,499,000 54,304,000 46,881,000 52,329,000 54,619,000
Cost of Revenue 24,918,000 23,097,000 19,634,000 20,362,000 20,359,000
Receivables 5,077,000 5,134,000 6,250,000 6,503,000
Inventory 5,284,000 4,391,000 4,322,000 4,111,000
Accounts Payable 17,810,000 15,898,000 15,876,000 15,512,000
Question 3a:
𝐼𝑛𝑣𝑒𝑛𝑡𝑜𝑟𝑦
𝐼𝑛𝑣𝑒𝑛𝑡𝑜𝑟𝑦 𝑑𝑎𝑦𝑠 = ∗ 365
𝐶𝑂𝐺𝑆
3.4 𝑏𝑙𝑛
𝐼𝑛𝑣𝑒𝑛𝑡𝑜𝑟𝑦 𝑑𝑎𝑦𝑠 = ∗ 365 ≈ 81 𝑏𝑙𝑛
15.4 𝑏𝑙𝑛
Hence, the inventory days are approx.: 81 bln
Question 3b:
𝐴𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑟𝑒𝑐𝑒𝑖𝑣𝑎𝑏𝑙𝑒𝑠
𝐴𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑟𝑒𝑐𝑒𝑖𝑣𝑎𝑏𝑙𝑒 𝑑𝑎𝑦𝑠 = ∗ 365
𝑅𝑒𝑣𝑒𝑛𝑢𝑒
3.5
𝐴𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑟𝑒𝑐𝑒𝑖𝑣𝑎𝑏𝑙𝑒 𝑑𝑎𝑦𝑠 = ∗ 365 ≈ 33 𝑏𝑙𝑛
38.7
Hence, the accounts receivable days are approx.: 33 bln
Question 3c:
𝐴𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑝𝑎𝑦𝑎𝑏𝑙𝑒
𝐴𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑝𝑎𝑦𝑎𝑏𝑙𝑒 𝑑𝑎𝑦𝑠 = ∗ 365
𝐶𝑂𝐺𝑆
4.6
𝐴𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑝𝑎𝑦𝑎𝑏𝑙𝑒 𝑑𝑎𝑦𝑠 = ∗ 365 ≈ 109 𝑏𝑙𝑛
15.4
Hence, the accounts payable days are approx.: 109 bln
Question 3d:
𝑪𝒂𝒔𝒉 𝑪𝒐𝒏𝒗𝒆𝒓𝒔𝒊𝒐𝒏 𝑪𝒚𝒄𝒍𝒆
= 𝒊𝒏𝒗𝒆𝒏𝒕𝒐𝒓𝒚 𝒅𝒂𝒚𝒔 + 𝒂𝒄𝒄𝒐𝒖𝒏𝒕𝒔 𝒓𝒆𝒄𝒆𝒊𝒗𝒂𝒃𝒍𝒆 𝒅𝒂𝒚𝒔
− 𝒂𝒄𝒄𝒐𝒖𝒏𝒕𝒔 𝒑𝒂𝒚𝒂𝒃𝒍𝒆 𝒅𝒂𝒚𝒔
