Case
Solutions to mini case 4 AFM (grade: 10/10)
- Module
- Institution
Correct solutions to mini case 4 of the course Advanced Financial Management at the VU. Grade: 10/10 Teachers: schauten & dijkstra
[Show more]
Seller
Followisabellaarnoldcrdenas
Reviews received
Content preview
Advanced Financial Management – Mini Case 4 Isabella Arnold, 2665767Mini 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:
𝑪𝒂𝒔𝒉 𝑪𝒐𝒏𝒗𝒆𝒓𝒔𝒊𝒐𝒏 𝑪𝒚𝒄𝒍𝒆
= 𝒊𝒏𝒗𝒆𝒏𝒕𝒐𝒓𝒚 𝒅𝒂𝒚𝒔 + 𝒂𝒄𝒄𝒐𝒖𝒏𝒕𝒔 𝒓𝒆𝒄𝒆𝒊𝒗𝒂𝒃𝒍𝒆 𝒅𝒂𝒚𝒔
− 𝒂𝒄𝒄𝒐𝒖𝒏𝒕𝒔 𝒑𝒂𝒚𝒂𝒃𝒍𝒆 𝒅𝒂𝒚𝒔
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller isabellaarnoldcrdenas. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £4.71. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81113 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now