Microsoft Excel LibreOffice Calc

Adobe Inc. (ADBE)

Long-term (Investment) Activity Analysis
Quarterly Data

Difficulty: Beginner

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Ratios (Summary)

Adobe Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Nov 30, 2018 Aug 31, 2018 Jun 1, 2018 Mar 2, 2018 Dec 1, 2017 Sep 1, 2017 Jun 2, 2017 Mar 3, 2017 Dec 2, 2016 Sep 2, 2016 Jun 3, 2016 Mar 4, 2016 Nov 27, 2015 Aug 28, 2015 May 29, 2015 Feb 27, 2015 Nov 28, 2014 Aug 29, 2014 May 30, 2014 Feb 28, 2014 Nov 29, 2013 Aug 30, 2013 May 31, 2013 Mar 1, 2013
Net fixed asset turnover 8.40 8.41 8.18 7.76 7.79 7.35 7.06 7.49 7.17 6.84 6.67 6.38 6.09 5.72 5.54 5.43 5.28 5.24 6.39 6.22 6.15 – – –
Total asset turnover 0.48 0.56 0.54 0.51 0.50 0.50 0.49 0.47 0.46 0.45 0.43 0.43 0.41 0.40 0.39 0.39 0.38 0.39 0.40 0.40 0.39 – – –
Equity turnover 0.96 0.97 0.93 0.89 0.86 0.84 0.84 0.81 0.79 0.76 0.73 0.72 0.68 0.67 0.66 0.65 0.61 0.61 0.62 0.61 0.60 – – –

Based on: 10-K (filing date: 2019-01-25), 10-Q (filing date: 2018-09-26), 10-Q (filing date: 2018-06-27), 10-Q (filing date: 2018-03-28), 10-K (filing date: 2018-01-22), 10-Q (filing date: 2017-09-27), 10-Q (filing date: 2017-06-28), 10-Q (filing date: 2017-03-29), 10-K (filing date: 2017-01-20), 10-Q (filing date: 2016-09-27), 10-Q (filing date: 2016-06-29), 10-Q (filing date: 2016-03-30), 10-K (filing date: 2016-01-19), 10-Q (filing date: 2015-09-23), 10-Q (filing date: 2015-06-24), 10-Q (filing date: 2015-03-25), 10-K (filing date: 2015-01-20), 10-Q (filing date: 2014-09-25), 10-Q (filing date: 2014-06-25), 10-Q (filing date: 2014-03-28), 10-K (filing date: 2014-01-21), 10-Q (filing date: 2013-10-03), 10-Q (filing date: 2013-06-28), 10-Q (filing date: 2013-03-28).

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Adobe Inc.’s net fixed asset turnover improved from Q2 2018 to Q3 2018 but then slightly deteriorated from Q3 2018 to Q4 2018.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Adobe Inc.’s total asset turnover improved from Q2 2018 to Q3 2018 but then deteriorated significantly from Q3 2018 to Q4 2018.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Adobe Inc.’s equity turnover improved from Q2 2018 to Q3 2018 but then slightly deteriorated from Q3 2018 to Q4 2018.

Net Fixed Asset Turnover

Adobe Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Nov 30, 2018 Aug 31, 2018 Jun 1, 2018 Mar 2, 2018 Dec 1, 2017 Sep 1, 2017 Jun 2, 2017 Mar 3, 2017 Dec 2, 2016 Sep 2, 2016 Jun 3, 2016 Mar 4, 2016 Nov 27, 2015 Aug 28, 2015 May 29, 2015 Feb 27, 2015 Nov 28, 2014 Aug 29, 2014 May 30, 2014 Feb 28, 2014 Nov 29, 2013 Aug 30, 2013 May 31, 2013 Mar 1, 2013
Selected Financial Data (USD $ in thousands)
Revenue 2,464,625  2,291,076  2,195,360  2,078,947  2,006,595  1,841,074  1,772,190  1,681,646  1,608,419  1,463,967  1,398,709  1,383,335  1,306,404  1,217,768  1,162,158  1,109,181  1,073,328  1,005,409  1,068,208  1,000,120  1,041,699  995,119  1,010,549  1,007,873 
Property and equipment, net 1,075,072  1,019,260  993,486  991,674  936,976  939,809  924,108  821,730  816,264  811,524  796,077  794,876  787,421  797,464  785,199  784,314  785,123  785,856  642,450  651,083  659,774  659,747  645,865  686,014 
Ratio
Net fixed asset turnover1 8.40 8.41 8.18 7.76 7.79 7.35 7.06 7.49 7.17 6.84 6.67 6.38 6.09 5.72 5.54 5.43 5.28 5.24 6.39 6.22 6.15 – – –

Based on: 10-K (filing date: 2019-01-25), 10-Q (filing date: 2018-09-26), 10-Q (filing date: 2018-06-27), 10-Q (filing date: 2018-03-28), 10-K (filing date: 2018-01-22), 10-Q (filing date: 2017-09-27), 10-Q (filing date: 2017-06-28), 10-Q (filing date: 2017-03-29), 10-K (filing date: 2017-01-20), 10-Q (filing date: 2016-09-27), 10-Q (filing date: 2016-06-29), 10-Q (filing date: 2016-03-30), 10-K (filing date: 2016-01-19), 10-Q (filing date: 2015-09-23), 10-Q (filing date: 2015-06-24), 10-Q (filing date: 2015-03-25), 10-K (filing date: 2015-01-20), 10-Q (filing date: 2014-09-25), 10-Q (filing date: 2014-06-25), 10-Q (filing date: 2014-03-28), 10-K (filing date: 2014-01-21), 10-Q (filing date: 2013-10-03), 10-Q (filing date: 2013-06-28), 10-Q (filing date: 2013-03-28).

Q4 2018 Calculations

1 Net fixed asset turnover = (RevenueQ4 2018 + RevenueQ3 2018 + RevenueQ2 2018 + RevenueQ1 2018) ÷ Property and equipment, net
= (2,464,625 + 2,291,076 + 2,195,360 + 2,078,947) ÷ 1,075,072 = 8.40

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Adobe Inc.’s net fixed asset turnover improved from Q2 2018 to Q3 2018 but then slightly deteriorated from Q3 2018 to Q4 2018.

Total Asset Turnover

Adobe Inc., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Nov 30, 2018 Aug 31, 2018 Jun 1, 2018 Mar 2, 2018 Dec 1, 2017 Sep 1, 2017 Jun 2, 2017 Mar 3, 2017 Dec 2, 2016 Sep 2, 2016 Jun 3, 2016 Mar 4, 2016 Nov 27, 2015 Aug 28, 2015 May 29, 2015 Feb 27, 2015 Nov 28, 2014 Aug 29, 2014 May 30, 2014 Feb 28, 2014 Nov 29, 2013 Aug 30, 2013 May 31, 2013 Mar 1, 2013
Selected Financial Data (USD $ in thousands)
Revenue 2,464,625  2,291,076  2,195,360  2,078,947  2,006,595  1,841,074  1,772,190  1,681,646  1,608,419  1,463,967  1,398,709  1,383,335  1,306,404  1,217,768  1,162,158  1,109,181  1,073,328  1,005,409  1,068,208  1,000,120  1,041,699  995,119  1,010,549  1,007,873 
Total assets 18,768,682  15,395,620  15,163,404  14,973,485  14,535,556  13,906,815  13,364,900  13,044,783  12,707,114  12,367,441  12,216,783  11,896,682  11,726,472  11,508,395  11,165,383  11,008,422  10,785,829  10,493,680  10,372,199  10,245,882  10,380,298  10,234,156  10,280,369  10,165,711 
Ratio
Total asset turnover1 0.48 0.56 0.54 0.51 0.50 0.50 0.49 0.47 0.46 0.45 0.43 0.43 0.41 0.40 0.39 0.39 0.38 0.39 0.40 0.40 0.39 – – –

Based on: 10-K (filing date: 2019-01-25), 10-Q (filing date: 2018-09-26), 10-Q (filing date: 2018-06-27), 10-Q (filing date: 2018-03-28), 10-K (filing date: 2018-01-22), 10-Q (filing date: 2017-09-27), 10-Q (filing date: 2017-06-28), 10-Q (filing date: 2017-03-29), 10-K (filing date: 2017-01-20), 10-Q (filing date: 2016-09-27), 10-Q (filing date: 2016-06-29), 10-Q (filing date: 2016-03-30), 10-K (filing date: 2016-01-19), 10-Q (filing date: 2015-09-23), 10-Q (filing date: 2015-06-24), 10-Q (filing date: 2015-03-25), 10-K (filing date: 2015-01-20), 10-Q (filing date: 2014-09-25), 10-Q (filing date: 2014-06-25), 10-Q (filing date: 2014-03-28), 10-K (filing date: 2014-01-21), 10-Q (filing date: 2013-10-03), 10-Q (filing date: 2013-06-28), 10-Q (filing date: 2013-03-28).

Q4 2018 Calculations

1 Total asset turnover = (RevenueQ4 2018 + RevenueQ3 2018 + RevenueQ2 2018 + RevenueQ1 2018) ÷ Total assets
= (2,464,625 + 2,291,076 + 2,195,360 + 2,078,947) ÷ 18,768,682 = 0.48

Ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Adobe Inc.’s total asset turnover improved from Q2 2018 to Q3 2018 but then deteriorated significantly from Q3 2018 to Q4 2018.

Equity Turnover

Adobe Inc., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Nov 30, 2018 Aug 31, 2018 Jun 1, 2018 Mar 2, 2018 Dec 1, 2017 Sep 1, 2017 Jun 2, 2017 Mar 3, 2017 Dec 2, 2016 Sep 2, 2016 Jun 3, 2016 Mar 4, 2016 Nov 27, 2015 Aug 28, 2015 May 29, 2015 Feb 27, 2015 Nov 28, 2014 Aug 29, 2014 May 30, 2014 Feb 28, 2014 Nov 29, 2013 Aug 30, 2013 May 31, 2013 Mar 1, 2013
Selected Financial Data (USD $ in thousands)
Revenue 2,464,625  2,291,076  2,195,360  2,078,947  2,006,595  1,841,074  1,772,190  1,681,646  1,608,419  1,463,967  1,398,709  1,383,335  1,306,404  1,217,768  1,162,158  1,109,181  1,073,328  1,005,409  1,068,208  1,000,120  1,041,699  995,119  1,010,549  1,007,873 
Stockholders’ equity 9,362,114  8,861,925  8,705,583  8,634,028  8,459,869  8,170,434  7,803,998  7,588,690  7,424,835  7,277,946  7,248,611  7,081,202  7,001,580  6,841,332  6,610,103  6,589,020  6,775,905  6,731,260  6,636,888  6,610,883  6,724,634  6,834,759  6,927,302  6,805,338 
Ratio
Equity turnover1 0.96 0.97 0.93 0.89 0.86 0.84 0.84 0.81 0.79 0.76 0.73 0.72 0.68 0.67 0.66 0.65 0.61 0.61 0.62 0.61 0.60 – – –

Based on: 10-K (filing date: 2019-01-25), 10-Q (filing date: 2018-09-26), 10-Q (filing date: 2018-06-27), 10-Q (filing date: 2018-03-28), 10-K (filing date: 2018-01-22), 10-Q (filing date: 2017-09-27), 10-Q (filing date: 2017-06-28), 10-Q (filing date: 2017-03-29), 10-K (filing date: 2017-01-20), 10-Q (filing date: 2016-09-27), 10-Q (filing date: 2016-06-29), 10-Q (filing date: 2016-03-30), 10-K (filing date: 2016-01-19), 10-Q (filing date: 2015-09-23), 10-Q (filing date: 2015-06-24), 10-Q (filing date: 2015-03-25), 10-K (filing date: 2015-01-20), 10-Q (filing date: 2014-09-25), 10-Q (filing date: 2014-06-25), 10-Q (filing date: 2014-03-28), 10-K (filing date: 2014-01-21), 10-Q (filing date: 2013-10-03), 10-Q (filing date: 2013-06-28), 10-Q (filing date: 2013-03-28).

Q4 2018 Calculations

1 Equity turnover = (RevenueQ4 2018 + RevenueQ3 2018 + RevenueQ2 2018 + RevenueQ1 2018) ÷ Stockholders’ equity
= (2,464,625 + 2,291,076 + 2,195,360 + 2,078,947) ÷ 9,362,114 = 0.96

Ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Adobe Inc.’s equity turnover improved from Q2 2018 to Q3 2018 but then slightly deteriorated from Q3 2018 to Q4 2018.