For katetutor Only
hooahp
spreadsheet.xlsxSheet1
| Providence Health Center | |||||||||||||
| The Pre-Procedural Testing Center | Year 1 | Year 2 | Year 3 | ||||||||||
| Financial Pro Forma | Gross Revenue | $9,833,925 | $10,325,621 | $11,358,840 | |||||||||
| Year 1 | Year 2 | Year 3 | 11358840 | Net Revenue | $2,163,464 | $2,271,637 | $2,498,945 | ||||||
| Revenue: | |||||||||||||
| Gross Revenue | $9,833,925 | $10,325,621 | $11,358,840 | Per unit calculations | |||||||||
| Net Revenue | $2,163,464 | $2,271,637 | $2,498,945 | 1545 | |||||||||
| Expected Annual Patient Encounters | 6,365 | 6,683 | 7,352 | ||||||||||
| Expenses: | |||||||||||||
| Advertising | $5,000 | $2,500 | $2,500 | ||||||||||
| Amortization & Depreciation | $32,000 | $32,000 | $32,000 | 160000 | |||||||||
| Bad Debts | $147,504 | $150,454 | $151,959 | ||||||||||
| Minor Medical Equipment | $15,000 | $12,000 | $12,000 | ||||||||||
| Medical Supplies | $39,781 | $41,770 | $45,950 | 6.25 | |||||||||
| Office Supplies | $2,000 | $2,000 | $2,000 | 0.314228 | |||||||||
| Salaries and Wages | $221,601 | $246,352 | $264,999 | ||||||||||
| Medical Director | $24,000 | $24,000 | $24,000 | ||||||||||
| Employee Benefits | $46,536 | $51,734 | $55,650 | ||||||||||
| Equipment Repair | $12,000 | $14,000 | $15,000 | ||||||||||
| Travel | $3,000 | $3,000 | $3,000 | ||||||||||
| Lab Supplies | $7,956 | $8,354 | $9,190 | 1.25 | |||||||||
| Radiology Supplies | $693,785 | $728,474 | $801,368 | 109 | |||||||||
| 116.8142 | |||||||||||||
| Total Expenses | $1,250,164 | $1,316,639 | $1,419,616 | ||||||||||
| Net Operating Income | $913,300 | $954,998 | $1,079,329 | ||||||||||
| Charity | $491,696 | $516,281 | $567,942 | ||||||||||
| Net Income (Loss) | $421,603 | $438,717 | $511,387 | ||||||||||
| Net Present Value | $1,051,973 | ||||||||||||
| Salaries and Wages | AHWR | Qty | Hours | Cost | Fixed and Variable Costs | ||||||||
| Nurse Manager | 25 | 1 | 2080 | $52,000.00 | Year 1 | Year 2 | Year 3 | ||||||
| RN | 21.95 | 1 | 2080 | $45,656.00 | Fixed Costs | $93,000 | $89,500 | $90,500 | |||||
| Technologist | 18.75 | 2 | 2080 | $78,000.00 | Variable Costs | $1,157,164 | $1,227,139 | $1,329,116 | |||||
| Front Desk | 10 | 2 | 2080 | $41,600.00 | $1,250,164 | $1,316,639 | $1,419,616 | ||||||
| $217,256.00 | 7.44% | 6.80% | 6.37% | ||||||||||
| Overtime | 2% | $4,345.12 | 92.56% | 93.20% | 93.63% | ||||||||
| Year 1 | $221,601.12 | ||||||||||||
| Incremental Staff | 16.9 | 1 | 1040 | 17576 | |||||||||
| Year 2 | $239,177.12 | ||||||||||||
| Incremental Staff | 17.407 | 1 | 1040 | 18103.28 | |||||||||
| Year 3 | $257,280.40 | ||||||||||||
| Medicare | 48.60% | ||||||||||||
| Medicaid | 10.80% | ||||||||||||
| Self-pay | 11.80% | ||||||||||||
| Private or Commercial | 28.80% |
Revenue Trends
Fixed and Variable Costs
Year
Expense ($)
Expected Annual Patient Encounters
Current PHC Payor Mix
