Start Up Expenses Worksheet
Start Up Expenses Worksheet
Start Up Expenses Worksheet
AMOUNT
NOTES
Working Capital
Sample Practice
OPERATING BUDGET FOR 2012
JAN
INCOME
Professional Fees
Other Revenue
Patient Refunds
Refund Insurance Companies
EXPENSES
Salaries-Physician Owners
Payroll Taxes-FICA Physician
Payroll Taxes-FUTA Physcian
Payroll Taxes-SUTA Physician
Insurance-Physician
Dues, Memberships, License Fees
Meetings & Travel-Physician
Meals & Entertainment-Physician
Salaries-Primary Care Providers
Salaries-Medical Support
Salaries-Administrative
Payroll Taxes-FICA Staff
Payroll Taxes-FUTA Staff
Payroll Taxes-SUTA Staff
Insurance Staff
Pension & Retirement Benefits
Meetings & Travel-Staff
Supplies-Drugs & Medications
Supplies-Medical
Supplies-Administrative
Supplies-Medical Forms
Supplies-Housekeeping/Maintenance
Supplies-Computer
Laboratory Services
Rent-Buildings
Utilities
Rent/Lease-Furniture & Equipment
Depreciation-Medical Equipment
Depreciation-Laser Equipment
Depreciation-Office Equipment
Depreciation-Computer Equipment
Franchise Tax
Property Taxes
Maint/Repair-Furniture & Equipment
Accounting Services
Legal Services
Recruitment
Employee Development & Training
Employee Relations
Uniforms & Laundry
General Liability Insurance-G&A
Professional Liability Insurance
$3,958,456.20
24,000.00
(23,252.00)
(8,088.00)
20,040.00
8,940.00
48,768.00
149,508.54
18,960.00
7,908.00
948.00
5,172.00
10,020.00
245,220.00
1,656.00
137,309.52
21,204.00
12,912.00
5,400.00
2,580.00
10,380.00
2,436.00
FEB
MAR
329,871.35
2,000.00
(1,937.67)
(674.00)
329,259.68
329,871.35
2,000.00
(1,937.67)
(674.00)
329,259.68
329,871.35
2,000.00
(1,937.67)
(674.00)
329,259.68
218,692.31
13,140.64
112.00
235.20
2,860.24
900.00
1,670.00
745.00
5,007.69
33,228.15
21,106.22
4,539.67
474.74
598.17
4,024.41
8,242.70
500.00
4,064.00
12,459.04
1,580.00
659.00
79.00
431.00
835.00
20,435.00
138.00
11,442.46
3,170.63
2,627.47
2,974.75
3,563.72
57,692.31
836.54
57,692.31
836.54
1,350.52
584.00
1,670.00
745.00
5,007.69
33,228.15
21,106.22
4,539.67
435.82
598.17
4,134.51
1,767.70
3,000.00
4,064.00
12,459.04
1,580.00
659.00
79.00
431.00
835.00
20,435.00
138.00
11,442.46
###
###
###
###
1,863.07
485.00
1,670.00
745.00
5,007.69
33,352.55
21,248.22
4,560.05
257.47
600.85
4,134.51
1,778.36
500.00
4,064.00
12,459.04
1,580.00
659.00
79.00
431.00
835.00
20,435.00
138.00
11,442.46
3,170.63
2,627.47
2,974.75
3,563.72
1,767.00
800.00
1,076.00
450.00
215.00
865.00
203.00
-
1,767.00
6,000.00
1,076.00
450.00
215.00
865.00
203.00
-
1,767.00
9,200.00
1,076.00
450.00
215.00
865.00
203.00
-
Telephone/Internet Access
Postage & Freight
Printing
Books & Subscriptions
Marketing
Amortization
Bank Fees
Interest Expense
NET INCOME
59,616.00
13,380.00
28,500.00
9,300.00
31,560.00
13,620.00
73,656.00
4,968.00
1,115.00
2,375.00
775.00
4,778.00
2,630.00
1,135.00
6,138.00
409,826.20
4,968.00
1,115.00
2,375.00
775.00
2,420.00
2,630.00
1,135.00
6,138.00
233,287.36
4,968.00
1,115.00
2,375.00
775.00
4,778.00
2,630.00
1,135.00
6,138.00
236,880.68
$ (80,566.52) $ 95,972.32
$ 92,379.00
Dividends
Net Cash after Dividends
$36,000.00
$ (80,566.52) $ 95,972.32
$ 56,379.00
APR
MAY
JUNE
JULY
AUG
SEPT
OCT
329,871.35
2,000.00
(1,937.67)
(674.00)
329,259.68
329,871.35
2,000.00
(1,937.67)
(674.00)
329,259.68
329,871.35
2,000.00
(1,937.67)
(674.00)
329,259.68
329,871.35
2,000.00
(1,937.67)
(674.00)
329,259.68
329,871.35
2,000.00
(1,937.67)
(674.00)
329,259.68
329,871.35
2,000.00
(1,937.67)
(674.00)
329,259.68
329,871.35
2,000.00
(1,937.67)
(674.00)
329,259.68
57,692.31
836.54
57,692.31
836.54
86,538.46
1,254.81
57,692.31
836.54
57,692.31
836.54
57,692.31
836.54
57,692.31
836.54
2,234.54
600.00
1,670.00
745.00
5,007.69
33,352.55
21,332.25
4,566.48
123.23
456.32
4,134.51
1,780.65
500.00
4,064.00
12,459.04
1,580.00
659.00
79.00
431.00
835.00
20,435.00
138.00
11,442.46
3,170.63
2,627.47
2,974.75
3,563.72
750.00
1,350.52
408.00
1,670.00
745.00
5,007.69
33,609.53
21,341.13
4,586.81
49.83
421.15
4,134.51
1,786.73
500.00
4,064.00
12,459.04
1,580.00
659.00
79.00
431.00
835.00
20,435.00
138.00
11,442.46
3,170.63
2,627.47
2,974.75
3,563.72
3,599.19
953.50
1,670.00
745.00
7,511.54
50,580.79
32,011.70
6,892.96
33.70
296.73
3,385.88
2,680.09
500.00
4,064.00
12,459.04
1,580.00
659.00
79.00
431.00
835.00
20,435.00
138.00
11,442.46
3,170.63
2,627.47
2,974.75
3,563.72
2,234.54
535.00
1,670.00
745.00
5,007.69
33,720.53
21,341.13
4,595.31
22.47
76.99
4,134.51
2,048.39
500.00
4,064.00
12,459.04
1,580.00
659.00
79.00
431.00
835.00
20,435.00
138.00
11,442.46
3,170.63
2,627.47
2,974.75
3,563.72
1,350.52
580.00
1,670.00
745.00
5,007.69
33,720.53
21,420.63
4,601.39
8.08
43.35
4,134.51
2,051.57
500.00
4,064.00
12,459.04
1,580.00
659.00
79.00
431.00
835.00
20,435.00
138.00
11,442.46
3,170.63
2,627.47
2,974.75
3,563.72
1,863.07
225.00
1,670.00
745.00
5,007.69
33,834.53
21,562.12
4,620.93
8.08
28.66
4,134.51
2,055.83
500.00
4,064.00
12,459.04
1,580.00
659.00
79.00
431.00
835.00
20,435.00
138.00
11,442.46
3,170.63
2,627.47
2,974.75
3,563.72
2,234.54
1,695.00
1,670.00
745.00
5,258.08
34,066.30
21,886.17
4,682.61
8.08
28.66
4,134.51
2,088.08
500.00
4,064.00
12,459.04
1,580.00
659.00
79.00
431.00
835.00
20,435.00
138.00
11,442.46
3,170.63
2,627.47
2,974.75
3,563.72
1,767.00
4,700.00
1,076.00
450.00
215.00
865.00
203.00
-
1,767.00
700.00
1,076.00
450.00
215.00
865.00
203.00
-
3,100.00
1,767.00
1,325.00
1,076.00
450.00
215.00
865.00
203.00
-
1,767.00
700.00
1,076.00
450.00
215.00
865.00
203.00
-
1,767.00
700.00
1,076.00
450.00
215.00
865.00
203.00
-
1,767.00
700.00
1,076.00
450.00
215.00
865.00
203.00
-
17,417.00
700.00
1,076.00
450.00
215.00
1,365.00
203.00
8,000.00
16,039.00
4,968.00
1,115.00
2,375.00
775.00
16,070.00
2,630.00
1,135.00
6,138.00
244,723.13
4,968.00
1,115.00
2,375.00
775.00
4,778.00
2,630.00
1,135.00
6,138.00
227,788.83
$ 84,536.55 $ 101,470.86
4,968.00
1,115.00
2,375.00
775.00
2,420.00
2,630.00
1,135.00
6,138.00
293,670.42
4,968.00
1,115.00
2,375.00
775.00
4,778.00
2,630.00
1,135.00
6,138.00
228,809.48
4,968.00
1,115.00
2,375.00
775.00
2,420.00
2,630.00
1,135.00
6,138.00
225,653.19
$ 84,536.55 $ 101,470.86
4,968.00
1,115.00
2,375.00
775.00
4,778.00
2,630.00
1,135.00
6,138.00
228,433.34
4,968.00
1,115.00
2,375.00
775.00
2,420.00
2,630.00
1,135.00
6,138.00
269,005.95
$ 100,826.34 $ 60,253.74
$36,000.00
$ 64,826.34 $ 60,253.74
NOV
329,871.35
2,000.00
(1,937.67)
(674.00)
329,259.68
DEC
TOTAL
329,871.35 $3,958,456.20
2,000.00
24,000.00
(1,937.67)
(23,252.00)
(674.00)
(8,088.00)
329,259.68
3,951,116.20
86,538.46
1,254.81
57,692.31
836.54
1,350.52
1,135.00
1,670.00
745.00
7,887.12
51,707.37
32,829.26
7,070.42
12.12
43.00
3,385.88
3,156.43
500.00
4,064.00
12,459.04
1,580.00
659.00
79.00
431.00
835.00
20,435.00
138.00
11,442.46
3,170.63
2,627.47
2,974.75
3,563.72
7,849.19
1,085.00
1,670.00
745.00
10,258.08
59,077.32
35,378.92
8,010.64
9.68
39.16
4,134.51
82,839.04
500.00
4,064.00
12,459.04
1,580.00
659.00
79.00
431.00
835.00
20,435.00
138.00
11,442.46
3,170.63
2,627.47
2,974.75
3,563.72
3,272.00
700.00
1,076.00
450.00
215.00
865.00
203.00
-
8,132.00
1,767.00
1,450.00
1,076.00
450.00
215.00
9,865.00
203.00
-
911,000.00
23,179.12
112.00
235.20
30,140.46
9,185.50
20,040.00
8,940.00
70,976.35
463,478.28
292,563.97
63,266.92
1,443.28
3,231.20
48,006.76
112,275.56
8,500.00
48,768.00
149,508.54
18,960.00
7,908.00
948.00
5,172.00
10,020.00
245,220.00
1,656.00
137,309.52
38,047.56
31,529.64
35,697.00
42,764.64
750.00
11,232.00
38,359.00
27,675.00
12,912.00
5,400.00
2,580.00
19,880.00
2,436.00
8,000.00
16,039.00
%
100.19%
0.61%
-0.59%
-0.20%
100.00%
23.06%
0.59%
0.00%
0.01%
0.76%
0.23%
0.51%
0.23%
1.80%
11.73%
7.40%
1.60%
0.04%
0.08%
1.22%
2.84%
0.22%
1.23%
3.78%
0.48%
0.20%
0.02%
0.13%
0.25%
6.21%
0.04%
3.48%
0.96%
0.80%
0.90%
1.08%
0.02%
0.28%
0.97%
0.70%
0.33%
0.14%
0.07%
0.50%
0.06%
0.20%
0.41%
4,968.00
1,115.00
2,375.00
775.00
4,778.00
2,630.00
1,135.00
6,138.00
294,439.45
$ 34,820.24
4,968.00
1,115.00
2,375.00
775.00
6,420.00
2,630.00
1,135.00
6,138.00
383,298.45
59,616.00
13,380.00
28,500.00
9,300.00
60,838.00
31,560.00
13,620.00
73,656.00
3,275,816.48
1.51%
0.34%
0.72%
0.24%
1.54%
0.80%
0.34%
1.86%
82.91%
$ (54,038.77) $ 675,299.72
17.09%
$36,000.00 $ 144,000.00
$ 34,820.24
$ (90,038.77) $ 531,299.72
[Business Name]
FUNDING
Estimated
Investor Funding
Owner 1
Owner 2
Other
Actual
10,000
5,000
9,600
5,500
Total Investment
15,000
15,100
Total Loans
15,000
15,100
Loans
Bank Loan 1
Bank Loan 2
Non Bank Loan 1
Other Funding
Grant 1
Other
Total FUNDING
COSTS
Fixed Costs
Advertising for Opening
Basic Website
Brand Development
Building Down Payment
Building Improvements/Remodeling
Business Cards/Stationery
Business Entity
Business Licenses/Permits
Computer Hardware/Software
Decorating
Franchise Start Up Fees
Internet Setup Deposit
Lease Security Deposit
Legal/Professional Fees
Machines & Equipment
Office Furniture/Fixtures
Operating Cash (Working Capital)
Point of Sale Hardware/Software
Prepaid Insurance
Public Utilities Deposits
Reserve for Contingencies
Security System Installation
Setup, installation and consulting fees
Signage
Starting Inventory
Telephone
Tools & Supplies
Estimated
Actual
Travel
Truck & Vehicle
Other 1 (specify)
Other 2 (specify)
[42]
Total COSTS
SURPLUS/(DEFICIT)
63
65
24
15
87
6
522
80
480
522
480
14,478
14,620
s Startup Costs
Under/(Over)
{42}
400
(500)
(100)
(100)
Under/(Over)
(2)
9
7
42
42
(142)
Initial advertising push. May include Grand Openings, Open Houses, etc.
Design and creation of a basic website
Creation of a Name, Logo and theme
Down payment for the purchase of a building/land
Sometimes referred to as Leasehold Improvements
Business cards, letterhead, flyers, brochures, menus, etc.
Creation of a business entity such as a Partnership, LLC or Corporation.
City license, health permits, liquor permits, safety licenses, etc.
Computers, printers, back up drives, networking hardware, industry specific software or custom software/database.
Plants, pictures, window treatments, etc.
One time franchise startup fees
Basic deposit on internet service and associated hardware
Deposit for lease of a building
Legal, accounting, etc.
Scales, copiers, fax machines, dollies, packing machines, etc. Depends on your business.
Cubicles, desks, chairs, counters, display cases, storage racks
Cash reserve for normal business operations
cash drawers, point of sale software, receipt printers, bar code scanners, credit card machines
Certain types of insurance must be prepaid
Deposit for public utilities such as water, gas and electricity.
Desired amount of cash to be held in reserve for unforeseen costs and issues
Purchase and installation of a security system (if needed)
Fees for consultants (Business, IT, Marketing) and setup of computers, equipment, etc.
This would include store front, window, door and street signs.
Inventory required to open your doors
Includes Cell Phones
Includes office suppliers, cleaning supplies, etc.
our business.
Marketing Development
Market research
Search engine listings and optimization
Design of marketing materials
Materials printing costs
Product launch expenses
Total Marketing Development
$
Product Development
Product design
Product prototype and testing
Total Product Development
Total
Other Expenses
Interest expenses
Miscellaneous expenses
Total Other Expenses