Question

In: Finance

Aetna Healthcare, Inc. financial statements namely the income statement and balance sheet. See below All publicly...

Aetna Healthcare, Inc. financial statements namely the income statement and balance sheet.

See below

All publicly traded corporations are required to disclose this information in their 10K. Using the 5 ratios, compute them for the latest fiscal year:

Total margin

Operating margin

Return on assets

Return on equity

Current ratio


These ratios will touch on areas such as profitability, financial leverage, liquidity, and asset utilization ratios Summarize your findings in a write-up. Be sure to state whether each ratio is good or bad. Be sure to show your calculations in the write-up.

2016 Consolidated Balance Sheets

Consolidated Balance Sheets At December 31, (Millions) 2016 Assets: Current assets: Cash and cash equivalents $ 17,996 Investments 3,046 Premiums receivable, net 2,356 Other receivables, net 2,224 Reinsurance recoverables 292 Accrued investment income 232 Income taxes receivable 365 44 Other current assets 2,259 Total current assets 28,449 Long-term investments 21,833 Reinsurance recoverables 727 Goodwill 10,637 Other acquired intangible assets, net 1,442 Property and equipment, net 587 Deferred income taxes 195 — Other long-term assets 1,480 Separate Accounts assets 3,991 Total assets $69,146 Liabilities and shareholders’ equity: Current liabilities: Health care costs payable $ 6,558 Future policy benefits 645 Unpaid claims 801 Unearned premiums 556 Policyholders’ funds 2,772 Current portion of long-term debt 1,634 Accrued expenses and other current liabilities 5,728 Total current liabilities 18,694 Future policy benefits 5,929 Unpaid claims 1,703 Policyholders’ funds 812 Long-term debt, less current portion 19,027 Deferred income taxes — 4 Other long-term liabilities 1,043 Separate Accounts liabilities 3,991 Total liabilities 51,203 Commitments and contingencies (Note 17) Shareholders’ equity: Common stock ($.01 par value; 2.5 billion shares authorized and 326.8 million shares issued outstanding in 2016) and additional paid-in capital 4,716 Retained earnings 14,717 Accumulated other comprehensive loss (1,552) Total Aetna shareholders’ equity 17,881 Non-controlling interests 257 62 Total equity 17,943 Total liabilities and equity $69,146

Income Statement All numbers in thousands Revenue 12/31/2016 Total Revenue 63,155,000 Cost of Revenue 46,356,000 Gross Profit 16,799,000 Operating Expenses Research Development - - - Selling General and Administrative 12,085,000 Non Recurring - - - Others 247,000 Total Operating Expenses - - - Operating Income or Loss 4,467,000 Income from Continuing Operations Total Other Income/Expenses Net 128,000 Earnings Before Interest and Taxes 4,595,000 Interest Expense 604,000 Income Before Tax 3,991,000 Income Tax Expense 1,735,000 Minority Interest 62,000 Net Income From Continuing Ops 2,256,000 Non-recurring Events Discontinued Operations - - - Extraordinary Items - - - Effect Of Accounting Changes - - - Other Items - - - Net Income Net Income 2,271,000 Preferred Stock And Other Adjustments - - - Net Income Applicable To Common Shares 2,271,000 Period Ending 12/31/2016 Current Assets Cash And Cash Equivalents 17,996,000 Short Term Investments - - - Net Receivables 5,643,000 Inventory - - - Other Current Assets - - - Total Current Assets - - - Long Term Investments 25,111,000 Property Plant and Equipment 587,000 Goodwill 10,637,000 Intangible Assets 1,442,000 Accumulated Amortization - - - Other Assets 7,730,000 Deferred Long Term Asset Charges 195,000 - - Total Assets 69,146,000 Current Liabilities Accounts Payable 5,728,000 Short/Current Long Term Debt - - - Other Current Liabilities - - - Total Current Liabilities - - - Long Term Debt 20,661,000 Other Liabilities 24,810,000 Deferred Long Term Liability Charges -177,000 Minority Interest 62,000 Negative Goodwill - - - Total Liabilities 51,265,000 Stockholders' Equity Misc. Stocks Options Warrants - - - Redeemable Preferred Stock - - - Preferred Stock - - - Common Stock 4,716,000 Retained Earnings 14,717,000 Treasury Stock - - - Capital Surplus - - - Other Stockholder Equity -1,552,000 Total Stockholder Equity 17,881,000 Net Tangible Assets 5,802,000

Solutions

Expert Solution

1) Total Margin Ratio = Net Income / Revenue

2,256,000 / 63,155,000 = 0.0357 or 3.57%

Net income includes both recurring and non-recurring components, Generally, the net income used to calculating total profit margin is adjusted for non-recurring item to offer a better view of company's profitability. $2,256,000 is asjusted for non-recurring item. If you included non-recurring items,net income will be $2,271,000.

Total margin ratio is useful for assessing and comparing the overall profitability of businesses. Calculating a firm's net profit margin tells you how much after-tax profit the business keeps for every dollar it generates in revenue or sales.Because of its simplicity, total margin ratio is not enough by itself to evaluate a potential investment, but it can be a good starting point.

A ratio by itsel is not useful. You need to perform a trend analysis or compare the ratio with other companies in the same business.

2) Operating margin = Operating income / Revenue

4,467,000 / 63,155,000 = 0.0707 or 7.07%

Operating profit margin shows a company's efficiency at controlling costs. The proportion is the amount of money left over after deducting variable expenses to pay off fixed expenses. Operating profit margin increasing faster than gross profit margin indicate improvements in controlling operating costs. in contrast, declining operating margin could be an indicatior of deteriorating control over operating costs.

A ratio by itsel is not useful. You need to perform a trend analysis or compare the ratio with other company's in the same business.

3) Return on Assets = Net income / Average total assets

Since we dont have the previous year's balance sheet tom take the average of total assets, i will use the figure of current balance sheet that is, 69,146,000.

  2,256,000 / 69,146,000 = 0.0326 or 3.2 %

ROA measures the return earned by company on its assets. The higher the ratio, more income is generated by the company. Most analysts compute this ratio as: net income / average total assets. An issue with this is that net income is the return to equity holders, whereas assets are both financed by debt abd equity. In such cases interest must be adjusted for income taxes because net income is determined after taxes. With this adjustment, the ratio would be: [net income + interest expense ( 1 - tax rate)] / Average total assets

A ratio by itsel is not useful. You need to perform a trend analysis or compare the ratio with other company's in the same business.

4) Return on equity = Net Income / Shareholders equity

2,256,000 / 17,881,000 = 0.126 or 12.6%

ROE measures the return earned by a company on its equity capital. It measures the profitability by revealing how much profit a company generates with the money shareholders have invested. This means that Company generated $0.12 of profit for every $1 of shareholders' equity.

  A ratio by itsel is not useful. You need to perform a trend analysis or compare the ratio with other company's in the same business.

5) Current Ratio = Current Assets / Current Liabilities

  28,449,000 / 18,694,000 = 1.52

The ratio expresses current assets in relation to current liabilities. A higher ratio indicates a higher level of liquidity. A cuurent ratio of 1 would indicate that the book value of its current assets are exactly equal to current liabilities.


Related Solutions

This week’s is about three common financial statements, namely the balance sheet, income statement, and statement...
This week’s is about three common financial statements, namely the balance sheet, income statement, and statement of cash flows. The basis of accounting for these statements for most non-governmental for-profit entities is known as Generally Accepted Accounting Principles (GAAP). One of the underlying principles of GAAP is that items on the balance sheet are listed at Book Value as opposed to Market Value. What are Book Value and Market Value? Under what circumstances could they be the same and under...
Three financial statements, the balance sheet, income statement, and statement of retained earnings for XYZ, Inc.,...
Three financial statements, the balance sheet, income statement, and statement of retained earnings for XYZ, Inc., an accounting and consulting firm, are included below. XYZ, Inc. Balance Sheet As of December 31, 2018 Assets: Liabilities and Shareholder's Equity: Cash $12,000 Accounts payable $2,000 Accounts receivable 22,000 Salaries payable 6,000 Supplies 7,000 Utilities payable 1,000 Land 18,000 Notes payable 25,000 Equipment (net) 30,000 Common stock 42,000 Retained earnings 13,000 Total assets $89,000 Total liabilities & stockholder's equity $89,000 XYZ, Inc. Income...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below:...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below: Company A Income Statement For the Years Ended 2017 Sales 550.00 Cost of sales 275.00 Gross profit 275.00 SG&A 55.00 Depreciation 60.00 Interest 14.47 Pretax income 145.53 Tax 43.66 Net income 101.87 Company A Balance Sheet As of 2017 Cash 60.00 Accounts receivable 5.00 Inventory 8.00 Total current assets 73.00 PP&E - gross 600.00 Accumulated depreciation 200.00 PP&E - net 400.00 Total assets 473.00...
FORECASTING FINANCIAL STATEMENTS - Below is a pro-forma income statement and balance sheet for Company A...
FORECASTING FINANCIAL STATEMENTS - Below is a pro-forma income statement and balance sheet for Company A for a 5-year period and a terminal year, based on various assumptions, which already have been completed. Company A Income Statement For the Years Ended 2017 2018 2019 2020 2021 2022 Terminal year 2023 Sales     550.00            825.00               990.00                  1,138.50                    1,252.35                    1,340.01                        1,393.62                 1.50 (825*120%) (990*115%) (1138.50*110%) (1252.35*107%) (1340.01*104%) Cost of Sales     275.00            288.75              ...
Attached are the financial statements (Balance Sheet/Income Statement) for Lost Cause, Inc, Inc for the year...
Attached are the financial statements (Balance Sheet/Income Statement) for Lost Cause, Inc, Inc for the year ended December 31, 2018. Assume the following (all as of 12/31/18): a. Beta was 1.60 b. There are 3,756,000 shares outstanding c. There are 4,256,000 shares authorized d. There are 500,000 shares in Treasury e. The share price was $78.50share. f. The overall market return was 9.0% g. The risk-free rate of return is 2.5% h. The amount in current maturities ($3,500) of LTD...
Based on the Income Statement and Balance Sheet for the XYZ Corporation (see below):         a)...
Based on the Income Statement and Balance Sheet for the XYZ Corporation (see below):         a) create the Pro Forma statement for 2015 given the following assumptions: - sales increase by 20% - all items vary directly with sales (except for Notes Payable, LTD, Owners Equity) - the company is currently operating at 100% capacity - the dividend payout ratio stays at 50%             Income Statement 2015 Pro Forma 2016 Sales $3,000,000 Cost of Goods Sold 2,000,000 Depreciation 300,000 EBIT...
The three financial statements: the Income Statement, the Balance Sheet, and the Statement of Cash Flows....
The three financial statements: the Income Statement, the Balance Sheet, and the Statement of Cash Flows. Please explain the advantages and disadvantages of using these statements to make financial decisions for the firm. Note what valuable information can be obtained from each statement. Think about how that information can be used to guide decisions and how that information might be misleading.  
The most recent financial statements for ABC, Inc. are shown here:                         Income Statement Balance Sheet...
The most recent financial statements for ABC, Inc. are shown here:                         Income Statement Balance Sheet Sales 4,800 Current assets 6,084 Current Liabilities 1,244 Costs 3,840 Fixed assets 5,183 Long-term debt 2,487 Taxable income 960 Equity 7,036 Taxes (35%) 336 Retained earnings 500 Net income 624 Total 11,267 Total 11,267 The company is running at full capacity and the company maintains a constant 50 percent dividend payout ratio. Like every other firm in its industry, next year's sales are projected...
The most recent financial statements for Bello, Inc., are shown here:    Income Statement Balance Sheet...
The most recent financial statements for Bello, Inc., are shown here:    Income Statement Balance Sheet   Sales $ 40,200   Assets $ 148,000   Debt $ 43,500   Costs 27,300   Equity 104,500   Taxable income $ 12,900   Total $ 148,000   Total $ 148,000   Taxes (23%) 2,967   Net income $ 9,933    Assets and costs are proportional to sales; debt and equity are not. A dividend of $3,450 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected...
The most recent financial statements for Bello, Inc., are shown here:    Income Statement Balance Sheet...
The most recent financial statements for Bello, Inc., are shown here:    Income Statement Balance Sheet   Sales $ 39,600   Assets $ 145,000   Debt $ 42,000   Costs 27,000   Equity 103,000   Taxable income $ 12,600   Total $ 145,000   Total $ 145,000   Taxes (25%) 3,150   Net income $ 9,450    Assets and costs are proportional to sales; debt and equity are not. A dividend of $3,300 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT