Medical Fitness Proforma established

Document Sample
Medical Fitness Proforma established Powered By Docstoc
					                                                                                  Medical Fitness Proforma 2011-2012
Month                                                          1             2              3             4             5             6             7             8             9            10
Patient evals per month                                        2             3              3             4             6             7             7             8            10            11
Patient visits per month                                      20            30             30            40            60            70            70            80           100           110
Cash Memberships                                                                            1             1             2             2             2             2             3             3
Revenue for Memberships                                                                 $800          $800         $1,600        $1,600        $1,600        $1,600        $2,400        $2,400
Insurance Income (If paid in full at time of visit)       $1,500        $2,250         $2,250        $3,000        $4,500        $5,250        $5,250        $5,250        $7,500        $8,250
Expected Ultimate Collection per visit                       $75           $75            $75           $75           $75           $75           $75           $75           $75           $75
PT Salary                                                $720.00     $1,080.00      $1,080.00     $1,440.00     $2,160.00     $2,520.00     $2,520.00     $2,880.00     $3,600.00     $3,960.00
Office Manager and Front Office                            $200          $300           $300          $400          $600          $700          $700          $800         $1,000        $1,100
Rent, Utilities, Phone and Internet, Misc                  $300          $300           $450          $600          $900         $1,050        $1,050        $1,200        $1,500        $1,650
Marketing & Misc.                                          $500          $500           $500          $200          $200          $200          $200          $200          $200          $200

Expense Total                                              $1,720        $2,180         $2,330        $2,640        $3,860        $4,470        $4,470        $5,080        $6,300        $6,910
Net                                                     ($220.00)       $70.00       $720.00      $1,160.00     $2,240.00     $2,380.00     $2,380.00     $1,770.00     $3,600.00     $3,740.00
Cummulative Net (Outstanding Debt)                      ($220.00)     ($150.00)      $570.00      $1,730.00     $3,970.00     $6,350.00     $8,730.00    $10,500.00    $14,100.00    $17,840.00
Revenue total                                          $1,500.00     $2,250.00      $3,050.00     $3,800.00     $6,100.00     $6,850.00     $6,850.00     $6,850.00     $9,900.00    $10,650.00

Net profit margin                                           -15%            3%           24%           31%           37%           35%           35%           26%           36%           35%

Month                                                         11            12             13            14            15            16            17            18            19            20
Patient evals per month                                       11            11             12            12            12            13            13            13            14            15
Patient visits per month                                     110           110            120           120           120           130           130           130           140           150
Cash Memberships                                               3             3              3             3             3             3             3             3             4             4
Revenue for Memberships                                   $2,400        $2,400         $2,400        $2,400        $2,400        $2,400        $2,400        $2,400        $3,200        $3,200
Insurance Income (If paid in full at time of visit)       $8,250        $8,250         $9,000        $9,000        $9,000        $9,750        $9,750        $9,750      $10,500       $11,250
Expected Ultimate Collection per visit                       $75           $75            $75           $75           $75           $75           $75           $75           $75           $75
PT Salary                                              $3,960.00     $3,960.00      $4,320.00     $4,320.00     $4,320.00     $4,680.00     $4,680.00     $4,680.00     $5,040.00     $5,400.00
Office Manager and Front Office                           $1,100        $1,100         $1,200        $1,200        $1,200        $1,300        $1,300        $1,300        $1,400        $1,500
Rent, Utilities, Phone and Internet, Misc                 $1,650        $1,650          1800          1800          1800          1950          1950          1950          2100          2250
Marketing & Misc.                                          $200          $200           $200          $200          $200          $200          $200          $200          $200          $200

Expense Total                                              $6,910        $6,910         $7,520        $7,520        $7,520        $8,130        $8,130        $8,130        $8,740        $9,350
Net                                                    $3,740.00     $3,740.00      $3,880.00     $3,880.00     $3,880.00     $4,020.00     $4,020.00     $4,020.00     $4,960.00     $5,100.00
Cummulative Net (Outstanding Debt)                    $21,580.00    $25,320.00     $29,200.00    $33,080.00    $36,960.00    $40,980.00    $45,000.00    $49,020.00    $53,980.00    $59,080.00
Revenue total                                                                         $11,400       $11,400       $11,400       $12,150       $12,150       $12,150       $13,700       $14,450

Net profit margin                                           35%           35%            34%           34%           34%           33%           33%           33%           36%           35%

Month                                                         21            22             23            24
Patient evals per month                                       15            15             16            16
Patient visits per month                                     150           150            160           160
Cash Memberships                                               4             4              4             4
Revenue for Memberships                                   $3,200        $3,200         $3,200        $3,200
Insurance Income (If paid in full at time of visit)     $11,250       $11,250        $12,000       $12,000
Expected Ultimate Collection per visit                       $75           $75            $75           $75
PT Salary                                              $5,400.00     $5,400.00      $5,760.00     $5,760.00
Office Manager and Front Office                           $1,500        $1,500         $1,600        $1,600
Rent, Utilities, Phone and Internet, Misc                  2250          2250           2400          2400
Marketing & Misc.                                          $200          $200           $200          $200

Expense Total                                              $9,350        $9,350         $9,960        $9,960
Net                                                        $5,100        $5,100         $5,240        $5,240
Cummulative Net (Outstanding Debt)                    $64,180.00    $69,280.00     $74,520.00    $79,760.00
Revenue total                                         $14,450.00    $14,450.00     $15,200.00    $15,200.00
Net profit margin                           35%   35%   34%   34%

ASSUMPTIONS:
Patient visits / evaluation:                 10
PT salary / patient                          36
Office Management, front office / patient    10
Rent, Utilities, Phone, Internet, Misc / patient   15
Expected collection per visit                      75

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:26
posted:12/20/2011
language:English
pages:3