URGENT: Budget Analysis and memo
heh96MedicalCenter_FinancialStatements2019YTDAssign3.xlsx
Trinity Budget Execution YTD
The UMUC Medical Center | |||
FY 2019 YTD (Jul - Dec) | FY 2019 Budget | FY 2019 Variance YTD | |
OPERATING REVENUE: | |||
Inpatient Revenue | $ 375,040,349 | $ 700,000,000 | $ 25,040,349 |
Outpatient Revenue | $ 232,498,397 | $ 525,000,000 | $ (30,001,603) |
TOTAL PATIENT SERVICES REVENUE | $ 607,538,746 | $ 1,225,000,000 | $ (4,961,254) |
DEDUCTIONS FROM REVENUE: | |||
Contractual Adjustments | $ 476,543,215 | $ 950,000,000 | $ 1,543,215 |
Charity and Uncompensated Care | $ 6,725,412 | $ 14,000,000 | $ (274,588) |
TOTAL DEDUCTIONS FROM REVENUE | $ 483,268,627 | $ 964,000,000 | $ 1,268,627 |
NET PATIENT SERVICE REVENUE | $ 124,270,119 | $ 261,000,000 | $ (6,229,881) |
OTHER OPERATING REVENUE | |||
Other Operating Revenue | $ 3,500,000 | $ 10,000,000 | $ (1,500,000) |
TOTAL OPERATING REVENUE | $ 127,770,119 | $ 271,000,000 | $ (7,729,881) |
OPERATING EXPENSES | |||
Salaries and Wages | $ 42,932,230 | $ 88,000,000 | $ (1,067,770) |
Employee Benefits | $ 12,624,012 | $ 25,000,000 | $ 124,012 |
Professional Fees | $ 4,082,215 | $ 9,000,000 | $ (417,785) |
Supplies | $ 23,883,407 | $ 46,000,000 | $ 883,407 |
Purchased Services - Utilities | $ 1,632,191 | $ 3,000,000 | $ 132,191 |
Purchased Services - Other | $ 11,536,320 | $ 22,000,000 | $ 536,320 |
Depreciation | $ 8,455,254 | $ 17,000,000 | $ (44,746) |
Rentals and Leases | $ 2,252,670 | $ 4,000,000 | $ 252,670 |
Insurance | $ 2,715,378 | $ 5,000,000 | $ 215,378 |
License and Taxes | $ 7,992,144 | $ 18,000,000 | $ (1,007,856) |
Interest | $ 8,393,790 | $ 18,000,000 | $ (606,210) |
Provision For Bad Debts | $ - 0 | $ - 0 | $ - 0 |
Other Direct Expenses | $ 4,744,642 | $ 8,000,000 | $ 744,642 |
TOTAL OPERATING EXPENSES | $ 131,244,253 | $ 263,000,000 | $ (255,747) |
NET OPERATING REVENUE | $ (3,474,134) | $ 8,000,000 | $ (7,474,134) |
NET REVENUE BEFORE ITEMS LISTED BELOW | $ (3,474,134) | $ 8,000,000 | $ (7,474,134) |
EXTRAORDINARY ITEM | $ - 0 | $ - 0 | $ - 0 |
NET REVENUE OR (EXPENSE) | $ (3,474,134) | $ 8,000,000 | $ (7,474,134) |
Med/Surg Department Budget | |||
FY 2019 YTD (Jul - Dec) | FY 2019 Budget | FY 2019 Variance TYD | |
OPERATING REVENUE: | |||
Inpatient Revenue | $ 23,123,516 | $ 50,000,000 | $ (1,876,484) |
TOTAL PATIENT SERVICES REVENUE | $ 23,123,516 | $ 50,000,000 | $ (1,876,484) |
OPERATING EXPENSES | |||
Salaries and Wages | $ 12,157,632 | $ 23,000,000 | $ 657,632 |
Employee Benefits | $ 3,040,408 | $ 5,750,000 | $ 165,408 |
Professional Fees | $ 250,160 | $ 400,000 | $ 50,160 |
Supplies | $ 5,883,497 | $ 10,000,000 | $ 883,497 |
Purchased Services - Utilities | $ 27,456 | $ 50,000 | $ 2,456 |
Purchased Services - Other | $ 23,484 | $ 50,000 | $ (1,516) |
Insurance | $ 57,315 | $ 105,000 | $ 4,815 |
License and Taxes | $ 21,456 | $ 40,000 | $ 1,456 |
Other Direct Expenses | $ 972,157 | $ 1,500,000 | $ 222,157 |
TOTAL OPERATING EXPENSES | $ 22,433,565 | $ 40,895,000 | $ 1,986,065 |
NET REVENUE OR (EXPENSE) | $ 689,951 | $ 9,105,000 | $ (3,862,549) |
2015
FS-1 BALANCE SHEET - UNRESTRICTED FUND | ||
Hospital: St. Anthony Medical Center, Vila Health System | FYE: 12/31/2015 | |
ASSETS | Lic.#: H-037 | |
1 | CURRENT ASSETS: | |
2 | Cash | (2,464,387) |
3 | Marketable Securities | 0 |
4 | Accounts Receivable | 39,102,464 |
5 | Less-Estimated Uncollectable & Allowances | 2,038,650 |
6 | Receivables From Third Party Payors | (3,067,704) |
7 | Pledges And Other Receivables | 1,770,581 |
8 | Due From Restricted Funds | 0 |
9 | Inventory | 7,328,984 |
10 | Prepaid Expenses | 1,230,053 |
11 | Current Portion Of Funds Held In Trust | 0 |
12 | TOTAL CURRENT ASSETS | 41,861,341 |
13 | ||
14 | BOARD DESIGNATED ASSETS: | |
15 | Cash | 0 |
16 | Marketable Securities | 0 |
17 | Other Assets | 0 |
18 | TOTAL BOARD DESIGNATED ASSETS: | 0 |
19 | ||
20 | PROPERTY, PLANT AND EQUIPMENT: | |
21 | Land | 15,239,201 |
22 | Land Improvements | 1,005,843 |
23 | Buildings | 85,916,245 |
24 | Fixed Equipment - Building Service | 28,562,665 |
25 | Fixed Equipment - Other | 9,305,052 |
26 | Equipment | 57,547,957 |
27 | Leasehold Improvements | 425,606 |
28 | Construction In Progress | 225,682 |
29 | TOTAL | 198,228,251 |
30 | Less Accumulated Depreciation | 62,102,069 |
31 | NET PROPERTY, PLANT & EQUIPMENT | 136,126,182 |
32 | ||
33 | INVESTMENTS AND OTHER ASSETS: | |
34 | Investments In Property, Plant & Equipment | 0 |
35 | Less - Accumulated Depreciation | 0 |
36 | Other Investments | 1,200,000 |
37 | Other Assets | 0 |
38 | TOTAL INVESTMENTS & OTHER ASSETS | 1,200,000 |
39 | ||
40 | INTANGIBLE ASSETS: | |
41 | Goodwill | 0 |
42 | Unamortized Loan Costs | 0 |
43 | Preopening And Other Organization Costs | 0 |
44 | Other Intangible Assets | 8,785,276 |
45 | TOTAL INTANGIBLE ASSETS | 8,785,276 |
46 | TOTAL ASSETS | 187,972,799 |
DOH - OHPD | ||
BALANCE SHEET - UNRESTRICTED FUND | ||
Hospital: St. Anthony Medical Center, Vila Health System | FYE: 12/31/2015 | |
LIABILITIES AND FUND BALANCES-UNRESTRICTED | Lic.#: H-037 | |
1 | CURRENT LIABILITIES | |
2 | Notes and Loans Payable | 0 |
3 | Accounts Payable | 15,538,863 |
4 | Accrued Compensation and Related Liabilities | 10,399,590 |
5 | Other Accrued Expenses | 2,147,237 |
6 | Advances from Third Party Payors | 0 |
7 | Payables to Third Party Payors | 0 |
8 | Due to Restricted Funds | 0 |
9 | Income Taxes Payable | 0 |
10 | Other Current Liabilities | 0 |
11 | Current Maturities of Long Term Debt | 110,036 |
12 | TOTAL CURRENT LIABILITIES | 28,195,726 |
13 | ||
14 | DEFERRED CREDITS: | |
15 | Deferred Income Taxes | 0 |
16 | Deferred Third Party Revenue | 0 |
17 | Other Deferred Credits | 185,548 |
18 | TOTAL DEFERRED CREDITS | 185,548 |
19 | ||
20 | LONG TERM DEBT | |
21 | Mortgage Payable | 0 |
22 | Construction Loans-Interim Financing | 0 |
23 | Notes Payable | 5,674,827 |
24 | Capitalized Lease Obligations | 0 |
25 | Bonds Payable | 0 |
26 | Notes and Loans Payable to Parent | 189,173,761 |
27 | Noncurrent Liabilities | 0 |
28 | TOTAL | 194,848,588 |
29 | Less Current Maturities of Long Term Debt | 110,036 |
30 | TOTAL LONG TERM DEBT | 194,738,552 |
31 | ||
32 | UNRESTRICTED FUND BALANCE | 0 |
33 | ||
34 | EQUITY (INVESTOR OWNED) | |
35 | Preferred Stock | |
36 | ||
37 | Common Stock | |
38 | ||
39 | Additional Paid In Stock | 0 |
40 | ||
41 | Retained Earnings (Capital Account for Partnership | (35,147,027) |
42 | (or Sole Proprietorship) | |
43 | ||
44 | Less Treasury Stock | |
45 | TOTAL EQUITY | (35,147,027) |
46 | TOTAL LIABILITIES AND FUND BALANCE OR EQUITY | 187,972,799 |
DOH - OHPD | ||
COMPARISON STATEMENT OF REVENUE & EXPENSE - UNRESTRICTED FUNDS | ||
Hospital: St. Anthony Medical Center, Vila Health System | FYE: 12/31/2015 | |
Lic.#: H-037 | ||
1 | OPERATING REVENUE: | |
2 | Inpatient Revenue | 666,080,698 |
3 | Outpatient Revenue | 464,996,793 |
4 | TOTAL PATIENT SERVICES REVENUE | 1,131,077,491 |
5 | ||
6 | DEDUCTIONS FROM REVENUE: | |
7 | Contractual Adjustments | 855,811,021 |
8 | Charity and Uncompensated Care | 13,400,000 |
9 | Other Adjustments and Allowances | 0 |
10 | TOTAL DEDUCTIONS FROM REVENUE | 869,211,021 |
11 | NET PATIENT SERVICE REVENUE | 261,866,470 |
12 | ||
13 | OTHER OPERATING REVENUE | |
14 | Other Operating Revenue | 9,969,048 |
15 | Tax Revenues | 0 |
16 | TOTAL OTHER OPERATING REVENUE | 9,969,048 |
17 | TOTAL OPERATING REVENUE | 271,835,518 |
18 | ||
19 | OPERATING EXPENSES | |
20 | Salaries and Wages | 85,864,459 |
21 | Employee Benefits | 25,248,024 |
22 | Professional Fees | 8,144,426 |
23 | Supplies | 47,766,813 |
24 | Purchased Services - Utilities | 3,264,382 |
25 | Purchased Services - Other | 23,072,640 |
26 | Depreciation | 16,910,508 |
27 | Rentals and Leases | 4,505,340 |
28 | Insurance | 5,430,756 |
29 | License and Taxes | 15,984,288 |
30 | Interest | 16,787,580 |
31 | Provision For Bad Debts | 2,564,197 |
32 | Other Direct Expenses | 9,489,283 |
33 | TOTAL OPERATING EXPENSES | 265,032,696 |
34 | NET OPERATING REVENUE | 6,802,822 |
35 | ||
36 | NON-OPERATING REVENUE-NET OF EXPENSES | 0 |
37 | ||
38 | NET REVENUE BEFORE ITEMS LISTED BELOW | 6,802,822 |
39 | ||
40 | EXTRAORDINARY ITEM | 1,374,000 |
41 | FEDERAL INCOME TAX | 0 |
42 | ||
43 | NET REVENUE OR (EXPENSE) | 8,176,822 |
44 | EXPLANATION: | |
45 | ||
DOH - OHPD |
2016
FS-1 BALANCE SHEET - UNRESTRICTED FUND | ||
Hospital: St. Anthony Medical Center, Vila Health System | FYE: 12/31/2016 | |
ASSETS | Lic.#: H-037 | |
1 | CURRENT ASSETS: | |
2 | Cash | (1,027,622) |
3 | Marketable Securities | 0 |
4 | Accounts Receivable | 32,410,207 |
5 | Less-Estimated Uncollectable & Allowances | 3,891,982 |
6 | Receivables From Third Party Payors | (247,989) |
7 | Pledges And Other Receivables | 1,889,617 |
8 | Due From Restricted Funds | 0 |
9 | Inventory | 8,014,988 |
10 | Prepaid Expenses | 1,301,476 |
11 | Current Portion Of Funds Held In Trust | 0 |
12 | TOTAL CURRENT ASSETS | 38,448,695 |
13 | ||
14 | BOARD DESIGNATED ASSETS: | |
15 | Cash | 0 |
16 | Marketable Securities | 0 |
17 | Other Assets | 0 |
18 | TOTAL BOARD DESIGNATED ASSETS: | 0 |
19 | ||
20 | PROPERTY, PLANT AND EQUIPMENT: | |
21 | Land | 15,239,201 |
22 | Land Improvements | 1,009,492 |
23 | Buildings | 122,015,477 |
24 | Fixed Equipment - Building Service | 77,067,373 |
25 | Fixed Equipment - Other | 0 |
26 | Equipment | 0 |
27 | Leasehold Improvements | 425,606 |
28 | Construction In Progress | 1,089,603 |
29 | TOTAL | 216,846,752 |
30 | Less Accumulated Depreciation | 75,384,791 |
31 | NET PROPERTY, PLANT & EQUIPMENT | 141,461,961 |
32 | ||
33 | INVESTMENTS AND OTHER ASSETS: | |
34 | Investments In Property, Plant & Equipment | 0 |
35 | Less - Accumulated Depreciation | 0 |
36 | Other Investments | 1,200,000 |
37 | Other Assets | 0 |
38 | TOTAL INVESTMENTS & OTHER ASSETS | 1,200,000 |
39 | ||
40 | INTANGIBLE ASSETS: | |
41 | Goodwill | 0 |
42 | Unamortized Loan Costs | 0 |
43 | Preopening And Other Organization Costs | 0 |
44 | Other Intangible Assets | 10,135,573 |
45 | TOTAL INTANGIBLE ASSETS | 10,135,573 |
46 | TOTAL ASSETS | 191,246,229 |
DOH - OHPD | ||
BALANCE SHEET - UNRESTRICTED FUND | ||
Hospital: St. Anthony Medical Center, Vila Health System | FYE: 12/31/2016 | |
LIABILITIES AND FUND BALANCES-UNRESTRICTED | Lic.#: H-037 | |
1 | CURRENT LIABILITIES | |
2 | Notes and Loans Payable | 0 |
3 | Accounts Payable | 16,230,075 |
4 | Accrued Compensation and Related Liabilities | 11,777,836 |
5 | Other Accrued Expenses | 1,866,967 |
6 | Advances from Third Party Payors | 0 |
7 | Payables to Third Party Payors | 0 |
8 | Due to Restricted Funds | 0 |
9 | Income Taxes Payable | 0 |
10 | Other Current Liabilities | 0 |
11 | Current Maturities of Long Term Debt | 0 |
12 | TOTAL CURRENT LIABILITIES | 29,874,878 |
13 | ||
14 | DEFERRED CREDITS: | |
15 | Deferred Income Taxes | 0 |
16 | Deferred Third Party Revenue | 0 |
17 | Other Deferred Credits | 0 |
18 | TOTAL DEFERRED CREDITS | 0 |
19 | ||
20 | LONG TERM DEBT | |
21 | Mortgage Payable | 0 |
22 | Construction Loans-Interim Financing | 0 |
23 | Notes Payable | 5,296,930 |
24 | Capitalized Lease Obligations | 0 |
25 | Bonds Payable | 0 |
26 | Notes and Loans Payable to Parent | 196,170,117 |
27 | Noncurrent Liabilities | 0 |
28 | TOTAL | 201,467,047 |
29 | Less Current Maturities of Long Term Debt | 0 |
30 | TOTAL LONG TERM DEBT | 201,467,047 |
31 | ||
32 | UNRESTRICTED FUND BALANCE | 0 |
33 | ||
34 | EQUITY (INVESTOR OWNED) | |
35 | Preferred Stock | |
36 | ||
37 | Common Stock | |
38 | ||
39 | Additional Paid In Stock | 0 |
40 | ||
41 | Retained Earnings (Capital Account for Partnership | (40,095,696) |
42 | (or Sole Proprietorship) | |
43 | ||
44 | Less Treasury Stock | |
45 | TOTAL EQUITY | (40,095,696) |
46 | TOTAL LIABILITIES AND FUND BALANCE OR EQUITY | 191,246,229 |
DOH - OHPD | ||
COMPARISON STATEMENT OF REVENUE & EXPENSE - UNRESTRICTED FUNDS | ||
Hospital: St. Anthony Medical Center, Vila Health System | FYE: 12/31/2016 | |
Lic.#: H-037 | ||
1 | OPERATING REVENUE: | |
2 | Inpatient Revenue | 752,813,180 |
3 | Outpatient Revenue | 529,706,918 |
4 | TOTAL PATIENT SERVICES REVENUE | 1,282,520,098 |
5 | ||
6 | DEDUCTIONS FROM REVENUE: | |
7 | Provision For Bad Debts | 5,083,718 |
8 | Contractual Adjustments | 1,010,760,525 |
9 | Charity and Uncompensated Care | 2,400,000 |
10 | Other Adjustments and Allowances | 0 |
11 | TOTAL DEDUCTIONS FROM REVENUE | 1,018,244,243 |
12 | NET PATIENT SERVICE REVENUE | 264,275,855 |
13 | ||
14 | OTHER OPERATING REVENUE | |
15 | Other Operating Revenue | 10,171,428 |
16 | Tax Revenues | 0 |
17 | TOTAL OTHER OPERATING REVENUE | 10,171,428 |
18 | TOTAL OPERATING REVENUE | 274,447,283 |
19 | ||
20 | OPERATING EXPENSES | |
21 | Salaries and Wages | 88,523,453 |
22 | Employee Benefits | 25,937,607 |
23 | Professional Fees | 9,613,656 |
24 | Supplies | 46,386,989 |
25 | Purchased Services - Utilities | 3,043,368 |
26 | Purchased Services - Other | 22,184,388 |
27 | Depreciation | 17,408,824 |
28 | Rentals and Leases | 4,866,384 |
29 | Insurance | 5,740,788 |
30 | License and Taxes | 18,828,504 |
31 | Interest | 18,671,136 |
32 | Other Direct Expenses | 8,522,136 |
33 | TOTAL OPERATING EXPENSES | 269,727,233 |
34 | NET OPERATING REVENUE | 4,720,050 |
35 | ||
36 | NON-OPERATING REVENUE-NET OF EXPENSES | 0 |
37 | ||
38 | NET REVENUE BEFORE ITEMS LISTED BELOW | 4,720,050 |
39 | ||
40 | EXTRAORDINARY ITEM | 750,000 |
41 | FEDERAL INCOME TAX | 0 |
42 | ||
43 | NET REVENUE OR (EXPENSE) | 5,470,050 |
44 | EXPLANATION: | |
45 | ||
DOH - OHPD |