Expert answer:Financial Data Analysis

Solved by verified expert:Complete the Financial Data Analysis Template. Note the order of the 2009 and 2008 columns.
•In the third column, calculate the difference by subtracting 2008 data from 2009 data. For instance, with cash, this would be $22,995 – $41,851 = -$18,856.
•In the fourth column, calculate the percentage change from the 2008 number. For instance, with Net Patient Revenue, 2009 = $459,900 and 2008 = $418,509 providing a $ change (third column) of $41,391. For the % change (fourth column), $41,391 / 418509 = .0989 which would be 9.89% (which is .0989 * 100).
•Using the explanations column, explain why the significant changes occurred from one year to the next. This explanation is based on your conceptual understanding of the way specific line items on financial statements work as well as thorough review and research of the PFCH Annual Audit.
****THE NUMBERS AND DATA HAVE ALREADY BEEN PUT IN I JUST NEED COLUMNS 5 COMPLETED with the explanations. the greyed out boxes do not need to be completed***Please check my formulas for me and there are two tabs for the spreadsheets. It should not take long. Just am in a jam with work schedules.
economic_analysis.xls

Unformatted Attachment Preview

Alyssa Repici
i
Patton-Fuller Community Hospital
Balance Sheet as of December 31
2009 and 2008
(in thousands)
(audited)
Explanation of Changes Based on the Annual Report 2009
ASSETS
Current Assets
Cash and cash equivalents
Assets of limited use
Patient accounts receivable
(net of allowance for bad
debts)
Other receivables
Inventories
Prepaid expenses
Total current assets
Other Assets
Funded Depreciation
Held under bond indenture
Property, plant and
equipment
Total assets
2008
$ Change
% Change
22,995
27,594
41,851
41,851
(18,856)
(14,257)
-45%
-34.07%
58,787
21,121
56.07%
18,396
95
127,867
37,666
87
8,370
201
130,026
10,026
(106)
(2,159)
119.78%
-52.74%
-1.66%
137,970
167,404
(29,434)
-17.58%
73,584
75,332
(1,748)
-2.32%
248,346
587,767
175,774
548,535
72,572
39,232
41.29%
7.15%
14,599
4,185
10,414
248.84%
9,198
10
23,807
4,185
10
8,380
5,013
0
15,427
119.78%
0.00%
184.09%
452,945
209,255
243,690
116.46%
14,599
438,346
462,153
4,185
205,069
213,450
10,414
233,277
248,703
248.84%
113.76%
116.52%
50
0
14,609
50
0
4,195
0
0
10,414
0.00%
0.00%
248.25%
LIABILITIES AND EQUITY
Current Liabilities
Current portion of longterm debt
Accounts payable and
accrued expenses
Bond interest payable
Total current liabilities
Other Liabilities
Long-term debt
Less: Current portion of
long-term debt
Net long-term debt
Total liabilities
Equity
Common Stock
Retained earnings
Total liabilities and equity
the changes occur?
(If the cell is grayed out then you do not need to provide an explanation)
WHY did
Patton-Fuller Community Hospital
Statement of Revenue & Expense
2009 and 2008
(in thousands)
(audited)
Explanation of Changes Based on the Annual Report 2009
REVENUE
2008
$ Change
% Change
Net patient revenue
Other revenue
Total Revenue
459,900
3,082
462,982
418,509
2,805
421,314
41,391
277
41,668
9.89%
9.88%
9.89%
Salaries and benefits
Supplies
Physician and professional
fees
Utilities
Other
Depreciation &
amortization (noncash
expenses)
Interest
Provision for doubtful
accounts
Total Expenses
220,752
74,584
214,129
71,346
6,623
3,238
3.09%
4.54%
110,376
1,200
1,840
107,065
1,164
1,784
3,311
36
56
3.09%
3.09%
3.14%
36,036
3,708
24,955
3,597
11,081
111
44.40%
3.09%
14,797
463,293
13,383
437,424
1,414
25,869
10.57%
5.91%
311
62
373
16,110
264
15,846
(15,799)
(202)
(15,473)
-98.07%
-76.52%
-97.65%
EXPENSES
INCOME
Operating Income
Investment Income
Net Income
the changes occur?
(If the cell is grayed out then you do not need to provide an explanation)
WHY did
…
Purchase answer to see full
attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades