One Week At A Time

Start your own business plan »

Educational Website 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
Reusable/Paper Products 0% $25 $31 $39 $49 $61 $76 $95 $119 $149 $186 $233 $291
Appliances 0% $50 $63 $78 $98 $122 $153 $191 $238 $298 $373 $466 $582
Food 0% $15 $17 $20 $23 $26 $30 $35 $40 $46 $53 $61 $70
Clothes/Diapers 0% $50 $63 $78 $98 $122 $153 $191 $238 $298 $373 $466 $582
Books/Music 0% $25 $30 $36 $43 $52 $62 $75 $90 $107 $129 $155 $186
Kitchen/Cleaners 0% $100 $125 $156 $195 $244 $305 $381 $477 $596 $745 $931 $1,164
Total Sales $265 $329 $407 $505 $627 $779 $968 $1,202 $1,494 $1,858 $2,311 $2,875
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
Online Marketing $50 $53 $55 $58 $61 $64 $67 $70 $74 $78 $81 $86
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $50 $53 $55 $58 $61 $64 $67 $70 $74 $78 $81 $86
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
Frank Williams 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $500 $500
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 1 1 1 1 1 1 1 1 1 1 1 1
Total Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $500 $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 $265 $329 $407 $505 $627 $779 $968 $1,202 $1,494 $1,858 $2,311 $2,875
Direct Cost of Sales $50 $53 $55 $58 $61 $64 $67 $70 $74 $78 $81 $86
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $50 $53 $55 $58 $61 $64 $67 $70 $74 $78 $81 $86
Gross Margin $215 $276 $352 $448 $567 $715 $901 $1,132 $1,421 $1,781 $2,230 $2,789
Gross Margin % 81.13% 84.02% 86.47% 88.55% 90.31% 91.81% 93.08% 94.15% 95.06% 95.83% 96.48% 97.03%
Expenses
Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $500 $500
Sales and Marketing and Other Expenses $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Web Site Hosting $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $75 $75
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $775 $775
Profit Before Interest and Taxes $15 $76 $152 $248 $367 $515 $701 $932 $1,221 $1,581 $1,455 $2,014
EBITDA $15 $76 $152 $248 $367 $515 $701 $932 $1,221 $1,581 $1,455 $2,014
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $5 $23 $46 $74 $110 $155 $210 $280 $366 $474 $436 $604
Net Profit $11 $53 $107 $173 $257 $361 $490 $652 $854 $1,106 $1,018 $1,410
Net Profit/Sales 3.96% 16.19% 26.16% 34.29% 40.90% 46.29% 50.68% 54.26% 57.17% 59.54% 44.06% 49.05%
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 $265 $329 $407 $505 $627 $779 $968 $1,202 $1,494 $1,858 $2,311 $2,875
Subtotal Cash from Operations $265 $329 $407 $505 $627 $779 $968 $1,202 $1,494 $1,858 $2,311 $2,875
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 $265 $329 $407 $505 $627 $779 $968 $1,202 $1,494 $1,858 $2,311 $2,875
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $500 $500
Bill Payments $8 $255 $276 $302 $333 $372 $420 $480 $553 $644 $753 $799
Subtotal Spent on Operations $8 $255 $276 $302 $333 $372 $420 $480 $553 $644 $1,253 $1,299
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 $255 $276 $302 $333 $372 $420 $480 $553 $644 $1,253 $1,299
Net Cash Flow $257 $73 $131 $204 $294 $407 $547 $723 $942 $1,214 $1,058 $1,576
Cash Balance $1,932 $2,005 $2,136 $2,340 $2,634 $3,040 $3,588 $4,310 $5,252 $6,466 $7,524 $9,100
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 $1,675 $1,932 $2,005 $2,136 $2,340 $2,634 $3,040 $3,588 $4,310 $5,252 $6,466 $7,524 $9,100
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $1,675 $1,932 $2,005 $2,136 $2,340 $2,634 $3,040 $3,588 $4,310 $5,252 $6,466 $7,524 $9,100
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $1,675 $1,932 $2,005 $2,136 $2,340 $2,634 $3,040 $3,588 $4,310 $5,252 $6,466 $7,524 $9,100
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 $246 $266 $291 $321 $358 $404 $461 $532 $619 $727 $766 $933
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 $246 $266 $291 $321 $358 $404 $461 $532 $619 $727 $766 $933
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $246 $266 $291 $321 $358 $404 $461 $532 $619 $727 $766 $933
Paid-in Capital $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Retained Earnings ($1,325) ($1,325) ($1,325) ($1,325) ($1,325) ($1,325) ($1,325) ($1,325) ($1,325) ($1,325) ($1,325) ($1,325) ($1,325)
Earnings $0 $11 $64 $170 $344 $600 $961 $1,451 $2,104 $2,958 $4,065 $5,083 $6,493
Total Capital $1,675 $1,686 $1,739 $1,845 $2,019 $2,275 $2,636 $3,126 $3,779 $4,633 $5,740 $6,758 $8,168
Total Liabilities and Capital $1,675 $1,932 $2,005 $2,136 $2,340 $2,634 $3,040 $3,588 $4,310 $5,252 $6,466 $7,524 $9,100
Net Worth $1,675 $1,686 $1,739 $1,845 $2,019 $2,275 $2,636 $3,126 $3,779 $4,633 $5,740 $6,758 $8,168