I must find out the following information based on the financial statements from

Question

I must find out the following information based on the financial statements from Google (Alphabet Inc.)

https://investor.google.com/financial/tables.html

3. Examine the statement of stockholders’ equity and the statement of cash flows to determine the
type and amount of any dividends issued.
4. Calculate the following ratios:
a. Current ratio
b. Debt ratio
c. Inventory turnover (if applicable)
d. Operating Income (profit) percentage
e. Return on common stockholders’ equity

In Millions of USD (except for per share items) As of 2015-06-30 6,062.00 As of 2014-09-30 6,294.00 46,552.00 As of 2014-06-30 9,533.00 41,584.00 As of 2015-03-31 As of 2014-12-31 Cash & Equivalents Short Term Investments 48,460.00 65,436.00 8,584.00 46,048.00 64,395.00 9,383.00 Cash and Short Term Investments 69,780.00 9,394.00 Accounts Receivable Trade, Net Receivables Total Receivables, Net Total Inventory Prepaid Expenses Other Current Assets, Total Total Current Assets Property/Plant/Equipment, Total - Gross Accumulated Depreciation, Total 2,258.00 2,451.00 2,560.00 5,533.00 84,164.00 37,112.00 -10,104.00 15,610.00 4,213.00 4,409.00 3,403.00 138,807.00 80,313.00 34,843.00 9,395.00 15,573.00 79,978.00 32,746.00 8,863.00 15,599.00 4,607.00 3,079.00 3,280.00 130,426.00 77,905.00 27,574.00 8,088.00 14,586.00 5,234.00 2,415.00 29,292.00 15,461.00 4,744.00 2,470.00 2,010.00 125,781.00 Long Term Investments Other Long Term Assets, Total 3,596.00 133,400.00 121,608.00 5,774.00 2,009.00 6,852.00 3,000.00 6,383.00 7,499.00 6,358.00 Notes Payable/Short Term Debt Current Port. of LT Debt/Capital Leases Other Current liabilities, Total Total Current Liabilities 2,009.00 5,582.00 2,009.00 4,256.00 14,336.00 2,993.00 17,097.00 2,991.00 17,362.00 17,920.00 2,992.00 2,992.00 Capital Lease Obligations Total Long Ter Total Debt Deferred Income Tax Minority Interest Other Liabilities, Total Total Liabilities Redeemable Preferred Stock, Total Preferred Stock Non Redeemable, Net Common Stock, Total Additional Paid-In Capital Retained Earnings (Accumulated Deficit) Treasury Stock Common Other Equity, Total Total Equity Total Liabilities & Shareholders' Equity 3,230.00 5,239.00 1,554.00 3,232.00 5,233.00 1,754.00 5,237.00 1,971.00 5,235.00 1,625.00 4,562.00 26,566.00 4,262.00 26,966.00 27,024.00 24,952.00 25,859.00 30,721.31 29,526.32 79,292.00 28,766.32 75,066.00 27,110.32 68,136.00 1,158.00 111,783.00 138,807.00 108,448.00 133,400.00 103,860.00 130,426.00 98,815.00 125,781.00 95,749.00 121,608.00 Shares Outs - Common Stock Primary Issue Total Common Shares Outstanding 679.21 676.83

Explanation / Answer

Answer to 4:

Calculation of ratios:

S.No

Particulars

30-06-2015

31-03-2015

31-12-2014

30-09-2014

30-06-2014

1

Total Current Assets

84164

80313

79978

80115

77905

2

Total Current Liabilities

17362

14336

16805

17920

17097

3

Current Ratio ((1)/(2))

4.847

5.602

4.759

4.471

4.556

4

Total Debt

5233

5235

5237

5239

5241

5

Total assets

138807

133400

130426

125781

121608

6

Debt Ratio ((4)/(5))

3.77%

3.92%

4.01%

4.16%

4.31%

7

Cost of Revenue

6583

6356

6921

6317

6114

8

Inventory

279

293

9

Inventory Turnover Ratio ((7)/(8))

NA

NA

NA

22.64

20.87

10

Operating Income

4825

4447

4399

3724

4258

11

Total Revenue

17727

17258

18103

16523

15955

12

Operating Income (Profit) Percentage ((10)/(11))

27.22%

25.77%

24.30%

22.54%

26.69%

13

Income available to Common Stockholders

3409

3515

4757

2813

3351

14

Total equity

111783

108448

103860

98815

95749

15

Return on common stockholders’ equity ((13)/(14))

3.05%

3.24%

4.58%

2.85%

3.50%

Ratios:

S.No

Ratio

30-06-2015

31-03-2015

31-12-2014

30-09-2014

30-06-2014

a

Current Ratio

4.847

5.602

4.759

4.471

4.556

b

Debt Ratio

3.77%

3.92%

4.01%

4.16%

4.31%

c

Inventory Turnover

NA

NA

NA

22.64

20.87

d

Operating Income (Profit) Percentage

27.22%

25.77%

24.30%

22.54%

26.69%

e

Return on common stockholders’ equity

3.05%

3.24%

4.58%

2.85%

3.50%

Note: In order to answer part 3, statement of cash flows has not been provided

S.No

Particulars

30-06-2015

31-03-2015

31-12-2014

30-09-2014

30-06-2014

1

Total Current Assets

84164

80313

79978

80115

77905

2

Total Current Liabilities

17362

14336

16805

17920

17097

3

Current Ratio ((1)/(2))

4.847

5.602

4.759

4.471

4.556

4

Total Debt

5233

5235

5237

5239

5241

5

Total assets

138807

133400

130426

125781

121608

6

Debt Ratio ((4)/(5))

3.77%

3.92%

4.01%

4.16%

4.31%

7

Cost of Revenue

6583

6356

6921

6317

6114

8

Inventory

279

293

9

Inventory Turnover Ratio ((7)/(8))

NA

NA

NA

22.64

20.87

10

Operating Income

4825

4447

4399

3724

4258

11

Total Revenue

17727

17258

18103

16523

15955

12

Operating Income (Profit) Percentage ((10)/(11))

27.22%

25.77%

24.30%

22.54%

26.69%

13

Income available to Common Stockholders

3409

3515

4757

2813

3351

14

Total equity

111783

108448

103860

98815

95749

15

Return on common stockholders’ equity ((13)/(14))

3.05%

3.24%

4.58%

2.85%

3.50%

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.