Question

In: Finance

Using the information presented in the Financial Statements of United Health Care, a major HMO, compute...

Using the information presented in the Financial Statements of United Health Care, a major HMO, compute financial ratios for 1994 and 1995 and discuss some of the primary observations that you would conclude regarding the financial performance of the firm. Provide an overall evaluation of the financial position of this company.

United Healthcare Financial Ratios

                                                                         Health Plan Median                          2017       2016       2015      

Liquidity

                Current                                                                  1.32                                        ?              ?              .93

                Days in Receivables                                            22.5                                       ?              ?              19.8       

                Days Cash on Hand                                            89.9                                       ?              ?              53.6

Capital Structure

                Equity Financing %                                            48.9                                        ?              ?              60.7%

                Long Term Debt to Equity %                            13.0                                        ?              ?              3.67%

                Cash Flow to Total Debt %                               15.0                                        ?              ?              37.7%

                Times Interest Earned                                        13.1                                       ?              ?              109.5

Activity

                Total Asset Turnover                                          1.55                                        ?              ?              1.74

                Fixed Asset Turnover                                         16.8                                        ?              ?              24.6

                Current Asset Turnover                                      2.88                                        ?              ?              5.07

Profitability

                Total Margin %                                                    3.6                                          ?              ?              6.81

                Return on Equity %                                             11.6                                        ?              ?              19.6

Income Statement (000$)

Fiscal Year Ending                                                              12/31/17                 12/31/16                 12/31/15

Net sales                                                                                5,670,878              3,768,882              3,115,202

Cost of goods                                                                       3,930,933              2,643,107              2,236,588

Gross profit                                                                           1,739,945              1,125,775              878,614

Selling, general and administration                                 1,030,906              555,649               491,635

Income before depreciation and                                       709,039               570,126               386,979

amortization

Depreciation and amortization                                         94,458                 64,079                   50,628

Nonoperating income                                                         -153,796                -35,940                     122

Interest expense                                                                          771                     2,163                    3,046

Income before taxes                                                           460,014                 467,944                 333,427

Provision for income tax                                                   170,205                 177,822                 119,379

Minority interest                                                                      3,845                    1,983                     1,970

Net income before extraordinaries                                   285,964                 288,139                 212,078

Extraordinary items and discounted

Operations                                                                            NA                          1,377,075              NA         

Net income                                                                           285,964                 1,665,214              212,078

United Healthcare Corporation Balance Sheet (Data in Thousands)

Fiscal Year Ending                                              12/31/17                12/31/16                 12/31/15

Assets

Cash                                                                       940,110                 1,519,049              228,260

Marketable securities                                          863,815                 135,287                 172,610

Receivables                                                          550,313                167,369                 169,075

Other current assets                                            512,883               86,510                  44,023

Total current assets                                             2,867,121              1,908,215              613,968

Prop. Plant, Equipment                                      417,166                 273,431                 215,628

Less Accumulated Depreciation                       149,514                 110,834                 88,886

Net Prop and Equipment                                   267,652                 162,597                 126,742

Investment in Subsidiaries                                 1,274,470              1,115,054              768,563

Intangibles                                                            1,751,743              303,613 278,081

Total assets                                                           6,160,986              3,489,479              1,787,354

Liabilities

Accounts payable                                                1,236,217              470,591                 535,863

Accrued expenses                                               566,770               122,993                52,027

Other current liabilities                                     631,009                70,718               70,844

Total current liabilities                                        2,433,996              664,302                 658,734

Noncurrent capital leases                                   38,970                 29,721               39,099

Total Liabilities                                                    2,472,966              694,023                697,833

Preferred stock                                                     500,000                 NA                             NA

Common stock net                                                  1,752                 1,728                      1,691

Capital surplus                                                     822,429                 752,472                 659,359

Retained earnings                                                               2,358,640             2,085,056              424,468

Other equities                                                            5,199                 -43,800                 -108

Shareholders equity                                            3,688,020              2,795,456              1,085,410

Total liability and net worth                              6,160,986              3,489,479              1,783,243

Solutions

Expert Solution

2017 2016
Liquidity
                Current                    current asset / current liabilities
2867121/2433996 1,908,215/664,302
1.18 2.872511298
                Days in Receivables        (total receivables/Total Sales)*365
(550313/5,670,878)*365 (167369/3,768,882)*365
35 16.20896727
Capital Structure
                Equity Financing %         shareholders equity/total assets
3688020/6,160,986 2795456/3,489,479
59.86087292 80.17241379
                Long Term Debt to Equity % Long Term Debt/Equity
38970/3,688,020 29721/2,795,456
1.030368764 1.037567084
                Times Interest Earned      (Earnings before tax+interest)/interest
460014+771/771 467944+2163/2163
597.6459144 217.3402681
Activity
                Total Asset Turnover       net sales/total assets
5670878/6,160,986 3768882/3,489,479
0.920454545 1.079965606
                Fixed Asset Turnover       net sales/total fixed assets
5670878/267,652 3768882/162,597
21.23595506 23.25925926
                Current Asset Turnover     net sales/total current assets
5670878/2,867,121 3768882/1,908,215
1.977677014 1.974842767
Profitability
                Total Margin %             net income/net sales
285964/5,670,878 1665214/3,768,882
5.026455026 44.18789809
                Return on Equity %         Net income/Shareholders fund
285964/3688020 1665214/2795456
8

60

Comments
* Company should increase its current ratio as it decreases interms of last year.
* Company should increase debt financing to take the advantage of leveraging.
* There was abnormal profit in 2016.
* Company should utilise its assets to the full capacity

Related Solutions

Using the information presented in the Financial Statements of United Health Care, a major HMO, compute...
Using the information presented in the Financial Statements of United Health Care, a major HMO, compute financial ratios for 1994 and 1995 and discuss some of the primary observations that you would conclude regarding the financial performance of the firm. Provide an overall evaluation of the financial position of this company. United Healthcare Financial Ratios                                                                         Health Plan Median                   2017     2016     2015     Liquidity             Current                                                  1.32                              1.18      2.87      .93             Days in Receivables                                 22.5                             ?          ?         ...
Using the information presented in the Financial Statements of United Health Care, a major HMO, compute...
Using the information presented in the Financial Statements of United Health Care, a major HMO, compute financial ratios for 2016 and 2017 and discuss some of the primary observations that you would conclude regarding the financial performance of the firm. Provide an overall evaluation of the financial position of this company. United Healthcare Financial Ratios                                                                          Health Plan Median                          2017       2016       2015       Liquidity                 Current                                                                  1.32 ? ? .93                 Days in Receivables                                            22.5                                       ?              ?             ...
The major issues of the health care system in the United States are the cost of...
The major issues of the health care system in the United States are the cost of health care, access to health care and quality of health care. In a minimum of 250 words list and explain an example of each of the 3 major issues.
The major issues of the health care system in the United States are the cost of...
The major issues of the health care system in the United States are the cost of health care, access to health care and quality of health care. In a minimum of 250 words list and explain an example of each of the 3 major issues.
Problem 1 Consider the following financial statements for BestCare HMO, a not-for-profit managed care plan:                 ...
Problem 1 Consider the following financial statements for BestCare HMO, a not-for-profit managed care plan:                  BestCare HMO       Statement of Operations and Change in Net Assets         Year Ended June 30, 2XXX                   (in thousands) Revenue: Premiums earned $26,682 Coinsurance $1,689 Interest and other income $242     Total revenue $28,613 Expenses: Salaries and benefits $15,154 Medical supplies and drugs $7,507 Insurance $3,963 Rent $19 Depreciation $367 Interest $385     Total expenses $27,395 Net income $1,218 Net assets, beginning of...
Choose a company and look at their financial statements. Using the information on the Financial Statements...
Choose a company and look at their financial statements. Using the information on the Financial Statements compute a minimum of four ratios of your choice. For each of the ratios you've calculated explain what these ratios tell about the company?
Choose a company and look at their financial statements. Using the information on the Financial Statements...
Choose a company and look at their financial statements. Using the information on the Financial Statements compute a minimum of four ratios of your choice. For each of the ratios you've calculated explain what these ratios tell about the company? Include a link to these financial statements.
According to the British United Provident Association, a major health care provider in the U.K., snoring...
According to the British United Provident Association, a major health care provider in the U.K., snoring can be an indication of sleep apnea which can cause chronic illness if left untreated. In the United States, the National Sleep foundation reports that 36.8% of the 995 adults they surveyed snored. Of the respondents, 81.5% were over the age of 30, and 32% were both over the age of 30 and snorers. a. Are the two events of being older than 30...
According to the British United Provident Association, a major health care provider in the U.K., snoring...
According to the British United Provident Association, a major health care provider in the U.K., snoring can be an indication of sleep apnea which can cause chronic illness if left untreated. In the United States, the National Sleep foundation reports that 36.8% of the 995 adults they surveyed snored. Of the respondents, 81.5% were over the age of 30, and 32% were both over the age of 30 and snorers. A. What is the probability of snoring? B. What percent...
Is the Affordable Care Act an HMO, why and what are the pros and cons of this model of health care insurance
this s a BUSINESS class conentratio HEALTHCARE ADMINISTRATIONHMO is a Health Maintenance Organization.Is the Affordable Care Act an HMO, why and what are the pros and cons of this model of health care insurance
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT