Budget Financial Management

Ja-Rule
assignment3budget301.xlsx
Home>Business & Finance homework help>Budget Financial Management

Trinity Budget Execution YTD

The Medical Center
FY 2019 YTD (Jul - Dec) FY 2019 Budget FY 2019 Variance YTD
OPERATING REVENUE:
Inpatient Revenue $ 700,000,000
Outpatient Revenue $ 525,000,000
TOTAL PATIENT SERVICES REVENUE $ 1,225,000,000
DEDUCTIONS FROM REVENUE:
Contractual Adjustments $ 950,000,000
Charity and Uncompensated Care $ 14,000,000
TOTAL DEDUCTIONS FROM REVENUE $ 964,000,000
NET PATIENT SERVICE REVENUE $ 261,000,000
OTHER OPERATING REVENUE
Other Operating Revenue $ 10,000,000
TOTAL OPERATING REVENUE $ 271,000,000
OPERATING EXPENSES
Salaries and Wages $ 88,000,000
Employee Benefits $ 25,000,000
Professional Fees $ 9,000,000
Supplies $ 46,000,000
Purchased Services - Utilities $ 3,000,000
Purchased Services - Other $ 22,000,000
Depreciation $ 17,000,000
Rentals and Leases $ 4,000,000
Insurance $ 5,000,000
License and Taxes $ 18,000,000
Interest $ 18,000,000
Provision For Bad Debts $ - 0
Other Direct Expenses $ 8,000,000
TOTAL OPERATING EXPENSES $ 263,000,000
NET OPERATING REVENUE $ 8,000,000
NET REVENUE BEFORE ITEMS LISTED BELOW $ 8,000,000
EXTRAORDINARY ITEM $ - 0
NET REVENUE OR (EXPENSE) $ 8,000,000
Med/Surg Department Budget
FY 2018 YTD (Jul - Dec) FY 2018 Budget FY 2018 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