Visit our US site at: www.bplans.comhide this bar
 
Edit This Plan

Freight Brokerage Business Plan

Silicon Freight Brokers

This sample business plan can be edited directly in Business Plan Pro software.

previous
next
Page 1   2   3   4   5   6   7   8  

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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
previous
next
Edit This Plan
Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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 Jan Feb Mar Apr May