Attachment # 00006975 - Case_1_Student_Model_._._(1)_.xlsx
Case_1_Student_Model_._._(1)_.xlsx (23.17 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
Contractual allowancesMedicare dischargesTotal dischargesOutpatient visitsLicensed bedsStaffed bedsPatient days+QuartileMedian-Quartile Deductible ratio Return on assets Return on equity Current ratio Days cash on hand Debt ratio Times interest earned Cash flow coverage Current asset turnover Fixed asset turnover Total asset turnover Occupancy rate Average daily census FTEs per occupied bed Salary per FTE Total margin CASE 1Beginning cash and investmentsEnding cash and investments Average age of plant (years) Profit per inpatient discharge Profit per outpatient visit Assessing Hospital Performance Adjusted length of stay RIVER COMMUNITY HOSPITAL (A)Operating expensesRevenuesOperating revenue Net patient service revenue Other revenueExpenses Salaries and wages Fringe benefits Interest expense Depreciation Professional liability OtherNet incomeAssets Cash and investments Accounts receivable (net) Inventories Other current assets Gross plant and equipment Accumulated depreciation Total revenue deductions Net patient service revenue Total operating expenses Total revenues Total expenses Total current assets Net plant and equipment Total assetsLiabilities and Net Assets Accounts payable Accruals Total current liabilities Long-term debt Net assets Total liabilities and net assets Current portion of long-term debtAll-payer Case Mix IndexFull-time equivalentsCash Flows from Operating Activities Net income Change in accounts receivable Change in inventories Change in other current assets Change in accounts payable Change in accruals Net cash flow from operationsCash Flows from Investing Activities Investment in plant and equipmentCash Flows from Financing Activities Change in long-term debt Change in current portion of long-term debt Net cash flow from financingCase 1 presents the opportunity to conduct an extensive financial statement and operatingflows analyses, Du Pont analyses, ratio analyses, and economic value added analyses. indicator analysis on a 210-bed not-for-profit hospital. The case includes statement of cashNote: The depreciation and fixed asset acquisitions data in the statements of directly from the other financial statements because of asset revaluations. cash flows are somewhat different than they would be if calculatedProfitability RatiosLiquidity RatiosDebt Management Ratios Debt to equityAsset Management Ratios Days in patient accounts receivable Average payment period (days)Other RatiosProfit IndicatorsNet Revenue Indicators Net revenue per discharge Net revenue per visit Medicare revenue percentage Bad debt / charity care percentage Contractual allowance percentage Outpatient revenue percentageVolume IndicatorsLength of Stay Indicators Average length of stay (days) Expense per discharge Expense per visit All-payer Case Mix IndexEfficiency Indicators Labor hours/visitUnit Cost Indicators Liability expense per dischargeNote:not represent actual industry data for the time period of the case.Note that the industry data used in this case are for instructional use only, and dothis case lies in interpretation of the data presented rather than number crunching.However, there is ample opportunity for students to extend the model to include percentagechange analysis and common size analysis, as well as to create graphs (charts) as neededto present their findings.Net increase (decrease) in cash and investmentsOperating Revenue and Expense Allocation (Millions of Dollars):Statements of Operations (Millions of Dollars):Balance Sheets (Millions of Dollars):Statements of Cash Flows (Millions of Dollars):Selected Operating Data:Selected Financial Ratios:Selected Operating Indicators:2013 Industry Data (200-299 Beds) Fringe benefits percentage Student Version Gross patient service revenue Expense per adjusted dischargeExpense Indicators Medical supplies and drugs Bad debt and charity care Gross inpatient service Gross outpatient service Inpatient service Outpatient serviceThe quartile values are based on the upper and lower numerical values regardless of whether that value isCopyright 2014 Health Administration Pressgood or bad. The interpretation is left to the analyst.The instructor version of the model is the same as this model. The key to student success in
RIVER COMMUNITY HOSPITAL Assessing Hospital Performance

RIVER COMMUNITY HOSPITAL Assessing Hospital Performance

Question # 00096551 Posted By: jia_andy Updated on: 08/25/2015 06:53 AM Due on: 11/14/2015
Subject Business Topic General Business Tutorials:
Question
Dot Image

RIVER COMMUNITY HOSPITAL (A)
Assessing Hospital Performance

Case 1 presents the opportunity to conduct an extensive financial statement and operating
indicator analysis on a 210-bed not-for-profit hospital. The case includes statement of cash
flows analyses, Du Pont analyses, ratio analyses, and economic value added analyses.
The instructor version of the model is the same as this model. The key to student success in
this case lies in interpretation of the data presented rather than number crunching.
However, there is ample opportunity for students to extend the model to include percentage
change analysis and common size analysis, as well as to create graphs (charts) as needed
to present their findings.
Note that the industry data used in this case are for instructional use only, and do
not represent actual industry data for the time period of the case.

Use Ms- Word for answer


refer attachments
Dot Image
Attachments
Case_1_Student_Model_._._(1)_.xlsx (23.17 KB)
CAESE_1_QUESTIONS.pdf (418.07 KB)
RIVER_COMMUNITY_HOSPITAL_CASE_1_(A).pdf (3125.27 KB)
Tutorials for this Question
  1. jia_andy
    Tutorial # 00090891 Posted By: jia_andy Posted on: 08/25/2015 06:53 AM
    Puchased By: 5
    Tutorial Preview
    The solution of RIVER COMMUNITY HOSPITAL Assessing Hospital Performance...
      Get the Solution
    Attachments
    River_community_hospital.docx (23.16 KB)
Whatsapp Lisa