Cigar World

Start your own business plan »

Cigar Manufacturing Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
All Product Lines 0% $100,000 $150,000 $200,000 $200,000 $200,000 $200,000 $200,000 $220,000 $220,000 $270,000 $270,000 $270,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $100,000 $150,000 $200,000 $200,000 $200,000 $200,000 $200,000 $220,000 $220,000 $270,000 $270,000 $270,000
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
All Product Lines $4,000 $6,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,800 $8,800 $10,800 $10,800 $10,800
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $4,000 $6,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,800 $8,800 $10,800 $10,800 $10,800
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
President 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Vice president 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Production manager 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Workers 0% $11,000 $11,000 $11,000 $11,000 $11,000 $11,000 $11,000 $11,000 $11,000 $11,000 $11,000 $11,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 10 10 10 10 10 10 10 10 10 10 10 10
Total Payroll $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest 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%
Long-term Interest 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%
Tax Rate 30.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $25,000 $37,500 $50,000 $50,000 $50,000 $50,000 $50,000 $55,000 $55,000 $67,500 $67,500 $67,500
Cash from Receivables $25,000 $27,500 $76,250 $113,750 $150,000 $150,000 $150,000 $150,000 $150,500 $165,000 $166,250 $202,500
Subtotal Cash from Operations $50,000 $65,000 $126,250 $163,750 $200,000 $200,000 $200,000 $205,000 $205,500 $232,500 $233,750 $270,000
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $150,000 $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 $200,000 $65,000 $126,250 $163,750 $200,000 $200,000 $200,000 $205,000 $205,500 $232,500 $233,750 $270,000
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Bill Payments $21,273 $38,664 $52,677 $69,754 $67,744 $71,361 $71,353 $71,561 $77,788 $77,469 $93,050 $91,025
Subtotal Spent on Operations $41,273 $58,664 $72,677 $89,754 $87,744 $91,361 $91,353 $91,561 $97,788 $97,469 $113,050 $111,025
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $0 $1,291 $1,291 $1,291 $1,291 $1,291 $1,291 $1,291 $1,291 $1,291 $1,291 $1,291
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $46,273 $64,955 $78,968 $96,045 $94,035 $97,652 $97,644 $97,852 $104,079 $103,760 $119,341 $117,316
Net Cash Flow $153,727 $45 $47,282 $67,705 $105,965 $102,348 $102,356 $107,148 $101,421 $128,740 $114,409 $152,684
Cash Balance $193,727 $193,772 $241,054 $308,759 $414,724 $517,071 $619,427 $726,575 $827,997 $956,737 $1,071,146 $1,223,829
Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $100,000 $150,000 $200,000 $200,000 $200,000 $200,000 $200,000 $220,000 $220,000 $270,000 $270,000 $270,000
Direct Cost of Sales $4,000 $6,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,800 $8,800 $10,800 $10,800 $10,800
Other $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $500 $500
Total Cost of Sales $4,400 $6,400 $8,400 $8,400 $8,400 $8,400 $8,400 $9,200 $9,200 $11,200 $11,300 $11,300
Gross Margin $95,600 $143,600 $191,600 $191,600 $191,600 $191,600 $191,600 $210,800 $210,800 $258,800 $258,700 $258,700
Gross Margin % 95.60% 95.73% 95.80% 95.80% 95.80% 95.80% 95.80% 95.82% 95.82% 95.85% 95.81% 95.81%
Expenses
Payroll $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Sales and Marketing and Other Expenses $10,667 $10,667 $15,667 $15,667 $20,667 $20,667 $20,667 $20,667 $20,667 $20,667 $20,667 $20,667
Depreciation $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Utilities $167 $167 $167 $167 $167 $167 $167 $167 $167 $167 $167 $167
Insurance $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833
Rent $208 $208 $208 $208 $208 $208 $208 $208 $208 $208 $208 $208
Payroll Taxes 15% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $4,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $35,375 $35,375 $40,375 $40,375 $45,375 $45,375 $45,375 $45,375 $45,375 $45,375 $45,375 $46,875
Profit Before Interest and Taxes $60,225 $108,225 $151,225 $151,225 $146,225 $146,225 $146,225 $165,425 $165,425 $213,425 $213,325 $211,825
EBITDA $60,725 $108,725 $151,725 $151,725 $146,725 $146,725 $146,725 $165,925 $165,925 $213,925 $213,825 $212,325
Interest Expense $2,083 $2,073 $2,062 $2,051 $2,040 $2,030 $2,019 $2,008 $1,997 $1,987 $1,976 $1,965
Taxes Incurred $17,442 $26,538 $37,291 $37,293 $36,046 $36,049 $36,052 $40,854 $40,857 $52,860 $52,837 $52,465
Net Profit $40,699 $79,614 $111,872 $111,880 $108,139 $108,147 $108,155 $122,563 $122,571 $158,579 $158,512 $157,395
Net Profit/Sales 40.70% 53.08% 55.94% 55.94% 54.07% 54.07% 54.08% 55.71% 55.71% 58.73% 58.71% 58.29%
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $40,000 $193,727 $193,772 $241,054 $308,759 $414,724 $517,071 $619,427 $726,575 $827,997 $956,737 $1,071,146 $1,223,829
Accounts Receivable $50,000 $100,000 $185,000 $258,750 $295,000 $295,000 $295,000 $295,000 $310,000 $324,500 $362,000 $398,250 $398,250
Inventory $5,000 $4,400 $6,600 $8,800 $8,800 $8,800 $8,800 $8,800 $9,680 $9,680 $11,880 $11,880 $11,880
Other Current Assets $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000
Total Current Assets $130,000 $333,127 $420,372 $543,604 $647,559 $753,524 $855,871 $958,227 $1,081,255 $1,197,177 $1,365,617 $1,516,276 $1,668,959
Long-term Assets
Long-term Assets $25,000 $30,000 $35,000 $40,000 $45,000 $50,000 $55,000 $60,000 $65,000 $70,000 $75,000 $80,000 $85,000
Accumulated Depreciation $5,000 $5,500 $6,000 $6,500 $7,000 $7,500 $8,000 $8,500 $9,000 $9,500 $10,000 $10,500 $11,000
Total Long-term Assets $20,000 $24,500 $29,000 $33,500 $38,000 $42,500 $47,000 $51,500 $56,000 $60,500 $65,000 $69,500 $74,000
Total Assets $150,000 $357,627 $449,372 $577,104 $685,559 $796,024 $902,871 $1,009,727 $1,137,255 $1,257,677 $1,430,617 $1,585,776 $1,742,959
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $20,000 $36,927 $50,349 $67,500 $65,366 $68,983 $68,975 $68,967 $75,223 $74,365 $90,017 $87,955 $89,035
Current Borrowing $0 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $20,000 $186,927 $200,349 $217,500 $215,366 $218,983 $218,975 $218,967 $225,223 $224,365 $240,017 $237,955 $239,035
Long-term Liabilities $100,000 $100,000 $98,709 $97,418 $96,127 $94,836 $93,545 $92,254 $90,963 $89,672 $88,381 $87,090 $85,799
Total Liabilities $120,000 $286,927 $299,058 $314,918 $311,493 $313,819 $312,520 $311,221 $316,186 $314,037 $328,398 $325,045 $324,834
Paid-in Capital $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Retained Earnings $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Earnings $0 $40,699 $120,313 $232,186 $344,066 $452,205 $560,351 $668,506 $791,069 $913,640 $1,072,219 $1,230,730 $1,388,125
Total Capital $30,000 $70,699 $150,313 $262,186 $374,066 $482,205 $590,351 $698,506 $821,069 $943,640 $1,102,219 $1,260,730 $1,418,125
Total Liabilities and Capital $150,000 $357,627 $449,372 $577,104 $685,559 $796,024 $902,871 $1,009,727 $1,137,255 $1,257,677 $1,430,617 $1,585,776 $1,742,959
Net Worth $30,000 $70,699 $150,313 $262,186 $374,066 $482,205 $590,351 $698,506 $821,069 $943,640 $1,102,219 $1,260,730 $1,418,125