• Formulas to :
• Predict the effect of changes in all financial metrics to changes in a proposed strategic plan in your chosen organization for the following 3 scenarios:
  • Payer mix changes from 50% Medicare and 5% Medicaid patients to 70% Medicare and 10% Medicaid patients in 1 year.
  • Professional turnover goes from 5% annually to 10% annually.
  • Demand for services increases 20% in 1 year
• Search course materials including your text and the Internet for assistance in completing applicable financial calculations for this assignment.
• Using the statements that you located, provide a financial plan that will do the following:
  • Create projected financial statements to analyze effects of alternate operating assumptions on the firms financial condition
  • Determine the projected financial requirements that will be needed to support each of the 3 sets of alternate operating instructions
  • Forecast the financial sources that might be needed to support your alternative assumptions
  • Assess the projected results using a financial condition analysis to the forecasted data
• Provide appropriate spreadsheets such as Projected Income Statement and Projected Balance Sheets to validate your projected assumptions.
• Consider the effect of the following factors to justify the changes that may be needed to the strategic plan as a result of your analysis:
  • Validity of data in the decision-making process
  • Revenue growth rate
  • Capacity
  • Rate of turnover

Revenues and expenses

Total revenue Total revenue reported during the accounting period year	$3,740,547,703
Total expenses Total expenses reported during the accounting period year	$3,786,673,658
Revenues less expenses Total revenues minus expenses reported during the accounting period year	$-46,125,955

Assets and liabilities

Assets Total assets reported at the end of the accounting period year	$2,606,228,792
Liabilities Total liabilities reported at the end of the accounting period year	$853,255,263
Net assets or fund balances Net assets or fund balances reported at the end of the accounting period year	$1,752,973,529

Other key financial information

Lobbying activities Did the organization engage in lobbying activities?	Yes
Lobbying fees The amount spent by the organization on lobbying fees	$181,203
Advertising fees The amount spent by the organization on advertising fees	$11,283,454

Charity and indigent care expenses

Charity care at cost The organizations financial assistance net expense	$15,982,889
Charity cost / total functional expenses The percentage of total functional expenses taken up by at-cost care	0.42%
Unreimbursed Medicaid expenses Medicaid expenses that were not reimbursed by the program	$33,690,206
Unreimbursed Medicaid expenses / total functional expenses The percentage of total functional expenses taken up by unreimbursed Medicaid costs	0.89%
Other community benefits Net other community benefits offered at cost	$4,270,584
Other community benefits / total functional expenses The percentage of total functional expenses taken up by other community benefits	0.11%
Net community benefits Net community benefits, including charity costs, Medcaid losses and other community benefits	$68,897,834
Net community benefits / total functional expenses The percentage of total functional expenses taken up by net community benefits	1.82%

Expenses related to bad debt

Bad debt expense amount Total expenses accrued due to bad debt	$144,159
Bad debt attributable to patients Estimated amount of the organizations bad debt expense attributable to patients eligible under the organizations financial assistance policy.	$0

Medicare reimbursement

Amount reimbursed by Medicare Total revenue received from Medicare	$390,649
Cost of care reimbursed by Medicare Medicare allowable costs of care relating to payments	$367,578
Total surplus or shortfall of Medicare reimbursement Total surplus or shortfall of Medicare reimbursements vs. the cost of care	$23,071

Total number of employees Total number of employees working across all facilities	8,743
Number of voting governing body members Total number of voting members on the governing body	9
Number of independent voting members Voting members on the governing body that are independent of the organization	6