Aditional Information Complete 2013

profilergg14
behns_finacial.xls

FINANCIAL DATA

Company Cigna Corporation (000's) Company UHC (000's)
Cigna Corporatio (Dec 31) UHC (Dec 31)
Balance Sheet 2012 2011 2010 2009 2012 2011 2010 2010 Liquidity Ratios 2012 2011 2010 2006 2012 2011 2006 2011
Cash and Cash Equivalents 2,978 4,690 1,605 8,406 9,429 9,123 Current 188.0% 150.7% 0.0% 77.6% 85.1% 0.0%
Marketable Securities 111 100 127 3,031 2,577 2,072 Quick 188.0% 150.7% 0.0% 77.6% 85.1% 0.0%
Accounts Receivable 1,777 1,358 1,318 2,709 2,294 2,061 Cash Flow 98.6% 55.5% 0.0% 416.0% 440.6% 0.0%
Inventories 0 0 0 0
Prepaid Expenses/Other Assets 6,512 6,508 6,730 6,906 6,050 3,494 Leverage Ratios
Total Current Assets 11,378 12,656 9,780 0 21,052 20,350 0 16,750 Debt/Asset 84.4% 85.2% 0.0% 58.8% 58.3% 0.0%
LT-Debt/Capitalization 81.2% 83.0% 0.0% 38.1% 35.7% 0.0%
Other Investments 23,660 22,490 20,948 17,711 16,166 14,707
Equity Investments 0 0 0 0 0 0 0 0 Activity Ratios
Total Long-Term Investments 23,660 22,490 20,948 0 17,711 16,166 0 14,707 Average AR Days 16.11 16.13 0.00 40.83 44.40 0.00
Fixed Asset Turnover 21.36 23.30 0.00 28.08 40.50 0.00
Property, Plant, and Equipment (net) 1,120 1,024 912 3,939 2,515 2,515 Total Asset Turnover 0.43 0.46 0.00 1.37 1.50 0.00
Other Assets 17,685 14,451 14,169 38,183 28,858 28,858
Total Assets 53,855 50,621 45,809 0 80,885 67,889 0 62,830 Profitability Ratios
Operating Profit Margin 8.4% 8.8% 10.3% 8.4% 8.3% 0.0%
Accounts Payable and Accruals 6,667 6,627 5,936 6,984 6,853 6,488 Net Profit Margin 5.5% 6.3% 7.1% 5.0% 5.0% 0.0%
Loans and Notes Payable 201 104 552 0 17,419 14,862 0 13,199 Return on Assets 2.4% 2.9% 0.0% 6.8% 7.6% 0.0%
Accrued Taxes 0 0 0 0 0 0 0 0 0.0%
Other Short-Term Payables 0 0 0 0 2,713 2,207 0 3,381 0.0%
Total Current Liabilities 6,868 6,731 6,488 0 27,116 23,922 0 23,068
Secured Mortgages
Long-Term Debt 12,743 13,083 10,196 14,041 10,656 10,656
Other Long-Term Payables 24,240 22,889 22,335 3,979 3,668 2,445
Deferred Income Taxes 2,450 1,351 2,515
Total Long-Term Liabilities 36,983 35,972 32,531 0 20,470 15,675 0 15,616
Total Liabilities 43,851 42,703 39,019 0 47,586 39,597 0 38,684
Common Stock 92 92 88 10 10 11
Paid-in Capital 3,295 3,188 2,534 66
Fund Balances 30,664 27,821 25,562
Treasury Stock -5,277 -5,286 -5,242 0 0 0 0
Other 10,350 10,350 9,283 2,559 461 0 280
Total Owners' Equity 8,460 8,344 6,663 0 33,299 28,292 0 25,853
Total Liabilities & Owners' Equity 52,311 51,047 45,682 0 80,885 67,889 0 64,537
Income Statement
Revenues 29,608 21,875 21,253 18,414 110,618 101,862 101,862
Operating Expenses
Salaries and Benefits 26,642 20,030 19,383 16,516 97,532 89,889 83,111
Provision for bad debts
Depreciation and Amortization
Payroll Tax
Supplies 3,832 3,509 3,180
Other
Total Operating Expense 26,642 20,030 19,383 16,516 101,364 93,398 0 86,291
Operating Income 2,966 1,845 1,870 1,898 9,254 8,464 0 15,571
Program Service Revenue
Non-Operating Income/Expense
Income Tax Expense 853 640 521 594 3,096 2,817 2,749
Interest Expense 632 505 481
Gifts & Contributions
Other
Gain (loss) from Sales of Assets
Income (loss) from Sales of Inventory
Net rental income (loss)
853 640 521 594 3,728 3,322 0 3,230
Net Gain/Loss 2,113 1,205 1,349 1,304 5,526 5,142 0 12,341

Sheet2

Purchase Svcs 44690
Prof Svcs 20910
Dues 857
Books 390
Recruiting 2769
Insurance 11677
Licenses 11433
Prop Bus Tax 1449
Ad 994
Pub Rel 664
Admin Alloc -3984
Demo 561
92410

Chart

2006 2007 2008
MHS-TR 809,991 893,562 925,997
SMC-TR 1105335 1179460 1252715
MHS-TA 898,546 1,326,011 1,304,997
SMC-TA 1,183,847 1,270,077 1,273,385

Chart

2006 2006 2006 2006
2007 2007 2007 2007
2008 2008 2008 2008
MHS-Total Revenue
SMC-Total Revenue
MHS-Total Assets
SMC-Total Assets
809991
1105335
898546
1183847
893562
1179460
1326011
1270077
925997
1252715
1304997
1273385
Christopher: Line 12: "Total Revenue"