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 |