Dr. Smith - Future Predictor Spreadsheet |
||||
MM/DD/YYY |
Active patients |
TTM Revenues |
Avg Rev/Active Patient |
|
5/15/2008 |
700 |
$700,000 |
$1,000.00 |
|
6/15/2009 |
710 |
$723,000 |
$1,018.31 |
|
Dr. Jones-Future Predictor Spreadsheet |
|||
Month |
Active Patients |
Revenues |
Avg Rev/Pt |
1 |
833 |
$750,000 |
$900.36 |
2 |
831 |
$761,000 |
$915.76 |
3 |
826 |
$743,000 |
$899.52 |
4 |
819 |
$745,000 |
$909.65 |
5 |
821 |
$739,000 |
$900.12 |
6 |
816 |
$721,000 |
$883.58 |
7 |
811 |
$733,000 |
$903.82 |
8 |
812 |
$738,000 |
$908.87 |
9 |
809 |
$716,000 |
$885.04 |
10 |
811 |
$722,000 |
$890.26 |
11 |
806 |
$731,000 |
$906.95 |
12 |
799 |
$719,500 |
$900.50 |