“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 | ||||||||||