I am failing my finance class and on academic probation please help.
I need a 15 PowerPoint presentation slide on the following: rario analysis from the 2005 and 2006 financial statements, current ratio, inventory turnover, total asset, a comparrison of both years ratios, valuation of the hospital's worth for both years, rules of thumb, discounted cash flow, comparison of both years variations, revenue variances from both years, and a summary of findings regarding the overall health and current status of the hospital with recommendations for next year's budget. Also this presentation needs three references.
Arcadia Hospital
Income Statement
YTD Dec 31, 2006
(Dollars in Millions)
Operating Revenues 2006 % of rev Budget Over/(Under)
Patient revenues 600 650
less: Allowance for doubtful accounts 10 20
equals Net patient revenues 590 630
Other Income:
Investments 80 70
Misc 2 0
Total Operating Revenue 672 100.00% 700
Operating expenses:
Wages 250 37.20% 240
Taxes & Benefits 100 14.88% 80
Temporary/Contract Labor 8 1.19% 5
Medical/surgical supplies 30 4.46% 35
Other misc supplies 4 0.60% 5
Dues/subscriptions 3 0.45% 3
Transcription expense 15 2.23% 20
Leases & rentals 40 5.95% 50
Malpractice Insurance 75 11.16% 70
Other Insurance 40 5.95% 40
Professional Fees 10 1.49% 20
Utilities 20 2.98% 15
Maintenance & Repairs 10 1.49% 12
Depreciation/Amortization 10 1.49% 10
Interest Expense 2 0.30% 2
Total Operating Expenses 617 91.82% 607
Net Income 55 8.18% 93
Arcadia Hospital
Income Statement
YTD Dec 31, 2006
(Dollars in Millions)
Operating Revenues 2006 % of rev Budget Over/(Under)
Patient revenues 600 650
less: Allowance for doubtful accounts 10 20
equals Net patient revenues 590 630
Other Income:
Investments 80 70
Misc 2 0
Total Operating Revenue 672 100.00% 700
Operating expenses:
Wages 250 37.20% 240
Taxes & Benefits 100 14.88% 80
Temporary/Contract Labor 8 1.19% 5
Medical/surgical supplies 30 4.46% 35
Other misc supplies 4 0.60% 5
Dues/subscriptions 3 0.45% 3
Transcription expense 15 2.23% 20
Leases & rentals 40 5.95% 50
Malpractice Insurance 75 11.16% 70
Other Insurance 40 5.95% 40
Professional Fees 10 1.49% 20
Utilities 20 2.98% 15
Maintenance & Repairs 10 1.49% 12
Depreciation/Amortization 10 1.49% 10
Interest Expense 2 0.30% 2
Total Operating Expenses 617 91.82% 607
Net Income 55 8.18% 93
Balance Sheet
as of 12/31/2006
(Dollars in Millions)
ASSETS 2005 % of total 2006 % of total
Current Assets
Cash & Cash equivalents 100 0.56% (345) -1.91%
ST Investments 200 1.12% 200 1.11%
Patient accounts receivable 3800 21.23% 3500 19.39%
Other misc receivables 350 1.96% 350 1.94%
Inventory 800 4.47% 800 4.43%
Prepaids 1650 9.22% 1650 9.14%
subtotal Current Assets 6900 38.55% 6155 34.09%
Property, Plant, & Equipment (PPE)
Property Plant & Equipment 13000 72.63% 14000 77.54%
less: Accumulated depreciation/amortization 2000 11.17% 2100 11.63%
Net PPE 11000 61.45% 11900 65.91%
TOTAL ASSETS 17900 100.00% 18055 100.00%
LIABILITIES & EQUITY
Current Liabilities
Accounts Payable 1100 6.15% 1200 6.65%
Accrued payroll taxes & wages 600 3.35% 600 3.32%
Other misc accrued liabilities 1500 8.38% 1600 8.86%
Total current liabilities 3200 17.88% 3400 18.83%
LT Liabilities
Note payable - mortgage 6000 33.52% 6000 33.23%
Bonds payable 800 4.47% 700 3.88%
TOTAL LIABILITIES 10000 55.87% 10100 55.94%
EQUITY
Retained Earnings 7900 44.13% 7955 44.06%
Total equity 7900 44.13% 7955 44.06%
TOTAL LIABILITIES & EQUITY 17900 100.00% 18055 100.00%
Arcadia Hospital
Statement of Cash Flows-Indirect Method
YE December 31, 2006
(Dollars in Millions)
$ %
Net Income from Operations 55 -12.36%
Add: Deprec / Amort 100 -22.47%
Equals Adjusted Net Income 155 -34.83%
Plus Other Operating Sources/(Uses) of Cash:
Short Term Investments 0 0.00%
Accounts Receivable 300 -67.42%
Inventory 0 0.00%
Prepaids 0 0.00%
Accounts Payable 100 -22.47%
Other Current Liabilities 100 -22.47%
Subtotal Sources/(Uses) of Cash 500 -112.36%
Net Cash Flow from Operations 655 -147.19%
Purchase of Equipment (1,000) 224.72%
Payments on Bonds payable (100) 22.47%
Net Increase/(Decrease) in Cash (445) 100.00%
Cash Account Beginning Balance 100
Cash Account Ending Balance (345)
Net Increase/(Decrease) in Cash (445)
I need a response by 5/16/2010... thank you. Okay to email me.
I need a 15 PowerPoint presentation slide on the following: rario analysis from the 2005 and 2006 financial statements, current ratio, inventory turnover, total asset, a comparrison of both years ratios, valuation of the hospital's worth for both years, rules of thumb, discounted cash flow, comparison of both years variations, revenue variances from both years, and a summary of findings regarding the overall health and current status of the hospital with recommendations for next year's budget. Also this presentation needs three references.
Arcadia Hospital
Income Statement
YTD Dec 31, 2006
(Dollars in Millions)
Operating Revenues 2006 % of rev Budget Over/(Under)
Patient revenues 600 650
less: Allowance for doubtful accounts 10 20
equals Net patient revenues 590 630
Other Income:
Investments 80 70
Misc 2 0
Total Operating Revenue 672 100.00% 700
Operating expenses:
Wages 250 37.20% 240
Taxes & Benefits 100 14.88% 80
Temporary/Contract Labor 8 1.19% 5
Medical/surgical supplies 30 4.46% 35
Other misc supplies 4 0.60% 5
Dues/subscriptions 3 0.45% 3
Transcription expense 15 2.23% 20
Leases & rentals 40 5.95% 50
Malpractice Insurance 75 11.16% 70
Other Insurance 40 5.95% 40
Professional Fees 10 1.49% 20
Utilities 20 2.98% 15
Maintenance & Repairs 10 1.49% 12
Depreciation/Amortization 10 1.49% 10
Interest Expense 2 0.30% 2
Total Operating Expenses 617 91.82% 607
Net Income 55 8.18% 93
Arcadia Hospital
Income Statement
YTD Dec 31, 2006
(Dollars in Millions)
Operating Revenues 2006 % of rev Budget Over/(Under)
Patient revenues 600 650
less: Allowance for doubtful accounts 10 20
equals Net patient revenues 590 630
Other Income:
Investments 80 70
Misc 2 0
Total Operating Revenue 672 100.00% 700
Operating expenses:
Wages 250 37.20% 240
Taxes & Benefits 100 14.88% 80
Temporary/Contract Labor 8 1.19% 5
Medical/surgical supplies 30 4.46% 35
Other misc supplies 4 0.60% 5
Dues/subscriptions 3 0.45% 3
Transcription expense 15 2.23% 20
Leases & rentals 40 5.95% 50
Malpractice Insurance 75 11.16% 70
Other Insurance 40 5.95% 40
Professional Fees 10 1.49% 20
Utilities 20 2.98% 15
Maintenance & Repairs 10 1.49% 12
Depreciation/Amortization 10 1.49% 10
Interest Expense 2 0.30% 2
Total Operating Expenses 617 91.82% 607
Net Income 55 8.18% 93
Balance Sheet
as of 12/31/2006
(Dollars in Millions)
ASSETS 2005 % of total 2006 % of total
Current Assets
Cash & Cash equivalents 100 0.56% (345) -1.91%
ST Investments 200 1.12% 200 1.11%
Patient accounts receivable 3800 21.23% 3500 19.39%
Other misc receivables 350 1.96% 350 1.94%
Inventory 800 4.47% 800 4.43%
Prepaids 1650 9.22% 1650 9.14%
subtotal Current Assets 6900 38.55% 6155 34.09%
Property, Plant, & Equipment (PPE)
Property Plant & Equipment 13000 72.63% 14000 77.54%
less: Accumulated depreciation/amortization 2000 11.17% 2100 11.63%
Net PPE 11000 61.45% 11900 65.91%
TOTAL ASSETS 17900 100.00% 18055 100.00%
LIABILITIES & EQUITY
Current Liabilities
Accounts Payable 1100 6.15% 1200 6.65%
Accrued payroll taxes & wages 600 3.35% 600 3.32%
Other misc accrued liabilities 1500 8.38% 1600 8.86%
Total current liabilities 3200 17.88% 3400 18.83%
LT Liabilities
Note payable - mortgage 6000 33.52% 6000 33.23%
Bonds payable 800 4.47% 700 3.88%
TOTAL LIABILITIES 10000 55.87% 10100 55.94%
EQUITY
Retained Earnings 7900 44.13% 7955 44.06%
Total equity 7900 44.13% 7955 44.06%
TOTAL LIABILITIES & EQUITY 17900 100.00% 18055 100.00%
Arcadia Hospital
Statement of Cash Flows-Indirect Method
YE December 31, 2006
(Dollars in Millions)
$ %
Net Income from Operations 55 -12.36%
Add: Deprec / Amort 100 -22.47%
Equals Adjusted Net Income 155 -34.83%
Plus Other Operating Sources/(Uses) of Cash:
Short Term Investments 0 0.00%
Accounts Receivable 300 -67.42%
Inventory 0 0.00%
Prepaids 0 0.00%
Accounts Payable 100 -22.47%
Other Current Liabilities 100 -22.47%
Subtotal Sources/(Uses) of Cash 500 -112.36%
Net Cash Flow from Operations 655 -147.19%
Purchase of Equipment (1,000) 224.72%
Payments on Bonds payable (100) 22.47%
Net Increase/(Decrease) in Cash (445) 100.00%
Cash Account Beginning Balance 100
Cash Account Ending Balance (345)
Net Increase/(Decrease) in Cash (445)
I need a response by 5/16/2010... thank you. Okay to email me.