Jasmine Teahouse

Start your own business plan »

Tea Room Business Plan

Appendix

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
Sales
Hot Teas 0% $1,500 $2,500 $3,000 $3,000 $3,200 $4,000 $6,000 $6,200 $6,500 $6,000 $5,500 $5,000
Iced Teas 0% $2,500 $3,000 $3,800 $3,400 $2,000 $1,400 $800 $600 $500 $900 $1,500 $2,000
Pastries 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Chocolate 0% $3,000 $5,000 $8,000 $7,000 $7,000 $7,000 $7,000 $7,000 $14,000 $7,000 $9,000 $7,000
Tea Paraphernalia 0% $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Gift Baskets 0% $200 $220 $225 $250 $300 $300 $800 $200 $600 $200 $400 $200
Loose Teas 0% $600 $500 $500 $600 $700 $950 $1,100 $1,000 $1,000 $1,100 $1,000 $1,100
Total Sales $9,250 $12,670 $16,975 $15,700 $14,650 $15,100 $17,150 $16,450 $24,050 $16,650 $18,850 $16,750
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Hot Teas $450 $750 $900 $900 $960 $1,200 $1,800 $1,860 $1,950 $1,800 $1,650 $1,500
Iced Teas $800 $960 $1,216 $1,088 $640 $448 $256 $192 $160 $288 $480 $640
Pastries $792 $792 $792 $792 $792 $792 $792 $792 $792 $792 $792 $792
Chocolate $1,350 $2,250 $3,600 $3,150 $3,150 $3,150 $3,150 $3,150 $6,300 $3,150 $4,050 $3,150
Tea Paraphernalia $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125
Gift Baskets $80 $88 $90 $100 $120 $120 $320 $80 $240 $80 $160 $80
Loose Teas $240 $200 $200 $240 $280 $380 $440 $400 $400 $440 $400 $440
Subtotal Direct Cost of Sales $3,837 $5,165 $6,923 $6,395 $6,067 $6,215 $6,883 $6,599 $9,967 $6,675 $7,657 $6,727
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Earl Grey 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Lady Grey 0% $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Part-time tea-tenders 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,400 $1,400 $1,000 $1,400 $1,000 $1,400 $1,000
Total People 3 3 3 3 3 4 4 3 4 3 4 4
Total Payroll $3,500 $3,500 $3,500 $3,500 $3,500 $3,900 $3,900 $3,500 $3,900 $3,500 $3,900 $3,500
General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50%
Long-term Interest Rate 9.25% 9.25% 9.25% 9.25% 9.25% 9.25% 9.25% 9.25% 9.25% 9.25% 9.25% 9.25%
Tax Rate 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 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $9,250 $12,670 $16,975 $15,700 $14,650 $15,100 $17,150 $16,450 $24,050 $16,650 $18,850 $16,750
Direct Cost of Sales $3,837 $5,165 $6,923 $6,395 $6,067 $6,215 $6,883 $6,599 $9,967 $6,675 $7,657 $6,727
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $3,837 $5,165 $6,923 $6,395 $6,067 $6,215 $6,883 $6,599 $9,967 $6,675 $7,657 $6,727
Gross Margin $5,413 $7,505 $10,052 $9,305 $8,583 $8,885 $10,267 $9,851 $14,083 $9,975 $11,193 $10,023
Gross Margin % 58.52% 59.23% 59.22% 59.27% 58.59% 58.84% 59.87% 59.88% 58.56% 59.91% 59.38% 59.84%
Expenses
Payroll $3,500 $3,500 $3,500 $3,500 $3,500 $3,900 $3,900 $3,500 $3,900 $3,500 $3,900 $3,500
Marketing/Promotion $1,500 $300 $300 $300 $300 $300 $600 $300 $600 $300 $300 $300
Depreciation $115 $115 $115 $115 $115 $115 $115 $115 $115 $115 $115 $115
Rent $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Utilities $621 $621 $621 $621 $621 $621 $621 $621 $621 $621 $900 $900
Monthly disposable supplies $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Insurance $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417
Payroll Taxes 20% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $7,753 $6,553 $6,553 $6,553 $6,553 $6,953 $7,253 $6,553 $7,253 $6,553 $7,232 $6,832
Profit Before Interest and Taxes ($2,340) $952 $3,499 $2,752 $2,030 $1,932 $3,014 $3,298 $6,830 $3,422 $3,961 $3,191
EBITDA ($2,225) $1,067 $3,614 $2,867 $2,145 $2,047 $3,129 $3,413 $6,945 $3,537 $4,076 $3,306
Interest Expense $408 $402 $396 $390 $385 $379 $373 $367 $362 $356 $350 $345
Taxes Incurred ($824) $165 $931 $709 $494 $466 $792 $879 $1,941 $920 $1,083 $854
Net Profit ($1,923) $385 $2,172 $1,653 $1,152 $1,087 $1,849 $2,052 $4,528 $2,146 $2,528 $1,993
Net Profit/Sales -20.79% 3.04% 12.80% 10.53% 7.86% 7.20% 10.78% 12.47% 18.83% 12.89% 13.41% 11.90%
Pro Forma Cash Flow
Month 1 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 $9,250 $12,670 $16,975 $15,700 $14,650 $15,100 $17,150 $16,450 $24,050 $16,650 $18,850 $16,750
Subtotal Cash from Operations $9,250 $12,670 $16,975 $15,700 $14,650 $15,100 $17,150 $16,450 $24,050 $16,650 $18,850 $16,750
Additional Cash Received
Sales Tax, VAT, HST/GST Received 6.00% $555 $760 $1,019 $942 $879 $906 $1,029 $987 $1,443 $999 $1,131 $1,005
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $9,805 $13,430 $17,994 $16,642 $15,529 $16,006 $18,179 $17,437 $25,493 $17,649 $19,981 $17,755
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $3,500 $3,500 $3,500 $3,500 $3,500 $3,900 $3,900 $3,500 $3,900 $3,500 $3,900 $3,500
Bill Payments $124 $3,870 $8,353 $13,013 $9,840 $9,544 $10,222 $11,969 $10,762 $18,814 $7,471 $13,279
Subtotal Spent on Operations $3,624 $7,370 $11,853 $16,513 $13,340 $13,444 $14,122 $15,469 $14,662 $22,314 $11,371 $16,779
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $555 $760 $1,019 $942 $879 $906 $1,029 $987 $1,443 $999 $1,131 $1,005
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $745 $745 $745 $745 $745 $745 $745 $745 $745 $745 $745 $745
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $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
Subtotal Cash Spent $4,924 $8,875 $13,616 $18,199 $14,964 $15,094 $15,896 $17,201 $16,850 $24,057 $13,247 $18,528
Net Cash Flow $4,881 $4,555 $4,377 ($1,557) $565 $912 $2,283 $236 $8,643 ($6,408) $6,734 ($773)
Cash Balance $19,881 $24,436 $28,814 $27,256 $27,822 $28,733 $31,016 $31,252 $39,895 $33,486 $40,220 $39,446
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $15,000 $19,881 $24,436 $28,814 $27,256 $27,822 $28,733 $31,016 $31,252 $39,895 $33,486 $40,220 $39,446
Inventory $10,000 $6,163 $5,682 $7,615 $7,035 $6,674 $6,837 $7,571 $7,259 $10,964 $7,343 $8,423 $7,400
Other Current Assets $6,605 $6,605 $6,605 $6,605 $6,605 $6,605 $6,605 $6,605 $6,605 $6,605 $6,605 $6,605 $6,605
Total Current Assets $31,605 $32,649 $36,723 $43,034 $40,896 $41,100 $42,175 $45,192 $45,116 $57,463 $47,434 $55,248 $53,451
Long-term Assets
Long-term Assets $13,808 $13,808 $13,808 $13,808 $13,808 $13,808 $13,808 $13,808 $13,808 $13,808 $13,808 $13,808 $13,808
Accumulated Depreciation $0 $115 $230 $345 $460 $575 $690 $805 $920 $1,035 $1,150 $1,265 $1,380
Total Long-term Assets $13,808 $13,693 $13,578 $13,463 $13,348 $13,233 $13,118 $13,003 $12,888 $12,773 $12,658 $12,543 $12,428
Total Assets $45,413 $46,342 $50,301 $56,497 $54,244 $54,333 $55,293 $58,195 $58,004 $70,236 $60,092 $67,791 $65,879
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 $0 $3,597 $7,915 $12,684 $9,523 $9,205 $9,822 $11,620 $10,122 $18,571 $7,025 $12,941 $9,782
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $3,597 $7,915 $12,684 $9,523 $9,205 $9,822 $11,620 $10,122 $18,571 $7,025 $12,941 $9,782
Long-term Liabilities $53,633 $52,888 $52,143 $51,399 $50,654 $49,909 $49,164 $48,419 $47,674 $46,930 $46,185 $45,440 $44,695
Total Liabilities $53,633 $56,485 $60,059 $64,083 $60,176 $59,114 $58,986 $60,040 $57,796 $65,501 $53,210 $58,381 $54,477
Paid-in Capital $10,330 $10,330 $10,330 $10,330 $10,330 $10,330 $10,330 $10,330 $10,330 $10,330 $10,330 $10,330 $10,330
Retained Earnings ($18,550) ($18,550) ($18,550) ($18,550) ($18,550) ($18,550) ($18,550) ($18,550) ($18,550) ($18,550) ($18,550) ($18,550) ($18,550)
Earnings $0 ($1,923) ($1,538) $634 $2,288 $3,440 $4,527 $6,376 $8,427 $12,955 $15,102 $17,629 $19,622
Total Capital ($8,220) ($10,143) ($9,758) ($7,586) ($5,932) ($4,780) ($3,693) ($1,844) $207 $4,735 $6,882 $9,409 $11,402
Total Liabilities and Capital $45,413 $46,342 $50,301 $56,497 $54,244 $54,333 $55,293 $58,195 $58,004 $70,236 $60,092 $67,791 $65,879
Net Worth ($8,220) ($10,143) ($9,758) ($7,586) ($5,932) ($4,780) ($3,693) ($1,844) $207 $4,735 $6,882 $9,409 $11,402