Don't bother with copy and paste.

Get this complete sample business plan as a free text document.

Download for free

Shipping, Freight & Trucking icon Freight Brokerage Business Plan

Start your plan

Silicon Freight Brokers

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
Buyers 0% $750 $1,400 $2,100 $3,500 $4,100 $5,400 $5,874 $6,212 $6,321 $6,400 $6,457 $6,658
Sellers 0% $250 $600 $1,100 $1,500 $900 $1,800 $1,897 $1,999 $1,800 $2,100 $2,214 $2,400
Total Sales $1,000 $2,000 $3,200 $5,000 $5,000 $7,200 $7,771 $8,211 $8,121 $8,500 $8,671 $9,058
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
Buyers $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sellers $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
President/Broker 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Secretary 0% $0 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440
Customer Service/Account Representitve 0% $0 $0 $0 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 1 2 2 3 3 3 3 3 3 3 3 3
Total Payroll $2,000 $3,440 $3,440 $4,880 $4,880 $4,880 $4,880 $4,880 $4,880 $4,880 $4,880 $4,880

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 $1,000 $2,000 $3,200 $5,000 $5,000 $7,200 $7,771 $8,211 $8,121 $8,500 $8,671 $9,058
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $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 $1,000 $2,000 $3,200 $5,000 $5,000 $7,200 $7,771 $8,211 $8,121 $8,500 $8,671 $9,058
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 $2,000 $3,440 $3,440 $4,880 $4,880 $4,880 $4,880 $4,880 $4,880 $4,880 $4,880 $4,880
Sales and Marketing and Other Expenses $450 $450 $450 $450 $450 $450 $350 $350 $350 $350 $350 $350
Depreciation $56 $56 $56 $56 $56 $56 $56 $56 $56 $56 $56 $56
Website Maintenance $65 $65 $65 $65 $65 $65 $65 $65 $65 $65 $65 $65
Utilities, DSL $120 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120
Insurance, Licenses $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Rent $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450
Payroll Taxes 15% $300 $516 $516 $732 $732 $732 $732 $732 $732 $732 $732 $732
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $3,541 $5,197 $5,197 $6,853 $6,853 $6,853 $6,753 $6,753 $6,753 $6,753 $6,753 $6,753
Profit Before Interest and Taxes ($2,541) ($3,197) ($1,997) ($1,853) ($1,853) $347 $1,018 $1,458 $1,368 $1,747 $1,918 $2,305
EBITDA ($2,485) ($3,141) ($1,941) ($1,797) ($1,797) $403 $1,074 $1,514 $1,424 $1,803 $1,974 $2,361
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 ($2,541) ($3,197) ($1,997) ($1,853) ($1,853) $347 $1,018 $1,458 $1,368 $1,747 $1,918 $2,305
Net Profit/Sales -254.10% -159.85% -62.41% -37.06% -37.06% 4.82% 13.10% 17.76% 16.85% 20.55% 22.12% 25.45%

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 $250 $500 $800 $1,250 $1,250 $1,800 $1,943 $2,053 $2,030 $2,125 $2,168 $2,265
Cash from Receivables $0 $25 $775 $1,530 $2,445 $3,750 $3,805 $5,414 $5,839 $6,156 $6,100 $6,379
Subtotal Cash from Operations $250 $525 $1,575 $2,780 $3,695 $5,550 $5,748 $7,467 $7,870 $8,281 $8,268 $8,644
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 $4,000 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $250 $525 $1,575 $2,780 $7,695 $5,550 $5,748 $7,467 $7,870 $8,281 $8,268 $8,644
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 $2,000 $3,440 $3,440 $4,880 $4,880 $4,880 $4,880 $4,880 $4,880 $4,880 $4,880 $4,880
Bill Payments $50 $1,492 $1,701 $1,708 $1,917 $1,917 $1,914 $1,817 $1,817 $1,817 $1,817 $1,817
Subtotal Spent on Operations $2,050 $4,932 $5,141 $6,588 $6,797 $6,797 $6,794 $6,697 $6,697 $6,697 $6,697 $6,697
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 $2,050 $4,932 $5,141 $6,588 $6,797 $6,797 $6,794 $6,697 $6,697 $6,697 $6,697 $6,697
Net Cash Flow ($1,800) ($4,407) ($3,566) ($3,808) $898 ($1,247) ($1,046) $770 $1,173 $1,584 $1,571 $1,947
Cash Balance $14,551 $10,143 $6,577 $2,769 $3,667 $2,420 $1,374 $2,144 $3,317 $4,901 $6,472 $8,418
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 $16,350 $14,551 $10,143 $6,577 $2,769 $3,667 $2,420 $1,374 $2,144 $3,317 $4,901 $6,472 $8,418
Accounts Receivable $0 $750 $2,225 $3,850 $6,070 $7,375 $9,025 $11,048 $11,792 $12,044 $12,263 $12,666 $13,080
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $16,350 $15,301 $12,368 $10,427 $8,839 $11,042 $11,445 $12,422 $13,936 $15,360 $17,163 $19,137 $21,498
Long-term Assets
Long-term Assets $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Accumulated Depreciation $0 $56 $112 $168 $224 $280 $336 $392 $448 $504 $560 $616 $672
Total Long-term Assets $2,200 $2,144 $2,088 $2,032 $1,976 $1,920 $1,864 $1,808 $1,752 $1,696 $1,640 $1,584 $1,528
Total Assets $18,550 $17,445 $14,456 $12,459 $10,815 $12,962 $13,309 $14,230 $15,688 $17,056 $18,803 $20,721 $23,026
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 $1,436 $1,644 $1,644 $1,853 $1,853 $1,853 $1,756 $1,756 $1,756 $1,756 $1,756 $1,756
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 $1,436 $1,644 $1,644 $1,853 $1,853 $1,853 $1,756 $1,756 $1,756 $1,756 $1,756 $1,756
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,436 $1,644 $1,644 $1,853 $1,853 $1,853 $1,756 $1,756 $1,756 $1,756 $1,756 $1,756
Paid-in Capital $22,000 $22,000 $22,000 $22,000 $22,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000
Retained Earnings ($3,450) ($3,450) ($3,450) ($3,450) ($3,450) ($3,450) ($3,450) ($3,450) ($3,450) ($3,450) ($3,450) ($3,450) ($3,450)
Earnings $0 ($2,541) ($5,738) ($7,735) ($9,588) ($11,441) ($11,094) ($10,076) ($8,618) ($7,250) ($5,503) ($3,585) ($1,280)
Total Capital $18,550 $16,009 $12,812 $10,815 $8,962 $11,109 $11,456 $12,474 $13,932 $15,300 $17,047 $18,965 $21,270
Total Liabilities and Capital $18,550 $17,445 $14,456 $12,459 $10,815 $12,962 $13,309 $14,230 $15,688 $17,056 $18,803 $20,721 $23,026
Net Worth $18,550 $16,009 $12,812 $10,815 $8,962 $11,109 $11,456 $12,474 $13,932 $15,300 $17,047 $18,965 $21,270