Historical Financial Data:
Monthly Averages
CY 2017 Jan 2018 Feb 2018 2017 Jan/Feb18 Combined
Number of visits
14,522 1.365
1,335
1,210 1,350 1.230
Net revenue
$548.747
$55,028 $54,748 $45,729 $54,888 $47,037
Salaries and wages
$154,250
$13,540
$13,544 $12,854 $13,542 $12,952
Physicians fees
192,000
Malpractice insurance
31,440
18,000 18,000 16,000 18,000 16,286
3.215 3,215 2.620 3,215 2.705
Travel and education
5,365
538
665
447
602
469
General insurance
8,112
843
843
676
843
700
Subscriptions
189
0
0
16
0
14
Electricity
11,820
1,124
1,029
985
1,077
998
Water
1,260
135
142
105
139
110
Equipment rental
1,260
105
105
105
105
105
Building lease
155,745
12,500
12,500
12,979
12,500
12.910
Other operating expenses
103,779
8,152
7,923
8,648
8.038
8,561
Total operating expenses
$665,220
$58,152 $57,966 $55,435 $58,059 $55,810
Net profit (loss)
($116,473) ($3,124) ($3,218) ($9,706) ($3,171) ($8,773)
Gross margin (%)
-21.2% -5.7% -5.9% -21.2% -5.8% -18.7%
Pro Forma Average Month:
}
Number of visits
0
Net revenue
$0
3 Salaries and wages
$0
› Physicians fees
$0
) Malpractice insurance
$0
| Travel and education
$0
2 General insurance
$0
3 Subscriptions
$0
+ Electricity
$0
To complete this input for question 1, choose the
historical values from above that represent the best
estimates for the average month for the entire coming
year. Only change the numbers in red.
Water
$0
> Equipment rental
$0
* Building lease
3 Other operating expenses
$0
$0
→ Total operating expenses
$0
)
| Net profit (loss)
$0
?
3 Gross margin (%)
#DIV/0!
--- OCR End ---
