Question

Financial Statement Analysis: You have just taken the position of Assistant to the Vice President for...

Financial Statement Analysis:

You have just taken the position of Assistant to the Vice President for Finance for a Medical Center, a 240-bed acute care hospital. The Vice President has asked you to study the organization's recent financial statements - Profit and Loss, Balance Sheet, Cash Flow (sheets are included in the files below) and provide your analysis of the organization’s strength and vulnerabilities. Considering the accounting and financial tools and skills used in technology healthcare, how would you go about this analysis?

Income Statement, Balance Sheet and Cash Flow Sheets below

Balance Sheet:

____________________________________________________________________

Period Ending                       Dec 31, 2015 Dec 31, 2014      Dec 31, 2013

Assets:

Current Assets:                        

    Cash & Cash Equivalents    10,923,000     7,495,000            7,276,000

    Short Term Investments      1,988,000          1,741,000            1,937,000

    Net Receivables                 13,324,000       9,750,000            7,050,000

    Inventory                                  -                      -                       -

    Other Current Assets              -                      -                    -

Total Current Assets                   -                     -                       -

Long Term Investments            18,792,000     18,827,000        19,605,000

Property Plant and Equip.           4,861,000      4,418,000         4,010,000

Goodwill                                 44,453,000       32,940,000        31,604,000

Intangible Assets                       8,391,000      3,669,000         3,844,000

Accumulated Amortization               -                        -                      -

Other Assets                             7,791,000     6,986,000          6,126,000

Deferred Long Term Asset Charges 860,000      556,000           430,000

Total Assets                          111,383,000   86,382,000          81,882,000

Liabilities:

________________________________________________________________

Current Liabilities:

     Accounts Payable              26,324,000   21,287,000        19,033,000

     Short/Current Long Term Debt 6,634,000    1,399,000       1,969,000

     Other Current Liabilities          -                         -                    -

Total Current Liabilities            -                     -                    -

Long Term Debt                       32,094,000    17,406,000         16,860,000

Other Liabilities                            11,775,000      9,810,000          9,269,000

Deferred Long Term Liability Charges 5,729,000    4,037,000      3,396,000

Minority Interest                         (105,000)              -                         -

Negative Goodwill                               -                  -                        -

Total Liabilities                         75,817,000      52,540,000        48,558,000

Stockholders' Equity:

_________________________________________________________________

Misc Stocks Options Warrants      1,736,000       1,388,000    1,175,000

Redeemable Preferred Stock            -                       -                         -

Preferred Stock                              -                       -                          -

Common Stock                             10,000            10,000              10,000

Retained Earnings                   37,125,000     33,836,000      33,047,000

Treasury Stock                                -                       -                        -

Capital Surplus                           29,000                -                       -

Other Stockholder Equity         (3,334,000)   (1,392,000)           (908,000)

Total Stockholder Equity    33,830,000         32,454,000          32,149,000

Net Tangible Assets              (19,014,000)   (4,155,000)             (3,299,000)

___________________________________________________________________

Cash Flow

___________________________________________________________________

Period Ending        Dec 31, 2015          Dec 31, 2014     Dec 31, 2013

Net Income             5,813,000             5,619,000           5,625,000

Operating Activities, Cash Flows Provided By or Used In:

____________________________________________________________________

Depreciation                                 693,000           1,478,000           1,375,000

Adjustments To Net Income              98,000               51,000)              249,000

Changes In Accounts Receivables (591,000)            (911,000)            (317,000)

Changes In Liabilities                   4,102,000          2,506,000             849,000

Changes In Inventories                      -                          -                            -

Changes/Operating Activities   (1,430,000)            (590,000)           (838,000)

Total Cash Flow/Operating Activities 9,740,000   8,051,000          6,991,000

Investing Activities, Cash Flows Provided By or Used In:

__________________________________________________________________________

Capital Expenditures                    (1,556,000)           (1,525,000)          (1,307,000)

Investments                                 (531,000)               799,000             (1,611,000)

Other Cash flows/Investing Activities (16,308,000)           (1,808,000)         (171,000)

Total Cash Flows/Investing Activities (18,395,000)          (2,534,000)      (3,089,000)

Financing Activities, Cash Flows Provided By or Used In:

__________________________________________________________________________

Dividends Paid                             (1,786,000)           (1,362,000)        (1,056,000)

Sale Purchase of Stock                  (916,000)           (3,546,000)        (4,046,000)

Net Borrowings                          14,607,000               391,000             152,000

Other Cash Flows/Financing Activitie 334,000              (776,000)                 4,000

Total Cash Flows/Financing Activities 12,239,000 (5,293,000)        (4,946,000)

Effect of Exchange Rate Changes         (156,000)           (5,000)            (86,000)

______________________________________________________________________________

Income Statement

______________________________________________________________________________

Period Ending                  Dec 31, 2015      Sep 30, 2015   Jun 30, 2015      Mar 31, 2015

Total Revenue               43,599,000          41,489,000        6,263,000          35,756,000

Cost of Revenue              26,542,000          25,618,000       26,026,000          25,689,000

Gross Profit                     17,057,000          15,871,000         10,237,000        10,067,000

               

Operating Expenses:  

________________________________________________________________________________

   Research Development          -                       -                       -                      -

     Selling General/Administrativ    -                      -                       -                      -

     Non Recurring                         -                 -                       -                      -

     Others                        14,589,000          12,853,000           7,342,000       7,427,000

_________________________________________________________________________________

      

       Total Operating Expenses          -                        -                      -                       -

Operating Income or Loss        2,468,000      3,018,000    2,895,000     2,640,000

Income from Continuing Operations:

__________________________________________________________________________________

Total Other Income/Expenses Net       -                       -                     -                          -

Earnings before Interest & Taxes 2,468,000 3,018,000                 2,895,000         2,640,000

Interest Expense                         260,000      229,000                    151,000            150,000

Income before Tax                2,208,000    2,789,000                 2,744,000      2,490,000

Income Tax Expense                  956,000    1,171,000                 1,159,000         1,077,000

Minority Interest                        (34,000)        (21,000)                 -                          -

__________________________________________________________________________________

Net Income from Continuing Ops   1,252,000     1,618,000          1,585,000            1,413,000

Non recurring Events:

__________________________________________________________________________________

Discontinued Operations              -                       -                            -                          -

Extraordinary Items                     -                       -                            -                          -

Effect Of Accounting Changes       -                       -                            -                         -

Other Items                               -                       -                            -                          -

Net Income                            1,218,000       1,597,000       1,585,000        1,413,000

Homework Answers

Answer #1

the financial health of the organisation does not look good.

though the cash componen has increased in the last three years. good will of the organisation has increased over the years. which is intangible asset hence no gain in funds,

on the other hand the debt component has increased which includes long term debt and other liabilities.

the net income of the corganisation has declined frm march 2015 to Dec 2015.

but the positive point in the balance sheet is that the retained earnings are high hence the orgaisation has a strong base.and will survive the losses made.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin...
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin Long-term debt to equity ratio Current ratio The Home Depot, Inc. Balance Sheet All numbers in thousands Period Ending 1/29/17 1/31/16 Current Assets Cash And Cash Equivalents 2,538,000 2,216,000 Short Term Investments - - Net Receivables 2,029,000 1,890,000 Inventory 12,549,000 11,809,000 Other Current Assets 608,000 569,000 Total Current Assets 17,724,000 16,484,000 Long Term Investments - - Property Plant and Equipment 21,914,000 22,191,000 Goodwill 2,093,000...
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin...
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin Long-term debt to equity ratio Current ratio The Home Depot, Inc. Balance Sheet All numbers in thousands Period Ending 1/29/17 1/31/16 Current Assets Cash And Cash Equivalents 2,538,000 2,216,000 Short Term Investments - - Net Receivables 2,029,000 1,890,000 Inventory 12,549,000 11,809,000 Other Current Assets 608,000 569,000 Total Current Assets 17,724,000 16,484,000 Long Term Investments - - Property Plant and Equipment 21,914,000 22,191,000 Goodwill 2,093,000...
Please compute the following ratios using $237.36B. market cap Market value added Market to book ratio...
Please compute the following ratios using $237.36B. market cap Market value added Market to book ratio Return on Asset The Home Depot, Inc. Balance Sheet All numbers in thousands Period Ending 1/29/17 1/31/16 Current Assets Cash And Cash Equivalents 2,538,000 2,216,000 Short Term Investments - - Net Receivables 2,029,000 1,890,000 Inventory 12,549,000 11,809,000 Other Current Assets 608,000 569,000 Total Current Assets 17,724,000 16,484,000 Long Term Investments - - Property Plant and Equipment 21,914,000 22,191,000 Goodwill 2,093,000 2,102,000 Intangible Assets -...
-BEFC reported cost of goods sold (COGS) of $1.8 million and average inventory for the year...
-BEFC reported cost of goods sold (COGS) of $1.8 million and average inventory for the year of $300,000. What was the Day's Sales in Inventory (DSOs) for the year? 60.0 days 60.8 days 64.3 days 68.8 days -A statement of cash flow will include all except: Operating activities Investing activities Financing activities Foreign trading activities -Operating activities is defined as: The principal revenue-generating activities of an organization and other activities that are not investing or financing; any cash flows from...
Statement of Cash Flows—Indirect Method The comparative balance sheet of Merrick Equipment Co. for December 31,...
Statement of Cash Flows—Indirect Method The comparative balance sheet of Merrick Equipment Co. for December 31, 20Y9 and 20Y8, is as follows: Dec. 31, 20Y9 Dec. 31, 20Y8 Assets Cash $239,430 $222,980 Accounts receivable (net) 86,740 80,090 Inventories 244,850 237,110 Investments 0 91,860 Land 125,590 0 Equipment 270,150 209,640 Accumulated depreciation—equipment (63,250) (56,530) Total assets $903,510 $785,150 Liabilities and Stockholders' Equity Accounts payable $163,540 $154,670 Accrued expenses payable 16,260 20,410 Dividends payable 9,040 7,070 Common stock, $10 par 48,790 38,470...
Statement of Cash Flows—Indirect Method The comparative balance sheet of Merrick Equipment Co. for December 31,...
Statement of Cash Flows—Indirect Method The comparative balance sheet of Merrick Equipment Co. for December 31, 20Y9 and 20Y8, is as follows: Dec. 31, 20Y9 Dec. 31, 20Y8 Assets Cash $222,710 $208,610 Accounts receivable (net) 80,680 74,920 Inventories 227,760 221,840 Investments 0 85,940 Land 116,820 0 Equipment 251,290 196,120 Accumulated depreciation—equipment (58,830) (52,890) Total assets $840,430 $734,540 Liabilities and Stockholders' Equity Accounts payable $152,120 $144,700 Accrued expenses payable 15,130 19,100 Dividends payable 8,400 6,610 Common stock, $10 par 45,380 35,990...
Please Give a Horizontal Analysis for CVS and Walgreens CVS Balance Sheet All numbers in thousands...
Please Give a Horizontal Analysis for CVS and Walgreens CVS Balance Sheet All numbers in thousands Period Ending 12/31/2017 12/31/2016 12/31/2015 Current Assets Cash And Cash Equivalents 1,696,000 3,371,000 2,459,000 Short Term Investments 111,000 87,000 88,000 Net Receivables 13,181,000 12,164,000 11,888,000 Inventory 15,296,000 14,760,000 14,001,000 Other Current Assets 945,000 660,000 722,000 Total Current Assets 31,229,000 31,042,000 29,158,000 Long Term Investments - - - Property Plant and Equipment 10,292,000 10,175,000 9,855,000 Goodwill 38,451,000 38,249,000 38,106,000 Intangible Assets 13,630,000 13,511,000 13,878,000 Accumulated...
The following chart is the Accounting Statement of Cashflows. Construct the financial statement of cash flows....
The following chart is the Accounting Statement of Cashflows. Construct the financial statement of cash flows. Assume taxes are $20 and all taxes are current. Interest expense is $5. Cash Flows from operating activities Net income $41 Add (subtract) items that affect net income and cash flow differently Depreciation $18 Gain on sale of plant assets (8) Increase in account receivable (13) Increase in Interest receivable (2) Decrease in Inventory 3 Increase in prepaid expenses (1) Increase in account payable...
I'll rate do all parts Statement of Cash Flows—Indirect Method The comparative balance sheet of Merrick...
I'll rate do all parts Statement of Cash Flows—Indirect Method The comparative balance sheet of Merrick Equipment Co. for December 31, 20Y9 and 20Y8, is as follows: Dec. 31, 20Y9 Dec. 31, 20Y8 Assets Cash $279,110 $261,730 Accounts receivable (net) 101,110 94,000 Inventories 285,420 278,320 Investments 0 107,820 Land 146,400 0 Equipment 314,920 246,060 Accumulated depreciation—equipment (73,730) (66,350) Total assets $1,053,230 $921,580 Liabilities and Stockholders' Equity Accounts payable $190,630 $181,550 Accrued expenses payable 18,960 23,960 Dividends payable 10,530 8,290 Common...
Which of the following is not, historically, typical of the attitude of an analyst where business...
Which of the following is not, historically, typical of the attitude of an analyst where business trends are upward (or positive)? Tendency to apply higher multiples on past earnings and cash flows. Build in speculative components to price target based upon future expected improvement. Neglect to differentiation between value and speculation. Fully account for possibility that forecasts are too optimistic. Financing activities is defined as: The principal revenue-generating activities of an organization and other activities that are not investing or...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT