Managerial Finance

profilerakesh.raki
GROUPPROJECTPARTII.docx

MICROSOFT CORPORATION

FinancialStatementFY20Q1

BALANCE SHEETS

(In millions) (Unaudited)

June 30,

June 30,

2019

2018

Assets

Current assets:

Cash and cash equivalents

$11,356,000

$11,946,000

Short-term investments

$122,463,000

$ 121,822,000

Total cash, cash equivalents, and short-term investments

$133,819,000

$ 133,768,000

Accounts receivable, net of allowance for doubtful accounts of $411 and $377

$ 29,524,000

$ 26,481,000

Inventories

$ 2,063,000

$ 2,662,000

Other current assets

$ 10,146,000

$ 6,751,000

Total current assets

$175,552,000

$ 169,662,000

Long-term assets:

Property and equipment, net of accumulated depreciation of $35,330 and $29,223

$ 36,477,000

$ 29,460,000

Operating lease right-of-use assets

$ 7,379,000

$ 6,686,000

Equity investments

$ 2,649,000

$ 1,862,000

Goodwill

$ 42,026,000

$ 35,683,000

Intangible assets, net

$ 7,750,000

$ 8,053,000

Other long-term assets

$ 14,723,000

$ 7,442,000

Deferred asset charges

$ -

$ -

Total assets

$286,556,000

$258,848,000

Liabilities and stockholders' equity

Current liabilities:

Accounts payable

$9,382,000

$8,617,000

Short-term Debt/Current portion of long-term debt

$ 5,516,000

$ 3,998,000

Accrued compensation

$ 6,830,000

$ 6,103,000

Short-term income taxes

$ 5,665,000

$ 2,121,000

Short-term unearned revenue

$ 32,676,000

$ 28,905,000

Other current liabilities

$ 9,351,000

$ 8,744,000

Total current liabilities

$ 69,420,000

$ 58,488,000

Long-term debt

$ 66,662,000

$ 72,242,000

Long-term income taxes

$ 29,612,000

$ 30,265,000

Long-term unearned revenue

$ 4,530,000

$ 3,815,000

Deferred income taxes

$ 233,000

$ 541,000

Operating lease liabilities

$ 6,188,000

$ 5,568,000

Other long-term liabilities

$ 7,581,000

$ 5,211,000

Misc. Stocks

$ -

$ -

Minority interest

$ -

$ -

Total liabilities

$184,226,000

$176,130,000

Stockholders' equity:

Common stock and paid-in capital - shares authorized 24,000; outstanding 7,643 and 7,677

$ 78,520,000

$ 71,223,000

Retained earnings

$ 24,150,000

$ 13,682,000

Accumulated other comprehensive loss/Other equity

$ (340,000)

$ (2,187,000)

Total stockholders' equity

$102,330,000

$ 82,718,000

Total liabilities and stockholders' equity

$286,556,000

$258,848,000

MICROSOFT CORPORATION

INCOME STATEMENTS

(In millions, except per share amounts) (Unaudited)

Twelve Months Ended June 30,

 

2019

 

2018

Sales:

 

 

Product

$66,069,000

$64,497,000

Service and other

$ 59,774,000

$ 45,863,000

Net sales

$125,843,000

$110,360,000

Cost of goods sold:

Product

$ 16,273,000

$ 15,420,000

Service and other

$ 26,637,000

$ 22,933,000

Total cost of goods sold

$ 42,910,000

$ 38,353,000

Gross profit

$ 82,933,000

$ 72,007,000

Research and development

$ 16,876,000

$ 14,726,000

Sales and marketing

$ 18,213,000

$ 17,469,000

General and administrative

$ 4,885,000

$ 4,754,000

Total operating expenses

$ 42,959,000

$ 35,058,000

less: Interest expense

$ 2,686,000

$ 2,733,000

Other income, net

$ 3,415,000

$ 4,149,000

Earnings before income and taxes

$ 43,688,000

$ 36,474,000

less: Provision for income taxes

$ 4,448,000

$ 19,903,000

Net income

$ 39,240,000

$ 16,571,000

Net income available to common shareholders

$ 39,240,000

$16,571,000

Earnings per share:

Basic

$5.11

$2.15

Diluted

$5.06

$2.13

Weighted average shares outstanding:

Basic

$ 7,673,000

$ 7,700,000

Diluted

$ 7,753,000

 

$ 7,794,000

MICROSOFT CORPORATION

CASH FLOWS STATEMENTS

(In millions) (Unaudited)

Twelve Months Ended June 30,

 

2019

Operating Activities

Net income

$39,240,000

Non-cash adjustments

Depreciation, amortization, and other

$ 11,682,000

Stock-based compensation expense

$ 4,652,000

Net recognized gains on investments and derivatives

$ (792,000)

Deferred income taxes

$ (6,463,000)

Changes in working capital

Accounts receivable

$ (2,812,000)

Inventories

$ 597,000

Other current assets

$ (1,718,000)

Other long-term assets

$ (1,834,000)

Accounts payable

$ 232,000

Unearned revenue

$ 4,462,000

Income taxes

$ 2,929,000

Other current liabilities

$ 1,419,000

Other long-term liabilities

$ 591,000

Net cash from operations

$ 52,185,000

Financing Activities

Repayments of short-term debt, maturities of 90 days or less, net

$ -

Proceeds from issuance of debt

$ -

Repayments of debt

$ (4,000,000)

Common stock issued

$ 1,142,000

Common stock repurchased

$ (19,543,000)

Common stock cash dividends paid

$ (13,811,000)

Other, net

$ (675,000)

Net cash used in financing

$ (36,887,000)

Investing Activities

Additions to property and equipment

$ (13,925,000)

Acquisition of companies, net of cash acquired, and purchases of intangible and other assets

$ (2,388,000)

Purchases of investments

$ (57,697,000)

Maturities of investments

$ 20,043,000

Sales of investments

$ 38,194,000

Securities lending payable

$ -

Net cash used in investing

$ (15,773,000)

Effect of foreign exchange rates on cash and cash equivalents

$ (115,000)

Net change in cash and cash equivalents

$ (590,000)

Cash and cash equivalents, beginning of period

$ 11,946,000

Cash and cash equivalents, end of period

$11,356,000

Based on the company you selected in Part I, complete the following:

1. Based on formulas in your textbook, compute the following ratios for two years. You may use Excel to compute your ratios.

1. Debt ratio (for the year 2019)

= Total Liabilities / Total Assets

= $286,556,000 / $286,556,000

= 1

Debt Ratio (for the year 2018)

= Total Liabilities / Total Assets

= $258,848,000 / $258,848,000

= 1

2. Gross profit margin (for the year 2019)

= [Net Sales – Cost of Goods Sold (COGS)]/Net Sales

= [$125,843,000 – $42,910,000] / $125,843,000

= 0.66 = 66%

Gross profit margin (for the year 2018)

= [Net Sales – Cost of Goods Sold (COGS)]/Net Sales

= [$110,360,000 – $38,353,000] / $110,360,000

= 0.65 = 65%

3. Free cash flow (for the year 2019)

= Net Cash flow from Operations – Capital Expenditures

= $52,185,000 – $13,925,000

= $38,260,000

4. Times interest earned (for the year 2019)

= Earnings before Interest & Taxes (EBIT) / Interest Expense

= $43,688,000 / $2,686,000

= 16.27 times the annual interest expense

Times interest earned (for the year 2018)

= Earnings before Interest & Taxes (EBIT) / Interest Expense

= $36,474,000 / $2,733,000

= 13.35 times the annual interest expense

5. Accounts receivable turnover (for the year 2019)

= Net Credit Sales / Accounts Receivables

= $125,843,000 / $29,524,000

= 4.26 times

Accounts receivable turnover (for the year 2018)

= Net Credit Sales / Accounts Receivables

= $110,360,000 / $26,481,000

= 4.17 times

6. Inventory turnover (for the year 2019)

= Cost of Goods Sold (COGS) / Inventory

= $42,910,000/ 2,063,000

= 20.8

Inventory turnover (for the year 2018)

= Cost of Goods Sold (COS) / Inventory

= $38,353,000 / $2,662,000

= 14.41

2. Prepare a DuPont Analysis of ROE for two years, including computations of

1. Return on Sales

2. Asset Turnover

3. Return on Assets

4. Financial Leverage

5. Return on Equity

1. Return on sales (for the year 2019)

= Operating Profit before Tax / Net Sales

= $42,959,000 / $125,843,000

= 0.34136 = 34.14%

Return on sales (for the year 2018)

= Operating Profit before Tax / Net Sales

= $35,058,00 / $110,360,000

= 0.31766 = 32%

2. Asset turnover (for the year 2019)

= Net Sales / Total Assets

= $125,843,000 / $286,556,000

= 0.44 times

Asset turnover (for the year 2018)

= Net Sales / Total Assets

= $110,360,000 / $169,662,000

= 0.65 times

3. Return on assets (for the year 2019)

= Net Profit Margin X Total Asset Turnover

= 31.18% / 0.44

= 13.69%

Calculation:

Net Profit Margin = Earnings Available for Common Stockholders / Net Sales

= $39,240,000 / $125,843,000

= 0.3118 = 31.18%

Return on asset (for the year 2018)

= Net Profit Margin X Total Asset Turnover

= 15.02% / 0.65

= 0.0977 = 10%

Calculation:

Net Profit Margin = Earnings Available for Common Stockholders / Net Sales

= $16,571,000 / $110,360,000

= 15.02%

4. Financial leverage (for the year 2019)

= Total Assets / Common Stock Equity

= $286,556,000 / $102,330,000

= 2.8      

Financial leverage (for the year 2018)

= Total Assets / Common Stock Equity

= $258,848,000 / $82,718,000

= 3.13

5. Return on equity (for the year 2019)

= Return on assets / Financial leverage

= 13.69% / 2.8

= 38.35%

Return on equity (for the year 2018)

= Return on assets / Financial leverage

= 10% / 3.13

= 30.56%