15 slides of ppt and 15 page research paper

hogaj8893

"Implementing Anesthesia Services with IT Systems into a New Hospistal"

I need a balance sheet or Pro Forma embedded into the PPT and discussed in the 15 page write up.

I have attached an example Anesthesia Pro Forma.

Here is an example of the excel balance sheet.

1. Budgeted forecast Income Statement over 5 years
Calculated assumptions	0	1	2	3	4	5	Totals
Volume growth	0	250	500	1,000	2,000	4,000	7,750
Payment growth	0	$185.00	$192.40	$200.10	$208.10	$216.42
Salary per hour growth	0	$30.00	$30.90	$31.83	$32.78	$33.77
Variable cost per test growth	0	$40.00	$41.60	$43.26	$44.99	$46.79
Budgeted Revenue & Expense
Revenue	0	$46,250	$96,200	$200,096	$416,200	$865,695	$1,624,441
Expenses
Salary variable	0	5,625	11,588	23,870	49,173	101,296	$191,551
Salary fixed	0	36,000	37,080	38,192	39,338	40,518	$191,129
Variable costs	0	10,000	20,800	43,264	89,989	187,177	$351,230
Fixed Cost/Overhead	0	100,000	100,000	100,000	100,000	100,000	$500,000
Depreciation	0	44,000	44,000	44,000	44,000	44,000	$220,000
Total Expenses		195,625	213,468	249,327	322,500	472,991	$1,453,911

Profit or Loss		-$149,375	-$117,268	-$49,231	$93,700	$392,704	$170,530
Operating Margin		-323.0%	-121.9%	-24.6%	22.5%	45.4%	10.5%	Operating income (profit) / operating revenue
Accounting Rate of Return							15.5%	Average annual income (profit) / investment

Answer(0)

Bids(0)

other Questions(10)