FireStarters

Start your own business plan »

E-commerce Internet 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
Clothing 0% $0 $8,000 $10,000 $21,000 $24,000 $26,000 $17,000 $25,000 $30,000 $30,000 $10,000 $8,000
Shoes 0% $0 $3,000 $3,350 $5,000 $8,000 $11,000 $14,000 $16,000 $24,000 $25,000 $10,000 $12,000
Products 0% $0 $1,500 $1,800 $2,000 $4,000 $6,000 $5,000 $7,000 $13,000 $4,000 $5,000 $6,000
Total Sales $0 $12,500 $15,150 $28,000 $36,000 $43,000 $36,000 $48,000 $67,000 $59,000 $25,000 $26,000
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
Clothing $0 $3,000 $4,000 $5,000 $6,000 $7,000 $5,000 $7,000 $10,000 $10,000 $4,000 $2,000
Shoes $0 $1,000 $1,200 $1,000 $1,500 $2,000 $3,000 $4,000 $5,200 $2,000 $2,000 $2,200
Products $0 $400 $500 $600 $1,000 $1,500 $1,250 $1,800 $2,000 $890 $1,200 $1,500
Subtotal Direct Cost of Sales $0 $4,400 $5,700 $6,600 $8,500 $10,500 $9,250 $12,800 $17,200 $12,890 $7,200 $5,700
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
Manager 0% $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Buyer/Marketing 0% $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Order Processor/Website Manager 0% $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800
Processing Staff (2) 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Total People 5 5 5 5 5 5 5 5 5 5 5 5
Total Payroll $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800
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 $12,500 $15,150 $28,000 $36,000 $43,000 $36,000 $48,000 $67,000 $59,000 $25,000 $26,000
Direct Cost of Sales $0 $4,400 $5,700 $6,600 $8,500 $10,500 $9,250 $12,800 $17,200 $12,890 $7,200 $5,700
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $4,400 $5,700 $6,600 $8,500 $10,500 $9,250 $12,800 $17,200 $12,890 $7,200 $5,700
Gross Margin $0 $8,100 $9,450 $21,400 $27,500 $32,500 $26,750 $35,200 $49,800 $46,110 $17,800 $20,300
Gross Margin % 0.00% 64.80% 62.38% 76.43% 76.39% 75.58% 74.31% 73.33% 74.33% 78.15% 71.20% 78.08%
Expenses
Payroll $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $595 $595 $595 $595 $595 $595 $595 $595 $595 $595 $595 $595
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Insurance $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Rent $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Payroll Taxes 15% $2,220 $2,220 $2,220 $2,220 $2,220 $2,220 $2,220 $2,220 $2,220 $2,220 $2,220 $2,220
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $20,615 $20,615 $20,615 $20,615 $20,615 $20,615 $20,615 $20,615 $20,615 $20,615 $20,615 $20,615
Profit Before Interest and Taxes ($20,615) ($12,515) ($11,165) $785 $6,885 $11,885 $6,135 $14,585 $29,185 $25,495 ($2,815) ($315)
EBITDA ($20,020) ($11,920) ($10,570) $1,380 $7,480 $12,480 $6,730 $15,180 $29,780 $26,090 ($2,220) $280
Interest Expense $1,235 $1,220 $1,205 $1,190 $1,175 $1,160 $1,145 $1,130 $1,115 $1,100 $1,085 $1,070
Taxes Incurred ($6,555) ($4,121) ($3,711) ($122) $1,713 $3,218 $1,497 $4,037 $8,421 $7,319 ($1,170) ($416)
Net Profit ($15,295) ($9,615) ($8,659) ($284) $3,997 $7,508 $3,493 $9,419 $19,649 $17,077 ($2,730) ($970)
Net Profit/Sales 0.00% -76.92% -57.16% -1.01% 11.10% 17.46% 9.70% 19.62% 29.33% 28.94% -10.92% -3.73%
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 $12,500 $15,150 $28,000 $36,000 $43,000 $36,000 $48,000 $67,000 $59,000 $25,000 $26,000
Subtotal Cash from Operations $0 $12,500 $15,150 $28,000 $36,000 $43,000 $36,000 $48,000 $67,000 $59,000 $25,000 $26,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 $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 $12,500 $15,150 $28,000 $36,000 $43,000 $36,000 $48,000 $67,000 $59,000 $25,000 $26,000
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 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800 $14,800
Bill Payments ($100) ($19) $2,333 $2,833 $6,349 $8,158 $9,540 $7,946 $10,994 $28,398 $21,266 $6,259
Subtotal Spent on Operations $14,700 $14,781 $17,133 $17,633 $21,149 $22,958 $24,340 $22,746 $25,794 $43,198 $36,066 $21,059
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 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800
Purchase Other Current Assets $0 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800
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 $16,500 $18,381 $20,733 $21,233 $24,749 $26,558 $27,940 $26,346 $29,394 $46,798 $39,666 $24,659
Net Cash Flow ($16,500) ($5,881) ($5,583) $6,767 $11,251 $16,442 $8,060 $21,654 $37,606 $12,202 ($14,666) $1,341
Cash Balance $48,100 $42,219 $36,637 $43,404 $54,654 $71,097 $79,157 $100,811 $138,416 $150,618 $135,953 $137,293
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 $64,600 $48,100 $42,219 $36,637 $43,404 $54,654 $71,097 $79,157 $100,811 $138,416 $150,618 $135,953 $137,293
Inventory $80,000 $80,000 $75,600 $69,900 $63,300 $54,800 $44,300 $35,050 $22,250 $18,920 $14,179 $7,979 $6,270
Other Current Assets $0 $0 $1,800 $3,600 $5,400 $7,200 $9,000 $10,800 $12,600 $14,400 $16,200 $18,000 $19,800
Total Current Assets $144,600 $128,100 $119,619 $110,137 $112,104 $116,654 $124,397 $125,007 $135,661 $171,736 $180,997 $161,932 $163,363
Long-term Assets
Long-term Assets $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000
Accumulated Depreciation $0 $595 $1,190 $1,785 $2,380 $2,975 $3,570 $4,165 $4,760 $5,355 $5,950 $6,545 $7,140
Total Long-term Assets $50,000 $49,405 $48,810 $48,215 $47,620 $47,025 $46,430 $45,835 $45,240 $44,645 $44,050 $43,455 $42,860
Total Assets $194,600 $177,505 $168,429 $158,352 $159,724 $163,679 $170,827 $170,842 $180,901 $216,381 $225,047 $205,387 $206,223
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 $0 $2,339 $2,720 $6,176 $7,934 $9,374 $7,697 $10,137 $27,768 $21,158 $6,027 $9,633
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 $0 $2,339 $2,720 $6,176 $7,934 $9,374 $7,697 $10,137 $27,768 $21,158 $6,027 $9,633
Long-term Liabilities $150,000 $148,200 $146,400 $144,600 $142,800 $141,000 $139,200 $137,400 $135,600 $133,800 $132,000 $130,200 $128,400
Total Liabilities $150,000 $148,200 $148,739 $147,320 $148,976 $148,934 $148,574 $145,097 $145,737 $161,568 $153,158 $136,227 $138,033
Paid-in Capital $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000
Retained Earnings ($155,400) ($155,400) ($155,400) ($155,400) ($155,400) ($155,400) ($155,400) ($155,400) ($155,400) ($155,400) ($155,400) ($155,400) ($155,400)
Earnings $0 ($15,295) ($24,910) ($33,569) ($33,852) ($29,855) ($22,348) ($18,855) ($9,436) $10,213 $27,290 $24,560 $23,590
Total Capital $44,600 $29,305 $19,691 $11,032 $10,748 $14,745 $22,253 $25,746 $35,164 $54,813 $71,890 $69,160 $68,190
Total Liabilities and Capital $194,600 $177,505 $168,429 $158,352 $159,724 $163,679 $170,827 $170,842 $180,901 $216,381 $225,047 $205,387 $206,223
Net Worth $44,600 $29,305 $19,691 $11,032 $10,748 $14,745 $22,253 $25,746 $35,164 $54,813 $71,890 $69,160 $68,190