The following is an analysis of financial statements of a Fortune 500 company. We will be identifying and comparing financial problems. WellPoint Health Networks Inc., one of those companies listed in the Fortune 500 Magazine.

Authors Avatar

Financial Ratio Analysis Report  of

Individual Financial Ratio Analysis Project (Week 3)

FIN 540: Managerial Accounting and Finance Foundations

Richard Richins

June 29th, 2005

Financial Ratio Analysis Report

Financial Ratios are calculated and then interpreted to gain an insight of every financial element of a company. From profitability, to effectiveness of the accounts receivable, to the level of liabilities a company currently has for continued operations.  Financial Ratios can be used to analyze trends and to compare the company’s financial statements against other firms in the same industry.  These ratios sometimes can help predict the company’s future.  They are used as a tool to indicate a firm’s performance and financial situation.  The following is an analysis of financial statements of a Fortune 500 company. We will be identifying and comparing financial problems. WellPoint Health Networks Inc., one of those companies listed in the Fortune 500 Magazine.  

COMPANY PROFILE:

WELLPOINT HEALTH NETWORKS INC. (2004)

        WellPoint Health Networks‘s predecessor was Blue Cross of California. It was founded in 1982.  It is one of the best well-known health benefits company in the United State.  “It offers a spectrum of network-based managed care plans to the large and small employer, individual, Medicaid, and senior markets.” ()  In 2004, WellPoint Health Networks Inc. and Anthem Inc. merged and became WellPoint Inc.   WellPoint Inc.’s headquarters are located in Indianapolis, Indiana.

Financial Ratio Calculation

        WellPoint’s Financial Ratios for the year 2002, 2003 and 2004 seem to change dramatically. There are a few key ratios that can be used to assess the financial performance of a company, which can be helps us determine the company’s profit or loss for a time period.  

All numbers used below for the financial ratios’ calculations are scaled in thousands

Liquidity Ratios:

                                            Current Assets              19,357,500

1. Current Ratio (2004) = ------------------------ =   ------------------- = 1.67

                                           Current Liabilities         11, 570,600

        Current Ratio is a standard measure of the business’ short term financial health.  It is used to measure a company’s ability to remain in the business for a short time period.  The current ratio is a number found by dividing current assets by current liabilities.  The current ratio of 1.0 can keep the business to survive for one year without having any revenues.  WellPoint has 1.67 as the current ratio which means the company can survive for around two years if the company has no revenues.  The current ratio for 2004 is lower than the last two years which means the company has fewer assets to cover the business if there is no sale.  This may happen because of the merged from Anthem and WellPoint Health Networks Inc.  

Quick assets (Cash + Marketable securities +Net                    Receivables)

2. Acid-test (Quick) Ratio (2004) = ----------------------------------------------------------------

                                                                                Current Liabilities

1,457,200 + 434,000 + (13,586,900 + 658,500) + (1,574,600 + 876,400)

      = ---------------------------------------------------------------------------------------- = 1.61

                                                      11,570,600

        Quick ratio (sometimes called acid-test ratio) is “an alternative measure of liquidity that does not include inventory in the current assets.” ().  Quick ratio includes cash, marketable securities, and net receivable divided by current liabilities.   Quick ratio of 1.61 is a favorable financial ratio and it indicates that WellPoint Inc. does not have to rely on sales of inventory to pay its current bills.  Even though the quick ratio is higher than its competitors, it is lower than the last two years. It means the companies did not generate more cash than the last two years.

Join now!

                                Net Working Capital          7,786,900

3. Net Working Capital Ratio = --------------------------- = ------------------- = 0.2

                                Total Assets                       39,738,400

        Net working capital ratio determines the company’s ability to meet the current liabilities.    Net working capital is determined by the difference between current assets minus the current liabilities.    In the year of 2004, WellPoint Inc. has a lower ratio than the last two years, but is still in the good standing within the industry.

Asset Management Ratios:

                                        Net credit sales (or net sales)

4. Account Receivables Turnover = ------------------------------------------  

                                        Average ...

This is a preview of the whole essay