1 / 5100%
Individual LearningProjectQuestions
Name_______________________________
General Information:
1.What is the name of your corporation? Microsoft Corporation
2.Where are the corporate headquarters? One Microsoft Way, Redmond, WA 98052
3.What is the corporation’s fiscal year end? June
4.What are the primary products or services of the corporation? Operating System, Office Software, Game
Consoles, Laptops
5.Graph the high and low price of the company’s stock for eachquarter of the last two years.What was
the high and what was the low?
Q1 19 $101.57
Q2 19 $102.32
Q3 19 $117.94
Q4 19 $133.96
Q1 20 $139.03
Q2 20 $157.70
Q3 20 $157.71
Q4 20 $203.51
6.Who is the company’s transfer agent and where are they located? ComputerShare P.O. Box 505005
Louisville, Kentucky 40233
7.Who are your company’s competitors? Apple, AWS, Google, IBM, Cisco, Oracle, VMware, Sony, Salesforce
and Mozilla.
Market Information:
8.On which stock exchange is your corporation’s stock traded? Nasdaq
9.What is the current market price of their stock? $213.26
10.What is the ticker symbol used to identify your corporation on the stock exchange? MSFT
Internet Information:
11.What is the Internet address of your corporation? Be sure it appears as a hyperlink.
https://www.microsoft.com/en-us
12.Is the corporation’s Annual Report online? Yes
13.Are its financial statements on-line? Yes
14.Is your company listed on Annualreports.com? Yes
15.How long is your company’s 10-K report at the Securities and Exchange Commission website (Edgar
Database)?104 pages
Cash Flow and Retained Earnings:
16.List the amount of cash flows from each of the3activities:Operating, Investing, and Financing for
the2most recent years. What was the increase or decrease in cash for each of these years? 2020,
2019
Operating 60,675 52,185
Financing (40,031) (36,887)
Investing 13,576 11,356
17.Were there any Non-Cash Investing/Financing Transactions? Describe the type and amount.
- Additions to property and equipment (15,441)
- Acquisition of companies (2,251)
- Purchases of investments (77,190)
- Maturities of investments 66,449
- Sales of investments 17,721
18.What is the dollar difference between accrual net income and Cash provided by Operations? 60,675 –
44,281 = 16,394
19.What investing activity provided the largest inflow of cash in the current year? Maturities of
investments 66,449
20.What investing activity used the largest amount of cash in the current year? Purchases of investments
(77,190)
21.What financing activity provided the largest inflow of cash in the current year? Common stock
repurchased (22,968)
22.What financing activity used the largest amount of cash in the current year? Common stock
repurchased (22,968)
23.Does the company have sufficient cash inflows from the appropriate category? Describe any problems
the company manyexperiencewith cash flow from your analysis of the cash flow statement. Yes. The
net cash used in financing could become a problem if it still increases.
24.Show the change in Retained Earnings for the2most recent years. What was net income for each
year?How much was paid out in dividends each year?
2020 2019
Retained Earnings 34.566 billion 24.15 billion
Net Income 44,281 billion 39,240 billion
Dividends Paid (15,483)billion (14,108)billion
25.Were the dividends on common stock and/or preferred stock? What was the amount of each? Common
Stock 2020 (15,137), 2019 (13,811)
26.Did Retained Earnings change for any reasons other than net income or dividends? Explain. Yes, it
changed due to the pandemic that occurred in 2020 otherwise it was due to net income and dividends.
27.What classes of stock does your company have? Microsoft has three classes Class A, Class B and Class
C.
28.How many shares of each class of stock are authorized, how many are issued, and how many are
outstanding?
Year Ended June 30th 2020 2019 2018
Balance beginning of
year
7643 7677 7608
Issued 54 116 68
Purchased (126) (150) (99)
Balance end of year 7571 7643 7677
According to the Microsoft website it does not break down by class but simply says as of October 22, 2020
there were 7,560,495,696 shares outstanding.
29.Does your company have any treasury stock? How many shares and what dollar amount? No
30.What is the par or stated value of each of your company’s stocks? No par stock
Footnote Disclosures:
31.How many footnote disclosures does your company have? 20
32.How many significant accounting policies are listed under its Summary of Significant Accounting
Policies? 14
33.What does it include as Cash and Cash Equivalents? Cash, Commercial Paper, Certificates of Deposit
and Money Market Prefers
34.What method does it use to value Inventory? Inventory valuation is the determination which is used by
the cost amount (actual) field of the value entries to the item.
35.What method(s) does it use to depreciate its assets? Straight line depreciation
36.Does it have any leased assets?If yes, describethem. Microsoft has operating and financed leases for
data centers, corporate offices, research and development facilities, retail stores and certain
equipment.
37.What policies does it have in regard to Foreign Currency Translations? Assets and liabilities translated
in foreign currencies are translated at the exchange rate on the balance sheet date.
38.Describe any pending lawsuits in which it is involved. Microsoft and class counsel have reached
proposed settlements of lawsuits pending in a number of states in which plaintiffs have alleged
Microsoft unlawfully used anticompetitive means to maintain a monopoly in markets……
39.Provide its Earnings per Share for the2most recent years? Fiscal Year 2020 $1.38 per share; Fiscal
Year 2019 $1.14 per share
Report of the Independent Auditor(s):
40.Who is/are your company’s auditor(s)? Deloitte and Touché LLP
41.Where are they located? 1633 Broadway, New York, NY 10019
42.Does the auditor(s)give a qualified opinion, an unqualified opinion, a disclaimer of opinion, or an
adverse opinion?What does that opinion mean? Is it good? It goes a qualified good opinion.
43.What is the auditor’sresponsibility in regard to the financial statements? Their responsibility is to
express an opinion on the company’s financial statements based on audits.
44.What is management’s responsibility in regard to the financial statements? The responsibility of
management is the company’s financial statements and it’s authenticity.
45.What financial statements were included in the auditor’sopinion? They audited the consolidated
balance sheets, consolidated statements of income, comprehensive income, cash flows, and
stockholder’s equity for the past three years ending June 30, 2020.
46.Did the auditor believe that the statements were presented fairly? Yes
Management’s Report:
47.Who bears the responsibility for the integrity and the objectivity of the financial statements? The Chief
Financial Officer – Frank H. Brod
48.What does management say they are doing to assure the public that the financial information is
reliable? Management conducted an evaluation of the effectiveness of the internal control over
financial reporting.
49.What is the responsibility of the Audit Committee of the Board of Directors? The audit committee
oversees its financial statements and reporting. Per regulation, the audit committee must include
outside board members as well as well as those versed in finance and accounting in order to produce
honest and accurate reports.
Analysis: (use Excel to complete this section)
50.Provide common-size analysis of your company’s income statement and balance sheet for the2most
recent years(must bedone using Excel with formulas). Please see excel spreadsheet.
51.Provide horizontal analysis of your company’s income statement and balance sheet, showing the dollar
amount and percent of change using the2most recent years(you must use anExcel spreadsheet with
formulas). Please see excel spreadsheet.
52.Perform ratio analysis on your company using the ratios listedin Exhibit 13.16on page505of your text
(these must be in an Excel spreadsheet, using formulas to calculate the ratios).You should present
them in a similar format as the text: group by category, list name of ratio, formula in words, and the
ratio calculation. Give a short explanation of your conclusions about your company after each category
of ratios (i.e. How liquid is your company? How efficiently is it using its assets?etc.).
Conclusions:
53.Are you optimistic or pessimistic regarding the future of yourchosencorporation? Explain. I feel
optimistic about the future of the company because they constantly make investments into new
products to stay up with current trends and competition.
54.Would you invest in the stock of the company? Explain. I would invest in the stock because the stock
grows year by year and has not fallen besides when 2020 remained stagnant.
55.Would you invest in the bonds of the company? Explain. I would invest in the bonds of the company
because of its stability.
Page3of3
Works Cited
2. https://corporate-office-headquarters.com/conversations
3. https://www.microsoft.com/en-us/Investor/earnings/FY-2020-Q4/press-release-webcast
4. https://www.microsoft.com/en-us
5.
https://www.nasdaq.com/market-activity/stocks/msft/historical
6
6. https://www.microsoft.com/en-us/investor/investor-information.aspx
https://www-us.computershare.com/investor/#Contact/Enquiry
7. https://whatcompetitors.com/microsoft/
8., 9., 10. https://www.nasdaq.com/market-activity/stocks/msft/historical
12. https://www.microsoft.com/en-us/Investor/annual-reports.aspx
13. https://www.microsoft.com/en-us/Investor/earnings/FY-2020-Q4/cash-flows
14. https://www.annualreports.com/Company/microsoft-corporation
15. https://www.sec.gov/Archives/edgar/data/789019/000156459017014900/msft-10k_20170630.htm
16.-23. https://www.microsoft.com/en-us/Investor/earnings/FY-2020-Q4/cash-flows
24. - 27. https://c.s-microsoft.com/en-us/CMSFiles/MSFT_FY20Q4_10K.docx?version=71873a68-d431-
e887-124f-4d24b9ade60c
28. https://www.microsoft.com/en-us/Investor/FAQ.aspx
https://c.s-microsoft.com/en-us/CMSFiles/MSFT_FY20Q4_10K.docx?version=71873a68-d431-e887-
124f-4d24b9ade60c
29. https://www.gurufocus.com/term/Treasury+Stock/MSFT/Treasury%252BStock/Microsoft%2BCorp
31. https://c.s-microsoft.com/en-us/CMSFiles/MSFT_FY20Q4_10K.docx?version=71873a68-d431-e887-
124f-4d24b9ade60c
32. https://www.microsoft.com/Investor/reports/ar99/downloads/notes.doc
33. https://www.microsoft.com/Investor/reports/ar99/downloads/notes.doc
34. https://docs.microsoft.com/en-us/dynamics365/business-central/design-details-inventory-valuation
35. https://www.stock-analysis-on.net/NASDAQ/Company/Microsoft-Corp/Analysis/Property-Plant-and-
Equipment
36. https://www.microsoft.com/en-us/Investor/earnings/FY-2019-Q3/IRFinancialStatementsPopups?
tag=us-gaap:LeasesOfLesseeDisclosureTextBlock&title=Operating%20lease%20right-of-use%20assets
37. https://www.microsoft.com/investor/reports/ar13/financial-review/notes/index.html
38. https://www.microsoft.com/en-us/legal/class/default.aspx
39. https://www.nasdaq.com/market-activity/stocks/msft/revenue-eps
40. https://www.microsoft.com/investor/reports/ar96/financials/ma.htm
41. https://www.bloomberg.com/profile/company/5091Z:US
42.- 48. https://c.s-microsoft.com/en-us/CMSFiles/MSFT_FY20Q4_10K.docx?version=71873a68-d431-
e887-124f-4d24b9ade60c
49. https://www.investopedia.com/terms/a/audit-committee.asp
50. https://www.microsoft.com/en-us/Investor/earnings/FY-2020-Q4/income-statements
51. https://www.microsoft.com/en-us/Investor/earnings/FY-2020-Q4/balance-sheets
Students also viewed