Nightclub PDF
Nightclub PDF
Nightclub PDF
This sample business plan has been made available to users of Business Plan Pro, business
planning software published by Palo Alto Software, Inc. Names, locations and numbers may
have been changed, and substantial portions of the original plan text may have been omitted
to preserve confidentiality and proprietary information.
You are welcome to use this plan as a starting point to create your own, but you do not have
permission to reproduce, publish, distribute or even copy this plan as it exists here.
Requests for reprints, academic use, and other dissemination of this sample plan should be
emailed to the marketing department of Palo Alto Software at [email protected]. For
product information visit our Website: www.paloalto.com or call: 1-800-229-7526.
Copyright Palo Alto Software, Inc., 1995-2006 All rights reserved.
Confidentiality Agreement
Table of Contents
1.0
Executive Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
2.0
Company Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
2.1
Company Ownership . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
2.2
Start-up Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
3.0
Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
4.0
5
5
7
7
8
9
5.0
10
11
12
12
13
6.0
Management Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
6.1
Management Team . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
6.2
Management Team Gaps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
6.3
Personnel Plan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
14
14
15
16
7.0
Financial Plan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
7.1
Important Assumptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
7.2
Break-even Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
7.3
Projected Profit and Loss . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
7.4
Projected Cash Flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
7.5
Projected Balance Sheet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
7.6
Business Ratios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
17
17
18
19
20
22
22
Appendix . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
24
Highlights
$3,000,000
$2,500,000
$2,000,000
Sales
$1,500,000
Gross Margin
Net Profit
$1,000,000
$500,000
$0
2001
2002
2003
Page 1
3.
4.
5.
6.
Entertainment and dance based themes -- The company will focus on themes that have
mass appeal.
Distinctive design features -- The Nightclub will be characterized by the elaborate
dance club situated in a spectator setting which comfortably accommodates 350
guests. The area will also offer three private sky boxes which can be combined for use
in a conference or private party setting. This room is intended for special events and
daily use. The adjoining dining room and bar would present an inviting and relaxing
atmosphere, which displays a collection of musical and dance memorabilia. A live dj will
coordinate the events and entertain the patrons with music and games during music
breaks and off-times.
Location, location, location -- One of the major advantages that the Nightclub will have
over its competition will be its location in the new, high-profile Your Town Center.
Gaming -- The Nightclub will provide several interactive style video games and pool
tables to provide for both additional entertainment and revenue.
Quality food -- All would be lost without special attention being paid to the level of food
quality. A simple menu offering foods similar to those found at a premier venue.
Traditional 'bar' appetizers will be on hand for people craving nachos, wings, or
quesadillas while they drink and enjoy themselves.
Exceptional service -- In order to reach and maintain a unique image of quality, the
Nightclub will provide attentive and friendly service through a high ratio of service
personnel to customers, and will also invest in the training and supervision of its
employees. We estimate nearly one service staff member for every 35 guests.
Page 2
Start-up
$600,000
$500,000
$400,000
$300,000
$200,000
$100,000
$0
Expenses
Assets
Investment
Loans
Page 3
$25,000
$2,750
$9,500
$5,500
$125,000
$15,000
$35,000
$75,000
$7,500
$22,500
$45,000
$12,500
$7,500
$25,000
$2,500
$35,000
$35,000
$485,250
$75,000
$7,500
$0
$82,500
Long-term Assets
Total Assets
Total Requirements
$0
$82,500
$567,750
Funding
Investment
Investor 1
Investor 2
Other
Total Investment
$250,000
$250,000
$67,750
$567,750
Current Liabilities
Accounts Payable
Current Borrowing
Other Current Liabilities
Current Liabilities
$0
$0
$0
$0
Long-term Liabilities
Total Liabilities
$0
$0
Loss at Start-up
Total Capital
Total Capital and Liabilities
($485,250)
$82,500
$82,500
Page 4
3.
Tourists and Business Travelers--More and more business and travelers and
tourists are finding themselves in Your City every year as is made evident by the
increased demand and subsequent expansion of the local airport. We plan to reach
these people through direct marketing to local hotel patrons. We anticipate a 20%
annual growth rate in this segment. As our relationships grow with the local hotels, so
too will the word of mouth recommendations from the hotel staff as well as the
patronizing of our restaurant by their families. Our future plan is to publish a simple
website in order to create awareness to any traveler who wants to take an advanced
look at the club before their visit.
The following chart and table outline the target market segments for the Nightclub, and
include annual growth projections.
Table: Market Analysis
Market Analysis
Potential Customers
Childless Young
Professionals
College Students
Tourists/Business Travelers
Total
Growth
2001
2002
2003
2004
2005
CAGR
15%
132,000
151,800
174,570
200,756
230,869
15.00%
5%
20%
13.95%
100,000
100,000
332,000
105,000
120,000
376,800
110,250
144,000
428,820
115,763
172,800
489,319
121,551
207,360
559,780
5.00%
20.00%
13.95%
Page 6
Page 8
Page 9
Page 10
Sales Monthly
$300,000
$250,000
$200,000
Beverage Sales
$150,000
Food Sales
Admission Sales
$100,000
$50,000
$0
Jan Feb Mar Apr May Jun
Page 12
2001
$1,346,100
$93,500
$836,740
$2,276,340
2002
$1,480,710
$102,850
$920,414
$2,503,974
2003
$1,628,781
$113,135
$1,012,455
$2,754,371
2001
$336,525
$30,855
$0
$367,380
2002
$370,178
$33,941
$0
$404,119
2003
$407,196
$37,335
$0
$444,531
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Weekly
Total Guests
Charged
Admission
325
475
675
775
2,250
Average
Admission Fee
$7
$7
$7
$10
$10
$10
$7
$9.57
Total
Admission
Sales
$0
$0
$2,275
$4,750
$6,750
$7,750
$0
$21,525
Total Bar
Guests
350
550
775
1,100
2,775
Average
Drinks per
Person
3.25
Average
Beverage
Sales per
Guest
$12.50
$12.50
$10.00
$12.50
$12.50
$12.50
$12.50
$12.18
Average Price
per Drink
$0
$3.75
$3.75
$3.75
$3.75
$3.75
$3.75
$3.75
Total
Beverage
Sales
$0
$0
$3,500
$6,875
$9,688
$13,750
$0
$33,812
Total
Admission
and Beverage
Sales
$0
$0
$5,775
$11,625
$16,438
$21,500
$0
$55,337
Total Food
Guests
30
50
70
100
250
Average Food
Sales per
Guest
$5.00
$5.00
$7.50
$7.50
$7.50
$7.50
$5.00
$45.00
Total Food
Sales
$0
$0
$225
$375
$525
$750
$0
$1,875
Misc. Sales
(10% of
Gross Sales)
$0
$0
$578
$1,163
$1,644
$2,150
$0
$5,533
Total Revenue
$0
$0
$6,578
$13,163
$18,606
$24,400
$0
$62,746
Page 13
Page 14
Page 15
Position
Quantity
Rate
Avg Hrs
Sub-total
Burden
Total
Monday
Staff Cost/Mon.
$0
$0
$0
$0
Tuesday
Staff Cost/Tues.
$0
$0
$0
Wednesday
Waitress
$5.00
7.5
$75
Security
$7.00
6.5
$195
Bartender
$5.00
7.5
$75
Barback
$4.50
$31
Police Detail
$15.00
$0
$8.00
$0
$64
$441
$88
$604
$120
$824
$839
$143
$982
$0
$0
$0
$2,436
$414
$2,850
Misc.
Staff Cost/Wed.
Thursday
$376
Waitress
$5.00
7.5
$113
Security
$7.50
6.5
$244
Bartender
$5.00
7.5
$113
Barback
1.5
$4.50
$47
Police Detail
$15.00
$0
Misc.
$15.00
$0
Staff Cost/Thur.
Friday
$516
Waitress
$5.00
7.5
$150
Security
$7.50
6.5
$341
Bartender
$5.00
7.5
$150
Barback
$4.50
$63
Police Detail
$15.00
$0
Misc.
$15.00
$0
Staff Cost/Fri.
Saturday
$704
Waitress
$5.00
7.5
$150
Security
$7.50
6.5
$439
Bartender
$5.00
7.5
$188
Barback
$4.50
$63
Police Detail
$15.00
$0
Misc.
$15.00
$0
Staff Cost/Sat.
Sunday
Staff Cost/Sun.
$0
Ttl Wkly/Hrly
Salaried Staff
Position
Salary
Yearly
Weekly
Burden
Manager #1
Oper Prtnr
$55,000
$877
$179
Manager #2
Oper Prtnr
$55,000
$877
$179
Manager #3
General Mgr
$50,000
$798
$163
Manager #4
PR Mgr
$45,000
$718
$147
Manager #5
Bar Mgr
$35,000
$558
$114
Manager #6
Asst.
$25,000
$399
$81
Entertainmnt
DJ
$65,000
$5,480
$866
Ttl Salaried
Ttl Weekly Staff
Total
$6,346
$9,196
Page 16
Salaried Staff
Hourly Staff
Total People
Total Payroll
2002
$298,968
$112,560
0
$411,528
2003
$313,916
$118,188
0
$432,104
2001
1
10.00%
10.00%
25.42%
10.00%
0
2002
2
10.00%
10.00%
25.00%
10.00%
0
2003
3
10.00%
10.00%
25.42%
10.00%
0
Page 17
139,924
$139,924
Assumptions:
Average Per-Unit Revenue
Average Per-Unit Variable Cost
Estimated Monthly Fixed Cost
$1.00
$0.16
$117,342
Break-even Analysis
$100,000
$50,000
$0
($50,000)
($100,000)
($150,000)
$0
$40,000
$80,000
$120,000
$160,000
$200,000
Page 18
2001
$2,276,340
$367,380
$0
-----------$367,380
$1,908,960
83.86%
2002
$2,503,974
$404,119
$0
-----------$404,119
$2,099,855
83.86%
2003
$2,754,371
$444,531
$0
-----------$444,531
$2,309,840
83.86%
$391,936
$411,576
$0
$10,764
$7,500
$0
$391,536
$0
$2,496
$36,000
$22,500
$75,000
$66,629
$0
-----------$1,415,937
$493,023
$0
$121,122
$371,901
16.34%
$411,528
$430,574
$0
$10,982
$7,650
$0
$399,368
$0
$2,550
$36,720
$22,950
$75,000
$69,960
$0
-----------$1,467,282
$632,573
$0
$158,143
$474,430
18.95%
$432,104
$451,284
$0
$11,202
$7,803
$0
$407,355
$0
$2,601
$37,454
$23,409
$76,500
$73,458
$0
-----------$1,523,170
$786,670
$0
$199,945
$586,725
21.30%
Page 19
Cash
$600,000
$500,000
$400,000
$300,000
$200,000
Cash Balance
$100,000
$0
($100,000)
Jan Feb Mar Apr May Jun
Page 20
2002
2003
Cash Received
Cash from Operations:
Cash Sales
Cash from Receivables
Subtotal Cash from Operations
$2,048,706
$212,383
$2,261,089
$2,253,577
$248,872
$2,502,449
$2,478,934
$273,760
$2,752,693
$0
$0
$0
$0
$0
$0
$0
$2,261,089
$0
$0
$0
$0
$0
$0
$0
$2,502,449
$0
$0
$0
$0
$0
$0
$0
$2,752,693
Expenditures
Expenditures from Operations:
Cash Spending
Payment of Accounts Payable
Subtotal Spent on Operations
2001
2002
2003
$144,573
$1,688,286
$1,832,858
$155,044
$1,869,949
$2,024,993
$166,133
$1,996,707
$2,162,840
$0
$0
$0
$0
$0
$0
$0
$1,832,858
$0
$0
$0
$0
$0
$0
$0
$2,024,993
$0
$0
$0
$0
$0
$0
$0
$2,162,840
$428,231
$503,231
$477,456
$980,687
$589,854
$1,570,541
Page 21
2001
$503,231
$15,251
$3,259
$0
$521,740
2002
$980,687
$16,776
$3,585
$0
$1,001,048
2003
$1,570,541
$18,453
$3,943
$0
$1,592,938
$0
$0
$0
$521,740
$0
$0
$0
$1,001,048
$0
$0
$0
$1,592,938
2001
$67,339
$0
$0
$67,339
2002
$72,217
$0
$0
$72,217
2003
$77,382
$0
$0
$77,382
Long-term Liabilities
Total Liabilities
$0
$67,339
$0
$72,217
$0
$77,382
$567,750
($485,250)
$371,901
$454,401
$521,740
$454,401
$567,750
($113,349)
$474,430
$928,831
$1,001,048
$928,831
$567,750
$361,081
$586,725
$1,515,556
$1,592,938
$1,515,556
Paid-in Capital
Retained Earnings
Earnings
Total Capital
Total Liabilities and Capital
Net Worth
Page 22
2002
10.00%
2003
10.00%
Industry Profile
1.90%
2.92%
0.62%
0.00%
100.00%
0.00%
100.00%
1.68%
0.36%
0.00%
100.00%
0.00%
100.00%
1.16%
0.25%
0.00%
100.00%
0.00%
100.00%
4.60%
3.10%
44.60%
52.30%
47.70%
100.00%
12.91%
0.00%
12.91%
87.09%
7.21%
0.00%
7.21%
92.79%
4.86%
0.00%
4.86%
95.14%
28.20%
23.10%
51.30%
48.70%
Percent of Sales
Sales
Gross Margin
Selling, General & Administrative Expenses
Advertising Expenses
Profit Before Interest and Taxes
100.00%
83.86%
67.36%
8.79%
21.66%
100.00%
83.86%
64.67%
8.39%
25.26%
100.00%
83.86%
62.20%
8.01%
28.56%
100.00%
42.30%
23.40%
2.40%
2.80%
Main Ratios
Current
Quick
Total Debt to Total Assets
Pre-tax Return on Net Worth
Pre-tax Return on Assets
7.75
7.70
12.91%
108.50%
94.50%
13.86
13.81
7.21%
68.10%
63.19%
20.59
20.53
4.86%
51.91%
49.38%
1.14
0.74
51.30%
5.20%
10.60%
2001
16.34%
81.84%
2002
18.95%
51.08%
2003
21.30%
38.71%
n.a
n.a
14.93
44
40.00
26.07
20
4.36
14.93
23
118.10
25.96
14
2.50
14.93
23
118.10
25.87
14
1.73
n.a
n.a
n.a
n.a
n.a
n.a
0.15
1.00
0.08
1.00
0.05
1.00
n.a
n.a
$454,401
0.00
$928,831
0.00
$1,515,556
0.00
n.a
n.a
0.23
13%
7.47
5.01
0.00
0.40
7%
13.58
2.70
0.00
0.58
5%
20.30
1.82
0.00
n.a
n.a
n.a
n.a
n.a
Sales Growth
Percent of Total Assets
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
Long-term Assets
Total Assets
Current Liabilities
Long-term Liabilities
Total Liabilities
Net Worth
Additional Ratios
Net Profit Margin
Return on Equity
Activity Ratios
Accounts Receivable Turnover
Collection Days
Inventory Turnover
Accounts Payable Turnover
Payment Days
Total Asset Turnover
Debt Ratios
Debt to Net Worth
Current Liab. to Liab.
Liquidity Ratios
Net Working Capital
Interest Coverage
Additional Ratios
Assets to Sales
Current Debt/Total Assets
Acid Test
Sales/Net Worth
Dividend Payout
Page 23
Appendix
Appendix Table: Sales Forecast
Sales Forecast
Sales
Beverage Sales
Food Sales
Admission Sales
Total Sales
Direct Cost of Sales
Beverage Sales
Food Sales
Admission Sales
Subtotal Direct Cost of Sales
25%
33%
Jan
$44,600
$4,900
$34,100
$83,600
Feb
$77,100
$6,300
$56,800
$140,200
Mar
$96,300
$7,100
$74,600
$178,000
Apr
$131,700
$7,900
$76,900
$216,500
May
$152,800
$9,100
$75,100
$237,000
Jun
$167,100
$9,900
$82,900
$259,900
Jul
$165,700
$10,000
$88,440
$264,140
Aug
$155,200
$9,400
$87,000
$251,600
Sep
$134,900
$8,700
$82,400
$226,000
Oct
$108,500
$7,500
$74,200
$190,200
Nov
$76,800
$6,600
$60,400
$143,800
Dec
$35,400
$6,100
$43,900
$85,400
Jan
$11,150
$1,617
$0
$12,767
Feb
$19,275
$2,079
$0
$21,354
Mar
$24,075
$2,343
$0
$26,418
Apr
$32,925
$2,607
$0
$35,532
May
$38,200
$3,003
$0
$41,203
Jun
$41,775
$3,267
$0
$45,042
Jul
$41,425
$3,300
$0
$44,725
Aug
$38,800
$3,102
$0
$41,902
Sep
$33,725
$2,871
$0
$36,596
Oct
$27,125
$2,475
$0
$29,600
Nov
$19,200
$2,178
$0
$21,378
Dec
$8,850
$2,013
$0
$10,863
Page 24
Appendix
Appendix Table: Personnel
Personnel Plan
Salaried Staff
Hourly Staff
Total People
Total Payroll
Jan
$23,728
$5,100
0
$28,828
Feb
$23,728
$8,700
0
$32,428
Mar
$23,728
$9,400
0
$33,128
Apr
$23,728
$9,500
0
$33,228
May
$23,728
$9,900
0
$33,628
Jun
$23,728
$10,600
0
$34,328
Jul
$23,728
$10,900
0
$34,628
Aug
$23,728
$10,700
0
$34,428
Sep
$23,728
$9,500
0
$33,228
Oct
$23,728
$8,500
0
$32,228
Nov
$23,728
$7,600
0
$31,328
Dec
$23,728
$6,800
0
$30,528
Page 25
Appendix
Appendix Table: General Assumptions
General Assumptions
Plan Month
Current Interest Rate
Long-term Interest Rate
Tax Rate
Sales on Credit %
Other
Jan
1
10.00%
10.00%
30.00%
10.00%
0
Feb
2
10.00%
10.00%
25.00%
10.00%
0
Mar
3
10.00%
10.00%
25.00%
10.00%
0
Apr
4
10.00%
10.00%
25.00%
10.00%
0
May
5
10.00%
10.00%
25.00%
10.00%
0
Jun
6
10.00%
10.00%
25.00%
10.00%
0
Jul
7
10.00%
10.00%
25.00%
10.00%
0
Aug
8
10.00%
10.00%
25.00%
10.00%
0
Sep
9
10.00%
10.00%
25.00%
10.00%
0
Oct
10
10.00%
10.00%
25.00%
10.00%
0
Nov
11
10.00%
10.00%
25.00%
10.00%
0
Dec
12
10.00%
10.00%
25.00%
10.00%
0
Page 26
Appendix
Appendix Table: Profit and Loss
Pro Forma Profit and Loss
Sales
Direct Cost of Sales
Other Production Expenses
Total Cost of Sales
Gross Margin
Gross Margin %
Expenses:
Payroll
Sales and Marketing and Other Expenses
Depreciation
Fees--Credit Card
Fees--Professional
Taxes--Admission
Taxes--Excise
Taxes--Property
Leased Equipment
Utilities
Insurance
Rent
Payroll Taxes
Other
Total Operating Expenses
Profit Before Interest and Taxes
Interest Expense
Taxes Incurred
Net Profit
Net Profit/Sales
17%
Jan
$83,600
$12,767
$0
-----------$12,767
$70,833
84.73%
Feb
$140,200
$21,354
$0
-----------$21,354
$118,846
84.77%
Mar
$178,000
$26,418
$0
-----------$26,418
$151,582
85.16%
Apr
$216,500
$35,532
$0
-----------$35,532
$180,968
83.59%
May
$237,000
$41,203
$0
-----------$41,203
$195,797
82.61%
Jun
$259,900
$45,042
$0
-----------$45,042
$214,858
82.67%
Jul
$264,140
$44,725
$0
-----------$44,725
$219,415
83.07%
Aug
$251,600
$41,902
$0
-----------$41,902
$209,698
83.35%
Sep
$226,000
$36,596
$0
-----------$36,596
$189,404
83.81%
Oct
$190,200
$29,600
$0
-----------$29,600
$160,600
84.44%
Nov
$143,800
$21,378
$0
-----------$21,378
$122,422
85.13%
Dec
$85,400
$10,863
$0
-----------$10,863
$74,537
87.28%
$28,828
$34,298
$0
$897
$625
$0
$32,628
$0
$208
$3,000
$1,875
$6,250
$4,901
$0
-----------$113,510
($42,677)
$0
($12,803)
($29,874)
-35.73%
$32,428
$34,298
$0
$897
$625
$0
$32,628
$0
$208
$3,000
$1,875
$6,250
$5,513
$0
-----------$117,722
$1,124
$0
$281
$843
0.60%
$33,128
$34,298
$0
$897
$625
$0
$32,628
$0
$208
$3,000
$1,875
$6,250
$5,632
$0
-----------$118,541
$33,041
$0
$8,260
$24,781
13.92%
$33,228
$34,298
$0
$897
$625
$0
$32,628
$0
$208
$3,000
$1,875
$6,250
$5,649
$0
-----------$118,658
$62,310
$0
$15,578
$46,733
21.59%
$33,628
$34,298
$0
$897
$625
$0
$32,628
$0
$208
$3,000
$1,875
$6,250
$5,717
$0
-----------$119,126
$76,671
$0
$19,168
$57,503
24.26%
$34,328
$34,298
$0
$897
$625
$0
$32,628
$0
$208
$3,000
$1,875
$6,250
$5,836
$0
-----------$119,945
$94,913
$0
$23,728
$71,185
27.39%
$34,628
$34,298
$0
$897
$625
$0
$32,628
$0
$208
$3,000
$1,875
$6,250
$5,887
$0
-----------$120,296
$99,119
$0
$24,780
$74,339
28.14%
$34,428
$34,298
$0
$897
$625
$0
$32,628
$0
$208
$3,000
$1,875
$6,250
$5,853
$0
-----------$120,062
$89,636
$0
$22,409
$67,227
26.72%
$33,228
$34,298
$0
$897
$625
$0
$32,628
$0
$208
$3,000
$1,875
$6,250
$5,649
$0
-----------$118,658
$70,746
$0
$17,687
$53,060
23.48%
$32,228
$34,298
$0
$897
$625
$0
$32,628
$0
$208
$3,000
$1,875
$6,250
$5,479
$0
-----------$117,488
$43,112
$0
$10,778
$32,334
17.00%
$31,328
$34,298
$0
$897
$625
$0
$32,628
$0
$208
$3,000
$1,875
$6,250
$5,326
$0
-----------$116,435
$5,987
$0
$1,497
$4,490
3.12%
$30,528
$34,298
$0
$897
$625
$0
$32,628
$0
$208
$3,000
$1,875
$6,250
$5,190
$0
-----------$115,499
($40,962)
$0
($10,240)
($30,721)
-35.97%
Page 27
Appendix
Appendix Table: Cash Flow
Pro Forma Cash Flow
Cash Received
Cash from Operations:
Cash Sales
Cash from Receivables
Subtotal Cash from Operations
Additional Cash Received
Sales Tax, VAT, HST/GST Received
New Current Borrowing
New Other Liabilities (interest-free)
New Long-term Liabilities
Sales of Other Current Assets
Sales of Long-term Assets
New Investment Received
Subtotal Cash Received
0.00%
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
$75,240
$0
$75,240
$126,180
$4,459
$130,639
$160,200
$11,379
$171,579
$194,850
$16,036
$210,886
$213,300
$19,853
$233,153
$233,910
$22,743
$256,653
$237,726
$24,921
$262,647
$226,440
$26,216
$252,656
$203,400
$25,745
$229,145
$171,180
$23,795
$194,975
$129,420
$20,691
$150,111
$76,860
$16,545
$93,405
$0
$0
$0
$0
$0
$0
$0
$75,240
$0
$0
$0
$0
$0
$0
$0
$130,639
$0
$0
$0
$0
$0
$0
$0
$171,579
$0
$0
$0
$0
$0
$0
$0
$210,886
$0
$0
$0
$0
$0
$0
$0
$233,153
$0
$0
$0
$0
$0
$0
$0
$256,653
$0
$0
$0
$0
$0
$0
$0
$262,647
$0
$0
$0
$0
$0
$0
$0
$252,656
$0
$0
$0
$0
$0
$0
$0
$229,145
$0
$0
$0
$0
$0
$0
$0
$194,975
$0
$0
$0
$0
$0
$0
$0
$150,111
$0
$0
$0
$0
$0
$0
$0
$93,405
Expenditures
Expenditures from Operations:
Cash Spending
Payment of Accounts Payable
Subtotal Spent on Operations
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
$7,835
$33,801
$41,637
$10,415
$109,070
$119,486
$11,614
$132,693
$144,307
$13,379
$143,770
$157,149
$14,202
$159,835
$174,037
$14,987
$168,047
$183,034
$14,936
$175,213
$190,150
$14,342
$174,358
$188,699
$13,264
$167,463
$180,727
$11,822
$156,487
$168,309
$10,035
$142,360
$152,395
$7,740
$125,188
$132,928
$0
$0
$0
$0
$0
$0
$0
$41,637
$0
$0
$0
$0
$0
$0
$0
$119,486
$0
$0
$0
$0
$0
$0
$0
$144,307
$0
$0
$0
$0
$0
$0
$0
$157,149
$0
$0
$0
$0
$0
$0
$0
$174,037
$0
$0
$0
$0
$0
$0
$0
$183,034
$0
$0
$0
$0
$0
$0
$0
$190,150
$0
$0
$0
$0
$0
$0
$0
$188,699
$0
$0
$0
$0
$0
$0
$0
$180,727
$0
$0
$0
$0
$0
$0
$0
$168,309
$0
$0
$0
$0
$0
$0
$0
$152,395
$0
$0
$0
$0
$0
$0
$0
$132,928
$33,603
$108,603
$11,153
$119,756
$27,272
$147,028
$53,737
$200,765
$59,116
$259,881
$73,619
$333,500
$72,497
$405,997
$63,957
$469,954
$48,419
$518,373
$26,665
$545,038
($2,284)
$542,754
($39,523)
$503,231
Page 28
Appendix
Appendix Table: Balance Sheet
Pro Forma Balance Sheet
Assets
Current Assets
Cash
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
Long-term Assets
Long-term Assets
Accumulated Depreciation
Total Long-term Assets
Total Assets
Starting Balances
$75,000
$0
$7,500
$0
$82,500
Jan
$108,603
$8,360
$3,830
$0
$120,793
Feb
$119,756
$17,921
$6,406
$0
$144,084
Mar
$147,028
$24,343
$7,925
$0
$179,296
Apr
$200,765
$29,957
$10,660
$0
$241,381
May
$259,881
$33,803
$12,361
$0
$306,045
Jun
$333,500
$37,050
$13,513
$0
$384,062
Jul
$405,997
$38,543
$13,418
$0
$457,957
Aug
$469,954
$37,487
$12,571
$0
$520,011
Sep
$518,373
$34,341
$10,979
$0
$563,693
Oct
$545,038
$29,567
$8,880
$0
$583,485
Nov
$542,754
$23,256
$6,413
$0
$572,423
Dec
$503,231
$15,251
$3,259
$0
$521,740
$0
$0
$0
$82,500
$0
$0
$0
$120,793
$0
$0
$0
$144,084
$0
$0
$0
$179,296
$0
$0
$0
$241,381
$0
$0
$0
$306,045
$0
$0
$0
$384,062
$0
$0
$0
$457,957
$0
$0
$0
$520,011
$0
$0
$0
$563,693
$0
$0
$0
$583,485
$0
$0
$0
$572,423
$0
$0
$0
$521,740
$0
$0
$0
$0
Jan
$68,167
$0
$0
$68,167
Feb
$90,614
$0
$0
$90,614
Mar
$101,045
$0
$0
$101,045
Apr
$116,398
$0
$0
$116,398
May
$123,558
$0
$0
$123,558
Jun
$130,391
$0
$0
$130,391
Jul
$129,947
$0
$0
$129,947
Aug
$124,773
$0
$0
$124,773
Sep
$115,395
$0
$0
$115,395
Oct
$102,853
$0
$0
$102,853
Nov
$87,301
$0
$0
$87,301
Dec
$67,339
$0
$0
$67,339
Long-term Liabilities
Total Liabilities
$0
$0
$0
$68,167
$0
$90,614
$0
$101,045
$0
$116,398
$0
$123,558
$0
$130,391
$0
$129,947
$0
$124,773
$0
$115,395
$0
$102,853
$0
$87,301
$0
$67,339
$567,750
($485,250)
$0
$82,500
$82,500
$82,500
$567,750
($485,250)
($29,874)
$52,626
$120,793
$52,626
$567,750
($485,250)
($29,031)
$53,469
$144,084
$53,469
$567,750
($485,250)
($4,250)
$78,250
$179,296
$78,250
$567,750
($485,250)
$42,483
$124,983
$241,381
$124,983
$567,750
($485,250)
$99,986
$182,486
$306,045
$182,486
$567,750
($485,250)
$171,171
$253,671
$384,062
$253,671
$567,750
($485,250)
$245,511
$328,011
$457,957
$328,011
$567,750
($485,250)
$312,738
$395,238
$520,011
$395,238
$567,750
($485,250)
$365,798
$448,298
$563,693
$448,298
$567,750
($485,250)
$398,132
$480,632
$583,485
$480,632
$567,750
($485,250)
$402,622
$485,122
$572,423
$485,122
$567,750
($485,250)
$371,901
$454,401
$521,740
$454,401
Paid-in Capital
Retained Earnings
Earnings
Total Capital
Total Liabilities and Capital
Net Worth
Page 29