| Gross Margins | |
|---|---|
| Patient Charge | $ |
| Treatment Cost | $ |
| Net profit per treatment | $ |
| Treatment Plan Charge | $ |
| Net profit per treatment plan | $ |
| Total Revenue per Applicator | $ |
| Total Revenue for ALL applicators | $ |
| Total Operational Expenses | $ |
| Net income (Revenue-Device Cost) | $ |
| Potential Weeks Until Pay Off | |
| Restart to change all inputs or use the plus and minus drop down menu to adjust specific cell variables. | |
| Restart | |
| Operational expenses | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Months | Month 1 | Month 2 | Month 3 | ||||||
| Operating Expenses | Quantity | Cost | Total | Quantity | Cost | Total | Quantity | Cost | Total |
| Technician (hourly) | $ | $ | $ | $ | $ | $ | |||
| Ultrasound Gel (5L/Applicator) | $ | $ | $ | $ | $ | $ | |||
| Paper Towels (16 Count/Applicator) | $ | $ | $ | $ | $ | $ | |||
| Electrical Usage/Month | $ | $ | $ | $ | $ | ||||
| Advertising | $ | $ | $ | $ | $ | $ | |||
| Ad spend | $ | $ | $ | $ | $ | $ | |||
| Rent (Room Usage)/Month | $ | $ | $ | $ | $ | $ | |||
| Total Operating Expenses | $ | $ | $ | ||||||
| Patients Care Plan Revenue | ||||||||
|---|---|---|---|---|---|---|---|---|
| Month | Week | New Patients / Week | Treatment Plans | Treatments / Week | Weekly Revenue | Discount | Monthly Net Revenue | Net Revenue |
| Month 1 | Week 1 | $ | $ | $ | $ | |||
| Week 2 | $ | $ | ||||||
| Week 3 | $ | $ | ||||||
| Week 4 | $ | $ | ||||||
| Month 2 | Week 5 | $ | $ | $ | ||||
| Week 6 | $ | $ | ||||||
| Week 7 | $ | $ | ||||||
| Week 8 | $ | $ | ||||||
| Month 3 | Week 9 | $ | $ | $ | ||||
| Week 10 | $ | $ | ||||||
| Week 11 | $ | $ | ||||||
| Week 12 | $ | $ | ||||||
