Dessert Bakery Business Plan
Dessert Bakery Business Plan
Dessert Bakery Business Plan
Table of Contents
Page 2
Rutabaga Sweets
Chart: Highlights
Highlights
$300,000
$270,000
$240,000
$210,000
Sales
$180,000
Gross Margin
$150,000
Net Profit
$120,000
$90,000
$60,000
$30,000
$0
Year 1
Year 2
Year 3
Page 1
Rutabaga Sweets
1.1 Objectives
1. Attain sales of $166,000 in the first year.
2. Increase second year sales by 50% and third year by 30%.
3. Expand to two stores by the third year of business.
1.2 Mission
Rutabaga Sweets is a hospitality company dedicated to providing high-quality desserts in a
comfortable atmosphere for clients who seek a fun "gourmet" experience outside restaurants.
We intend to make enough profit to generate a fair return for our investors and to finance
continued growth and development in quality products. We also maintain a friendly, fair, and
creative work environment, which respects diversity, new ideas, and hard work.
1.3 Keys to Success
Dedication to the finest quality ingredients and "make it happen no matter what" customer
service.
Ongoing employee education and recognition programs.
Give back to the community.
Page 2
Rutabaga Sweets
Start-up
Requirements
Start-up Expenses
Legal
Office Supplies
Beginning Inventory
Sommelier consulting
Menus, etc
Insurance
Rent
Design & Construction
Research and Development
Furnishings
Expensed Equipment
Dishes, silverware, glassware, etc
Total Start-up Expenses
$1,000
$2,000
$5,000
$500
$1,000
$500
$5,000
$125,000
$1,000
$10,000
$125,000
$5,000
$281,000
Start-up Assets
Cash Required
Start-up Inventory
Other Current Assets
Long-term Assets
Total Assets
$19,000
$0
$0
$0
$19,000
Total Requirements
$300,000
Page 3
Rutabaga Sweets
$281,000
$19,000
$300,000
Assets
Non-cash Assets from Start-up
Cash Requirements from Start-up
Additional Cash Raised
Cash Balance on Starting Date
Total Assets
$0
$19,000
$0
$19,000
$19,000
$0
$0
$0
$0
$0
Capital
Planned Investment
Investor 1
Other
Additional Investment Requirement
Total Planned Investment
Loss at Start-up (Start-up Expenses)
Total Capital
$300,000
$0
$0
$300,000
($281,000)
$19,000
$19,000
$300,000
Page 4
Rutabaga Sweets
Chart: Start-up
Start-up
$300,000
$270,000
$240,000
$210,000
$180,000
$150,000
$120,000
$90,000
$60,000
$30,000
$0
Expenses
Assets
Investment
Loans
Page 5
Rutabaga Sweets
Celebrators are just that - people celebrating special occasions. Birthday, anniversary,
graduation, valentine's day, etc., families and loved ones will gather at Rutabaga Sweets over
sumptuous desserts and a festive atmosphere.
Soccer Moms actually encompasses all family members. Rutabaga Sweets is a gathering place
where families are welcome and feel comfortable. "Moms" can come in for after school
milk and cookies with their children and relax while we pamper the little ones. Or they can
meet up with friends for our Tea Time - a little civilized time stolen in the midst of a busy day.
Gourmet Wanna-bes watch the Food Network and easily spend $50 for the latest cookbook.
They'll be the adventuresome diners at Rutabaga Sweets, as well as the first to sign up for our
cooking classes.
Comfort Creatures
Celebrators
Gourmet Wanna-bes
Soccer Mom's
Market Analysis
Potential Customers
Growth
Comfort Creatures
Celebrators
Gourmet Wanna-bes
Soccer Mom's
Total
10%
15%
15%
10%
12.59%
Year 1
Year 2
Year 3
Year 4
Year 5
5,000
5,000
5,000
5,000
20,000
5,500
5,750
5,750
5,500
22,500
6,050
6,613
6,613
6,050
25,326
6,655
7,605
7,605
6,655
28,520
7,321
8,746
8,746
7,321
32,134
CAGR
10.00%
15.00%
15.00%
10.00%
12.59%
Page 6
Rutabaga Sweets
Page 7
Rutabaga Sweets
Page 8
Rutabaga Sweets
Sales Forecast
Year 1
Year 2
Year 3
$144,000
$2,650
$5,100
$14,400
$166,150
$216,000
$3,445
$6,240
$15,840
$241,525
$280,800
$5,167
$9,360
$17,424
$312,751
Year 1
$28,800
$398
$765
$2,160
$32,123
Year 2
$43,200
$936
$936
$2,160
$47,232
Year 3
$56,160
$775
$1,404
$2,160
$60,499
Sales
Dessert Sales
POP Sales
Carry Out
Weekly Lessons
Total Sales
Direct Cost of Sales
Dessert Sales
POP Sales
Carry Out
Weekly Lessons
Subtotal Direct Cost of Sales
Sales Monthly
$20,000
$18,000
$16,000
$14,000
Dessert Sales
$12,000
POP Sales
$10,000
Carry Out
$8,000
Weekly Lessons
$6,000
$4,000
$2,000
Month 12
Month 11
Month 10
Month 9
Month 8
Month 7
Month 6
Month 5
Month 4
Month 3
Month 2
Month 1
$0
Page 9
Rutabaga Sweets
Sales by Year
$320,000
$280,000
$240,000
Dessert Sales
$200,000
POP Sales
$160,000
Carry Out
$120,000
Weekly Lessons
$80,000
$40,000
$0
Year 1
Year 2
Year 3
5.3 Milestones
Rutabaga Sweets plans to be profitable within the first year of operation. Our goal is to
reinvest in the company and expand to three stores by the third year. From that point we hope
to establish partnerships with each store's chef; similar to Outback's proprietor program. They
will each invest in their store and be directly rewarded for its profitability.
6.0 Management Summary
Rutabaga Sweets will be slow to hire people in the first few years of operation, but very loyal to
those who are hired. Initially all employees will be part-time as the majority of the work will be
done by the chef-proprietor. As the company grows, new employees will be trained and
supervised by original employees who have been promoted to a leadership position. It is our
belief that employees who are dedicated to the success of Rutabaga Sweets should be
rewarded. They will be leaders in our future store developments.
6.1 Personnel Plan
Our Personnel Plan begins at ground zero with the founder being the only employee. Wendi
James, the chef and proprietor, will initially serve as the only dessert bar chef, as well as
the store manager and the instructor for the weekly lessons. Being a graduate of Le Cordon
Bleu in Paris, France with experience in three five-star restaurants she is well prepared for the
jobs of chef and instructor. In addition, her degree from the University of Illinois, C-U in
Restaurant Management equally prepares her for the managerial aspects of the business.
Rutabaga Sweets intends to promote from within and reward the best employees with
leadership roles. Our opening employment goal is 4 with a goal to increase to 7 by the end of
the first year, 10 the second year and 12 the third year. We realize that this is very aggressive
staffing, but intend to hire culinary professionals who are used to the demands of the
restaurant business. By this hiring philosophy, we will be able to operate with fewer, but more
Page 10
Rutabaga Sweets
productive employees and reward them accordingly. From that point we intend to increase the
responsibilities of each employee as opposed to hiring more people. Thereby rewarding those
who have worked hard to establish Rutabaga Sweets as a superior dessert shop. These people
will then be vital in our expansion as we open new stores.
Table: Personnel
Personnel Plan
Year 1
Year 2
Year 3
Chef/Proprietor
Baker
Host
Dessert Bar Assistants
Dishwasher/Busser
Total People
$28,800
$3,920
$4,347
$7,200
$5,796
7
$31,680
$4,312
$4,347
$7,920
$5,760
10
$34,848
$6,720
$4,347
$8,712
$5,760
12
Total Payroll
$50,063
$54,019
$60,387
General Assumptions
Plan Month
Current Interest Rate
Long-term Interest Rate
Tax Rate
Other
Year 1
Year 2
Year 3
1
10.00%
10.00%
30.00%
0
2
10.00%
10.00%
30.00%
0
3
10.00%
10.00%
30.00%
0
Page 11
Rutabaga Sweets
Break-even Analysis
$8,000
$6,000
$4,000
$2,000
$0
($2,000)
($4,000)
($6,000)
($8,000)
($10,000)
$0
$4,000
$2,000
$8,000
$6,000
$12,000
$16,000
$20,000
$10,000
$14,000
$18,000
$22,000
Break-even Analysis
Monthly Revenue Break-even
$13,251
Assumptions:
Average Percent Variable Cost
Estimated Monthly Fixed Cost
19%
$10,689
Page 12
Rutabaga Sweets
Year 2
Year 3
Sales
Direct Cost of Sales
Other Production Expenses
Total Cost of Sales
$166,150
$32,123
$0
$32,123
$241,525
$47,232
$0
$47,232
$312,751
$60,499
$0
$60,499
Gross Margin
Gross Margin %
$134,028
80.67%
$194,293
80.44%
$252,252
80.66%
$50,063
$2,300
$0
$0
$6,000
$2,400
$60,000
$7,509
$0
$54,019
$2,500
$0
$0
$6,000
$2,400
$60,000
$8,103
$0
$60,387
$2,500
$0
$0
$6,000
$2,400
$60,000
$9,058
$0
$128,272
$133,022
$140,345
$5,755
$5,755
$0
$1,727
$61,271
$61,271
$0
$18,381
$111,907
$111,907
$0
$33,572
Net Profit
Net Profit/Sales
$4,029
2.42%
$42,890
17.76%
$78,335
25.05%
Expenses
Payroll
Sales and Marketing and Other Expenses
Depreciation
Leased Equipment
Utilities
Insurance
Rent
Payroll Taxes
Other
Total Operating Expenses
Page 13
Rutabaga Sweets
Profit Monthly
$3,000
$2,500
$2,000
$1,500
$1,000
$500
$0
($500)
($1,000)
($1,500)
($2,000)
Month 1
Month 3
Month 5
Month 7
Month 9
Month 11
Month 2
Month 4
Month 6
Month 8
Month 10
Month 12
Profit Yearly
$80,000
$70,000
$60,000
$50,000
$40,000
$30,000
$20,000
$10,000
$0
Year 1
Year 2
Year 3
Page 14
Rutabaga Sweets
$240,000
$210,000
$180,000
$150,000
$120,000
$90,000
$60,000
$30,000
$0
Year 1
Year 2
Year 3
Page 15
Rutabaga Sweets
Year 2
Year 3
$166,150
$166,150
$241,525
$241,525
$312,751
$312,751
$0
$0
$0
$0
$0
$0
$0
$166,150
$0
$0
$0
$0
$0
$0
$0
$241,525
$0
$0
$0
$0
$0
$0
$0
$312,751
Year 1
Year 2
Year 3
$50,063
$104,118
$154,181
$54,019
$146,921
$200,940
$60,387
$172,515
$232,902
$0
$0
$0
$0
$0
$0
$0
$154,181
$0
$0
$0
$0
$0
$0
$0
$200,940
$0
$0
$0
$0
$0
$0
$0
$232,902
$11,969
$30,969
$40,585
$71,554
$79,849
$151,403
Cash Received
Cash from Operations
Cash Sales
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
Expenditures
Expenditures from Operations
Cash Spending
Bill Payments
Subtotal Spent on Operations
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out
Principal Repayment of Current Borrowing
Other Liabilities Principal Repayment
Long-term Liabilities Principal Repayment
Purchase Other Current Assets
Purchase Long-term Assets
Dividends
Subtotal Cash Spent
Net Cash Flow
Cash Balance
Page 16
Rutabaga Sweets
Chart: Cash
Cash
$32,000
$28,000
$24,000
$20,000
$16,000
$12,000
Cash Balance
$8,000
$4,000
$0
($4,000)
($8,000)
Month 1
Month 3
Month 5
Month 7
Month 9
Month 11
Month 2
Month 4
Month 6
Month 8
Month 10 Month 12
Page 17
Rutabaga Sweets
Year 2
Year 3
$30,969
$3,834
$0
$34,802
$71,554
$6,467
$0
$78,021
$151,403
$7,216
$0
$158,619
$0
$0
$0
$34,802
$0
$0
$0
$78,021
$0
$0
$0
$158,619
Year 1
Year 2
Year 3
Accounts Payable
Current Borrowing
Other Current Liabilities
Subtotal Current Liabilities
$11,774
$0
$0
$11,774
$12,103
$0
$0
$12,103
$14,365
$0
$0
$14,365
Long-term Liabilities
Total Liabilities
$0
$11,774
$0
$12,103
$0
$14,365
$300,000
($281,000)
$4,029
$23,029
$34,802
$300,000
($276,971)
$42,890
$65,918
$78,021
$300,000
($234,082)
$78,335
$144,253
$158,619
$23,029
$65,918
$144,253
Assets
Current Assets
Cash
Inventory
Other Current Assets
Total Current Assets
Long-term Assets
Long-term Assets
Accumulated Depreciation
Total Long-term Assets
Total Assets
Liabilities and Capital
Current Liabilities
Paid-in Capital
Retained Earnings
Earnings
Total Capital
Total Liabilities and Capital
Net Worth
Page 18
Rutabaga Sweets
Ratio Analysis
Year 1
Year 2
Year 3
Industry Profile
n.a.
45.37%
29.49%
4.56%
Inventory
Other Current Assets
Total Current Assets
Long-term Assets
Total Assets
11.02%
0.00%
100.00%
0.00%
100.00%
8.29%
0.00%
100.00%
0.00%
100.00%
4.55%
0.00%
100.00%
0.00%
100.00%
13.08%
33.35%
54.27%
45.73%
100.00%
Current Liabilities
Long-term Liabilities
Total Liabilities
Net Worth
33.83%
0.00%
33.83%
66.17%
15.51%
0.00%
15.51%
84.49%
9.06%
0.00%
9.06%
90.94%
24.73%
27.23%
51.96%
48.04%
100.00%
80.67%
78.24%
1.38%
3.46%
100.00%
80.44%
62.69%
1.04%
25.37%
100.00%
80.66%
55.61%
0.80%
35.78%
100.00%
24.26%
12.12%
0.98%
1.92%
2.96
2.63
33.83%
24.99%
16.54%
6.45
5.91
15.51%
92.95%
78.53%
11.04
10.54
9.06%
77.58%
70.55%
1.37
0.74
59.26%
4.93%
12.10%
Sales Growth
Percent of Total Assets
Percent of Sales
Sales
Gross Margin
Selling, General & Administrative Expenses
Advertising Expenses
Profit Before Interest and Taxes
Main Ratios
Current
Quick
Total Debt to Total Assets
Pre-tax Return on Net Worth
Pre-tax Return on Assets
Additional Ratios
Year 1
Year 2
Year 3
2.42%
17.49%
17.76%
65.07%
25.05%
54.30%
n.a
n.a
10.74
9.84
27
4.77
9.17
12.17
30
3.10
8.84
12.17
28
1.97
n.a
n.a
n.a
n.a
0.51
1.00
0.18
1.00
0.10
1.00
n.a
n.a
$23,029
0.00
$65,918
0.00
$144,253
0.00
n.a
n.a
0.21
34%
2.63
7.21
0.00
0.32
16%
5.91
3.66
0.00
0.51
9%
10.54
2.17
0.00
n.a
n.a
n.a
n.a
n.a
Activity Ratios
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 19
Appendix
Table: Sales Forecast
Sales Forecast
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
$8,000
$100
$200
$900
$9,200
$12,000
$300
$500
$900
$13,700
$16,000
$500
$500
$900
$17,900
Sales
Dessert Sales
POP Sales
Carry Out
Weekly Lessons
Total Sales
0%
0%
0%
0%
$12,000
$200
$300
$1,800
$14,300
$12,000
$200
$300
$1,800
$14,300
$12,000
$200
$300
$1,800
$14,300
$12,000
$100
$300
$900
$13,300
$12,000
$100
$300
$900
$13,300
$12,000
$100
$500
$900
$13,500
$16,000
$300
$1,000
$1,800
$19,100
$8,000
$50
$200
$900
$9,150
$12,000
$500
$700
$900
$14,100
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
Dessert Sales
$2,400
$2,400
$2,400
$2,400
$2,400
$2,400
$3,200
$1,600
$2,400
$1,600
$2,400
$3,200
POP Sales
$30
$30
$30
$15
$15
$15
$45
$8
$75
$15
$45
$75
Carry Out
$45
$45
$45
$45
$45
$75
$150
$30
$105
$30
$75
$75
$270
$270
$270
$135
$135
$135
$270
$135
$135
$135
$135
$135
$2,745
$2,745
$2,745
$2,595
$2,595
$2,625
$3,665
$1,773
$2,715
$1,780
$2,655
$3,485
Weekly Lessons
Subtotal Direct Cost of Sales
Page 1
Appendix
Table: Personnel
Personnel Plan
Chef/Proprietor
Baker
Host
Dessert Bar Assistants
Dishwasher/Busser
Total People
Total Payroll
0%
0%
0%
0%
0%
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
$2,400
$0
$483
$600
$483
4
$2,400
$0
$0
$600
$483
4
$2,400
$0
$0
$600
$483
4
$2,400
$0
$0
$600
$483
4
$2,400
$0
$483
$600
$483
4
$2,400
$560
$483
$600
$483
5
$2,400
$560
$483
$600
$483
5
$2,400
$560
$483
$600
$483
5
$2,400
$560
$483
$600
$483
5
$2,400
$560
$483
$600
$483
7
$2,400
$560
$483
$600
$483
7
$2,400
$560
$483
$600
$483
7
$3,966
$3,483
$3,483
$3,483
$3,966
$4,526
$4,526
$4,526
$4,526
$4,526
$4,526
$4,526
Page 2
Appendix
Table: General Assumptions
General Assumptions
Plan Month
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
10
11
Month 12
12
10.00%
10.00%
10.00%
10.00%
10.00%
10.00%
10.00%
10.00%
10.00%
10.00%
10.00%
10.00%
Long-term Interest
Rate
Tax Rate
10.00%
10.00%
10.00%
10.00%
10.00%
10.00%
10.00%
10.00%
10.00%
10.00%
10.00%
10.00%
30.00%
30.00%
30.00%
30.00%
30.00%
30.00%
30.00%
30.00%
30.00%
30.00%
30.00%
30.00%
Other
Page 3
Appendix
Table: Profit and Loss
Month 11
Month 12
$14,300
Month 1
$14,300
$14,300
$13,300
$13,300
$13,500
$19,100
$9,150
$14,100
$9,200
$13,700
$17,900
$2,745
$2,745
$2,745
$2,595
$2,595
$2,625
$3,665
$1,773
$2,715
$1,780
$2,655
$3,485
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$2,745
$2,745
$2,745
$2,595
$2,595
$2,625
$3,665
$1,773
$2,715
$1,780
$2,655
$3,485
$11,555
$11,555
$11,555
$10,705
$10,705
$10,875
$15,435
$7,378
$11,385
$7,420
$11,045
$14,415
80.80%
80.80%
80.80%
80.49%
80.49%
80.56%
80.81%
80.63%
80.74%
80.65%
80.62%
80.53%
Payroll
$3,966
$3,483
$3,483
$3,483
$3,966
$4,526
$4,526
$4,526
$4,526
$4,526
$4,526
$4,526
$1,000
$0
$0
$0
$0
$300
$500
$0
$0
$0
$0
$500
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$500
$500
$500
$500
$500
$500
$500
$500
$500
$500
$500
$500
Sales
Direct Cost of Sales
Other Production
Expenses
Total Cost of Sales
Gross Margin
Gross Margin %
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Expenses
Leased Equipment
Utilities
Insurance
$200
$200
$200
$200
$200
$200
$200
$200
$200
$200
$200
$200
$5,000
$5,000
$5,000
$5,000
$5,000
$5,000
$5,000
$5,000
$5,000
$5,000
$5,000
$5,000
$595
$0
$522
$0
$522
$0
$522
$0
$595
$0
$679
$0
$679
$0
$679
$0
$679
$0
$679
$0
$679
$0
$679
$0
$11,261
$9,705
$9,705
$9,705
$10,261
$11,205
$11,405
$10,905
$10,905
$10,905
$10,905
$11,405
$294
$1,850
$1,850
$1,000
$444
($330)
$4,030
($3,527)
$480
($3,485)
$140
$3,010
$294
$1,850
$1,850
$1,000
$444
($330)
$4,030
($3,527)
$480
($3,485)
$140
$3,010
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$88
$555
$555
$300
$133
($99)
$1,209
($1,058)
$144
($1,045)
$42
$903
$206
$1,295
$1,295
$700
$311
($231)
$2,821
($2,469)
$336
($2,439)
$98
$2,107
1.44%
9.05%
9.05%
5.26%
2.34%
-1.71%
14.77%
-26.99%
2.38%
-26.52%
0.72%
11.77%
Rent
Payroll Taxes
Other
Interest Expense
Taxes Incurred
Net Profit
Net Profit/Sales
15%
Page 4
Appendix
Table: Cash Flow
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
Cash Received
Cash from Operations
Cash Sales
$14,300
$14,300
$14,300
$13,300
$13,300
$13,500
$19,100
$9,150
$14,100
$9,200
$13,700
$17,900
$14,300
$14,300
$14,300
$13,300
$13,300
$13,500
$19,100
$9,150
$14,100
$9,200
$13,700
$17,900
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$14,300
$14,300
$14,300
$13,300
$13,300
$13,500
$19,100
$9,150
$14,100
$9,200
$13,700
$17,900
0.00%
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
$3,966
$3,483
$3,483
$3,483
$3,966
$4,526
$438
$13,027
$9,522
$9,503
$8,955
$9,030
$4,526
$4,526
$4,526
$4,526
$4,526
$4,526
$9,360
$12,644
$5,476
$9,844
$6,449
$4,404
$16,510
$13,005
$12,986
$12,921
$9,870
$13,556
$13,886
$17,170
$10,002
$14,370
$10,975
$14,396
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Dividends
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$4,404
$16,510
$13,005
$12,986
$12,921
$13,556
$13,886
$17,170
$10,002
$14,370
$10,975
$14,396
$9,896
($2,210)
$1,295
$314
$379
($8,020)
$4,098
($5,170)
$2,725
$3,504
($56)
$5,214
Page 5
Appendix
Cash Balance
$28,896
$26,686
$27,981
$28,294
$28,674
$28,617
$33,831
$25,811
$29,910
$24,739
$27,465
$30,969
Month 10
Month 11
Month 12
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Starting
Balances
Current Assets
Cash
Inventory
Other Current Assets
Total Current Assets
$19,000
$0
$0
$19,000
$28,896
$3,020
$0
$31,915
$26,686
$3,020
$0
$29,705
$27,981
$3,020
$0
$31,000
$28,294
$2,855
$0
$31,149
$28,674
$2,855
$0
$31,528
$28,617
$2,888
$0
$31,505
$33,831
$4,032
$0
$37,863
$25,811
$2,259
$0
$28,070
$29,910
$2,987
$0
$32,896
$24,739
$2,207
$0
$26,946
$27,465
$2,921
$0
$30,385
$30,969
$3,834
$0
$34,802
$0
$0
$0
$19,000
$0
$0
$0
$31,915
$0
$0
$0
$29,705
$0
$0
$0
$31,000
$0
$0
$0
$31,149
$0
$0
$0
$31,528
$0
$0
$0
$31,505
$0
$0
$0
$37,863
$0
$0
$0
$28,070
$0
$0
$0
$32,896
$0
$0
$0
$26,946
$0
$0
$0
$30,385
$0
$0
$0
$34,802
Long-term Assets
Long-term Assets
Accumulated Depreciation
Total Long-term Assets
Total Assets
Liabilities and Capital
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
Current Liabilities
Accounts Payable
Current Borrowing
Other Current Liabilities
Subtotal Current Liabilities
$0
$0
$0
$0
$12,709
$0
$0
$12,709
$9,205
$0
$0
$9,205
$9,205
$0
$0
$9,205
$8,654
$0
$0
$8,654
$8,722
$0
$0
$8,722
$8,930
$0
$0
$8,930
$12,467
$0
$0
$12,467
$5,143
$0
$0
$5,143
$9,633
$0
$0
$9,633
$6,122
$0
$0
$6,122
$9,464
$0
$0
$9,464
$11,774
$0
$0
$11,774
Long-term Liabilities
Total Liabilities
$0
$0
$0
$12,709
$0
$9,205
$0
$9,205
$0
$8,654
$0
$8,722
$0
$8,930
$0
$12,467
$0
$5,143
$0
$9,633
$0
$6,122
$0
$9,464
$0
$11,774
Paid-in Capital
Retained Earnings
$300,000
($281,000)
Earnings
Total Capital
Total Liabilities and Capital
$0
$19,000
$19,000
$300,000
($281,00
0)
$206
$19,206
$31,915
Net Worth
$19,000
$19,206
$300,000
($281,00
0)
$1,501
$20,501
$29,705
$300,000
($281,00
0)
$2,795
$21,795
$31,000
$300,000
($281,00
0)
$3,495
$22,495
$31,149
$300,000
($281,00
0)
$3,806
$22,806
$31,528
$300,000
($281,00
0)
$3,575
$22,575
$31,505
$300,000
($281,00
0)
$6,396
$25,396
$37,863
$300,000
($281,00
0)
$3,927
$22,927
$28,070
$300,000
($281,00
0)
$4,263
$23,263
$32,896
$300,000
($281,00
0)
$1,823
$20,823
$26,946
$300,000
($281,00
0)
$1,921
$20,921
$30,385
$300,000
($281,00
0)
$4,029
$23,029
$34,802
$20,501
$21,795
$22,495
$22,806
$22,575
$25,396
$22,927
$23,263
$20,823
$20,921
$23,029
Page 6