Velocipede / Snowpede Borrow Bank
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 | |||||||||||||
| Tourists | 0% | $0 | $958 | $1,025 | $4,587 | $5,214 | $6,457 | $7,254 | $7,545 | $8,974 | $8,547 | $8,782 | $5,701 |
| Locals | 0% | $0 | $1,005 | $1,265 | $2,547 | $3,154 | $3,545 | $3,245 | $3,874 | $4,145 | $4,212 | $4,354 | $4,454 |
| Total Sales | $0 | $1,963 | $2,290 | $7,134 | $8,368 | $10,002 | $10,499 | $11,419 | $13,119 | $12,759 | $13,136 | $10,155 | |
| 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 | |
| Tourists | $0 | $48 | $51 | $229 | $261 | $323 | $363 | $377 | $449 | $427 | $439 | $285 | |
| Locals | $0 | $50 | $63 | $127 | $158 | $177 | $162 | $194 | $207 | $211 | $218 | $223 | |
| Subtotal Direct Cost of Sales | $0 | $98 | $115 | $357 | $418 | $500 | $525 | $571 | $656 | $638 | $657 | $508 | |
| 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 | ||
| Dan | 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 |
| Full-time employee | 0% | $0 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
| Full-time employee | 0% | $0 | $0 | $0 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $0 |
| Full-time employee | 0% | $0 | $0 | $0 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $0 |
| Total People | 1 | 2 | 2 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 2 | |
| Total Payroll | $3,000 | $4,500 | $4,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $4,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 | $1,963 | $2,290 | $7,134 | $8,368 | $10,002 | $10,499 | $11,419 | $13,119 | $12,759 | $13,136 | $10,155 | |
| Direct Cost of Sales | $0 | $98 | $115 | $357 | $418 | $500 | $525 | $571 | $656 | $638 | $657 | $508 | |
| Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $0 | $98 | $115 | $357 | $418 | $500 | $525 | $571 | $656 | $638 | $657 | $508 | |
| Gross Margin | $0 | $1,865 | $2,176 | $6,777 | $7,950 | $9,502 | $9,974 | $10,848 | $12,463 | $12,121 | $12,479 | $9,647 | |
| Gross Margin % | 0.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | |
| Expenses | |||||||||||||
| Payroll | $3,000 | $4,500 | $4,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $4,500 | |
| Sales and Marketing and Other Expenses | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
| Depreciation | $432 | $432 | $432 | $432 | $432 | $432 | $432 | $432 | $432 | $432 | $432 | $432 | |
| Utilities | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Insurance | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Rent | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Payroll Taxes | 15% | $450 | $675 | $675 | $1,125 | $1,125 | $1,125 | $1,125 | $1,125 | $1,125 | $1,125 | $1,125 | $675 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $6,032 | $7,757 | $7,757 | $11,207 | $11,207 | $11,207 | $11,207 | $11,207 | $11,207 | $11,207 | $11,207 | $7,757 | |
| Profit Before Interest and Taxes | ($6,032) | ($5,892) | ($5,582) | ($4,430) | ($3,257) | ($1,705) | ($1,233) | ($359) | $1,256 | $914 | $1,272 | $1,890 | |
| EBITDA | ($5,600) | ($5,460) | ($5,150) | ($3,998) | ($2,825) | ($1,273) | ($801) | $73 | $1,688 | $1,346 | $1,704 | $2,322 | |
| 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 | ($6,032) | ($5,892) | ($5,582) | ($4,430) | ($3,257) | ($1,705) | ($1,233) | ($359) | $1,256 | $914 | $1,272 | $1,890 | |
| Net Profit/Sales | 0.00% | -300.16% | -243.73% | -62.09% | -38.93% | -17.05% | -11.74% | -3.14% | 9.57% | 7.16% | 9.68% | 18.61% | |
| 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 | $1,963 | $2,290 | $7,134 | $8,368 | $10,002 | $10,499 | $11,419 | $13,119 | $12,759 | $13,136 | $10,155 | |
| Subtotal Cash from Operations | $0 | $1,963 | $2,290 | $7,134 | $8,368 | $10,002 | $10,499 | $11,419 | $13,119 | $12,759 | $13,136 | $10,155 | |
| 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 | $1,963 | $2,290 | $7,134 | $8,368 | $10,002 | $10,499 | $11,419 | $13,119 | $12,759 | $13,136 | $10,155 | |
| 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 | $3,000 | $4,500 | $4,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $4,500 | |
| Bill Payments | $87 | $2,611 | $2,924 | $2,963 | $3,634 | $3,696 | $3,776 | $3,801 | $3,849 | $3,930 | $3,914 | $3,912 | |
| Subtotal Spent on Operations | $3,087 | $7,111 | $7,424 | $10,463 | $11,134 | $11,196 | $11,276 | $11,301 | $11,349 | $11,430 | $11,414 | $8,412 | |
| 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 | $3,087 | $7,111 | $7,424 | $10,463 | $11,134 | $11,196 | $11,276 | $11,301 | $11,349 | $11,430 | $11,414 | $8,412 | |
| Net Cash Flow | ($3,087) | ($5,148) | ($5,134) | ($3,329) | ($2,766) | ($1,194) | ($777) | $118 | $1,770 | $1,329 | $1,722 | $1,743 | |
| Cash Balance | $21,813 | $16,666 | $11,532 | $8,203 | $5,438 | $4,243 | $3,466 | $3,584 | $5,354 | $6,683 | $8,405 | $10,148 | |
| 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 | $24,900 | $21,813 | $16,666 | $11,532 | $8,203 | $5,438 | $4,243 | $3,466 | $3,584 | $5,354 | $6,683 | $8,405 | $10,148 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $24,900 | $21,813 | $16,666 | $11,532 | $8,203 | $5,438 | $4,243 | $3,466 | $3,584 | $5,354 | $6,683 | $8,405 | $10,148 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $25,900 | $25,900 | $25,900 | $25,900 | $25,900 | $25,900 | $25,900 | $25,900 | $25,900 | $25,900 | $25,900 | $25,900 | $25,900 |
| Accumulated Depreciation | $0 | $432 | $864 | $1,296 | $1,728 | $2,160 | $2,592 | $3,024 | $3,456 | $3,888 | $4,320 | $4,752 | $5,184 |
| Total Long-term Assets | $25,900 | $25,468 | $25,036 | $24,604 | $24,172 | $23,740 | $23,308 | $22,876 | $22,444 | $22,012 | $21,580 | $21,148 | $20,716 |
| Total Assets | $50,800 | $47,281 | $41,702 | $36,136 | $32,375 | $29,178 | $27,551 | $26,342 | $26,028 | $27,366 | $28,263 | $29,553 | $30,864 |
| 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 | $2,513 | $2,826 | $2,842 | $3,511 | $3,570 | $3,649 | $3,673 | $3,718 | $3,800 | $3,783 | $3,801 | $3,222 |
| 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 | $2,513 | $2,826 | $2,842 | $3,511 | $3,570 | $3,649 | $3,673 | $3,718 | $3,800 | $3,783 | $3,801 | $3,222 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $0 | $2,513 | $2,826 | $2,842 | $3,511 | $3,570 | $3,649 | $3,673 | $3,718 | $3,800 | $3,783 | $3,801 | $3,222 |
| Paid-in Capital | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 |
| Retained Earnings | ($1,200) | ($1,200) | ($1,200) | ($1,200) | ($1,200) | ($1,200) | ($1,200) | ($1,200) | ($1,200) | ($1,200) | ($1,200) | ($1,200) | ($1,200) |
| Earnings | $0 | ($6,032) | ($11,924) | ($17,506) | ($21,935) | ($25,193) | ($26,898) | ($28,131) | ($28,490) | ($27,234) | ($26,320) | ($25,047) | ($23,157) |
| Total Capital | $50,800 | $44,768 | $38,876 | $33,294 | $28,865 | $25,607 | $23,902 | $22,669 | $22,310 | $23,566 | $24,480 | $25,753 | $27,643 |
| Total Liabilities and Capital | $50,800 | $47,281 | $41,702 | $36,136 | $32,375 | $29,178 | $27,551 | $26,342 | $26,028 | $27,366 | $28,263 | $29,553 | $30,864 |
| Net Worth | $50,800 | $44,768 | $38,876 | $33,294 | $28,865 | $25,607 | $23,902 | $22,669 | $22,310 | $23,566 | $24,480 | $25,753 | $27,643 |
By 
