| Expense Category | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | TOTAL |
| PERSONNEL |
| Doctor 1 | $ | $ | $ | $ | $ | $ |
| Doctor 2 | $ | $ | $ | $ | $ | $ |
| Doctor 3 | $ | $ | $ | $ | $ | $ |
| Doctor 4 | $ | $ | $ | $ | $ | $ |
| Doctor 5 | $ | $ | $ | $ | $ | $ |
| Doctor 6 | $ | $ | $ | $ | $ | $ |
| Physician Assistant 1 | $ | $ | $ | $ | $ | $ |
| Physician Assistant 2 | $ | $ | $ | $ | $ | $ |
| Physician Assistant 3 | $ | $ | $ | $ | $ | $ |
| Physician Assistant 4 | $ | $ | $ | $ | $ | $ |
| Registered Nurse 1 | $ | $ | $ | $ | $ | $ |
| Registered Nurse 2 | $ | $ | $ | $ | $ | $ |
| Medical Assistant 1 | $ | $ | $ | $ | $ | $ |
| Medical Assistant 2 | $ | $ | $ | $ | $ | $ |
| Medical Assistant 3 | $ | $ | $ | $ | $ | $ |
| Medical Assistant 4 | $ | $ | $ | $ | $ | $ |
| Medical Assistant 5 | $ | $ | $ | $ | $ | $ |
| Front Desk Receptionist 1 | $ | $ | $ | $ | $ | $ |
| Front Desk Receptionist 2 | $ | $ | $ | $ | $ | $ |
| TOTAL | $ | $ | $ | $ | $ | $ |
| MEDICAL SUPPLIES | $ | $ | $ | $ | $ | $ |
| OFFICE SUPPLIES | $ | $ | $ | $ | $ | $ |
| CONTINUING EDUCATION | $ | $ | $ | $ | $ | $ |
| OVERHEAD EXPENSES | $ | $ | $ | $ | $ | $ |
| TOTAL | $ | $ | $ | $ | $ | $ |
| INCOME |
| PATIENT VOLUME | $ | $ | $ | $ | $ |
| Patient volume in year one is based on 75,000 patient visits at $200 average payment per patient. |
| INCOME (Add) | $ | $ | $ | $ | $ | $ |
| PERSONNEL EXPENSES (Subtract) | $ | $ | $ | $ | $ | $ |
| MEDICAL SUPPLIES (Subtract) | $ | $ | $ | $ | $ | $ |
| OFFICE SUPPLIES (Subtract) | $ | $ | $ | $ | $ | $ |
| CONTINUING EDUCATION (Subtract) | $ | $ | $ | $ | $ | $ |
| OVERHEAD (Subtract) | $ | $ | $ | $ | $ | $ |
| TOTAL INCOME | $ | $ | $ | $ | $ | $ |
Snapple_girl1
Week1Discussion_StudentExcelSpreadsheet.xlsx
