Write Bike
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 | |||||||||||||
0% | $500 | $750 | $850 | $1,600 | $2,000 | $2,400 | $2,600 | $2,800 | $3,100 | $2,300 | $1,900 | $1,500 | |
Web based | 0% | $335 | $503 | $570 | $1,072 | $1,340 | $1,608 | $1,742 | $1,876 | $2,077 | $1,541 | $1,273 | $1,005 |
Total Sales | $835 | $1,253 | $1,420 | $2,672 | $3,340 | $4,008 | $4,342 | $4,676 | $5,177 | $3,841 | $3,173 | $2,505 | |
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 | |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||
Web based | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
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 | ||
Steve | 0% | $1,500 | $1,500 | $2,000 | $2,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
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 | $1,500 | $1,500 | $2,000 | $2,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
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 | $835 | $1,253 | $1,420 | $2,672 | $3,340 | $4,008 | $4,342 | $4,676 | $5,177 | $3,841 | $3,173 | $2,505 | |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Gross Margin | $835 | $1,253 | $1,420 | $2,672 | $3,340 | $4,008 | $4,342 | $4,676 | $5,177 | $3,841 | $3,173 | $2,505 | |
Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
Expenses | |||||||||||||
Payroll | $1,500 | $1,500 | $2,000 | $2,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Account Name | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | |
Rent | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Utilities | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Insurance | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Travel, trade shows. other expenses | $150 | $800 | $150 | $150 | $250 | $150 | $150 | $150 | $600 | $150 | $100 | $100 | |
Total Operating Expenses | $2,158 | $2,808 | $2,658 | $2,658 | $3,758 | $3,658 | $3,658 | $3,658 | $4,108 | $3,658 | $3,608 | $3,608 | |
Profit Before Interest and Taxes | ($1,323) | ($1,556) | ($1,239) | $14 | ($418) | $350 | $684 | $1,018 | $1,069 | $183 | ($435) | ($1,103) | |
EBITDA | ($1,240) | ($1,473) | ($1,156) | $97 | ($335) | $433 | $767 | $1,101 | $1,152 | $266 | ($352) | ($1,020) | |
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 | ($1,323) | ($1,556) | ($1,239) | $14 | ($418) | $350 | $684 | $1,018 | $1,069 | $183 | ($435) | ($1,103) | |
Net Profit/Sales | -158.44% | -124.19% | -87.25% | 0.52% | -12.51% | 8.73% | 15.75% | 21.77% | 20.65% | 4.76% | -13.71% | -44.03% |
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 | $835 | $1,253 | $1,420 | $2,672 | $3,340 | $4,008 | $4,342 | $4,676 | $5,177 | $3,841 | $3,173 | $2,505 | |
Subtotal Cash from Operations | $835 | $1,253 | $1,420 | $2,672 | $3,340 | $4,008 | $4,342 | $4,676 | $5,177 | $3,841 | $3,173 | $2,505 | |
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 | $835 | $1,253 | $1,420 | $2,672 | $3,340 | $4,008 | $4,342 | $4,676 | $5,177 | $3,841 | $3,173 | $2,505 | |
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 | $1,500 | $1,500 | $2,000 | $2,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Bill Payments | $19 | $597 | $1,203 | $575 | $578 | $672 | $575 | $575 | $590 | $1,010 | $573 | $525 | |
Subtotal Spent on Operations | $1,519 | $2,097 | $3,203 | $2,575 | $3,578 | $3,672 | $3,575 | $3,575 | $3,590 | $4,010 | $3,573 | $3,525 | |
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 | $1,519 | $2,097 | $3,203 | $2,575 | $3,578 | $3,672 | $3,575 | $3,575 | $3,590 | $4,010 | $3,573 | $3,525 | |
Net Cash Flow | ($684) | ($844) | ($1,784) | $97 | ($238) | $336 | $767 | $1,101 | $1,587 | ($169) | ($400) | ($1,020) | |
Cash Balance | $8,516 | $7,672 | $5,888 | $5,985 | $5,747 | $6,083 | $6,850 | $7,951 | $9,538 | $9,369 | $8,969 | $7,949 |
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 | $9,200 | $8,516 | $7,672 | $5,888 | $5,985 | $5,747 | $6,083 | $6,850 | $7,951 | $9,538 | $9,369 | $8,969 | $7,949 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $9,200 | $8,516 | $7,672 | $5,888 | $5,985 | $5,747 | $6,083 | $6,850 | $7,951 | $9,538 | $9,369 | $8,969 | $7,949 |
Long-term Assets | |||||||||||||
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 | $5,000 |
Accumulated Depreciation | $0 | $83 | $166 | $249 | $332 | $415 | $498 | $581 | $664 | $747 | $830 | $913 | $996 |
Total Long-term Assets | $5,000 | $4,917 | $4,834 | $4,751 | $4,668 | $4,585 | $4,502 | $4,419 | $4,336 | $4,253 | $4,170 | $4,087 | $4,004 |
Total Assets | $14,200 | $13,433 | $12,506 | $10,639 | $10,653 | $10,332 | $10,585 | $11,269 | $12,287 | $13,791 | $13,539 | $13,056 | $11,953 |
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 | $556 | $1,184 | $556 | $556 | $653 | $556 | $556 | $556 | $991 | $556 | $508 | $508 |
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 | $556 | $1,184 | $556 | $556 | $653 | $556 | $556 | $556 | $991 | $556 | $508 | $508 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $556 | $1,184 | $556 | $556 | $653 | $556 | $556 | $556 | $991 | $556 | $508 | $508 |
Paid-in Capital | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 |
Retained Earnings | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) |
Earnings | $0 | ($1,323) | ($2,879) | ($4,117) | ($4,103) | ($4,521) | ($4,171) | ($3,487) | ($2,469) | ($1,400) | ($1,217) | ($1,652) | ($2,755) |
Total Capital | $14,200 | $12,877 | $11,322 | $10,083 | $10,097 | $9,679 | $10,029 | $10,713 | $11,731 | $12,800 | $12,983 | $12,548 | $11,445 |
Total Liabilities and Capital | $14,200 | $13,433 | $12,506 | $10,639 | $10,653 | $10,332 | $10,585 | $11,269 | $12,287 | $13,791 | $13,539 | $13,056 | $11,953 |
Net Worth | $14,200 | $12,877 | $11,322 | $10,083 | $10,097 | $9,679 | $10,029 | $10,713 | $11,731 | $12,800 | $12,983 | $12,548 | $11,445 |