Start Up Expenses Worksheet

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 16

WORKSHEET

START UP EXPENSES & MONTHLY OPERATING EXPENSES


ONE TIME START UP EXPENSES

AMOUNT

NOTES

One Time Start-Up Costs:


Rent Deposit
Furniture & Fixtures
Equipment
Buildout/ Renovations
Decorating, Painting and Remodeling
Installation of Fixtures & Equipment
Starting Inventory
Deposits with Public Utilities
Legal and Other Professional Fees
License and Permits
Advertising and Promotion
Consulting
Software
Cash
Other:
Other:
Other:
Other:
Total One Time Start-Up Costs:
Monthly Expenses:
Bank Charges
Debt Service (Principal & Interest)
Insurance
Membership & Dues
Maintenance & Repairs
Marketing & Promotion: Advertising
Marketing & Promotion: Other
Miscellaneous
Payroll: Wages (Owner/ Manager)
Payroll: Wages (Employees)
Payroll Tax
Professional Fees: Accounting
Professional Fees: Legal
Professional Fees: Other
Rent
Subscriptions
Supplies: Office
Supplies: Operating
Telephone
Utilities
Other:
Total Monthly Expenses:
Number of months required to cover Expenses:

Working Capital

TOTAL START-UP FUNDS REQUIRED:


Loan Amount (At 80% of Total Start-Up)

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

$ 35,589.26 $ 100,450.21 $ 103,606.50


$36,000.00

$ 84,536.55 $ 101,470.86

(410.74) $ 100,450.21 $ 103,606.50

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 Startup Costs

[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

Total Other Funding

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 Fixed Costs

Average Monthly Costs


Advertising (print, broadcast and Internet)
Business Insurance
Business Vehicle Insurance
Employee Salaries and Commissions
Equipment Lease Payments
Inventory, raw materials, parts
Franchise Fee
Health Insurance
Internet Connection
Loan and Credit Card Interest & Principal
Legal/Accounting Fees
Merchant Account Fees
Miscellaneous Expenses
Mortgage Payments
Lease Payment
Owner Salary
Payroll taxes or Self-employment tax
Postage/Shipping Costs
Security System Monthly Payment
Supplies
Telephone
Travel
Public Utilities
Website Hosting/Maintenance
Other 1 (specify)
Other 2 (specify)
Total Average Monthly Costs
x Number of Months
Total Monthly Costs

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)

Note: Hide this column prior to printing


Amount to be contributed by an owner
Add above this line. Other Investor Funding (minority owners, etc)

Funds available from Bank Loans


Add above this line. Funds available from other types of loans
Funds from other sources such as Government grants.
Add above this line. Funds from any other sources.

Total Available Funds for Startup

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.

May include travel to visit suppliers or distributors.


Include any equipment or vehicles for any significant warehousing needs (forklifts, dollies, pallet jacks)
Include lines items specific to your business.
Add new lines above this line

Ongoing advertising and promotion costs


Business insurance costs including building, inventory and liability.
Insurance for your company vehicles
Do not forget to include any costs for employee benefits
Payments for equipment that is leased
Ongoing purchase of inventory and raw materials to keep your business running
Monthly franchise fees such as percentage of sales and marketing co-op fees.
May be for the owners or all employees.
Fee for having an internet connection to your building.
Interest and principal payments on any loans or credit cards.
On going fees for taxes, payroll or other legal issues.
Fees for maintaining a merchant account (ability to accept and process credit and debit cards)
Other miscellaneous costs associated with your business
Mortgage payments for land or buildings you have purchased
Lease payment if you are leasing your facilities
Don't forget contributions to retirement plans or HSAs.
Self Employment and payroll taxes can add up and often have to be paid quarterly.
Includes shipping fees as well as packing supplies (boxes, filler, paper, tape)
Monthly fee for maintaining an alarm system.
Any and all supplies including inks, toner, cleaning, paper towels, toilet paper, etc.
Also includes cell phones
Travel such as site visits, sales calls, customer meetings.
Water, gas, electricity, telephone
Monthly fee for having your website hosted and maintained by a 3rd party
Include lines items specific to your business.
Add new lines above this line
Insert the estimated number of months until your company will have enough income to sustain itself.

oftware or custom software/database.

our business.

dit card machines

klifts, dollies, pallet jacks)

t and debit cards)

ncome to sustain itself.

(Your Company Name Here)


Start-Up Budget
Period Covering: (Month) 200_ - (Month) 200_
OPERATING EXPENSES

(Mth) 200_ (Mth) 200_ (Mth) 200_ (Mth) 200_

General and Administration


Salaries and wages
Payroll taxes
Rent and lease expenses
Office supplies
Utilities
Insurance
Vehicle expenses
Accounting services
Legal services (including incorporation)
Total General and Administration
$
Buildings and Equipment
Building acquisition costs
Building renovations
Manufacturing machinery and equipment
Office equipment
Computers
Vehicles
Depreciation
Total Buildings and Equipment
$
Web Site Development
Web site set-up expenses
Web site design
Web site testing
Art and multi-media
Total Web Site Development

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

Total Operating Expenses

You might also like