The Two Wheeled Oracle

Start your own business plan »

Bicycle Courier 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
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)