Financial Analysis - Accounting for Decision Makers Research Paper

profiledhriase
ProjectFinancialDataTemplate.xlsx
Home>Business & Finance homework help>Accounting homework help>Financial Analysis - Accounting for Decision Makers Research Paper

Financial Statements

ABC Hospital
Center City, TX  11111
CMS Certification Number: 100000
Financial Statements
Balance Sheet
Period ending date 12/31/18 12/31/17 12/31/16 12/31/15 12/31/14
Number of months in period 12 12 12 12 12
Assets
Current Assets $265,779,336 $243,718,788 $217,141,619 $223,579,480 $197,141,667
Fixed Assets $596,166,511 $616,350,881 $595,730,396 $512,767,047 $508,765,419
Other Assets $854,785,820 $580,542,351 $425,717,892 $382,566,446 $270,584,786
Total Assets $1,716,731,667 $1,440,612,020 $1,238,589,907 $1,118,912,973 $976,491,872
Liabilities and Fund Balances (Equity)
Current Liabilities $120,159,373 $101,785,629 $96,551,519 $66,089,816 $52,917,296
Long-Term Liabilities $0 $0 $0 $0 $0
Total Liabilities $120,159,373 $101,785,629 $96,551,519 $66,089,816 $52,917,296
Total Fund Balances (Equity) $1,596,572,294 $1,338,826,391 $1,142,038,388 $1,052,823,157 $923,574,576
Total Liabilities & Fund Balances (Equity) $1,716,731,667 $1,440,612,020 $1,238,589,907 $1,118,912,973 $976,491,872
Income Statement
Period ending date 12/31/18 12/31/17 12/31/16 12/31/15 12/31/14
Number of months in period 12 12 12 12 12
Revenue
Inpatient Revenue $3,352,814,176 $3,047,442,262 $2,663,867,539 $2,675,161,960 $2,427,740,493
Outpatient Revenue $2,963,849,688 $2,694,689,636 $2,287,032,586 $2,244,979,664 $1,853,091,968
Total Patient Revenue $6,316,663,864 $5,742,131,898 $4,950,900,125 $4,920,141,624 $4,280,832,461
Contractual Allowance (Discounts) $4,604,460,855 $4,156,055,065 $3,484,066,505 $3,378,946,746 $2,859,953,931
Net Patient Revenues $1,712,203,009 $1,586,076,833 $1,466,833,620 $1,541,194,878 $1,420,878,530
Total Operating Expense1 $1,596,004,262 $1,399,901,765 $1,365,798,200 $1,355,376,824 $1,264,744,556
Operating Income $116,198,747 $186,175,068 $101,035,420 $185,818,054 $156,133,974
Other Income (Contributions, Bequests, etc.) $6,891,214 $7,499,339 $5,558,043 $4,493,004 $1,679,910
Income from Investments $1,744,466 $0 $0 $8,064 $8,411
Governmental Appropriations $0 $0 $0 $0 $0
Miscellaneous Non-Patient Revenue $12,528,126 $16,355,528 $25,630,081 $24,284,201 $14,407,769
Total Non-Patient Revenue $21,163,806 $23,854,867 $31,188,124 $28,785,269 $16,096,090
Total Other Expenses $0 $22,672,312 $593,063 $1,189,446 $77,393
Net Income or (Loss) $137,362,553 $187,357,623 $131,630,481 $213,413,877 $172,152,671
____________
1 Depreciation Expense (included above) $59,292,107 $62,375,167 $61,718,179 $60,114,081 $65,355,889
Source: https://www.ahd.com/financial.php?hcfa_id=0e6ed911d02223fd12ca9d585a2c3af1&ek=6403c22aa2c1fb49d9a76994b5ccbc51

Common Size

Common Size Financial Data
Balance Sheet
Period ending date 2018 2017 2016 2015 2014
Assets
Current Assets 17% 18% 20% 20%
Fixed Assets 43% 48% 46% 52%
Other Assets 40% 34% 34% 28%
Total Assets 100% 100% 100% 100%
Liabilities and Fund Balances (Equity)
Current Liabilities 7% 8% 6% 5%
Long-Term Liabilities 0% 0% 0% 0%
Total Liabilities 7% 8% 6% 5%
Total Fund Balances (Equity) 93% 92% 94% 95%
Total Liabilities & Fund Balances (Equity) 100% 100% 100% 100%
Income Statement
Period ending date 2018 2017 2016 2015 2014
Revenue
Inpatient Revenue 53% 54% 54% 57%
Outpatient Revenue 47% 46% 46% 43%
Total Patient Revenue 100% 100% 100% 100%

Ratios

ABC Hospital
2018 2017 2016 2015 2014
CURRENT RATIO:
Current assets ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Current liabilities
DEBT TO TOTAL ASSETS:
Total debt ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Total assets
DEBT TO TOTAL EQUITY:
Total debt ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Total equity
NET PROFIT ON SALES:
Net income ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Net sales

Job Costing

This tool demonstrates a basic job costing system. The following assumptions apply: (1) There are three specific jobs: X (low care), Y (mid care), and Z (high care) (2) There are two employees: Assistant A and Nurse B (3) There are three days of activity: 1, 2, and 3 (4) There are three types of direct material: AA, BB, and CC. The amount of material used is equal to the number of hours worked by each employee (5) A is paid $15 per hour and B is paid $25 per hour (6) AA costs $11 (mid), BB costs $23 (high), and CC costs $9 (low) (7) Overhead is applied at $20 per direct labor hour (8) Each employee is only allowed to requisition one item of direct material daily
Complete each time card below by assigning exactly 8 hours of work to each day for each employee (use the pick lists accessible from within the boxed areas; it is up to you to choose how many hours are worked on each job . Administrative time that is not charged to a specific job but is 1 hour for Assistant A and 2 hours for Nurse B each day). As you select the hours keep in mind the Nurse would be mainly assigned to the high care patients where the assistant would mainly be assigned to the low care patients. Similarly, use the pick lists within the material requisition cards to input the materials used by each employee on each day. The job costs sheets will be automatically prepared based on your selections. Discuss what you observed.
Employee A: Time Card Employee B: Time Card
Day Job Hours Daily Total Day Job Hours Daily Total X 0
1 X 1 X Y 1
1 Y 1 Y Z 2
1 Z 1 Z Admin 3
1 Admin error 1 Admin error 4
2 X 2 X 5
2 Y 2 Y 6
2 Z 2 Z 7
2 Admin error 2 Admin error 8
3 X 3 X
3 Y 3 Y
3 Z 3 Z
3 Admin error 3 Admin error
Employee A: Material Requisition Employee B: Material Requisition -
Day Job Item Qty Day Job Item Qty AA
1 X 1 X BB
1 Y 1 Y CC
1 Z 1 Z
2 X 2 X -
2 Y 2 Y
2 Z 2 Z
3 X 3 X
3 Y 3 Y
3 Z 3 Z
JOB Low Care Cost Sheet
Direct Labor Materials Overhead
Day 1
Employee Hours Rate Total Item Qty Cost Per Total $20 per DL hour
A 0 $ 15.00 $ - 0 0 0 $ - 0 $ - 0 $ - 0
B 0 25.00 - 0 0 0 - 0 - 0 - 0
Day 2
A 0 15.00 - 0 0 0 - 0 - 0 - 0
B 0 25.00 - 0 - 0 - 0 - 0 - 0
Day 3
A 0 15.00 - 0 0 0 - 0 - 0 - 0
B 0 25.00 - 0 0 0 - 0 - 0 - 0
$0.00 = $ - 0 $ - 0 $ - 0
JOB Mid Care Cost Sheet
Direct Labor Materials Overhead
Day 1
Employee Hours Rate Total Item Qty Cost Per Total $20 per DL hour
A 0 $ 15.00 $ - 0 0 0 $ - 0 $ - 0 $ - 0
B 0 25.00 - 0 0 0 - 0 - 0 - 0
Day 2
A 0 15.00 - 0 0 0 - 0 - 0 - 0
B 0 25.00 - 0 0 0 - 0 - 0 - 0
Day 3
A 0 15.00 - 0 0 0 - 0 - 0 - 0
B 0 25.00 - 0 0 0 - 0 - 0 - 0
$0.00 = $ - 0 $ - 0 $ - 0
JOB High Care Cost Sheet
Direct Labor Materials Overhead
Day 1
Employee Hours Rate Total Item Qty Cost Per Total $20 per DL hour
A 0 $ 15.00 $ - 0 0 0 $ - 0 $ - 0 $ - 0
B 0 25.00 - 0 0 0 - 0 - 0 - 0
Day 2
A 0 15.00 - 0 0 0 - 0 - 0 - 0
B 0 25.00 - 0 0 0 - 0 - 0 - 0
Day 3
A 0 15.00 - 0 0 0 - 0 - 0 - 0
B 0 25.00 - 0 0 0 - 0 - 0 - 0
$0.00 = $ - 0 $ - 0 $ - 0

&"Myriad Web Pro,Bold"&20I-17.03