Business Start Up Costs (DEMO)

	A	B	C	D	E
1			Business Startup Costs
2
3
4	FUNDING		Estimated	Actual	Under/(Over)
5	Investor Funding				{42}
6		Owner 1	15,000	15,000	0
7		Owner 2	15,000	15,000	0
8		Other
9		Total Investment	30,000	30,000	0
10
11	Loans
12		Bank Loan 1	10,000	9,000	1,000
13		Bank Loan 2	0	0	0
14		Non Bank Loan 1
15		Total Loans	10,000	9,000	1,000
16	Other Funding
17		Grant 1
18		Other
19		Total Other Funding	0	0	0
20
21	Total FUNDING		40,000	39,000	1,000
22
23	COSTS		Estimated	Actual	Under/(Over)
24	Fixed Costs
25		Advertising for Opening	1,000	1,000	0
26		Basic Website	1,300	1,500	(200)
27		Brand Development	1,500	1,500	0
28		Building Down Payment	1,200	1,500	(300)
29		Building Improvements/Remodeling	0	0	0
30		Business Cards/Stationery	0	0	0
31		Business Entity	0	0	0
32		Business Licenses/Permits	0	0	0
33		Computer Hardware/Software	0	0	0
34		Decorating	0	0	0
35		Franchise Start Up Fees	0	0	0
36		Internet Setup Deposit	0	0	0
37		Lease Security Deposit	0	0	0
38		Legal/Professional Fees	0	0	0
39		Machines & Equipment	0	0	0
40		Office Furniture/Fixtures	0	0	0
41		Operating Cash (Working Capital)	0	0	0
42		Point of Sale Hardware/Software	0	0	0
43		Prepaid Insurance	0	0	0
44		Public Utilities Deposits	0	0	0
45		Reserve for Contingencies	0	0	0
46		Security System Installation	0	0	0
47		Setup, installation and consulting fees	0	0	0
48		Signage	0	0	0
49		Starting Inventory	0	0	0
50		Telephone	0	0	0
51		Tools & Supplies	0	0	0
52		Travel	0	0	0
53		Truck & Vehicle	0	0	0
54		Other 1 (specify)	0	0	0
55		Other 2 (specify)	0	0	0
56	[42]	Total Fixed Costs	5,000	5,500	(500)
57
58	Average Monthly Costs
59		Advertising (print, broadcast and Internet)	1,000	1,000	0
60		Business Insurance	500	600	(100)
61		Business Vehicle Insurance	500	500	0
62		Employee Salaries and Commissions	1,000	1,000	0
63		Equipment Lease Payments	0	0	0
64		Inventory, raw materials, parts	0	0	0
65		Franchise Fee	900	1,200	(300)
66		Health Insurance	0	0	0
67		Internet Connection	500	600	(100)
68		Loan and Credit Card Interest & Principal	0	0	0
69		Legal/Accounting Fees	0	0	0
70		Merchant Account Fees	0	0	0
71		Miscellaneous Expenses	0	0	0
72		Mortgage Payments	0	0	0
73		Lease Payment	0	0	0
74		Owner Salary	0	0	0
75		Payroll taxes or Self-employment tax	0	0	0
76		Postage/Shipping Costs	0	0	0
77		Security System Monthly Payment	0	0	0
78		Supplies	0	0	0
79		Telephone	63	65	(2)
80		Travel	0	0	0
81		Public Utilities	0	0	0
82		Website Hosting/Maintenance	24	15	9
83		Other 1 (specify)	0	0	0
84		Other 2 (specify)	0	0	0
85		Total Average Monthly Costs	4,487	4,980	(493)
86		x Number of Months	6
87		Total Monthly Costs	26,922	29,880	(2,958)
88
89	Total COSTS		31,922	35,380	(3,458)
90
91	SURPLUS/(DEFICIT)		8,078	3,620	4,458

	A	B	C	D	E	G
1	[Business Name]		Restaurant Startup Costs			Business Templates by Vertex42.com
2					HELP	© 2011 Vertex42 LLC
3
4	FUNDING		Estimated	Actual	Under/(Over)	Note: Hide this column prior to printing
5	Investor Funding				{42}
6		Owner 1	10,000	9,000	1,000	← Amount to be contributed by an owner
7		Owner 2	5,000	5,500	(500)
8		Other				← Add above this line. Other Investor Funding (minority owners, etc)
9		Total Investment	15,000	14,500	500
10
11	Loans
12		Bank Loan 1				← Funds available from Bank Loans
13		Bank Loan 2
14		Non Bank Loan 1				← Add above this line. Funds available from other types of loans
15		Total Loans	0	0	0
16	Other Funding
17		Grant 1				← Funds from other sources such as Government grants.
18		Other				← Add above this line. Funds from any other sources.
19		Total Other Funding	0	0	0
20
21	Total FUNDING		15,000	14,500	500	← Total Available Funds for Startup
22
23	COSTS		Estimated	Actual	Under/(Over)
24	Fixed Costs
25		Advertising for Opening				← Initial advertising push. May include Grand Openings, Open Houses, etc.
26		Basic Website				← Design and creation of a basic website
27		Brand Development				← Creation of a Name, Logo and theme
28		Building Down Payment				← Down payment for the purchase of a building/land
29		Building Improvements/Remodeling				← Sometimes referred to as Leasehold Improvements
30		Business Cards/Stationery				← Business cards, letterhead, flyers, brochures, menus, etc.
31		Business Entity				← Creation of a business entity such as a Partnership, LLC or Corporation.
32		Business Licenses/Permits				← City license, health permits, liquor permits, safety licenses, etc.
33		Commercial Cooking Equipment				← Commercial grade ranges, ovens, fryers and more can be expensive. Make sure to include the little things like can openers, slicers, warmers, etc.
34		Compliance Permits (Health, Safety, etc)				← Make sure you find out what local permits are required and how much they will cost you. The permits will force you to have certain kinds of equipment on site.
35		Computer Hardware/Software				← Computers, printers, back up drives, networking hardware, industry specific software or custom software/database.
36		Cutlery				← This would include cutlery for preparation as well as for guests.
37		Decorating				← Plants, pictures, window treatments, etc.
38		Dishes/Glasses				← Glasses, cups, bowls, plates. Don't forget to include racks and trays for storage and transport. Don't forget the bar area if applicable.
39		Dishwasher				← Health codes are fairly strict on the cleaning requirements. An industrial dishwasher may be necessary.
40		Employee Uniforms				← Whether custom or off the rack, uniform costs can add up.
41		Fixture Installation				← Installation of non permanent fixtures such as booths, free standing counters, etc.
42		Fixtures/Counters				← This can be a significant cost, depending on the size and type of restaurant.
43		Franchise Start Up Fees				← One time franchise startup fees
44		Freezers/Refrigerators				← Absolutely necessary. Make sure you purchase an adequate amount of storage space to handle growth.
45		Internet Setup Deposit				← Basic deposit on internet service and associated hardware
46		Kitchen Supplies & Equipment				← All the little things you will need in the kitchen and/or bar.
47		Lease Security Deposit				← Deposit for lease of a building
48		Legal/Professional Fees				← Legal, accounting, etc.
49		Linens				← Napkins, table cloths, towels, etc.
50		Machines & Equipment				← Scales, copiers, fax machines, dollies, packing machines, etc. Depends on your business.
51		Menu Development				← Includes design and printing of the menu as well as testing new recipes
52		Office Furniture				← Cubicles, desks, chairs, counters, display cases, storage racks
53		Operating Cash (Working Capital)				← Cash reserve for normal business operations
54		Point of Sale Hardware/Software				← cash drawers, point of sale software, receipt printers, bar code scanners, credit card machines
55		Potential Market Surveys				← Could include market research, taste testing surveys - anything to help you get things right.
56		Prepaid Insurance				← Certain types of insurance must be prepaid
57		Public Utilities Deposits				← Deposit for public utilities such as water, gas and electricity.
58		Reserve for Contingencies				← Desired amount of cash to be held in reserve for unforeseen costs and issues
59		Salaries for Employee Trainers/Trainees				← It will take time to hire and train employees and you will need help doing it.
60		Security System Installation				← Purchase and installation of a security system (if needed)
61		Setup, installation and consulting fees				← Fees for consultants (Business, IT, Marketing) and setup of computers, equipment, etc.
62		Signage				← This would include store front, window, door and street signs.
63		Starting Inventory				← Inventory required to open your doors
64		Tables/Chairs				← These can add up quickly.
65		Telephone				← Includes Cell Phones
66		Tools & Supplies				← Includes office suppliers, cleaning supplies, etc.
67		Travel				← May include travel to visit suppliers or distributors.
68		Travel to secure suppliers/distributors				← Depending on your menu, you may need to travel to suppliers and distributors to secure specialty ingredients or bulk items.
69		Truck & Vehicle				← Include any equipment or vehicles for any significant warehousing needs (forklifts, dollies, pallet jacks)
70		Ventilation Equipment				← This includes range covers and fire suppression equipment - required by law.
71		Other 1 (specify)				← Include lines items specific to your business.
72		Other 2 (specify)				← Add new lines above this line
73	[42]	Total Fixed Costs	0	0	0
74
75	Average Monthly Costs
76		Advertising (print, broadcast and Internet)				← Ongoing advertising and promotion costs
77		Business Insurance				← Business insurance costs including building, inventory and liability.
78		Business Vehicle Insurance				← Insurance for your company vehicles
79		Cleaning Services				← Can include dry cleaning, carpet cleaning or other services.
80		Employee Salaries and Commissions				← Do not forget to include any costs for employee benefits
81		Equipment Lease Payments				← Payments for equipment that is leased
82		Inventory, raw materials, parts				← Ongoing purchase of inventory and raw materials to keep your business running
83		Franchise Fee				← Monthly franchise fees such as percentage of sales and marketing co-op fees.
84		Health Insurance				← May be for the owners or all employees.
85		Internet Connection				← Fee for having an internet connection to your building.
86		Loan and Credit Card Interest & Principal				← Interest and principal payments on any loans or credit cards.
87		Legal/Accounting Fees				← On going fees for taxes, payroll or other legal issues.
88		Merchant Account Fees				← Fees for maintaining a merchant account (ability to accept and process credit and debit cards)
89		Miscellaneous Expenses				← Other miscellaneous costs associated with your business
90		Mortgage Payments				← Mortgage payments for land or buildings you have purchased
91		Lease Payment				← Lease payment if you are leasing your facilities
92		Owner Salary				← Don't forget contributions to retirement plans or HSAs.
93		Payroll taxes or Self-employment tax				← Self Employment and payroll taxes can add up and often have to be paid quarterly.
94		Postage/Shipping Costs				← Includes shipping fees as well as packing supplies (boxes, filler, paper, tape)
95		Security System Monthly Payment				← Monthly fee for maintaining an alarm system.
96		Supplies				← Any and all supplies including inks, toner, cleaning, paper towels, toilet paper, etc.
97		Telephone	63	65	(2)	← Also includes cell phones
98		Travel				← Travel such as site visits, sales calls, customer meetings.
99		Public Utilities				← Water, gas, electricity, telephone
100		Website Hosting/Maintenance	24	24	0	← Monthly fee for having your website hosted and maintained by a 3rd party
101		Other 1 (specify)				← Include lines items specific to your business.
102		Other 2 (specify)				← Add new lines above this line
103		Total Average Monthly Costs	87	89	(2)
104		x Number of Months	6			← Insert the estimated number of months until your company will have enough income to sustain itself.
105		Total Monthly Costs	522	534	(12)
106
107	Total COSTS		522	534	(12)
108
109	SURPLUS/(DEFICIT)		14,478	13,966	512