An accompanying Excel spreadsheet that, with reference to Vila Health:

• Provides the revenue and expenses through the current month of the current year.
• Estimates the revenue and expenses for the rest of the current fiscal year (Since revenue will be discussed in BHA4009, we will assume a 5% increase in revenue for the purposes of this course).
• Prepares a budget for the next fiscal year.

Hospital: St. Anthony Medical Center, Vila Health INCOME STATEMENT FY 2016 YTD (Jul - Dec) OPERATING REVENUE: Inpatient Revenue Outpatient Revenue TOTAL PATIENT SERVICES REVENUE DEDUCTIONS FROM REVENUE: Contractual Adjustments Charity and Uncompensated Care TOTAL DEDUCTIONS FROM REVENUE NET PATIENT SERVICE REVENUE OTHER OPERATING REVENUE Other Operating Revenue TOTAL OPERATING REVENUE OPERATING EXPENSES Salaries and Wages Employee Benefits Professional Fees Supplies Purchased Services - Utilities Purchased Services - Other Depreciation Rentals and Leases Insurance License and Taxes Interest Provision For Bad Debts Other Direct Expenses TOTAL OPERATING EXPENSES NET OPERATING REVENUE $ 375,040,349 $ $ 232,498,397 $ $ 607,538,746 $ FY 2016 Variance YTD 700,000,000 $ 25,040,349 525,000,000 $ (30,001,603) 1,225,000,000 $ (4,961,254) $ 476,543,215 $ $ 6,725,412 $ $ 483,268,627 $ $ 124,270,119 $ 950,000,000 14,000,000 964,000,000 261,000,000 $ $ $ $ 1,543,215 (274,588) 1,268,627 (6,229,881) $ 3,500,000 $ $ 127,770,119 $ 10,000,000 $ 271,000,000 $ (1,500,000) (7,729,881) $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 88,000,000 25,000,000 9,000,000 46,000,000 3,000,000 22,000,000 17,000,000 4,000,000 5,000,000 18,000,000 18,000,000 8,000,000 263,000,000 8,000,000 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ (1,067,770) 124,012 (417,785) 883,407 132,191 536,320 (44,746) 252,670 215,378 (1,007,856) (606,210) 744,642 (255,747) (7,474,134) 8,000,000 $ (7,474,134) NET REVENUE BEFORE ITEMS LISTED BELOW $ EXTRAORDINARY ITEM FY 2016 Budget $ 42,932,230 12,624,012 4,082,215 23,883,407 1,632,191 11,536,320 8,455,254 2,252,670 2,715,378 7,992,144 8,393,790 4,744,642 131,244,253 (3,474,134) $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ (3,474,134) $ - $ - $ - NET REVENUE OR (EXPENSE) $ (3,474,134) $ 8,000,000 $ (7,474,134) Med/Surg Department Budget FY 2016 YTD (Jul - Dec) FY 2016 Budget FY 2016 Variance TYD OPERATING REVENUE: Inpatient Revenue TOTAL PATIENT SERVICES REVENUE OPERATING EXPENSES Salaries and Wages Employee Benefits Professional Fees Supplies Purchased Services - Utilities Purchased Services - Other Insurance License and Taxes Other Direct Expenses TOTAL OPERATING EXPENSES $ $ 23,123,516 $ 23,123,516 $ 50,000,000 $ 50,000,000 $ $ $ $ $ $ $ $ $ $ $ 12,157,632 3,040,408 250,160 5,883,497 27,456 23,484 57,315 21,456 972,157 22,433,565 23,000,000 5,750,000 400,000 10,000,000 50,000 50,000 105,000 40,000 1,500,000 40,895,000 NET REVENUE OR (EXPENSE) $ $ $ $ $ $ $ $ $ $ $ 689,951 $ (1,876,484) (1,876,484) $ $ $ $ $ $ $ $ $ $ 657,632 165,408 50,160 883,497 2,456 (1,516) 4,815 1,456 222,157 1,986,065 9,105,000 $ (3,862,549) Estimate 2016 Actuals FY 2017 Budget