Fundies.
English

AETNA INC /PA/

EDGAR
Filing (4) · filed 2018-11-28

248 filing records in this dataset, filed from 2001-02-13 to 2018-11-28. Reported financial figures are available; chart coverage varies by period.

Inspect reported changes Compare with another company Historical disclosures Search filings Segments
Watchlist

Latest quarter

Revenue

15.5 billion USD

2018 Q3 · USD

Exact inputs and evidence
  • Revenue: 15484000000 USD Source

Net margin

6.46%

2018 Q3 · %

Exact inputs and evidence
  • Net Income: 1000000000 USD Source
  • Revenue: 15484000000 USD Source

Operating cash flow

-700 million USD

2018 Q3 · USD

Exact inputs and evidence
  • Operating Cash Flow: 3685000000 USD Source
  • Operating Cash Flow: 4385000000 USD Source

Free cash flow

-817 million USD

2018 Q3 · USD

Exact inputs and evidence
  • Operating Cash Flow: 3685000000 USD Source
  • Operating Cash Flow: 4385000000 USD Source
  • Capital Expenditure: 336000000 USD Source
  • Capital Expenditure: 219000000 USD Source
Cash and cash equivalents
6.77 billion USD Source
Exact value

6769000000 USD

Long-term debt including current maturities
8.16 billion USD Source
Exact value

8157000000 USD

Shares outstanding
327 million shares Source
Exact value

327400000 shares

Reported share-count change

0.40% · 1.3 million shares

Year-over-year change in reported shares. Splits, issuance and buybacks can affect this figure; it does not isolate employee compensation or economic dilution.

Exact inputs and evidence
  • 326100000 shares · 2017-09-30· Source
  • 327400000 shares · 2018-09-30· Source

Company performance

Up to ten complete financial years · consolidated figures

Includes later revisions to earlier periods. Annual charts exclude incomplete years.

Latest filing recorded: 2018-11-28.

Financial data available through: 2017-12-31.

Coverage by financial measure
  • Revenue: 9 of 11 periods available· newest 2017-12-31
  • operating income: No compatible figures in this window
  • Net income: 9 of 11 periods available· newest 2017-12-31
  • Operating cash flow: 9 of 11 periods available· newest 2017-12-31
  • Capital expenditure: 9 of 11 periods available· newest 2017-12-31
  • Total assets: 10 of 11 periods available· newest 2017-12-31
  • Total liabilities: 9 of 11 periods available· newest 2017-12-31
  • Current assets: 9 of 11 periods available· newest 2017-12-31
  • Current liabilities: 9 of 11 periods available· newest 2017-12-31
  • Cash and cash equivalents: 10 of 11 periods available· newest 2017-12-31
  • Long-term debt including current maturities: 8 of 11 periods available· newest 2017-12-31
  • Shares outstanding: 8 of 11 periods available· newest 2017-12-31

Coverage describes values retained in this snapshot. Missing values are not zero; loading limits are reported separately.

What changed year over year

Latest complete year compared with the corresponding period one year earlier. These are measured changes; they do not establish their business causes.

  • Revenue

    -4.1%

    Prior period

    USD 63.16 billion

    –

    Current period

    USD 60.54 billion

    –

    Exact inputs and evidence

    60535000000 − 63155000000 = -2620000000 USD

    63155000000 USD · 2016-01-01 – 2016-12-31

    Inspect prior input Prior source

    60535000000 USD · 2017-01-01 – 2017-12-31

    Inspect current input Current source
    Share or cite

    The citation records this snapshot. The page link may show a newer release later.

  • Net income

    -16.2%

    Prior period

    USD 2.27 billion

    –

    Current period

    USD 1.9 billion

    –

    Exact inputs and evidence

    1904000000 − 2271000000 = -367000000 USD

    2271000000 USD · 2016-01-01 – 2016-12-31

    Inspect prior input Prior source

    1904000000 USD · 2017-01-01 – 2017-12-31

    Inspect current input Current source
    Share or cite

    The citation records this snapshot. The page link may show a newer release later.

  • Operating cash flow

    -112.5%

    Prior period

    USD 3.72 billion

    –

    Current period

    −USD 464 million

    –

    Exact inputs and evidence

    -464000000 − 3719000000 = -4183000000 USD

    3719000000 USD · 2016-01-01 – 2016-12-31

    Inspect prior input Prior source

    -464000000 USD · 2017-01-01 – 2017-12-31

    Inspect current input Current source
    Share or cite

    The citation records this snapshot. The page link may show a newer release later.

  • Capital expenditure

    +51.9%

    Prior period

    USD 270 million

    –

    Current period

    USD 410 million

    –

    Exact inputs and evidence

    410000000 − 270000000 = 140000000 USD

    270000000 USD · 2016-01-01 – 2016-12-31

    Inspect prior input Prior source

    410000000 USD · 2017-01-01 – 2017-12-31

    Inspect current input Current source
    Share or cite

    The citation records this snapshot. The page link may show a newer release later.

Where revenue goes

How a period’s revenue divides into costs and what remains as profit. Items marked Derived are calculated by subtraction from reported figures.

2017 2017-01-01 – 2017-12-31

  • Revenue USD 60.54 billion 100% of revenue
  • Operating costs Derived Unavailable An input is unavailable.
  • Operating income Unavailable An input is unavailable.
  • Tax, interest and other Derived Unavailable An input is unavailable.
  • Net income USD 1.9 billion 3.1% of revenue

Cash

  • Operating cash flow −USD 464 million −0.8% of revenue
  • Capital expenditure USD 410 million 0.7% of revenue
  • Free cash flow Derived −USD 874 million −1.4% of revenue

Share of revenue by period

  • Net income
  • Tax, interest and other
  • Operating costs
  • 2009 Not shown: operating income or net income is not reported.
  • 2010 Not shown: operating income or net income is not reported.
  • 2011 Not shown: operating income or net income is not reported.
  • 2012 Not shown: operating income or net income is not reported.
  • 2013 Not shown: operating income or net income is not reported.
  • 2014 Not shown: operating income or net income is not reported.
  • 2015 Not shown: operating income or net income is not reported.
  • 2016 Not shown: operating income or net income is not reported.
  • 2017 Not shown: operating income or net income is not reported.
Values and sources
Revenue breakdown by annual reporting period
PeriodRevenueOperating costsOperating incomeTax, interest and otherNet incomeFree cash flowSource
2009 2009-01-01 – 2009-12-3134764100000 UnavailableUnavailableUnavailable1276500000 2126300000 Derived
Source
2010 2010-01-01 – 2010-12-3134246000000 UnavailableUnavailableUnavailable1766800000 1123400000 Derived
Source
2011 2011-01-01 – 2011-12-3133782200000 UnavailableUnavailableUnavailable1985700000 2139100000 Derived
Source
2012 2012-01-01 – 2012-12-3136599800000 UnavailableUnavailableUnavailable1657900000 1486700000 Derived
Source
2013 2013-01-01 – 2013-12-3147294600000 UnavailableUnavailableUnavailable1913600000 1799600000 Derived
Source
2014 2014-01-01 – 2014-12-3158003000000 UnavailableUnavailableUnavailable2041000000 3003000000 Derived
Source
2015 2015-01-01 – 2015-12-3160337000000 UnavailableUnavailableUnavailable2390000000 3503000000 Derived
Source
2016 2016-01-01 – 2016-12-3163155000000 UnavailableUnavailableUnavailable2271000000 3449000000 Derived
Source
2017 2017-01-01 – 2017-12-3160535000000 UnavailableUnavailableUnavailable1904000000 -874000000 Derived
Source

Amounts are exact, in USD.

Growth

Sales over time and how quickly they are changing.

Revenue

Revenue reported for each complete financial period.

USD 60.5B 2017
Revenue historyRevenue reported for each complete financial period. Values are shown by financial reporting period. Open Values and sources below for the exact observations and evidence.68.2B51.2B34.1B17.1B0.0200920132017
Values and sources
Revenue values and source evidence
PeriodSeriesValue(USD)Source evidence
2009Revenue34764100000
2010Revenue34246000000
2011Revenue33782200000
2012Revenue36599800000
2013Revenue47294600000
2014Revenue58003000000
2015Revenue60337000000
2016Revenue63155000000
2017Revenue60535000000

Revenue growth

Change in revenue from the same financial period one year earlier.

-4.1% 2017
Revenue growth historyChange in revenue from the same financial period one year earlier. Values are shown by financial reporting period. Open Values and sources below for the exact observations and evidence.31.9%22.2%12.5%2.9%-6.8%200920132017
Values and sources
Revenue growth values and source evidence
PeriodSeriesValueSource evidence
2009Year over yearNo prior comparable period
2010Year over year-1.5%
2011Year over year-1.4%
2012Year over year8.3%
2013Year over year29.2%
2014Year over year22.6%
2015Year over year4%
2016Year over year4.7%
2017Year over year-4.1%

Profit and cash

How much revenue becomes profit, and how much cash operations generate.

Profit margins

Operating income, net income and free cash flow as a share of revenue.

Net margin 3.1% 2017
Free cash flow margin -1.4% 2017
Profit margins historyOperating income, net income and free cash flow as a share of revenue. Values are shown by financial reporting period. Open Values and sources below for the exact observations and evidence.7.0%4.7%2.4%0.2%-2.1%2009-12-312013-12-312017-12-31
  • Operating margin
  • Net margin
  • Free cash flow margin
Values and sources
Profit margins values and source evidence
PeriodSeriesValueSource evidence
2009-12-31Operating marginNot reported
2010-12-31Operating marginNot reported
2011-12-31Operating marginNot reported
2012-12-31Operating marginNot reported
2013-12-31Operating marginNot reported
2014-12-31Operating marginNot reported
2015-12-31Operating marginNot reported
2016-12-31Operating marginNot reported
2017-12-31Operating marginNot reported
2009Net margin3.7%
2010Net margin5.2%
2011Net margin5.9%
2012Net margin4.5%
2013Net margin4%
2014Net margin3.5%
2015Net margin4%
2016Net margin3.6%
2017Net margin3.1%
2009Free cash flow margin6.1%
2010Free cash flow margin3.3%
2011Free cash flow margin6.3%
2012Free cash flow margin4.1%
2013Free cash flow margin3.8%
2014Free cash flow margin5.2%
2015Free cash flow margin5.8%
2016Free cash flow margin5.5%
2017Free cash flow margin-1.4%

Operating cash flow

Cash generated by the company’s normal business operations.

USD -464M 2017
Operating cash flow historyCash generated by the company’s normal business operations. Values are shown by financial reporting period. Open Values and sources below for the exact observations and evidence.4.2B3.0B1.7B445.3M-810.4M200920132017
Values and sources
Operating cash flow values and source evidence
PeriodSeriesValue(USD)Source evidence
2009Operating cash flow2488300000
2010Operating cash flow1412100000
2011Operating cash flow2511100000
2012Operating cash flow1824900000
2013Operating cash flow2278700000
2014Operating cash flow3373000000
2015Operating cash flow3866000000
2016Operating cash flow3719000000
2017Operating cash flow-464000000

Free cash flow

Operating cash flow minus capital expenditure for the same period and unit.

USD -874M 2017
Free cash flow historyOperating cash flow minus capital expenditure for the same period and unit. Values are shown by financial reporting period. Open Values and sources below for the exact observations and evidence.3.9B2.6B1.3B45.2M-1.2B200920132017
Values and sources
Free cash flow values and source evidence
PeriodSeriesValue(USD)Source evidence
2009Free cash flow2126300000
2010Free cash flow1123400000
2011Free cash flow2139100000
2012Free cash flow1486700000
2013Free cash flow1799600000
2014Free cash flow3003000000
2015Free cash flow3503000000
2016Free cash flow3449000000
2017Free cash flow-874000000

Balance sheet

Liabilities and short-term ability to meet obligations at each period end.

Liabilities to assets

Total liabilities as a share of total assets.

71.3% 2017
Liabilities to assets historyTotal liabilities as a share of total assets. Values are shown by financial reporting period. Open Values and sources below for the exact observations and evidence.81%61%41%20%0%2009-12-3120132017
Values and sources
Liabilities to assets values and source evidence
PeriodSeriesValueSource evidence
2009-12-31Liabilities / assetsNot reported
2010Liabilities / assets73.8%
2011Liabilities / assets73.8%
2012Liabilities / assets75.1%
2013Liabilities / assets71.7%
2014Liabilities / assets72.8%
2015Liabilities / assets69.8%
2016Liabilities / assets74.1%
2017Liabilities / assets71.3%

Current assets to current liabilities

Current assets divided by current liabilities.

0.92× 2017
Current assets to current liabilities historyCurrent assets divided by current liabilities. Values are shown by financial reporting period. Open Values and sources below for the exact observations and evidence.1.64×1.23×0.82×0.41×0.00×2009-12-3120132017
Values and sources
Current assets to current liabilities values and source evidence
PeriodSeriesValueSource evidence
2009-12-31Current assets / current liabilitiesNot reportedNo source recorded
2010Current assets / current liabilities0.8×
2011Current assets / current liabilities0.69×
2012Current assets / current liabilities0.98×
2013Current assets / current liabilities0.77×
2014Current assets / current liabilities0.77×
2015Current assets / current liabilities0.82×
2016Current assets / current liabilities1.52×
2017Current assets / current liabilities0.92×

Cash generation

Compare reported profit with operating cash and capital spending. Free cash flow is calculated as operating cash flow minus capital expenditure when both exact, consolidated amounts match the same period and unit.

Cash generation by annual reporting period
PeriodNet incomeOperating cash flowCapital expenditureFree cash flow
2009 2009-01-01 – 2009-12-31
USD 1.28 billion
Exact value

Exact value: 1276500000 USD

2009-01-01 – 2009-12-31: 1276500000 USD Inspect Net Income Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 2.49 billion
Exact value

Exact value: 2488300000 USD

2009-01-01 – 2009-12-31: 2488300000 USD Inspect Operating Cash Flow Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 362 million
Exact value

Exact value: 362000000 USD

2009-01-01 – 2009-12-31: 362000000 USD Inspect Capital Expenditure Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 2.13 billion
Calculation and evidence

2488300000 − 362000000 USD

Exact free cash flow: 2126300000 USD

Share or cite

The citation records this snapshot. The page link may show a newer release later.

2010 2010-01-01 – 2010-12-31
USD 1.77 billion
Exact value

Exact value: 1766800000 USD

2010-01-01 – 2010-12-31: 1766800000 USD Inspect Net Income Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 1.41 billion
Exact value

Exact value: 1412100000 USD

2010-01-01 – 2010-12-31: 1412100000 USD Inspect Operating Cash Flow Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 288.7 million
Exact value

Exact value: 288700000 USD

2010-01-01 – 2010-12-31: 288700000 USD Inspect Capital Expenditure Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 1.12 billion
Calculation and evidence

1412100000 − 288700000 USD

Exact free cash flow: 1123400000 USD

Share or cite

The citation records this snapshot. The page link may show a newer release later.

2011 2011-01-01 – 2011-12-31
USD 1.99 billion
Exact value

Exact value: 1985700000 USD

2011-01-01 – 2011-12-31: 1985700000 USD Inspect Net Income Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 2.51 billion
Exact value

Exact value: 2511100000 USD

2011-01-01 – 2011-12-31: 2511100000 USD Inspect Operating Cash Flow Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 372 million
Exact value

Exact value: 372000000 USD

2011-01-01 – 2011-12-31: 372000000 USD Inspect Capital Expenditure Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 2.14 billion
Calculation and evidence

2511100000 − 372000000 USD

Exact free cash flow: 2139100000 USD

Share or cite

The citation records this snapshot. The page link may show a newer release later.

2012 2012-01-01 – 2012-12-31
USD 1.66 billion
Exact value

Exact value: 1657900000 USD

2012-01-01 – 2012-12-31: 1657900000 USD Inspect Net Income Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 1.82 billion
Exact value

Exact value: 1824900000 USD

2012-01-01 – 2012-12-31: 1824900000 USD Inspect Operating Cash Flow Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 338.2 million
Exact value

Exact value: 338200000 USD

2012-01-01 – 2012-12-31: 338200000 USD Inspect Capital Expenditure Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 1.49 billion
Calculation and evidence

1824900000 − 338200000 USD

Exact free cash flow: 1486700000 USD

Share or cite

The citation records this snapshot. The page link may show a newer release later.

2013 2013-01-01 – 2013-12-31
USD 1.91 billion
Exact value

Exact value: 1913600000 USD

2013-01-01 – 2013-12-31: 1913600000 USD Inspect Net Income Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 2.28 billion
Exact value

Exact value: 2278700000 USD

2013-01-01 – 2013-12-31: 2278700000 USD Inspect Operating Cash Flow Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 479.1 million
Exact value

Exact value: 479100000 USD

2013-01-01 – 2013-12-31: 479100000 USD Inspect Capital Expenditure Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 1.8 billion
Calculation and evidence

2278700000 − 479100000 USD

Exact free cash flow: 1799600000 USD

Share or cite

The citation records this snapshot. The page link may show a newer release later.

2014 2014-01-01 – 2014-12-31
USD 2.04 billion
Exact value

Exact value: 2041000000 USD

2014-01-01 – 2014-12-31: 2041000000 USD Inspect Net Income Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 3.37 billion
Exact value

Exact value: 3373000000 USD

2014-01-01 – 2014-12-31: 3373000000 USD Inspect Operating Cash Flow Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 370 million
Exact value

Exact value: 370000000 USD

2014-01-01 – 2014-12-31: 370000000 USD Inspect Capital Expenditure Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 3 billion
Calculation and evidence

3373000000 − 370000000 USD

Exact free cash flow: 3003000000 USD

Share or cite

The citation records this snapshot. The page link may show a newer release later.

2015 2015-01-01 – 2015-12-31
USD 2.39 billion
Exact value

Exact value: 2390000000 USD

2015-01-01 – 2015-12-31: 2390000000 USD Inspect Net Income Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 3.87 billion
Exact value

Exact value: 3866000000 USD

2015-01-01 – 2015-12-31: 3866000000 USD Inspect Operating Cash Flow Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 363 million
Exact value

Exact value: 363000000 USD

2015-01-01 – 2015-12-31: 363000000 USD Inspect Capital Expenditure Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 3.5 billion
Calculation and evidence

3866000000 − 363000000 USD

Exact free cash flow: 3503000000 USD

Share or cite

The citation records this snapshot. The page link may show a newer release later.

2016 2016-01-01 – 2016-12-31
USD 2.27 billion
Exact value

Exact value: 2271000000 USD

2016-01-01 – 2016-12-31: 2271000000 USD Inspect Net Income Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 3.72 billion
Exact value

Exact value: 3719000000 USD

2016-01-01 – 2016-12-31: 3719000000 USD Inspect Operating Cash Flow Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 270 million
Exact value

Exact value: 270000000 USD

2016-01-01 – 2016-12-31: 270000000 USD Inspect Capital Expenditure Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 3.45 billion
Calculation and evidence

3719000000 − 270000000 USD

Exact free cash flow: 3449000000 USD

Share or cite

The citation records this snapshot. The page link may show a newer release later.

2017 2017-01-01 – 2017-12-31
USD 1.9 billion
Exact value

Exact value: 1904000000 USD

2017-01-01 – 2017-12-31: 1904000000 USD Inspect Net Income Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

−USD 464 million
Exact value

Exact value: -464000000 USD

2017-01-01 – 2017-12-31: -464000000 USD Inspect Operating Cash Flow Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 410 million
Exact value

Exact value: 410000000 USD

2017-01-01 – 2017-12-31: 410000000 USD Inspect Capital Expenditure Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

−USD 874 million
Calculation and evidence

-464000000 − 410000000 USD

Exact free cash flow: -874000000 USD

Share or cite

The citation records this snapshot. The page link may show a newer release later.

Capital expenditure uses the canonical mapped positive-spending convention. A missing, ambiguous, incompatible, or negative-sign input is left blank. Values use the latest reported version.

Dataset coverage and company identifiers

Coverage reflects filings processed into this Fundies dataset; it does not imply every source filing is loaded.

248 filings · 3,172 latest values · 3,172 originally reported values

Dataset published . Source filing dates and reporting periods are shown separately.

Identifiers: 0001122304, 1122304, edgar:1122304

Also known as AETNA INC /PA/, AETNA U S HEALTHCARE INC