Question

In: Accounting

showing your work, use the 2018-2019 10k from apple and microsoft to calculate the average days...

showing your work, use the 2018-2019 10k from apple and microsoft to calculate the average days to collect as well as inventory turnover ratio.

file:///C:/Users/chase/Downloads/Apple%2010-K%20for%202018.pdf

file:///C:/Users/chase/Downloads/Microsoft%2010-K%20for%202019.pdf

Solutions

Expert Solution

Apple 2019 2018
average days to collect 365/accounts receivable turnover ratio 365/11.28 32 365/11.45 32
accounts receivable turnover ratio total net sales/average accounts receivables 260174/23056 11.28 265595/23186 11.45
average accounts receivables (22926+23186)/2 23056 23186
Inventory turnover ratio cost of sales/average inventory 161782/4031 40.13 163756/3956 41.39
average inventory (4106+3956)/2 4031 3956
Microsoft 2019 2018
average days to collect 365/accounts receivable turnover ratio 365/4.49 81 365/5.17 71
accounts receivable turnover ratio total net sales/average accounts receivables 125843/28002.5 4.49 110360/26481 4.17
average accounts receivables (29524+26481)/2 28002.5 23056 26481
Inventory turnover ratio cost of sales/average inventory 42910/2362.5 18.16 38353/2662 14.41
average inventory (2063+2662)/2 2362.5 2662

Related Solutions

Review the 10k reports from Microsoft and Apple in 2018-2019, write a few paragraphs about which...
Review the 10k reports from Microsoft and Apple in 2018-2019, write a few paragraphs about which company you would rather invest in maybe give a a few reasons why you choose this company with possible financial information and non-financial information in it. Thank you :)
Use this 10K report from 2018 to calculate Amazon's Operations Profit Margin. Please show your work....
Use this 10K report from 2018 to calculate Amazon's Operations Profit Margin. Please show your work. https://fintel.io/doc/www.sec.gov/Archives/edgar/data/1018724/000101872418000005/amzn-20171231x10k.htm Do you think they are a well-run company after viewing their financial statements and reading through the note in the 10k?
Use this 10K report from 2018 to calculate Amazon's Net Profit Margin Ratio. Please show your...
Use this 10K report from 2018 to calculate Amazon's Net Profit Margin Ratio. Please show your work. https://fintel.io/doc/www.sec.gov/Archives/edgar/data/1018724/000101872418000005/amzn-20171231x10k.htm Do you think they are a well-run company after viewing their financial statements and reading through the note in the 10k?
Calculate the descriptive statistics BY HAND (showing your work) (variance , standard deviation, range, average, dispersion,...
Calculate the descriptive statistics BY HAND (showing your work) (variance , standard deviation, range, average, dispersion, median, mode)that we've covered in class for the two following variables: Variable X Variable Y 4 40 2 36 8 49 6 38 10 56 5 58 3 39 9 53 10 34 9 47
If the DuPont Analysis for Apple (in 2018) is 54.77% and the same analysis for Microsoft...
If the DuPont Analysis for Apple (in 2018) is 54.77% and the same analysis for Microsoft (also in 2018) is 39.88%, then... Explain how the debt has served to influence the ROE DuPont performance results for each company you choose, and then describe how volatility plays a role in the debt choices in the context of this DuPont analysis. Explore the factors that influence the valuation of equity.
SUMMARIZE YOUR CALCULATIONS AND USE MICROSOFT EXCEL. DRAW ONE GRAPH SHOWING AVERAGE FIXED COSTS, AVERAGE VARIABLE COSTS, AVERAGE TOTAL COSTS, MARGINAL REVENUE AND MARGINAL COSTS.
OUTPUT AVERAGE FIXED COST AVERAGE VARIABLE COST AVERAGE TOTAL COST 0 1 $180.00 $135.00 $315.00 2 $90.00 $127.50 $217.50 3 $60.00 $120.00 $180.00 4 $45.00 $112.50 $157.50 5 $36.00 $111.00 $147.00 6 $30.00 $112.50 $142.50 7 $25.71 $115.70 $141.41 8 $22.50 $121.90 $144.40 9 $20.00 $130.00 $150.00 10 $18.00 $139.50 $157.50 OUTPUT MARGINAL COST PRICE TOTAL REVENUE TOTAL REVENUE 0 $345.00 1 $300.00 2 $249.00 3 $213.00 4 $189.00 5 $165.00 6 $144.00 7 $126.00 8 $111.00 9 $99.00 10...
Looking at the footnote disclosures of the Form 10K (2018 and 2019) for UnitedHealth Group, what...
Looking at the footnote disclosures of the Form 10K (2018 and 2019) for UnitedHealth Group, what are the individual components of property, plant, and equipment (PP&E)? For example, what are the amounts for land, building, equipment, accumulated depreciation, and so forth?
Calculate Beta for Apple and Microsoft, using a characteristic line. Display the data points on a...
Calculate Beta for Apple and Microsoft, using a characteristic line. Display the data points on a graph and display the characteristic line. Yearly Returns Microsoft Apple Market Jan 2010 - Dec 2010 Year. 1 -0.34% 5.18% 14.93% Jan 2011 - Dec 2011 Year. 2 -0.37% 7.93% 2.06% Jan 2012 - Dec 2012 Year. 3 0.40% 5.15% 15.84% Jan 2013 - Dec 2013 Year 4 2.81% 5.99% 32.21% Jan 2014 - Dec 2014 Year. 5 1.91% 4.62% 13.53% Jan 2015 -...
Calculate Beta for Apple and Microsoft, using a characteristic line. Display the data points on a...
Calculate Beta for Apple and Microsoft, using a characteristic line. Display the data points on a graph and display the characteristic line. Year Microsoft Apple Market Jan 2010 - Dec 2010 1 -0.34% 3.85% 14.93% Jan 2011 - Dec 2011 2 -0.37% 2.09% 2.06% Jan 2012 - Dec 2012 3 0.40% 2.87% 15.84% Jan 2013 - Dec 2013 4 2.81% 0.38% 32.21% Jan 2014 - Dec 2014 5 1.91% 3.05% 13.53% Jan 2015 - Dec 2015 6 1.75% -0.45% 1.34%...
Review Apple Inc.'s financial statements in 2018 10K form and write two paragraphs about Apple's horizontal...
Review Apple Inc.'s financial statements in 2018 10K form and write two paragraphs about Apple's horizontal financial analysis.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT