The efficiency of Working Capital Management Bill Gates, Chairman of Microsoft inc, is concerned about the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The efficiency of Working Capital Management Bill Gates, Chairman of Microsoft inc, is concerned about the firm's high level of investment in short term assets. Bill is considering the reduction in such investments, which can be achieved by improved management of cash. Hence, Bill handed over the task of assessing the firm's cash management efficiency to Satya Nadella, the CEO of Microsoft. Nadella wants to start the assessment by scrutinizing Microsoft's cycle cash conversion operating and cycle. Nadella asked his subordinates for all the relevant information, and he was provided with the followings: Oracle (competitor) 45 Average payment period (in days) Average age of inventory (in days) Average collection period (in days) Microsoft 25 Revenue 120 Annual Investment in operating cycle Variable costs Bad debts 60 Microsoft associates a cost of $63,000 to extend the payment period to 40 days Microsoft associates a cost of $160,000 to reduce inventory age to 85 days Before $13,750,000 80 $13,000,000 35 Nadella used big data analytics, and statistical modeling to see the outcome of a 2% cash discount for payments made within 10 days. The statistical model predicted that such discount would reduce Microsoft's collection period to 42 days. In addition, the model predicted the following changes: 80% of sales n/a Industry 40 85 42 After Additional sales of $1,250,000 than before $14,100,000 80% of sales n/a 75% of total sales will use the benefit of the newly introduced 2% discount The operating-cycle investment across all organizations/ WC accounts will be same Nadella was not sure if Microsoft was managing an optimum level of investment in short term resources. However, he knew that current annual (365 days) interest rate in the market was 6.9%, and wanted to check if there are missing opportunities of earning extra by managing the cash conversion cycle efficiently. a) Assuming a constant rate for purchases, production, and sales throughout the year, what are Microsoft and its competitors existing operating cycle (OC), cash conversion cycle (CCC), and how much resource is absorbed in there CCCs? b) If Microsoft can optimize operations according to industry standards, what would its operating cycle (OC), cash conversion cycle (CCC) be, and how much of the resources will be absorbed in its CCC under these more efficient conditions? What about Oracle? c) What is the annual cost of Microsoft's operational inefficiency, or in other words, longer CCC? d) Based on your findings so far, should Microsoft & Oracle try to achieve industry level efficiency? Why or why not? Deadline Answer all the aforementioned questions (with calculations). Turn the assignment in through Classroom) on or before 03 September, 2023. N.B. - Each day of delayed submission of any item will be penalized with 1% reduction in the overall grade. Plagiarism will be met with highest penalty. The efficiency of Working Capital Management Bill Gates, Chairman of Microsoft inc, is concerned about the firm's high level of investment in short term assets. Bill is considering the reduction in such investments, which can be achieved by improved management of cash. Hence, Bill handed over the task of assessing the firm's cash management efficiency to Satya Nadella, the CEO of Microsoft. Nadella wants to start the assessment by scrutinizing Microsoft's cycle cash conversion operating and cycle. Nadella asked his subordinates for all the relevant information, and he was provided with the followings: Oracle (competitor) 45 Average payment period (in days) Average age of inventory (in days) Average collection period (in days) Microsoft 25 Revenue 120 Annual Investment in operating cycle Variable costs Bad debts 60 Microsoft associates a cost of $63,000 to extend the payment period to 40 days Microsoft associates a cost of $160,000 to reduce inventory age to 85 days Before $13,750,000 80 $13,000,000 35 Nadella used big data analytics, and statistical modeling to see the outcome of a 2% cash discount for payments made within 10 days. The statistical model predicted that such discount would reduce Microsoft's collection period to 42 days. In addition, the model predicted the following changes: 80% of sales n/a Industry 40 85 42 After Additional sales of $1,250,000 than before $14,100,000 80% of sales n/a 75% of total sales will use the benefit of the newly introduced 2% discount The operating-cycle investment across all organizations/ WC accounts will be same Nadella was not sure if Microsoft was managing an optimum level of investment in short term resources. However, he knew that current annual (365 days) interest rate in the market was 6.9%, and wanted to check if there are missing opportunities of earning extra by managing the cash conversion cycle efficiently. a) Assuming a constant rate for purchases, production, and sales throughout the year, what are Microsoft and its competitors existing operating cycle (OC), cash conversion cycle (CCC), and how much resource is absorbed in there CCCs? b) If Microsoft can optimize operations according to industry standards, what would its operating cycle (OC), cash conversion cycle (CCC) be, and how much of the resources will be absorbed in its CCC under these more efficient conditions? What about Oracle? c) What is the annual cost of Microsoft's operational inefficiency, or in other words, longer CCC? d) Based on your findings so far, should Microsoft & Oracle try to achieve industry level efficiency? Why or why not? Deadline Answer all the aforementioned questions (with calculations). Turn the assignment in through Classroom) on or before 03 September, 2023. N.B. - Each day of delayed submission of any item will be penalized with 1% reduction in the overall grade. Plagiarism will be met with highest penalty.
Expert Answer:
Answer rating: 100% (QA)
Based on the information provided we can assess the efficiency of Microsofts working capital management and compare it with industry standards and the competitor Oracle Lets address each question one ... View the full answer
Related Book For
Intermediate Financial Management
ISBN: 978-1111530266
11th edition
Authors: Eugene F. Brigham, Phillip R. Daves
Posted Date:
Students also viewed these accounting questions
-
H Ltd. is producing kitchen equipment from the five components three of which are made using general purpose machines and two by manual labour. The data for the manufacture of the equipment is as...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
The operations manager of a company that produces frozen dinners had received numerous complaints from supermarkets about the companys Chick-n-Gravy dinners. The manager spilled/mixed items,...
-
The following instalment payment schedule is for a long-term bank loan payable: Instructions (a) Is the above schedule a fi xed principal or blended principal and interest payment schedule? (b)...
-
Using the appropriate interest table, answer each of the following questions. Each case is independent of the others. a. What is the future value of 9,000 at the end of 5 periods at 8% compounded...
-
Recall that before drafting pleadings, multiple prefiling requirements must be considered. Review the California Code of Civil Procedure Section 372, which governs ones capacity to sue....
-
Why has eBay succeeded as an online auction marketplace while so many others have failed?
-
Create a PHP file to access your MySQLdatabase Create a PHP file and save it as guitar_list.php . (2) (3) Set the HTML title element for your new page to be Product Listing: Guitars . Add an...
-
Files and More, Inc. (F&M), a manufacturer of office equipment, uses MRP to schedule its production. Because of the current recession and the need to cut costs, F&M has targeted inventory as a prime...
-
What is capital budgeting? Your text book talks about several techniques for evaluating projects. Briefly discuss about the capital budgeting techniques with examples. If you were the CFO of XYZ...
-
When teachers say they are color blind, they are usually saying that they do not discriminate and that they treat all their students equally. Of course, being fair and treating each student with...
-
Define difference and articulate why it matters to the author (Allen, 2010) and to you. Be thoughtful in your response. Offer examples that support why difference is important to you. Ground your...
-
Identify and explain three principles of risk communication. Identify one person who has been communicating to the public about COVID-19 (this can be Dr. Fauci, the CDC, President Biden, your local...
-
Define a research question that can be answered (in full or in part) with qualitative data. Describe the sample of participants you might obtain to help you answer this research question. Draft an...
-
Description: In this assignment, you will assume the role of staff auditor. Your client is the Parks and Recreation Department in Boston, Massachusetts. Your task is to perform substantive and...
-
What is the weighted-average cost of capital for SKYE Corporation given the following information? Equity shares outstanding Stock price per share Yield to maturity on debt Book value of...
-
Compare and contrast debt financing and equity financing as ways of starting a new business. Does one have an overall advantage over the other? What situation is more favorable to the use of debt...
-
Madison Manufacturing is considering a new machine that costs $350,000 and would reduce pre-tax manufacturing costs by $110,000 annually. Madison would use the 3-year MACRS method to depreciate the...
-
Hatfield Medical Supplies's stock price had been lagging its industry averages, so its board of directors brought in a new CEO, Adam Lee. Lee asked for the company's long-run strategic plan; when he...
-
Woidtke Manufacturing's stock currently sells for $22 a share. The stock just paid a dividend of $1.20 a share (i.e., D0 5 $1.20), and the dividend is expected to grow forever at a constant rate of...
-
The financial management process is important for auditors because of its role in helping to form expectations about financial statement results. To illustrate this concept, explain how an...
-
Consider Manny Corp., our military outfitting operation from Chapter 10. Its financial data is reprinted here for convenience. a. If you were the auditor assigned to perform substantive analytical...
-
Following are some routine procedures for the audit of payroll (discussed in the Appendix). For each procedure, (1) state whether it is a test of controls or a substantive test, (2) state which...
Study smarter with the SolutionInn App