Financial Ratio assignment Paper

Financial Ratio assignment Paper

Sheet1
Financial Ratios Assignment
Instructions
Answer all questions below. The statements start at row 18 and the questions start at row 80. A Detroit Free Press Story that inspired the questions is in row 16.
For each question, there are three required parts:
(1) calculate the ratio for both years, 2012 and 2011.
(2) comment on whether performance has gotten better or worse based on the ratio.
(3) provide a direct answer to the question.
Grading will be related to the “quality” of the answer. A simple “yes” or “no” will not yield a high grade.
Eventhough the questions deal with the same topic – treat each question as being separate.
Don’t use the data or information for one question on the others.
Insert rows between the questions to permit space for your answers.
Please insert rows rather than creating additional worksheets.
Henry Ford Health System • 2012 System Report
Note: Components of the financial statements attributable to Health Alliance Plan, the wholely owned HMO of the Henry Ford Health System are labeled (HAP)
CONSOLIDATED BALANCE SHEETS
December 31, 2012 and 2011 (In Thousands) 2012 2011
ASSETS
Current Assets:
Cash and cash equivalents 266,960 226,068
Cash and cash equivalents (HAP) 209,028 118,010
Short-term investments 16,211 14,261
Net Patient care receivables 174,534 195,592
Health care premium receivables (HAP) 43,020 50,479
Other current assets 208,312 175,351
Total Current Assets 918,065 779,761
LONG-TERM INVESTMENTS 343,112 460,767
ASSETS LIMITED AS TO USE 608,390 470,480
ASSETS LIMITED AS TO USE (HAP) 249,842 329,399
JOINT VENTURES AND OTHER ASSETS 116,726 100,628
PROPERTY, PLANT AND EQUIPMENT 2,815,104 2,628,995
(Accumulated Depreciation) (1,596,587) (1,467,043)
NET PROPERTY, PLANT AND EQUIPMENT 1,218,517 1,161,952
TOTAL ASSETS 3,454,652 3,302,987
LIABILITIES AND NET ASSETS
Current Liabilities 430,943 374,483
Current Liabilities (HAP) 270,435 259,328
Long-Term Debt 817,971 827,923
Other Long-Term Liabilities 497,828 481,157
TOTAL LIABILITIES 2,017,177 1,942,891
NET ASSETS 1,206,020 1,121,536
NET ASSETS (HAP) 231,455 238,560
TOTAL LIABILITIES AND NET ASSETS 3,454,652 3,302,987
CONSOLIDATED STATEMENT OF OPERATIONS
December 31, 2012 and 2011 (In Thousands) 2012 2011
UNRESTRICTED REVENUE
Patient service revenue 2,224,038 2,115,846
(Provision for uncompensated services) (158,729) (147,992)
Net patient service revenue 2,065,309 1,967,854
Health care premiums (HAP) 1,875,087 1,791,335
Investment income 66,150 26,186
Other income 456,943 189,051
Total Unrestricted Revenue 4,463,489 3,974,426
EXPENSES
Salaries, wages, and employee benefits 1,356,884 1,299,574
Salaries, wages, and employee benefits (HAP) 145,758 140,379
Healthcare provider expense (HAP) 1,380,862 1,398,888
Supplies and other expenses 1,036,860 693,106
Supplies and other expenses (HAP) 326,634 228,289
Depreciation and amortization 168,568 145,278
Total Expenses 4,415,566 3,905,514
EXCESS OF REVENUE OVER EXPENSES 26,090 45,133
EXCESS OF REVENUE OVER EXPENSES (HAP) 21,833 23,779
UNUSUAL ITEMS 7,425 (4,263)
EXCESS OF REVENUE OVER EXPENSES 55,348 64,649
2012 2011
1. Calculating the Total Margin, separately for (a) Health Alliance Plan and (b) the Henry Ford Health System excluding Health Alliance Plan, does it appear that Henry Ford Health System has “the wherewithal to go it alone”?
1
2. Calculated Days Cash on Hand
Sheet1
Financial Ratios Assignment
Instructions
Answer all questions below. The statements start at row 18 and the questions start at row 80. A Detroit Free Press Story that inspired the questions is in row 16.
For each question, there are three required parts:
(1) calculate the ratio for both years, 2012 and 2011.
(2) comment on whether performance has gotten better or worse based on the ratio.
(3) provide a direct answer to the question.
Grading will be related to the “quality” of the answer. A simple “yes” or “no” will not yield a high grade.
Eventhough the questions deal with the same topic – treat each question as being separate.
Don’t use the data or information for one question on the others.
Insert rows between the questions to permit space for your answers.
Please insert rows rather than creating additional worksheets.
Henry Ford Health System • 2012 System Report
Note: Components of the financial statements attributable to Health Alliance Plan, the wholely owned HMO of the Henry Ford Health System are labeled (HAP)
CONSOLIDATED BALANCE SHEETS
December 31, 2012 and 2011 (In Thousands) 2012 2011
ASSETS
Current Assets:
Cash and cash equivalents 266,960 226,068
Cash and cash equivalents (HAP) 209,028 118,010
Short-term investments 16,211 14,261
Net Patient care receivables 174,534 195,592
Health care premium receivables (HAP) 43,020 50,479
Other current assets 208,312 175,351
Total Current Assets 918,065 779,761
LONG-TERM INVESTMENTS 343,112 460,767
ASSETS LIMITED AS TO USE 608,390 470,480
ASSETS LIMITED AS TO USE (HAP) 249,842 329,399
JOINT VENTURES AND OTHER ASSETS 116,726 100,628
PROPERTY, PLANT AND EQUIPMENT 2,815,104 2,628,995
(Accumulated Depreciation) (1,596,587) (1,467,043)
NET PROPERTY, PLANT AND EQUIPMENT 1,218,517 1,161,952
TOTAL ASSETS 3,454,652 3,302,987
LIABILITIES AND NET ASSETS
Current Liabilities 430,943 374,483
Current Liabilities (HAP) 270,435 259,328
Long-Term Debt 817,971 827,923
Other Long-Term Liabilities 497,828 481,157
TOTAL LIABILITIES 2,017,177 1,942,891
NET ASSETS 1,206,020 1,121,536
NET ASSETS (HAP) 231,455 238,560
TOTAL LIABILITIES AND NET ASSETS 3,454,652 3,302,987
CONSOLIDATED STATEMENT OF OPERATIONS
December 31, 2012 and 2011 (In Thousands) 2012 2011
UNRESTRICTED REVENUE
Patient service revenue 2,224,038 2,115,846
(Provision for uncompensated services) (158,729) (147,992)
Net patient service revenue 2,065,309 1,967,854
Health care premiums (HAP) 1,875,087 1,791,335
Investment income 66,150 26,186
Other income 456,943 189,051
Total Unrestricted Revenue 4,463,489 3,974,426
EXPENSES
Salaries, wages, and employee benefits 1,356,884 1,299,574
Salaries, wages, and employee benefits (HAP) 145,758 140,379
Healthcare provider expense (HAP) 1,380,862 1,398,888
Supplies and other expenses 1,036,860 693,106
Supplies and other expenses (HAP) 326,634 228,289
Depreciation and amortization 168,568 145,278
Total Expenses 4,415,566 3,905,514
EXCESS OF REVENUE OVER EXPENSES 26,090 45,133
EXCESS OF REVENUE OVER EXPENSES (HAP) 21,833 23,779
UNUSUAL ITEMS 7,425 (4,263)
EXCESS OF REVENUE OVER EXPENSES 55,348 64,649
2012 2011
1. Calculating the Total Margin, separately for (a) Health Alliance Plan and (b) the Henry Ford Health System excluding Health Alliance Plan, does it appear that Henry Ford Health System has “the wherewithal to go it alone”?
1
2. Calculated Days Cash on Hand separately (a) using current asset accounts only and (b) including long-term investments and assets limited as to use, do you think that Henry Ford Health System has the liquidity to pay their bills?
3. Based upon the Debt Ratio, do you think that Henry Ford would have the ability to borrow money if they need to make additional investments associated with the Affordable Care Act?
4. Based upon the Average Age of Plant, do you think that they are keeping pace with technology?
5. Based upon the Current Ratio, do you think that they are able to meet their short term obligations and do you foresee any liquidity issues?
6. Calculate the Return on Assets, separately for (a) Health Alliance Plan and (b) the Henry Ford Health System excluding Health Alliance Plan, does it appear that Henry Ford Health System has “the wherewithal to go it alone”?
Sheet2
Sheet3
separately (a) using current asset accounts only and (b) including long-term investments and assets limited as to use, do you think that Henry Ford Health System has the liquidity to pay their bills?
3. Based upon the Debt Ratio, do you think that Henry Ford would have the ability to borrow money if they need to make additional investments associated with the Affordable Care Act?
4. Based upon the Average Age of Plant, do you think that they are keeping pace with technology?
5. Based upon the Current Ratio, do you think that they are able to meet their short term obligations and do you foresee any liquidity issues?
6. Calculate the Return on Assets, separately for (a) Health Alliance Plan and (b) the Henry Ford Health System excluding Health Alliance Plan, does it appear that Henry Ford Health System has “the wherewithal to go it alone”?
Sheet2
Sheet3

Essay writing help – Financial Ratio assignment Paper Online Essay Writing Agency – EssayGuru Pro.

Write my Essay. Premium essay writing services is the ideal place for homework help or essay writing service. if you are looking for affordable, high quality & non-plagiarized papers, click on the button below to place your order. Provide us with the instructions and one of our writers will deliver a unique, no plagiarism, and professional paper.

Get help with your toughest assignments and get them solved by a Reliable Custom Papers Writing Company. Save time, money and get quality papers. Buying an excellent plagiarism-free paper is a piece of cake!

All our papers are written from scratch. We can cover any assignment/essay in your field of study.