What is the Operating Cash Flow and NOPLAT (Net operating profit less adjusted taxes) for the past
Fantastic news! We've Found the answer you've been seeking!
Question:
What is the Operating Cash Flow and NOPLAT (Net operating profit less adjusted taxes) for the past 5 years for Microsoft Corp?
Pick whichever one method/formula you want to use to solve from below. Show your work.
Operating Cash Flow
1. OCF = NOPLAT + Depreciation.
1A. OCF = (EBIT)(1-TC) + Depreciation.
2. OCF = Total Revenues - [(Cost of Goods Sold + Operating Expenses)] (1-Tax Rate) + Depreciation.
NOPLAT:
- NOPLAT = (EBIT)(1-Tax Rate)
- if you use another method/formula please show.
Transcribed Image Text:
Microsoft Corporation (NMs: MSFT) Exchange rate used is that of the Year End reported date As Reported Annual Income Statement Report Date Currency 06/30/2020 06/30/2019 06/30/2018 06/30/2017 06/30/2016 USD USD USD USD USD Not Qualified Audit Status Not Not Not Not Available Qualified Qualified Qualified Consolidated Yes Yes Yes Yes Yes Scale Thousands Thousands Thousands Thousands Thousands Product revenue 68041000 66069000 64497000 57190000 61502000 Service & other revenue 74974000 59774000 45863000 32760000 23818000 Revenue 143015000 125843000 110360000 89950000 85320000 Cost of revenue - product Cost of revenue - service & other revenue Cost of revenue Gross margin Research & development Sales & marketing 16017000 16273000 15420000 15175000 17880000 30061000 26637000 22933000 19086000 14900000 46078000 42910000 38353000 34261000 32780000 96937000 82933000 72007000 55689000 52540000 19269000 16876000 14726000 13037000 11988000 19598000 18213000 17469000 15539000 14697000 General & administrative 5111000 4885000 4754000 4481000 4563000 Impairment, integration, & restructuring Operating income (loss) Interest & dividends income Interest expense Net recognized gains on investments Net gains (losses) on derivatives Net gains (losses) on foreign currency remeasurements Other income (expense), net 306000 1110000 52959000 42959000 35058000 22326000 20182000 2680000 2762000 2214000 1387000 903000 2591000 2686000 2733000 2222000 1243000 32000 648000 2399000 2583000 668000 187000 144000 -187000 -510000 -443000 -191000 -82000 -218000 -164000 -121000 -40000 -57000 -59000 -251000 -195000 Other income, net 77000 729000 1416000 823000 -431000 453000 22696000 -325000 Income (loss) before income taxes - United States Income (loss) before income taxes - foreign Income (loss) before income taxes Current taxes provision (benefit) - United States federal Current taxes provision (benefit) - United States state & local Current taxes provision (benefit) - foreign Current taxes provision (benefit) Deferred taxes provision (benefit) - United States federal Deferred taxes provision (benefit) - United States state & loce Deferred taxes provision (benefit) - foreign Deferred taxes provision (benefit) 24116000 15799000 11527000 28920000 27889000 24947000 20076000 53036000 43688000 36474000 23149000 19751000 3537000 4718000 19764000 2739000 545000 763000 662000 934000 30000 136000 4444000 5531000 4348000 2472000 1940000 8744000 10911000 25046000 5241000 2621000 58000 -5647000 -4292000 -6000 -1010000 -458000 -41000 194000 -393000 11000 -6463000 -5143000 -3296000 332000 8755000 Provision for income taxes Net income (loss) Weighted average shares outstanding - basic Weighted average shares outstanding - diluted Year end shares outstanding Net earnings (loss) per share - basic Net earnings (loss) per share - diluted Cash dividends declared per common share Number of full time employees Number of common stockholders 4448000 19903000 1945000 2953000 44281000 39240000 16571000 21204000 16798000 7610000 7673000 7700000 7746000 7925000 7683000 7753000 7794000 7832000 8013000 7571000 7643000 7677000 7708000 7808000 5.82 5.11 2.15 2.74 2.12 5.76 5.06 2.13 2.71 2.1 2.04 1.84 1.68 1.56 1.44 163000 144000 97535 124000 114000 91674 94069 131000 101825 106534 Foreign currency translation adjustments -426000 -318000 228000 -519000 Microsoft Corporation (NMs: MSFT) Exchange rate used is that of the Year End reported date As Reported Annual Income Statement Report Date Currency 06/30/2020 06/30/2019 06/30/2018 06/30/2017 06/30/2016 USD USD USD USD USD Not Qualified Audit Status Not Not Not Not Available Qualified Qualified Qualified Consolidated Yes Yes Yes Yes Yes Scale Thousands Thousands Thousands Thousands Thousands Product revenue 68041000 66069000 64497000 57190000 61502000 Service & other revenue 74974000 59774000 45863000 32760000 23818000 Revenue 143015000 125843000 110360000 89950000 85320000 Cost of revenue - product Cost of revenue - service & other revenue Cost of revenue Gross margin Research & development Sales & marketing 16017000 16273000 15420000 15175000 17880000 30061000 26637000 22933000 19086000 14900000 46078000 42910000 38353000 34261000 32780000 96937000 82933000 72007000 55689000 52540000 19269000 16876000 14726000 13037000 11988000 19598000 18213000 17469000 15539000 14697000 General & administrative 5111000 4885000 4754000 4481000 4563000 Impairment, integration, & restructuring Operating income (loss) Interest & dividends income Interest expense Net recognized gains on investments Net gains (losses) on derivatives Net gains (losses) on foreign currency remeasurements Other income (expense), net 306000 1110000 52959000 42959000 35058000 22326000 20182000 2680000 2762000 2214000 1387000 903000 2591000 2686000 2733000 2222000 1243000 32000 648000 2399000 2583000 668000 187000 144000 -187000 -510000 -443000 -191000 -82000 -218000 -164000 -121000 -40000 -57000 -59000 -251000 -195000 Other income, net 77000 729000 1416000 823000 -431000 453000 22696000 -325000 Income (loss) before income taxes - United States Income (loss) before income taxes - foreign Income (loss) before income taxes Current taxes provision (benefit) - United States federal Current taxes provision (benefit) - United States state & local Current taxes provision (benefit) - foreign Current taxes provision (benefit) Deferred taxes provision (benefit) - United States federal Deferred taxes provision (benefit) - United States state & loce Deferred taxes provision (benefit) - foreign Deferred taxes provision (benefit) 24116000 15799000 11527000 28920000 27889000 24947000 20076000 53036000 43688000 36474000 23149000 19751000 3537000 4718000 19764000 2739000 545000 763000 662000 934000 30000 136000 4444000 5531000 4348000 2472000 1940000 8744000 10911000 25046000 5241000 2621000 58000 -5647000 -4292000 -6000 -1010000 -458000 -41000 194000 -393000 11000 -6463000 -5143000 -3296000 332000 8755000 Provision for income taxes Net income (loss) Weighted average shares outstanding - basic Weighted average shares outstanding - diluted Year end shares outstanding Net earnings (loss) per share - basic Net earnings (loss) per share - diluted Cash dividends declared per common share Number of full time employees Number of common stockholders 4448000 19903000 1945000 2953000 44281000 39240000 16571000 21204000 16798000 7610000 7673000 7700000 7746000 7925000 7683000 7753000 7794000 7832000 8013000 7571000 7643000 7677000 7708000 7808000 5.82 5.11 2.15 2.74 2.12 5.76 5.06 2.13 2.71 2.1 2.04 1.84 1.68 1.56 1.44 163000 144000 97535 124000 114000 91674 94069 131000 101825 106534 Foreign currency translation adjustments -426000 -318000 228000 -519000
Expert Answer:
Answer rating: 100% (QA)
NOPLAT is earning after tax that is net incomeloss is here 2020 44281000 2019 39240... View the full answer
Related Book For
Essentials of Materials Science and Engineering
ISBN: 978-1111576851
3rd edition
Authors: Donald R. Askeland, Wendelin J. Wright
Posted Date:
Students also viewed these accounting questions
-
Q1: You bought a small cap, illiquid stock 6 months ago, paying $1,734.55 per share. Two weeks ago, due to some unexpected financial pressures, you needed to sell the stock, with some urgency. You...
-
The 1-dimensional heat equation is given as follows: du d'u dt - =k- for all 0xL and t>0 dx Deduce the solution to the above differential equation, subjected to the following boundary and initial...
-
What is underapplied overhead? When Cost of Goods Sold is adjusted for underapplied overhead, will the cost increase or decrease? Why?
-
The following data have been extracted from the financial statements of Prentiss, Inc., a calendar-year merchandising corporation: Total sales for 2018 were $1,200,000 and for 2017 were $1,100,000....
-
Consider the reaction Q + R S + T and the rate law for the reaction: Rate = k[Q]0[R]2 a. You run the reaction three times, each time starting with [R] = 2.0 M. For each run you change the starting...
-
On April 1, Soccer Kicks of Toledo prepaid six months of rent, \($4,800\). Requirements 1. Record the journal entry for the April 1 payment. 2. Record the adjusting entry required at April 30. 3....
-
For the standpipe system shown in Fig. P8.94, calculate the flow rate for \(H=4.0 \mathrm{ft}, D=6.77\) in., \(d=0.125\) in., and \(L=48\) in. The fluid is \(70^{\circ} \mathrm{F}\) water. Assume...
-
What is the minimum cost of crashing the following project that James Walters manages at Ball State University by 4days? Normal Crash Time Time Normal Crash Immediate Activity (days) (days) Cost Cost...
-
Describe the advancements and challenges associated with the implementation of smart grids in modern electrical distribution systems, emphasizing their potential benefits in optimizing power delivery...
-
Amherst Networking Systems adjusts and closes its books and then prepares financial statements monthly. Amherst uses the perpetual inventory system and all sales on credit have terms of n/30. The...
-
Ram, Shyam and Raman get their salary in the ratio 3:5:7. If Ram and Shyam get Rs. 2000 after 25% canteen expenses been cut from their salary. How much money Raman will get if he don't eat canteen...
-
A ____________ in the BCG Matrix would have a high market share in a low-growth market, and the correct grand or master strategy is ____________. (a) Dog, growth (b) Cash Cow, stability (c) Question...
-
List five steps in the planning process.
-
The first component of a good business plan is usually a/an ____________. (a) industry analysis (b) marketing strategy (c) executive summary of mission and business model (d) set of financial...
-
The people who take ownership shares in new ventures in return for providing the entrepreneurs with critical start-up funds are called ____________. (a) business incubators (b) angel investors (c)...
-
In Hofstedes study of national cultures, Canada was found to be the most ____________ compared with other countries in his sample. (a) individualistic (b) collectivist (c) feminine (d) long-term...
-
Iramba Sea Foods Investment is negotiating a Loan from Tanzania Investments Bank which has kindly requested the Company to prepare and submit their cash budget for the first half year. The following...
-
What key concerns must functional tactics address in marketing? Finance? POM? Personnel?
-
A plot of true stress versus true strain for a metal. For total imposed strains of ε = 0.1, 0.2, 0.3 and 0.4, determine the elastic and plastic components of the strain. The modulus of...
-
A 1050 steel should be austenitized at 820 C, quenched in oil to 25 C, and tempered at 400 C for an appropriate time. (a) What yield strength, hardness, and % elongation would you expect to obtain...
-
Determine the Miller indices of the plane that passes through three points having the following coordinates. (a) (0, 0, 1); (1, 0, 0); and (, , 0) (b) (, 0, 1); (, 0, 0); and (0, 1, 0) (c) (1, 0, 0);...
-
The NCAA is described as a cartel. In what way is it a cartel? What is the product being produced? How does the cartel stay together?
-
What is the cost to a firm in an oligopoly that fails to take rivals actions into account?
-
The cement industry is an example of an undifferentiated oligopoly. The automobile industry is a differentiated oligopoly. Which of these two is more likely to advertise? Why?
Study smarter with the SolutionInn App