The Two Wheeled Oracle
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 | |||||||||||||
Law firms | 0% | $0 | $3,525 | $7,214 | $8,600 | $10,254 | $11,458 | $15,455 | $17,458 | $18,524 | $19,874 | $19,952 | $20,145 |
Assorted customers | 0% | $0 | $954 | $1,245 | $1,154 | $1,547 | $2,154 | $2,658 | $2,014 | $2,147 | $2,200 | $2,314 | $2,454 |
Total Sales | $0 | $4,479 | $8,459 | $9,754 | $11,801 | $13,612 | $18,113 | $19,472 | $20,671 | $22,074 | $22,266 | $22,599 | |
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 | |
Law firms | $0 | $71 | $144 | $172 | $205 | $229 | $309 | $349 | $370 | $397 | $399 | $403 | |
Assorted customers | $0 | $19 | $25 | $23 | $31 | $43 | $53 | $40 | $43 | $44 | $46 | $49 | |
Subtotal Direct Cost of Sales | $0 | $90 | $169 | $195 | $236 | $272 | $362 | $389 | $413 | $441 | $445 | $452 |
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 | ||
Alwy Laate | 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 |
Dispatcher | 0% | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 |
Messenger | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
Messenger | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
Messenger | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
Messenger | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
Messenger | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
Messenger | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
Messenger | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Total Payroll | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 |
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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | $4,479 | $8,459 | $9,754 | $11,801 | $13,612 | $18,113 | $19,472 | $20,671 | $22,074 | $22,266 | $22,599 | |
Direct Cost of Sales | $0 | $90 | $169 | $195 | $236 | $272 | $362 | $389 | $413 | $441 | $445 | $452 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $90 | $169 | $195 | $236 | $272 | $362 | $389 | $413 | $441 | $445 | $452 | |
Gross Margin | $0 | $4,389 | $8,290 | $9,559 | $11,565 | $13,340 | $17,751 | $19,083 | $20,258 | $21,633 | $21,821 | $22,147 | |
Gross Margin % | 0.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | |
Expenses | |||||||||||||
Payroll | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | |
Sales and Marketing and Other Expenses | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Depreciation | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | |
Cellular service | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
Utilities | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Insurance | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Rent | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
Payroll Taxes | 15% | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | |
Profit Before Interest and Taxes | ($18,772) | ($14,383) | ($10,482) | ($9,213) | ($7,207) | ($5,432) | ($1,021) | $311 | $1,486 | $2,861 | $3,049 | $3,375 | |
EBITDA | ($18,647) | ($14,258) | ($10,357) | ($9,088) | ($7,082) | ($5,307) | ($896) | $436 | $1,611 | $2,986 | $3,174 | $3,500 | |
Interest Expense | $411 | $405 | $399 | $392 | $386 | $380 | $374 | $367 | $361 | $354 | $348 | $341 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($19,183) | ($14,787) | ($10,881) | ($9,605) | ($7,593) | ($5,812) | ($1,395) | ($57) | $1,125 | $2,506 | $2,701 | $3,034 | |
Net Profit/Sales | 0.00% | -330.14% | -128.63% | -98.48% | -64.34% | -42.70% | -7.70% | -0.29% | 5.44% | 11.35% | 12.13% | 13.42% |
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,120 | $2,115 | $2,439 | $2,950 | $3,403 | $4,528 | $4,868 | $5,168 | $5,519 | $5,567 | $5,650 | |
Cash from Receivables | $0 | $0 | $112 | $3,459 | $6,377 | $7,367 | $8,896 | $10,322 | $13,619 | $14,634 | $15,538 | $16,560 | |
Subtotal Cash from Operations | $0 | $1,120 | $2,227 | $5,897 | $9,327 | $10,770 | $13,424 | $15,190 | $18,786 | $20,152 | $21,105 | $22,210 | |
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,120 | $2,227 | $5,897 | $9,327 | $10,770 | $13,424 | $15,190 | $18,786 | $20,152 | $21,105 | $22,210 | |
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,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | |
Bill Payments | $143 | $4,280 | $4,364 | $4,435 | $4,456 | $4,490 | $4,522 | $4,604 | $4,624 | $4,642 | $4,663 | $4,660 | |
Subtotal Spent on Operations | $14,923 | $19,060 | $19,144 | $19,215 | $19,236 | $19,270 | $19,302 | $19,384 | $19,404 | $19,422 | $19,443 | $19,440 | |
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 | $720 | $726 | $732 | $739 | $745 | $751 | $757 | $764 | $770 | $777 | $783 | $790 | |
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 | $15,643 | $19,787 | $19,876 | $19,954 | $19,980 | $20,021 | $20,059 | $20,147 | $20,174 | $20,199 | $20,226 | $20,230 | |
Net Cash Flow | ($15,643) | ($18,667) | ($17,649) | ($14,057) | ($10,654) | ($9,252) | ($6,635) | ($4,958) | ($1,388) | ($46) | $879 | $1,980 | |
Cash Balance | $85,557 | $66,890 | $49,241 | $35,184 | $24,530 | $15,279 | $8,644 | $3,686 | $2,298 | $2,252 | $3,131 | $5,111 |
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 | $101,200 | $85,557 | $66,890 | $49,241 | $35,184 | $24,530 | $15,279 | $8,644 | $3,686 | $2,298 | $2,252 | $3,131 | $5,111 |
Accounts Receivable | $0 | $0 | $3,359 | $9,592 | $13,448 | $15,922 | $18,765 | $23,453 | $27,736 | $29,620 | $31,542 | $32,703 | $33,092 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $101,200 | $85,557 | $70,249 | $58,832 | $48,632 | $40,453 | $34,043 | $32,097 | $31,422 | $31,918 | $33,794 | $35,834 | $38,203 |
Long-term Assets | |||||||||||||
Long-term Assets | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 |
Accumulated Depreciation | $0 | $125 | $250 | $375 | $500 | $625 | $750 | $875 | $1,000 | $1,125 | $1,250 | $1,375 | $1,500 |
Total Long-term Assets | $7,500 | $7,375 | $7,250 | $7,125 | $7,000 | $6,875 | $6,750 | $6,625 | $6,500 | $6,375 | $6,250 | $6,125 | $6,000 |
Total Assets | $108,700 | $92,932 | $77,499 | $65,957 | $55,632 | $47,328 | $40,793 | $38,722 | $37,922 | $38,293 | $40,044 | $41,959 | $44,203 |
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 | $4,135 | $4,216 | $4,287 | $4,306 | $4,340 | $4,368 | $4,449 | $4,470 | $4,487 | $4,507 | $4,505 | $4,505 |
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 | $4,135 | $4,216 | $4,287 | $4,306 | $4,340 | $4,368 | $4,449 | $4,470 | $4,487 | $4,507 | $4,505 | $4,505 |
Long-term Liabilities | $50,000 | $49,280 | $48,553 | $47,821 | $47,082 | $46,337 | $45,586 | $44,829 | $44,065 | $43,295 | $42,518 | $41,735 | $40,945 |
Total Liabilities | $50,000 | $53,415 | $52,769 | $52,108 | $51,388 | $50,677 | $49,955 | $49,278 | $48,534 | $47,781 | $47,025 | $46,240 | $45,450 |
Paid-in Capital | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 |
Retained Earnings | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) |
Earnings | $0 | ($19,183) | ($33,970) | ($44,851) | ($54,456) | ($62,049) | ($67,861) | ($69,256) | ($69,313) | ($68,188) | ($65,682) | ($62,981) | ($59,947) |
Total Capital | $58,700 | $39,517 | $24,730 | $13,849 | $4,244 | ($3,349) | ($9,161) | ($10,556) | ($10,613) | ($9,488) | ($6,982) | ($4,281) | ($1,247) |
Total Liabilities and Capital | $108,700 | $92,932 | $77,499 | $65,957 | $55,632 | $47,328 | $40,793 | $38,722 | $37,922 | $38,293 | $40,044 | $41,959 | $44,203 |
Net Worth | $58,700 | $39,517 | $24,730 | $13,849 | $4,244 | ($3,349) | ($9,161) | ($10,556) | ($10,613) | ($9,488) | ($6,982) | ($4,281) | ($1,247) |