15 slides of ppt and 15 page research paper

“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
         
  • March 15, 2018
Click Here to Leave a Comment Below 0 comments

Leave a Reply:

University of Nairobi