ADM 1340 Lecture 2: ADM1340 - Chapter 2 - Jan 15

Using the 2005 and 2006 Statement of Financial Position (SFP) and the Statement of Earnings (SE) found on pages 465 and 466, complete a vertical analysis (common-sized statements) for both years and a horizontal analysis (trend) from 2005 to 2006.Please show work.......thanks

Table13:1

Bayside Memorial Hospital Statements of Operations (Income Statements) Years Ended December 31, 2006 and 2005 (Thousands of dollars 2006 2005

Net Patient Service Revenue $108,600 $97,393

Premium revenue 5,232 4,622

Other revenue $ 3,644 6,014

Total revenues $117,476 $108,029

Expense:

Nursing Services $58,245 56,752

Dietary Services 5,424 4,718

General services 13,198 11,655

Administrative services 11,427 11,585

Employee health and welfare 10,250 10,705

Provision for uncollectible 3,328 3,469

Provision for malpractice 1,320 1,204

Depreciation 4,130 4,025

Interest expense 1,542 1,521

Total Expense $108,904 $105,634

Net Income $8,572 $2,395

Balance Sheet

Table 13.2 contains Bay side’s 2005 and 2006 balance sheets. Although the assets are all stated in terms of dollars, only cash represents actual money we see that bayside can if it liquidated its short-term investment securities. Write checks at the end of 2006 for a total $6,263,000 (verse total current liabilities of $13,332,000 due during 2006). The noncash current assets will presumably be converted to cash within a year, but they do not represent cash on hand.

Then Claims against assets are two types: 1) liabilities, or money the firm owes, and 2) equity, also called net assets or fund capital. Equity is a residual, so for 2006

Assets -Liabilities = Equity

151,278,000 - ($13,332,000+$30,582,000) =$107,364,000

Liabilities consist of $(13,332,000 of current liabilities plus $30,582,000of long-term liabilities. If assets decline in value-suppose some of Bayside’ s fixed assets were sold at less that book value-liabilities remain constant, so the value of the equity capital declines.

Table 13:2 Bayside Memorial Hospital Balance Sheets December 31, 2006 and 2005 (thousand of dollars)

2006 2005

Cash $4,263 $5,095

Short-term investments 2,000 0

Accounts receivable 21,840 20,738

Inventories 3,177 2,982

Total current assets $31,280 $28,815

Gross plant and equipment $145,168 $140,865

Accumulated depreciations 25,160 21,030

Net plant and equipment $119,998 $119,835

Total assets $151,278 $148,650

Accounts payable $4,707 $5,145

Accrued expenses 5,650 5,421

Notes payable 825 4,237

Current portion of long-term debt 2,150 2,000

Total current liabilities $13,332 $16,803

Long-term debt $28,750 $30,900

Capital lease obligations 1,832 2,155

Total long-term liabilities $30,582 $33,055

Net assets (equity) $107,364 $98,792

Total liabilities and net assets $151,278 $148,650

1. The formula for Accounts Receivable turnover is

Select one:

a. Net Sales / average accounts receivable

b. Cost of goods sold / average accounts receivable

c. Net Sales / average merchandise inventory

d. 360 days / average accounts receivable

2. The category of ratios that determine the economic status ofpublicly-traded companies is

Select one:

a. Profitability ratios

b. Market value ratios

c. Liquidity Ratios

d. Solvency ratios

3. The working capital ratio is

Select one:

a. Quick assets / current liabilities

b. Working capital /current liabilities

c. Current assets minus current liabilities

d. Current assets/current liabilities

4. Earnings per share is calculated by

Select one:

a. Dividing net income by the authorized ordinary shares.

b. Dividing net income less preferred dividends by number ofordinary shares outstanding.

c. None of the above.

d. Dividing net income by the total number of ordinary andpreferred shares issued.

5. Which of the following belong to the profitabilityratios?

Select one:

a. Rate of return on equity

b. Rate of return on assets

c. All of the above

d. Gross Profit Margin

6. The category of ratios that shows the ability of the firm topay its long-term obligations is

Select one:

a. Profitability ratios

b. Solvency ratios

c. Market value ratios

d. Liquidity Ratios

7. Operating profit margin equals

Select one:

a. Income from operations / sales

b. Net income / sales

c. Gross profit / sales

d. Profit from operations / cost of sales

8. The following are quick assets except

Select one:

a. Short-term investments

b. Merchandise Inventory

c. Accounts Receivable

d. Cash

9. The following are liquidity ratios except

Select one:

a. Earnings per share

b. Working capital ratio

c. Quick ratio

d. Receivable turnover

10. Quick assets equals

Select one:

a. All current assets

b. Cash and Accounts receivable only.

c. Total assets less non-current assets

d. Current assets minus inventory

What are the Balance Sheet Ratios (debt-to-asset and debt-to-equity ratios) for the following financial information? (PLEASE SHOW WORK SO I CAN UNDERSTAND HOW THIS WAS DONE. Thank you)