Income Statement Wide Table Generator

Summary

The following R script loads income statements from EDGAR and builds a wide table with entries for all companies. For this exercise Google and Facebook are added to the table.

Load Libraries

The finreportr package is used to scrape data out of the EDGAR site together with the tidyverse package

#install.packages("finreportr")
#install.packages("tidyverse")

finreportr and tidyverse libraries are loaded

library(finreportr)
library(tidyverse)
## ── Attaching packages ──────────────────────────────────────────────────────────────────────────────────────────────── tidyverse 1.2.1 ──
## ✔ ggplot2 3.0.0     ✔ purrr   0.2.5
## ✔ tibble  1.4.2     ✔ dplyr   0.7.7
## ✔ tidyr   0.8.1     ✔ stringr 1.3.1
## ✔ readr   1.1.1     ✔ forcats 0.3.0
## ── Conflicts ─────────────────────────────────────────────────────────────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
library(kableExtra)

Load income statements

Income statement for Google is loaded

inc_g<-GetIncome("GOOG", 2017)
inc_g %>% kable() %>% kable_styling() %>% scroll_box(height = "400px")
Metric Units Amount startDate endDate
Revenues usd 66001000000 2014-01-01 2014-12-31
Revenues usd 74989000000 2015-01-01 2015-12-31
Revenues usd 90272000000 2016-01-01 2016-12-31
Cost of Revenue usd 25691000000 2014-01-01 2014-12-31
Cost of Revenue usd 28164000000 2015-01-01 2015-12-31
Cost of Revenue usd 35138000000 2016-01-01 2016-12-31
Research and Development Expense usd 9832000000 2014-01-01 2014-12-31
Research and Development Expense usd 12282000000 2015-01-01 2015-12-31
Research and Development Expense usd 13948000000 2016-01-01 2016-12-31
Selling and Marketing Expense usd 8131000000 2014-01-01 2014-12-31
Selling and Marketing Expense usd 9047000000 2015-01-01 2015-12-31
Selling and Marketing Expense usd 10485000000 2016-01-01 2016-12-31
General and Administrative Expense usd 5851000000 2014-01-01 2014-12-31
General and Administrative Expense usd 6136000000 2015-01-01 2015-12-31
General and Administrative Expense usd 6985000000 2016-01-01 2016-12-31
Costs and Expenses usd 49505000000 2014-01-01 2014-12-31
Costs and Expenses usd 55629000000 2015-01-01 2015-12-31
Costs and Expenses usd 66556000000 2016-01-01 2016-12-31
Operating Income (Loss) usd 16496000000 2014-01-01 2014-12-31
Operating Income (Loss) usd 19360000000 2015-01-01 2015-12-31
Operating Income (Loss) usd 23716000000 2016-01-01 2016-12-31
Nonoperating Income (Expense) usd 763000000 2014-01-01 2014-12-31
Nonoperating Income (Expense) usd 291000000 2015-01-01 2015-12-31
Nonoperating Income (Expense) usd 434000000 2016-01-01 2016-12-31
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Extraordinary Items, Noncontrolling Interest usd 17259000000 2014-01-01 2014-12-31
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Extraordinary Items, Noncontrolling Interest usd 19651000000 2015-01-01 2015-12-31
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Extraordinary Items, Noncontrolling Interest usd 24150000000 2016-01-01 2016-12-31
Income Tax Expense (Benefit) usd 3639000000 2014-01-01 2014-12-31
Income Tax Expense (Benefit) usd 3303000000 2015-01-01 2015-12-31
Income Tax Expense (Benefit) usd 4672000000 2016-01-01 2016-12-31
Income (Loss) from Continuing Operations Attributable to Parent usd 13620000000 2014-01-01 2014-12-31
Income (Loss) from Continuing Operations Attributable to Parent usd 16348000000 2015-01-01 2015-12-31
Income (Loss) from Continuing Operations Attributable to Parent usd 19478000000 2016-01-01 2016-12-31
Income (Loss) from Discontinued Operations, Net of Tax, Including Portion Attributable to Noncontrolling Interest usd 516000000 2014-01-01 2014-12-31
Income (Loss) from Discontinued Operations, Net of Tax, Including Portion Attributable to Noncontrolling Interest usd 0 2015-01-01 2015-12-31
Income (Loss) from Discontinued Operations, Net of Tax, Including Portion Attributable to Noncontrolling Interest usd 0 2016-01-01 2016-12-31
Net Income (Loss) Attributable to Parent usd 14136000000 2014-01-01 2014-12-31
Net Income (Loss) Attributable to Parent usd 16348000000 2015-01-01 2015-12-31
Net Income (Loss) Attributable to Parent usd 19478000000 2016-01-01 2016-12-31
Preferred Stock Dividends and Other Adjustments usd 0 2014-01-01 2014-12-31
Preferred Stock Dividends and Other Adjustments usd 522000000 2015-01-01 2015-12-31
Preferred Stock Dividends and Other Adjustments usd 0 2016-01-01 2016-12-31
Net Income (Loss) Available to Common Stockholders, Basic usd 14136000000 2014-01-01 2014-12-31
Net Income (Loss) Available to Common Stockholders, Basic usd 15826000000 2015-01-01 2015-12-31
Net Income (Loss) Available to Common Stockholders, Basic usd 19478000000 2016-01-01 2016-12-31

Amazon income statement is loaded

inc_a<-GetIncome("AMZN", 2017)
inc_a %>% kable() %>% kable_styling() %>% scroll_box(height = "400px")
Metric Units Amount startDate endDate
Sales Revenue, Goods, Net usd 70080000000 2014-01-01 2014-12-31
Sales Revenue, Goods, Net usd 79268000000 2015-01-01 2015-12-31
Sales Revenue, Goods, Net usd 94665000000 2016-01-01 2016-12-31
Sales Revenue, Services, Net usd 18908000000 2014-01-01 2014-12-31
Sales Revenue, Services, Net usd 27738000000 2015-01-01 2015-12-31
Sales Revenue, Services, Net usd 41322000000 2016-01-01 2016-12-31
Revenue, Net usd 88988000000 2014-01-01 2014-12-31
Revenue, Net usd 22717000000 2015-01-01 2015-03-31
Revenue, Net usd 23185000000 2015-04-01 2015-06-30
Revenue, Net usd 25358000000 2015-07-01 2015-09-30
Revenue, Net usd 35747000000 2015-10-01 2015-12-31
Revenue, Net usd 107006000000 2015-01-01 2015-12-31
Revenue, Net usd 29128000000 2016-01-01 2016-03-31
Revenue, Net usd 30404000000 2016-04-01 2016-06-30
Revenue, Net usd 32714000000 2016-07-01 2016-09-30
Revenue, Net usd 43741000000 2016-10-01 2016-12-31
Revenue, Net usd 135987000000 2016-01-01 2016-12-31
Cost of Goods and Services Sold usd 62752000000 2014-01-01 2014-12-31
Cost of Goods and Services Sold usd 71651000000 2015-01-01 2015-12-31
Cost of Goods and Services Sold usd 88265000000 2016-01-01 2016-12-31
Fulfillment Expense usd 10766000000 2014-01-01 2014-12-31
Fulfillment Expense usd 13410000000 2015-01-01 2015-12-31
Fulfillment Expense usd 17619000000 2016-01-01 2016-12-31
Marketing Expense usd 4332000000 2014-01-01 2014-12-31
Marketing Expense usd 5254000000 2015-01-01 2015-12-31
Marketing Expense usd 7233000000 2016-01-01 2016-12-31
Technology And Content Expense usd 9275000000 2014-01-01 2014-12-31
Technology And Content Expense usd 12540000000 2015-01-01 2015-12-31
Technology And Content Expense usd 16085000000 2016-01-01 2016-12-31
General and Administrative Expense usd 1552000000 2014-01-01 2014-12-31
General and Administrative Expense usd 1747000000 2015-01-01 2015-12-31
General and Administrative Expense usd 2432000000 2016-01-01 2016-12-31
Other Cost and Expense, Operating usd 133000000 2014-01-01 2014-12-31
Other Cost and Expense, Operating usd 171000000 2015-01-01 2015-12-31
Other Cost and Expense, Operating usd 167000000 2016-01-01 2016-12-31
Costs and Expenses usd 88810000000 2014-01-01 2014-12-31
Costs and Expenses usd 104773000000 2015-01-01 2015-12-31
Costs and Expenses usd 131801000000 2016-01-01 2016-12-31
Operating Income (Loss) usd 178000000 2014-01-01 2014-12-31
Operating Income (Loss) usd 255000000 2015-01-01 2015-03-31
Operating Income (Loss) usd 464000000 2015-04-01 2015-06-30
Operating Income (Loss) usd 406000000 2015-07-01 2015-09-30
Operating Income (Loss) usd 1108000000 2015-10-01 2015-12-31
Operating Income (Loss) usd 2233000000 2015-01-01 2015-12-31
Operating Income (Loss) usd 1071000000 2016-01-01 2016-03-31
Operating Income (Loss) usd 1285000000 2016-04-01 2016-06-30
Operating Income (Loss) usd 575000000 2016-07-01 2016-09-30
Operating Income (Loss) usd 1255000000 2016-10-01 2016-12-31
Operating Income (Loss) usd 4186000000 2016-01-01 2016-12-31
Investment Income, Interest usd 39000000 2014-01-01 2014-12-31
Investment Income, Interest usd 50000000 2015-01-01 2015-12-31
Investment Income, Interest usd 100000000 2016-01-01 2016-12-31
Interest Expense usd 210000000 2014-01-01 2014-12-31
Interest Expense usd 459000000 2015-01-01 2015-12-31
Interest Expense usd 484000000 2016-01-01 2016-12-31
Other Nonoperating Income (Expense) usd -118000000 2014-01-01 2014-12-31
Other Nonoperating Income (Expense) usd -256000000 2015-01-01 2015-12-31
Other Nonoperating Income (Expense) usd 90000000 2016-01-01 2016-12-31
Nonoperating Income (Expense) usd -289000000 2014-01-01 2014-12-31
Nonoperating Income (Expense) usd -665000000 2015-01-01 2015-12-31
Nonoperating Income (Expense) usd -294000000 2016-01-01 2016-12-31
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest usd -111000000 2014-01-01 2014-12-31
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest usd 21000000 2015-01-01 2015-03-31
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest usd 362000000 2015-04-01 2015-06-30
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest usd 247000000 2015-07-01 2015-09-30
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest usd 938000000 2015-10-01 2015-12-31
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest usd 1568000000 2015-01-01 2015-12-31
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest usd 1056000000 2016-01-01 2016-03-31
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest usd 1179000000 2016-04-01 2016-06-30
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest usd 491000000 2016-07-01 2016-09-30
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest usd 1166000000 2016-10-01 2016-12-31
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest usd 3892000000 2016-01-01 2016-12-31
Income Tax Expense (Benefit) usd 167000000 2014-01-01 2014-12-31
Income Tax Expense (Benefit) usd 71000000 2015-01-01 2015-03-31
Income Tax Expense (Benefit) usd 266000000 2015-04-01 2015-06-30
Income Tax Expense (Benefit) usd 161000000 2015-07-01 2015-09-30
Income Tax Expense (Benefit) usd 453000000 2015-10-01 2015-12-31
Income Tax Expense (Benefit) usd 950000000 2015-01-01 2015-12-31
Income Tax Expense (Benefit) usd 475000000 2016-01-01 2016-03-31
Income Tax Expense (Benefit) usd 307000000 2016-04-01 2016-06-30
Income Tax Expense (Benefit) usd 229000000 2016-07-01 2016-09-30
Income Tax Expense (Benefit) usd 414000000 2016-10-01 2016-12-31
Income Tax Expense (Benefit) usd 1425000000 2016-01-01 2016-12-31
Income (Loss) from Equity Method Investments usd 37000000 2014-01-01 2014-12-31
Income (Loss) from Equity Method Investments usd -22000000 2015-01-01 2015-12-31
Income (Loss) from Equity Method Investments usd -96000000 2016-01-01 2016-12-31
Net Income (Loss) Attributable to Parent usd -241000000 2014-01-01 2014-12-31
Net Income (Loss) Attributable to Parent usd -57000000 2015-01-01 2015-03-31
Net Income (Loss) Attributable to Parent usd 92000000 2015-04-01 2015-06-30
Net Income (Loss) Attributable to Parent usd 79000000 2015-07-01 2015-09-30
Net Income (Loss) Attributable to Parent usd 482000000 2015-10-01 2015-12-31
Net Income (Loss) Attributable to Parent usd 596000000 2015-01-01 2015-12-31
Net Income (Loss) Attributable to Parent usd 513000000 2016-01-01 2016-03-31
Net Income (Loss) Attributable to Parent usd 857000000 2016-04-01 2016-06-30
Net Income (Loss) Attributable to Parent usd 252000000 2016-07-01 2016-09-30
Net Income (Loss) Attributable to Parent usd 749000000 2016-10-01 2016-12-31
Net Income (Loss) Attributable to Parent usd 2371000000 2016-01-01 2016-12-31
Earnings Per Share, Basic usdPerShare -0.52 2014-01-01 2014-12-31
Earnings Per Share, Basic usdPerShare -0.12 2015-01-01 2015-03-31
Earnings Per Share, Basic usdPerShare 0.20 2015-04-01 2015-06-30
Earnings Per Share, Basic usdPerShare 0.17 2015-07-01 2015-09-30
Earnings Per Share, Basic usdPerShare 1.03 2015-10-01 2015-12-31
Earnings Per Share, Basic usdPerShare 1.28 2015-01-01 2015-12-31
Earnings Per Share, Basic usdPerShare 1.09 2016-01-01 2016-03-31
Earnings Per Share, Basic usdPerShare 1.81 2016-04-01 2016-06-30
Earnings Per Share, Basic usdPerShare 0.53 2016-07-01 2016-09-30
Earnings Per Share, Basic usdPerShare 1.57 2016-10-01 2016-12-31
Earnings Per Share, Basic usdPerShare 5.01 2016-01-01 2016-12-31
Earnings Per Share, Diluted usdPerShare -0.52 2014-01-01 2014-12-31
Earnings Per Share, Diluted usdPerShare -0.12 2015-01-01 2015-03-31
Earnings Per Share, Diluted usdPerShare 0.19 2015-04-01 2015-06-30
Earnings Per Share, Diluted usdPerShare 0.17 2015-07-01 2015-09-30
Earnings Per Share, Diluted usdPerShare 1.00 2015-10-01 2015-12-31
Earnings Per Share, Diluted usdPerShare 1.25 2015-01-01 2015-12-31
Earnings Per Share, Diluted usdPerShare 1.07 2016-01-01 2016-03-31
Earnings Per Share, Diluted usdPerShare 1.78 2016-04-01 2016-06-30
Earnings Per Share, Diluted usdPerShare 0.52 2016-07-01 2016-09-30
Earnings Per Share, Diluted usdPerShare 1.54 2016-10-01 2016-12-31
Earnings Per Share, Diluted usdPerShare 4.90 2016-01-01 2016-12-31
Weighted Average Number of Shares Outstanding, Basic shares 462000000 2014-01-01 2014-12-31
Weighted Average Number of Shares Outstanding, Basic shares 465000000 2015-01-01 2015-03-31
Weighted Average Number of Shares Outstanding, Basic shares 467000000 2015-04-01 2015-06-30
Weighted Average Number of Shares Outstanding, Basic shares 468000000 2015-07-01 2015-09-30
Weighted Average Number of Shares Outstanding, Basic shares 470000000 2015-10-01 2015-12-31
Weighted Average Number of Shares Outstanding, Basic shares 467000000 2015-01-01 2015-12-31
Weighted Average Number of Shares Outstanding, Basic shares 471000000 2016-01-01 2016-03-31
Weighted Average Number of Shares Outstanding, Basic shares 473000000 2016-04-01 2016-06-30
Weighted Average Number of Shares Outstanding, Basic shares 474000000 2016-07-01 2016-09-30
Weighted Average Number of Shares Outstanding, Basic shares 476000000 2016-10-01 2016-12-31
Weighted Average Number of Shares Outstanding, Basic shares 474000000 2016-01-01 2016-12-31
Weighted Average Number of Shares Outstanding, Diluted shares 462000000 2014-01-01 2014-12-31
Weighted Average Number of Shares Outstanding, Diluted shares 465000000 2015-01-01 2015-03-31
Weighted Average Number of Shares Outstanding, Diluted shares 476000000 2015-04-01 2015-06-30
Weighted Average Number of Shares Outstanding, Diluted shares 478000000 2015-07-01 2015-09-30
Weighted Average Number of Shares Outstanding, Diluted shares 481000000 2015-10-01 2015-12-31
Weighted Average Number of Shares Outstanding, Diluted shares 477000000 2015-01-01 2015-12-31
Weighted Average Number of Shares Outstanding, Diluted shares 481000000 2016-01-01 2016-03-31
Weighted Average Number of Shares Outstanding, Diluted shares 483000000 2016-04-01 2016-06-30
Weighted Average Number of Shares Outstanding, Diluted shares 485000000 2016-07-01 2016-09-30
Weighted Average Number of Shares Outstanding, Diluted shares 486000000 2016-10-01 2016-12-31
Weighted Average Number of Shares Outstanding, Diluted shares 484000000 2016-01-01 2016-12-31

Build wide tables

A wide table for Google is created

inc_wide_g<-inc_g %>% spread(Metric,Amount)
inc_wide_g <- inc_wide_g %>% mutate(company="Google")
inc_wide_g %>% kable() %>% kable_styling() %>% scroll_box(height = "400px")
Units startDate endDate Cost of Revenue Costs and Expenses General and Administrative Expense Income (Loss) from Continuing Operations Attributable to Parent Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Extraordinary Items, Noncontrolling Interest Income (Loss) from Discontinued Operations, Net of Tax, Including Portion Attributable to Noncontrolling Interest Income Tax Expense (Benefit) Net Income (Loss) Attributable to Parent Net Income (Loss) Available to Common Stockholders, Basic Nonoperating Income (Expense) Operating Income (Loss) Preferred Stock Dividends and Other Adjustments Research and Development Expense Revenues Selling and Marketing Expense company
usd 2014-01-01 2014-12-31 25691000000 49505000000 5851000000 13620000000 17259000000 516000000 3639000000 14136000000 14136000000 763000000 16496000000 0 9832000000 66001000000 8131000000 Google
usd 2015-01-01 2015-12-31 28164000000 55629000000 6136000000 16348000000 19651000000 0 3303000000 16348000000 15826000000 291000000 19360000000 522000000 12282000000 74989000000 9047000000 Google
usd 2016-01-01 2016-12-31 35138000000 66556000000 6985000000 19478000000 24150000000 0 4672000000 19478000000 19478000000 434000000 23716000000 0 13948000000 90272000000 10485000000 Google

A wide table for Amazon is created

inc_wide_a<-inc_a %>% spread(Metric,Amount)
inc_wide_a <- inc_wide_a %>% mutate(company="Amazon")
inc_wide_a %>% kable() %>% kable_styling() %>% scroll_box(height = "400px")
Units startDate endDate Cost of Goods and Services Sold Costs and Expenses Earnings Per Share, Basic Earnings Per Share, Diluted Fulfillment Expense General and Administrative Expense Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest Income (Loss) from Equity Method Investments Income Tax Expense (Benefit) Interest Expense Investment Income, Interest Marketing Expense Net Income (Loss) Attributable to Parent Nonoperating Income (Expense) Operating Income (Loss) Other Cost and Expense, Operating Other Nonoperating Income (Expense) Revenue, Net Sales Revenue, Goods, Net Sales Revenue, Services, Net Technology And Content Expense Weighted Average Number of Shares Outstanding, Basic Weighted Average Number of Shares Outstanding, Diluted company
shares 2014-01-01 2014-12-31 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 462000000 462000000 Amazon
shares 2015-01-01 2015-03-31 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 465000000 465000000 Amazon
shares 2015-01-01 2015-12-31 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 467000000 477000000 Amazon
shares 2015-04-01 2015-06-30 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 467000000 476000000 Amazon
shares 2015-07-01 2015-09-30 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 468000000 478000000 Amazon
shares 2015-10-01 2015-12-31 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 470000000 481000000 Amazon
shares 2016-01-01 2016-03-31 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 471000000 481000000 Amazon
shares 2016-01-01 2016-12-31 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 474000000 484000000 Amazon
shares 2016-04-01 2016-06-30 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 473000000 483000000 Amazon
shares 2016-07-01 2016-09-30 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 474000000 485000000 Amazon
shares 2016-10-01 2016-12-31 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 476000000 486000000 Amazon
usd 2014-01-01 2014-12-31 62752000000 88810000000 NA NA 10766000000 1552000000 -111000000 37000000 167000000 210000000 39000000 4332000000 -241000000 -289000000 178000000 133000000 -118000000 88988000000 70080000000 18908000000 9275000000 NA NA Amazon
usd 2015-01-01 2015-03-31 NA NA NA NA NA NA 21000000 NA 71000000 NA NA NA -57000000 NA 255000000 NA NA 22717000000 NA NA NA NA NA Amazon
usd 2015-01-01 2015-12-31 71651000000 104773000000 NA NA 13410000000 1747000000 1568000000 -22000000 950000000 459000000 50000000 5254000000 596000000 -665000000 2233000000 171000000 -256000000 107006000000 79268000000 27738000000 12540000000 NA NA Amazon
usd 2015-04-01 2015-06-30 NA NA NA NA NA NA 362000000 NA 266000000 NA NA NA 92000000 NA 464000000 NA NA 23185000000 NA NA NA NA NA Amazon
usd 2015-07-01 2015-09-30 NA NA NA NA NA NA 247000000 NA 161000000 NA NA NA 79000000 NA 406000000 NA NA 25358000000 NA NA NA NA NA Amazon
usd 2015-10-01 2015-12-31 NA NA NA NA NA NA 938000000 NA 453000000 NA NA NA 482000000 NA 1108000000 NA NA 35747000000 NA NA NA NA NA Amazon
usd 2016-01-01 2016-03-31 NA NA NA NA NA NA 1056000000 NA 475000000 NA NA NA 513000000 NA 1071000000 NA NA 29128000000 NA NA NA NA NA Amazon
usd 2016-01-01 2016-12-31 88265000000 131801000000 NA NA 17619000000 2432000000 3892000000 -96000000 1425000000 484000000 100000000 7233000000 2371000000 -294000000 4186000000 167000000 90000000 135987000000 94665000000 41322000000 16085000000 NA NA Amazon
usd 2016-04-01 2016-06-30 NA NA NA NA NA NA 1179000000 NA 307000000 NA NA NA 857000000 NA 1285000000 NA NA 30404000000 NA NA NA NA NA Amazon
usd 2016-07-01 2016-09-30 NA NA NA NA NA NA 491000000 NA 229000000 NA NA NA 252000000 NA 575000000 NA NA 32714000000 NA NA NA NA NA Amazon
usd 2016-10-01 2016-12-31 NA NA NA NA NA NA 1166000000 NA 414000000 NA NA NA 749000000 NA 1255000000 NA NA 43741000000 NA NA NA NA NA Amazon
usdPerShare 2014-01-01 2014-12-31 NA NA -0.52 -0.52 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon
usdPerShare 2015-01-01 2015-03-31 NA NA -0.12 -0.12 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon
usdPerShare 2015-01-01 2015-12-31 NA NA 1.28 1.25 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon
usdPerShare 2015-04-01 2015-06-30 NA NA 0.20 0.19 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon
usdPerShare 2015-07-01 2015-09-30 NA NA 0.17 0.17 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon
usdPerShare 2015-10-01 2015-12-31 NA NA 1.03 1.00 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon
usdPerShare 2016-01-01 2016-03-31 NA NA 1.09 1.07 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon
usdPerShare 2016-01-01 2016-12-31 NA NA 5.01 4.90 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon
usdPerShare 2016-04-01 2016-06-30 NA NA 1.81 1.78 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon
usdPerShare 2016-07-01 2016-09-30 NA NA 0.53 0.52 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon
usdPerShare 2016-10-01 2016-12-31 NA NA 1.57 1.54 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon

A wide table containing all companies is created

inc_all<-bind_rows(inc_wide_a,inc_wide_g)
inc_all %>% kable() %>% kable_styling() %>% scroll_box(height = "400px")
Units startDate endDate Cost of Goods and Services Sold Costs and Expenses Earnings Per Share, Basic Earnings Per Share, Diluted Fulfillment Expense General and Administrative Expense Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest Income (Loss) from Equity Method Investments Income Tax Expense (Benefit) Interest Expense Investment Income, Interest Marketing Expense Net Income (Loss) Attributable to Parent Nonoperating Income (Expense) Operating Income (Loss) Other Cost and Expense, Operating Other Nonoperating Income (Expense) Revenue, Net Sales Revenue, Goods, Net Sales Revenue, Services, Net Technology And Content Expense Weighted Average Number of Shares Outstanding, Basic Weighted Average Number of Shares Outstanding, Diluted company Cost of Revenue Income (Loss) from Continuing Operations Attributable to Parent Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Extraordinary Items, Noncontrolling Interest Income (Loss) from Discontinued Operations, Net of Tax, Including Portion Attributable to Noncontrolling Interest Net Income (Loss) Available to Common Stockholders, Basic Preferred Stock Dividends and Other Adjustments Research and Development Expense Revenues Selling and Marketing Expense
shares 2014-01-01 2014-12-31 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 462000000 462000000 Amazon NA NA NA NA NA NA NA NA NA
shares 2015-01-01 2015-03-31 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 465000000 465000000 Amazon NA NA NA NA NA NA NA NA NA
shares 2015-01-01 2015-12-31 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 467000000 477000000 Amazon NA NA NA NA NA NA NA NA NA
shares 2015-04-01 2015-06-30 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 467000000 476000000 Amazon NA NA NA NA NA NA NA NA NA
shares 2015-07-01 2015-09-30 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 468000000 478000000 Amazon NA NA NA NA NA NA NA NA NA
shares 2015-10-01 2015-12-31 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 470000000 481000000 Amazon NA NA NA NA NA NA NA NA NA
shares 2016-01-01 2016-03-31 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 471000000 481000000 Amazon NA NA NA NA NA NA NA NA NA
shares 2016-01-01 2016-12-31 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 474000000 484000000 Amazon NA NA NA NA NA NA NA NA NA
shares 2016-04-01 2016-06-30 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 473000000 483000000 Amazon NA NA NA NA NA NA NA NA NA
shares 2016-07-01 2016-09-30 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 474000000 485000000 Amazon NA NA NA NA NA NA NA NA NA
shares 2016-10-01 2016-12-31 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 476000000 486000000 Amazon NA NA NA NA NA NA NA NA NA
usd 2014-01-01 2014-12-31 62752000000 88810000000 NA NA 10766000000 1552000000 -111000000 37000000 167000000 210000000 39000000 4332000000 -241000000 -289000000 178000000 133000000 -118000000 88988000000 70080000000 18908000000 9275000000 NA NA Amazon NA NA NA NA NA NA NA NA NA
usd 2015-01-01 2015-03-31 NA NA NA NA NA NA 21000000 NA 71000000 NA NA NA -57000000 NA 255000000 NA NA 22717000000 NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usd 2015-01-01 2015-12-31 71651000000 104773000000 NA NA 13410000000 1747000000 1568000000 -22000000 950000000 459000000 50000000 5254000000 596000000 -665000000 2233000000 171000000 -256000000 107006000000 79268000000 27738000000 12540000000 NA NA Amazon NA NA NA NA NA NA NA NA NA
usd 2015-04-01 2015-06-30 NA NA NA NA NA NA 362000000 NA 266000000 NA NA NA 92000000 NA 464000000 NA NA 23185000000 NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usd 2015-07-01 2015-09-30 NA NA NA NA NA NA 247000000 NA 161000000 NA NA NA 79000000 NA 406000000 NA NA 25358000000 NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usd 2015-10-01 2015-12-31 NA NA NA NA NA NA 938000000 NA 453000000 NA NA NA 482000000 NA 1108000000 NA NA 35747000000 NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usd 2016-01-01 2016-03-31 NA NA NA NA NA NA 1056000000 NA 475000000 NA NA NA 513000000 NA 1071000000 NA NA 29128000000 NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usd 2016-01-01 2016-12-31 88265000000 131801000000 NA NA 17619000000 2432000000 3892000000 -96000000 1425000000 484000000 100000000 7233000000 2371000000 -294000000 4186000000 167000000 90000000 135987000000 94665000000 41322000000 16085000000 NA NA Amazon NA NA NA NA NA NA NA NA NA
usd 2016-04-01 2016-06-30 NA NA NA NA NA NA 1179000000 NA 307000000 NA NA NA 857000000 NA 1285000000 NA NA 30404000000 NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usd 2016-07-01 2016-09-30 NA NA NA NA NA NA 491000000 NA 229000000 NA NA NA 252000000 NA 575000000 NA NA 32714000000 NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usd 2016-10-01 2016-12-31 NA NA NA NA NA NA 1166000000 NA 414000000 NA NA NA 749000000 NA 1255000000 NA NA 43741000000 NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usdPerShare 2014-01-01 2014-12-31 NA NA -0.52 -0.52 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usdPerShare 2015-01-01 2015-03-31 NA NA -0.12 -0.12 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usdPerShare 2015-01-01 2015-12-31 NA NA 1.28 1.25 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usdPerShare 2015-04-01 2015-06-30 NA NA 0.20 0.19 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usdPerShare 2015-07-01 2015-09-30 NA NA 0.17 0.17 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usdPerShare 2015-10-01 2015-12-31 NA NA 1.03 1.00 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usdPerShare 2016-01-01 2016-03-31 NA NA 1.09 1.07 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usdPerShare 2016-01-01 2016-12-31 NA NA 5.01 4.90 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usdPerShare 2016-04-01 2016-06-30 NA NA 1.81 1.78 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usdPerShare 2016-07-01 2016-09-30 NA NA 0.53 0.52 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usdPerShare 2016-10-01 2016-12-31 NA NA 1.57 1.54 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Amazon NA NA NA NA NA NA NA NA NA
usd 2014-01-01 2014-12-31 NA 49505000000 NA NA NA 5851000000 NA NA 3639000000 NA NA NA 14136000000 763000000 16496000000 NA NA NA NA NA NA NA NA Google 25691000000 13620000000 17259000000 516000000 14136000000 0 9832000000 66001000000 8131000000
usd 2015-01-01 2015-12-31 NA 55629000000 NA NA NA 6136000000 NA NA 3303000000 NA NA NA 16348000000 291000000 19360000000 NA NA NA NA NA NA NA NA Google 28164000000 16348000000 19651000000 0 15826000000 522000000 12282000000 74989000000 9047000000
usd 2016-01-01 2016-12-31 NA 66556000000 NA NA NA 6985000000 NA NA 4672000000 NA NA NA 19478000000 434000000 23716000000 NA NA NA NA NA NA NA NA Google 35138000000 19478000000 24150000000 0 19478000000 0 13948000000 90272000000 10485000000

Extract only reveneu data

Find columns with revenue

rev <- inc_all %>% select(endDate,company,starts_with("Revenue")) 
rev %>% kable() %>% kable_styling() %>% scroll_box(height = "400px")
endDate company Revenue, Net Revenues
2014-12-31 Amazon NA NA
2015-03-31 Amazon NA NA
2015-12-31 Amazon NA NA
2015-06-30 Amazon NA NA
2015-09-30 Amazon NA NA
2015-12-31 Amazon NA NA
2016-03-31 Amazon NA NA
2016-12-31 Amazon NA NA
2016-06-30 Amazon NA NA
2016-09-30 Amazon NA NA
2016-12-31 Amazon NA NA
2014-12-31 Amazon 88988000000 NA
2015-03-31 Amazon 22717000000 NA
2015-12-31 Amazon 107006000000 NA
2015-06-30 Amazon 23185000000 NA
2015-09-30 Amazon 25358000000 NA
2015-12-31 Amazon 35747000000 NA
2016-03-31 Amazon 29128000000 NA
2016-12-31 Amazon 135987000000 NA
2016-06-30 Amazon 30404000000 NA
2016-09-30 Amazon 32714000000 NA
2016-12-31 Amazon 43741000000 NA
2014-12-31 Amazon NA NA
2015-03-31 Amazon NA NA
2015-12-31 Amazon NA NA
2015-06-30 Amazon NA NA
2015-09-30 Amazon NA NA
2015-12-31 Amazon NA NA
2016-03-31 Amazon NA NA
2016-12-31 Amazon NA NA
2016-06-30 Amazon NA NA
2016-09-30 Amazon NA NA
2016-12-31 Amazon NA NA
2014-12-31 Google NA 66001000000
2015-12-31 Google NA 74989000000
2016-12-31 Google NA 90272000000 
rev_col<-colnames(rev)
rev_col<-rev_col[3:length(rev_col)]

Build new long table with revenues

rev_only <- rev %>% unite('Revenue',rev_col)
rev_only <- rev_only[!(rev_only$Revenue=="NA_NA"),]
rev_only$Revenue<-gsub("[^0-9\\.]", "", rev_only$Revenue)
rev_only <- rev_only %>% group_by(company)
rev_only %>% kable() %>% kable_styling() %>% scroll_box(height = "400px")
endDate company Revenue
12 2014-12-31 Amazon 88988000000
13 2015-03-31 Amazon 22717000000
14 2015-12-31 Amazon 107006000000
15 2015-06-30 Amazon 23185000000
16 2015-09-30 Amazon 25358000000
17 2015-12-31 Amazon 35747000000
18 2016-03-31 Amazon 29128000000
19 2016-12-31 Amazon 135987000000
20 2016-06-30 Amazon 30404000000
21 2016-09-30 Amazon 32714000000
22 2016-12-31 Amazon 43741000000
34 2014-12-31 Google 66001000000
35 2015-12-31 Google 74989000000
36 2016-12-31 Google 90272000000

Improvements

  • Plot data as a bar chart
  • Add a third company
  • Add a company with a different fiscal cycle