Nature's Candy

Start your own business plan »

E-commerce Retailer 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
Baby Boomers 0% $0 $3,254 $5,647 $7,845 $10,254 $14,545 $16,455 $18,455 $20,454 $22,547 $24,555 $25,455
Other 0% $0 $1,024 $1,245 $863 $1,128 $1,600 $1,810 $2,030 $2,250 $2,480 $2,701 $2,800
Total Sales $0 $4,278 $6,892 $8,708 $11,382 $16,145 $18,265 $20,485 $22,704 $25,027 $27,256 $28,255
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
Baby Boomers $0 $976 $1,694 $2,354 $3,076 $4,364 $4,937 $5,537 $6,136 $6,764 $7,367 $7,637
Other $0 $307 $374 $259 $338 $480 $543 $609 $675 $744 $810 $840
Subtotal Direct Cost of Sales $0 $1,283 $2,068 $2,612 $3,415 $4,843 $5,480 $6,146 $6,811 $7,508 $8,177 $8,477
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
Quack 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
Stewart 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
Programmer 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Customer service 0% $0 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Distribution 0% $0 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Total People 3 5 5 5 5 5 5 5 5 5 5 5
Total Payroll $8,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,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 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% 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 $0 $4,278 $6,892 $8,708 $11,382 $16,145 $18,265 $20,485 $22,704 $25,027 $27,256 $28,255
Direct Cost of Sales $0 $1,283 $2,068 $2,612 $3,415 $4,843 $5,480 $6,146 $6,811 $7,508 $8,177 $8,477
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $1,283 $2,068 $2,612 $3,415 $4,843 $5,480 $6,146 $6,811 $7,508 $8,177 $8,477
Gross Margin $0 $2,995 $4,824 $6,096 $7,967 $11,301 $12,786 $14,340 $15,893 $17,519 $19,079 $19,779
Gross Margin % 0.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00%
Expenses
Payroll $8,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500
Sales and Marketing and Other Expenses $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Depreciation $53 $53 $53 $53 $53 $53 $53 $53 $53 $53 $53 $53
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Insurance $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125
Rent $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
Payroll Taxes 15% $1,275 $2,025 $2,025 $2,025 $2,025 $2,025 $2,025 $2,025 $2,025 $2,025 $2,025 $2,025
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $11,703 $17,453 $17,453 $17,453 $17,453 $17,453 $17,453 $17,453 $17,453 $17,453 $17,453 $17,453
Profit Before Interest and Taxes ($11,703) ($14,458) ($12,629) ($11,357) ($9,486) ($6,152) ($4,667) ($3,113) ($1,560) $66 $1,626 $2,326
EBITDA ($11,650) ($14,405) ($12,576) ($11,304) ($9,433) ($6,099) ($4,614) ($3,060) ($1,507) $119 $1,679 $2,379
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($11,703) ($14,458) ($12,629) ($11,357) ($9,486) ($6,152) ($4,667) ($3,113) ($1,560) $66 $1,626 $2,326
Net Profit/Sales 0.00% -337.97% -183.24% -130.43% -83.34% -38.10% -25.55% -15.20% -6.87% 0.26% 5.97% 8.23%
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 $0 $4,278 $6,892 $8,708 $11,382 $16,145 $18,265 $20,485 $22,704 $25,027 $27,256 $28,255
Subtotal Cash from Operations $0 $4,278 $6,892 $8,708 $11,382 $16,145 $18,265 $20,485 $22,704 $25,027 $27,256 $28,255
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 $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 $0 $4,278 $6,892 $8,708 $11,382 $16,145 $18,265 $20,485 $22,704 $25,027 $27,256 $28,255
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 $8,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500
Bill Payments $105 $3,218 $5,210 $5,986 $6,539 $7,362 $8,765 $9,402 $10,068 $10,734 $11,430 $12,087
Subtotal Spent on Operations $8,605 $16,718 $18,710 $19,486 $20,039 $20,862 $22,265 $22,902 $23,568 $24,234 $24,930 $25,587
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $8,605 $16,718 $18,710 $19,486 $20,039 $20,862 $22,265 $22,902 $23,568 $24,234 $24,930 $25,587
Net Cash Flow ($8,605) ($12,440) ($11,818) ($10,778) ($8,657) ($4,717) ($4,000) ($2,417) ($864) $793 $2,326 $2,668
Cash Balance $56,995 $44,555 $32,738 $21,960 $13,303 $8,585 $4,586 $2,169 $1,305 $2,098 $4,424 $7,092
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 $65,600 $56,995 $44,555 $32,738 $21,960 $13,303 $8,585 $4,586 $2,169 $1,305 $2,098 $4,424 $7,092
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $65,600 $56,995 $44,555 $32,738 $21,960 $13,303 $8,585 $4,586 $2,169 $1,305 $2,098 $4,424 $7,092
Long-term Assets
Long-term Assets $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200
Accumulated Depreciation $0 $53 $106 $159 $212 $265 $318 $371 $424 $477 $530 $583 $636
Total Long-term Assets $3,200 $3,147 $3,094 $3,041 $2,988 $2,935 $2,882 $2,829 $2,776 $2,723 $2,670 $2,617 $2,564
Total Assets $68,800 $60,142 $47,649 $35,779 $24,948 $16,238 $11,467 $7,415 $4,945 $4,028 $4,768 $7,041 $9,656
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,045 $5,011 $5,769 $6,295 $7,071 $8,452 $9,067 $9,711 $10,354 $11,028 $11,674 $11,964
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,045 $5,011 $5,769 $6,295 $7,071 $8,452 $9,067 $9,711 $10,354 $11,028 $11,674 $11,964
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $3,045 $5,011 $5,769 $6,295 $7,071 $8,452 $9,067 $9,711 $10,354 $11,028 $11,674 $11,964
Paid-in Capital $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000
Retained Earnings ($11,200) ($11,200) ($11,200) ($11,200) ($11,200) ($11,200) ($11,200) ($11,200) ($11,200) ($11,200) ($11,200) ($11,200) ($11,200)
Earnings $0 ($11,703) ($26,161) ($38,790) ($50,147) ($59,633) ($65,785) ($70,452) ($73,566) ($75,126) ($75,060) ($73,434) ($71,108)
Total Capital $68,800 $57,097 $42,639 $30,010 $18,653 $9,167 $3,015 ($1,652) ($4,766) ($6,326) ($6,260) ($4,634) ($2,308)
Total Liabilities and Capital $68,800 $60,142 $47,649 $35,779 $24,948 $16,238 $11,467 $7,415 $4,945 $4,028 $4,768 $7,041 $9,656
Net Worth $68,800 $57,097 $42,639 $30,010 $18,653 $9,167 $3,015 ($1,652) ($4,766) ($6,326) ($6,260) ($4,634) ($2,308)