Option 1. Prioritizing customers
9.I’d like to focus on the Wines & Spirits segment and select the U.S. (34%) and Asia ex-Japan (18%) regions for a new product launch. Together they make up 52%, while the remaining regions total 48%. Can I prioritize these two regions even though the split isn’t exactly 50/50?
Yes, that will be perfectly fine. The proportions are close enough to 50/50.
8. While I have selected Option 1 as my primary focus for McDonald’s, I find myself still curious about the broader aspects of how to understand this financial document.(It seems no payable and inventory?)
Excellent questions. Mc Donalds is different than their competitors. In their case, 95% of the business is operated by franchisees and they buy the products directly from the suppiers. That is the reason why there is almost no inventory or accounts payable.
On the other hand, the major investment that Mc Donalds makes is in owning the Real Estate. That is why the % of Net Property, Plant and Equipment is so high. These figures are from the WSJ
7. Financial Impact client prioritization. I am currently working on client prioritization and segmentation but am facing some difficulty in calculating the financial impact. Since the revenue for Google is projected to double from $350,018 to $700,038 in FY 2025, I wanted to clarify how we should attribute this increase.
Specifically, should we assume that these 100 consumers will be responsible for the entire revenue, with each customer spending approximately $7,000, making it easier to estimate revenue loss per customer? Would this mean the company could lose half its revenue if these customers leave? Or is there a better way to make this assumption?
This problem is about making a choice. As a markeer, you need to evaluate customer value:
1.Determine how much is a new customer woth compared to losing an old customer
2.Adapt the scenario to Google’s business model:
Research Google’s largest clients using Perplexity
Categorize clients as “old” and “new” based on industry sectors
For example:
Old customers: Finance and Insurance industries
New customers: Computer & Consumer Electronics industries
3.Analyze the impact of customer loss:
Research Google’s most significant customer loss and its consequences
Remember, as a marketer, your goal is to retain both new and existing customers.
For simplicity in calculations, you can use the $7Billion per client you asked me about in your question. If you chose to sell to old customers, you are losing the new ones, and vice-versa. What’s best?
6. How do I quantify the P&L impact of something I recommend?
For any marketing activity you propose, always quantify its P&L impact.
The easiest way to solve Financial problems is to start by looking at the “what happens if I do nothing scenario”, quantifying the impact of what you are proposing to do, and then comparing the two alternatives.
Example number 1
Customers will get a 10% discount for Pre-ordering. Unless this will get you to sell more units, the cost is easy: you will lose 10%
Do nothing: 10 units at$1,000= $10,000
10% discount 10 units at $900=$9,000. You lost 10% or $1,000.
Example number 2. This is for the Accounts Receivables problem (option 3)
The Account Receivable for your company is 30 days. Because your company is a Fortune 500, you can assume that the cost of debt is 5%. If you get paid now, instead of in 30 days, you will reduce your borrowing cost by one month. You pay 5% to borrow money for a year, or 0.4% for a month. You would save 0.4%. Imagine you would give a 10% cash discount. This is how you could quantify it:
Do nothing and collect in 30 days: your borrowing cost is 0.4%. Your sales are $ 10 Billion, the cost is $40 million (0.4% of $10 Billion)
You offer a 10% cash discount: Your cost is 10% of sales or $10 Billion, or $1 Billion. You spend $1 Billion on the discount and save $40 million on borrowing cost. You are $960 million worse off compared to the do-nothing scenario. In general, cash discounts only pay off if it enables you to sell more units
Option 2. Accounts receivables/ accounts payable
See Option 1 above an example on how to quantify the impact of what you will propose
7. For the Reduction of Receivables by cash discount, should we calculate the discount based on the total Receivables or should we assume a scenario, e.g. 50% of customers take advantage of the discount?
Great question. Assume a ratio. Because we don’t work in the company, we don’t have access to that figure, you can make it up. What you want to show is that you will know how to calculate the cost.
8.For the Payment by Credit Card for Small Businesses, how should we determine the percentage of small business customers within our total sales?
Same as above. Assume a ratio. Because we don’t work in the company, we don’t have access to that figure, you can make it up. What you want to show is that you will know how to calculate the cost.
5.s it necessary to increase the payables and decrease the receivables? Can we go vice-versa or increase/ decrease both?
The objective is to increase cash. If we decrease Payables we would need more cash. If we increase receivables we are getting less cash, so it doesn’t help either. While you could do just one, it’s safer if we develop a strategy for both.
4.By the logic of increasing payables and decreasing receivables, is it because we want more ready cash and more immediate payments and we increase payables because we want a grace period for payments since we have less cash?
Yes, the objective is to increase cash. However, we need to measure the financial consequences of it. For example, if we get a 3% discount for paying cash instead of in 30 days, we are much better off paying cash. The annualized rate of interest is 43%, and our cost of borrowing is substantially lower than that. On the other hand, if suppliers don’t give us any incentive to pay on time or faster, we need to develop a strategy. When we think about receivables, we need to do the opposite. What incentives does a customer have to pay ontime? If when they pay late, nothing happens to them, while would they pay on time?
3.Immediate payments go to cash and do not go to accounts receivables, correct?
Yes, that is correct.
2.Nike doesn’t split its financial report into “unit sales by product” into the specific product i.e. the Air Force One (it just splits it into apparel, footwear, equipment, other). How would I go about calculating my accounts receivables/accounts payables for a product? ? I know Nike sells over 10 million Air Force Ones a year.
To calculate the level for one product, please use the overall numbers. I prefer the number of inventory days, but inventory turnover is also widely used. All the figures below are from Nike’s 2019 Annual report.
The number of inventory days is 94. Here is the “good enough formula”: ending inventory($5,622)/divided by cost of sales ($39,117 minus $17,474) times 365. That’s 94
The “correct formula” is
- Average inventory, (beginning inventory and ending inventory divided by two).
- Cost of goods sold,
- Divide cost of average inventory by cost of goods sold
Once we know that in general, we have 94 days of inventory, and we can add 10% more if you wish. Caution: what if it is a failure? What if there is greater demand?
If they sell 10 million units, 94 days of inventory would be 2.58 million. Once you add 10% more, that would be 2.8 million units.
1.How would I go about calculating my accounts receivables/accounts payables in this circumstance?
Treat the Accounts Payable and Accounts Receivable part of the exercise separately, it would be easier. Imagine that you have been asked to encourage the Finance team to save cash. You will use the launch of the new product as an excuse. What business incentives could you give?
First, how many days do we have? Receivables are $4,272/$39,117= 40 days
Payables are $2,612/$39,117= well above 24 days (It’s incorrect to divide by revenues as I am doing, we should have divided by cost, but we don’t know how much it is because payables may include expenses). Even if payables were twice as many days (48 instead of 24), it’s well below Receivables and inventory (94+40=134). What can we do to increase Payables and decrease Receivables?
I’m in the 3M team. By reading 3M Balance Sheet, I learned that 3M’s inventory control is very good, only 91 Million. This is due to excellent supply chain management and steady growth in market demand. In 2020, accounts receivable fell by nearly half compared with 2019. Accounts payable also doubled. Perhaps because of the pandemic, money is tight between companies and other enterprises. However, net income has increased a lot. 3M’s sales have been stable for the past three years but its debt has increased. This is an increase of nearly 34.2 percent compared to 2018.
The subject of my research is the Disney Corporation. By searching the internet for relevant information, I learned that Disney Corporation’s accounts receivables decreased by one percent in 2021 compared to 2020. This phenomenon indicates that the company’s cash flow in 2021 is still in good hands. Due to the pandemic in 2021, Disney’s main revenue comes from subscriptions. Let’s look at the situation of Disney’s accounts payable. The company’s accounts payable in 2021 increased by 29.2 percent compared to 2020, but I think the company still needs to increase its payable debt in the future because the company still needs a lot of cash flow.
Inventory Management: Apple introduces iPhone 14 and iPhone 14 Plus. A new, larger 6.7-inch size joins the popular 6.1-inch design, featuring a new dual-camera system, Crash Detection, a smartphone industry-first safety service with Emergency SOS via satellite, and the best battery life on iPhone. According to the Apple Balance Sheet 2021, Apple had Total asset of 351,002,000, Total Liabilities of 287,912,000, and Total Equity of 63,090,000. To calculate how many units to have on Inventory, first looking at Net sales for iPhone for 2021 was $ 191,973 million. As of 2021-09-25, Apple had Cost of Goods sold of $213 billion, Average inventory of $5.321 Billion; therefore the Inventory Turnover for fiscal year 2021 would be 40.0x. The Inventory Turnover ratio measures the number for times a company’s inventory is sold and replaced over a year. A low turnover ratio can serve as a leading indicator of poor sales (excess inventory) while a high ratio may imply strong sales. Therefore, Apple’s high ratio of Inventory Turnover indicates the strong sales for the new product. To deal with the strong sales for the new product, Apple allows customers to pre-order to receive new products on a first-come-first-serve basis. The pre-ordering through digital platforms can increase sales for new products and visualize the hype of demand for new products.
Apple inventory for the quarter ending June 30, 2022, was $5.433B, a 4.92% increase year-over-year. Apple’s average total inventories from the quarter that ended in Mar. 2022 to the quarter that ended in Jun. 2022 was $5,447 Mil. Even in an environment of demand uncertainty and disruptions caused by the COVID-19 crisis, Apple has managed its supply chain tightly.
Apple’s products have a life cycle of about twelve months, depreciating in value by 1-2% every week. With this in mind, Apple decided to treat inventory as if all of its products had an expiration date. The goal is to keep as little inventory as possible to ensure that they sold everything they produced
The annual report result that Apple has a high ratio of Inventory Turnover, which indicates Apple has strong sales for the new product. Apple launch a pre-order strategy for the customer to receive new products on a first-come-first-serve basis, this strategy through digital platforms will increase sales for new products, which also clearly noticed how much inventory Apple should prepare.
After reading the slides from Terrace Huang, I agree with how Apple deals with its inventory management. I believe it’s very efficient and cost-effective. However, my biggest concern is consumers would be willing to wait this long if the understocking persists, they might switch to other competitors with fewer wait times. And how would Apple address this problem?
Meta primarily generates revenue from advertising and does not maintain inventory in its financial statements. Between 2022 and 2023, its Accounts Receivables grew by 20%, significantly impacting cash flow. At the same time, heavy investments in AI, the Metaverse, and AR/VR products have further strained liquidity. To address this, Meta should implement strategies to optimize Account Receivables and Accounts Payables to enhance cash flow management.
To reduce Accounts Receivables, Meta could implement strategies such as offering early payment incentives to advertisers. For instance, advertisers who settle their invoices within 10 days instead of the standard 30-day period could receive discounts or additional advertising credits. Additionally, Meta could encourage long-term partnerships by providing favourable terms to advertisers or partners who commit to contracts lasting two years or more. These measures would accelerate cash inflows and improve liquidity. On the other hand, Meta could strategically increase its Accounts Payables by negotiating extended payment terms with suppliers or vendors. By deferring payments without incurring penalties, Meta can retain cash for a longer period, thereby enhancing its working capital.