Timely Trucking

Start your own business plan »

General Motor Freight Trucking 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
Unit Sales
Miles of Shipping 12,000 18,000 27,000 37,800 52,920 55,566 58,344 61,262 64,325 67,541 70,918 74,464
Preferred Client Accounts 0 1 2 4 7 8 9 10 10 11 12 14
Total Unit Sales 12,000 18,001 27,002 37,804 52,927 55,574 58,353 61,272 64,335 67,552 70,930 74,478
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Miles of Shipping $1.30 $1.30 $1.30 $1.30 $1.30 $1.30 $1.30 $1.30 $1.30 $1.30 $1.30 $1.30
Preferred Client Accounts $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00
Sales
Miles of Shipping $15,600 $23,400 $35,100 $49,140 $68,796 $72,236 $75,848 $79,640 $83,622 $87,803 $92,193 $96,803
Preferred Client Accounts $0 $1,000 $2,000 $4,000 $7,000 $8,000 $9,000 $10,000 $10,000 $11,000 $12,000 $14,000
Total Sales $15,600 $24,400 $37,100 $53,140 $75,796 $80,236 $84,848 $89,640 $93,622 $98,803 $104,193 $110,803
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Miles of Shipping 50.00% $0.65 $0.65 $0.65 $0.65 $0.65 $0.65 $0.65 $0.65 $0.65 $0.65 $0.65 $0.65
Preferred Client Accounts 10.00% $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00
Direct Cost of Sales
Miles of Shipping $7,800 $11,700 $17,550 $24,570 $34,398 $36,118 $37,924 $39,820 $41,811 $43,902 $46,097 $48,401
Preferred Client Accounts $0 $100 $200 $400 $700 $800 $900 $1,000 $1,000 $1,100 $1,200 $1,400
Subtotal Direct Cost of Sales $7,800 $11,800 $17,750 $24,970 $35,098 $36,918 $38,824 $40,820 $42,811 $45,002 $47,297 $49,801
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
CEO $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
COO $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Sales/Marketing Associate $0 $0 $0 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Administrator $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Truck Drivers (Non-Job Payroll) $1,000 $1,200 $1,440 $1,584 $1,901 $2,091 $2,300 $2,530 $2,783 $3,061 $3,367 $3,704
Total People 6 6 6 6 6 6 6 6 7 7 8 8
Total Payroll $13,000 $13,200 $13,440 $16,584 $16,901 $17,091 $17,300 $17,530 $17,783 $18,061 $18,367 $18,704
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 $15,600 $24,400 $37,100 $53,140 $75,796 $80,236 $84,848 $89,640 $93,622 $98,803 $104,193 $110,803
Direct Cost of Sales $7,800 $11,800 $17,750 $24,970 $35,098 $36,918 $38,824 $40,820 $42,811 $45,002 $47,297 $49,801
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $7,800 $11,800 $17,750 $24,970 $35,098 $36,918 $38,824 $40,820 $42,811 $45,002 $47,297 $49,801
Gross Margin $7,800 $12,600 $19,350 $28,170 $40,698 $43,318 $46,024 $48,820 $50,811 $53,802 $56,897 $61,001
Gross Margin % 50.00% 51.64% 52.16% 53.01% 53.69% 53.99% 54.24% 54.46% 54.27% 54.45% 54.61% 55.05%
Expenses
Payroll $13,000 $13,200 $13,440 $16,584 $16,901 $17,091 $17,300 $17,530 $17,783 $18,061 $18,367 $18,704
Marketing/Promotion $6,000 $6,000 $16,000 $6,000 $6,000 $6,000 $16,000 $6,000 $6,000 $16,000 $6,000 $6,000
Depreciation $4,580 $4,580 $4,580 $4,580 $4,580 $4,580 $4,580 $4,580 $4,580 $6,038 $6,038 $6,038
Truck Maintenance/Repair $600 $600 $600 $600 $600 $600 $600 $600 $600 $800 $800 $800
Rent $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Utilities $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Insurance $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Payroll Taxes 15% $2,535 $2,865 $3,347 $4,360 $5,167 $5,332 $5,507 $5,691 $5,878 $6,084 $6,302 $6,541
Licenses and Permitting 15% $0 $0 $1,000 $0 $0 $1,000 $0 $0 $5,000 $0 $0 $1,000
Web Hosting and Development $300 $218 $238 $259 $282 $307 $335 $365 $398 $434 $473 $516
Total Operating Expenses $31,315 $31,763 $43,505 $36,683 $37,830 $39,210 $48,622 $39,066 $44,539 $51,718 $42,281 $43,899
Profit Before Interest and Taxes ($23,515) ($19,163) ($24,155) ($8,513) $2,868 $4,108 ($2,598) $9,754 $6,272 $2,084 $14,616 $17,103
EBITDA ($18,935) ($14,583) ($19,575) ($3,933) $7,448 $8,688 $1,982 $14,334 $10,852 $8,122 $20,654 $23,141
Interest Expense $61 $60 $58 $57 $55 $53 $51 $48 $46 $1,168 $1,133 $1,100
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($23,576) ($19,223) ($24,214) ($8,570) $2,813 $4,055 ($2,649) $9,706 $6,226 $916 $13,483 $16,003
Net Profit/Sales -151.13% -78.78% -65.27% -16.13% 3.71% 5.05% -3.12% 10.83% 6.65% 0.93% 12.94% 14.44%
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 $3,900 $6,100 $9,275 $13,285 $18,949 $20,059 $21,212 $22,410 $23,405 $24,701 $26,048 $27,701
Cash from Receivables $0 $6,240 $15,220 $23,380 $34,241 $48,917 $58,623 $62,022 $65,553 $68,823 $72,289 $76,258
Subtotal Cash from Operations $3,900 $12,340 $24,495 $36,665 $53,190 $68,976 $79,835 $84,432 $88,958 $93,524 $98,337 $103,959
Additional Cash Received
Sales Tax, VAT, HST/GST Received 8.00% $1,248 $1,952 $2,968 $4,251 $6,064 $6,419 $6,788 $7,171 $7,490 $7,904 $8,335 $8,864
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 $135,000 $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 $5,148 $14,292 $27,463 $40,916 $59,254 $75,395 $86,623 $91,603 $96,448 $236,428 $106,673 $112,823
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 $13,000 $13,200 $13,440 $16,584 $16,901 $17,091 $17,300 $17,530 $17,783 $18,061 $18,367 $18,704
Bill Payments $720 $21,738 $26,425 $43,202 $40,911 $51,603 $54,880 $65,356 $58,064 $65,325 $73,538 $66,430
Subtotal Spent on Operations $13,720 $34,938 $39,865 $59,786 $57,812 $68,693 $72,180 $82,886 $75,847 $83,386 $91,905 $85,134
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $1,248 $1,952 $2,968 $4,251 $6,064 $6,419 $6,788 $7,171 $7,490 $7,904 $8,335 $8,864
Principal Repayment of Current Borrowing $100 $110 $121 $133 $146 $161 $177 $195 $215 $237 $261 $144
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 $3,750 $3,750
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 $175,000 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $15,068 $37,000 $42,954 $64,170 $64,022 $75,273 $79,145 $90,253 $83,552 $266,527 $104,252 $97,892
Net Cash Flow ($9,920) ($22,708) ($15,491) ($23,254) ($4,768) $122 $7,477 $1,350 $12,896 ($30,099) $2,421 $14,931
Cash Balance $80,080 $57,372 $41,882 $18,628 $13,860 $13,982 $21,459 $22,809 $35,705 $5,605 $8,026 $22,957
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 $90,000 $80,080 $57,372 $41,882 $18,628 $13,860 $13,982 $21,459 $22,809 $35,705 $5,605 $8,026 $22,957
Accounts Receivable $0 $11,700 $23,760 $36,365 $52,840 $75,446 $86,705 $91,718 $96,927 $101,590 $106,870 $112,726 $119,570
Other Current Assets $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Total Current Assets $110,000 $111,780 $101,132 $98,247 $91,468 $109,306 $120,687 $133,177 $139,736 $157,295 $132,475 $140,752 $162,527
Long-term Assets
Long-term Assets $550,000 $550,000 $550,000 $550,000 $550,000 $550,000 $550,000 $550,000 $550,000 $550,000 $725,000 $725,000 $725,000
Accumulated Depreciation $0 $4,580 $9,160 $13,740 $18,320 $22,900 $27,480 $32,060 $36,640 $41,220 $47,258 $53,296 $59,334
Total Long-term Assets $550,000 $545,420 $540,840 $536,260 $531,680 $527,100 $522,520 $517,940 $513,360 $508,780 $677,742 $671,704 $665,666
Total Assets $660,000 $657,200 $641,972 $634,507 $623,148 $636,406 $643,207 $651,117 $653,096 $666,075 $810,217 $812,456 $828,193
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 $20,876 $24,981 $41,850 $39,195 $49,786 $52,693 $63,429 $55,897 $62,865 $71,328 $64,095 $67,723
Current Borrowing $5,000 $4,900 $4,790 $4,669 $4,536 $4,390 $4,229 $4,052 $3,857 $3,642 $3,405 $3,144 $3,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $5,000 $25,776 $29,771 $46,519 $43,731 $54,176 $56,922 $67,481 $59,754 $66,507 $74,733 $67,239 $70,723
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $135,000 $131,250 $127,500
Total Liabilities $5,000 $25,776 $29,771 $46,519 $43,731 $54,176 $56,922 $67,481 $59,754 $66,507 $209,733 $198,489 $198,223
Paid-in Capital $718,000 $718,000 $718,000 $718,000 $718,000 $718,000 $718,000 $718,000 $718,000 $718,000 $718,000 $718,000 $718,000
Retained Earnings ($63,000) ($63,000) ($63,000) ($63,000) ($63,000) ($63,000) ($63,000) ($63,000) ($63,000) ($63,000) ($63,000) ($63,000) ($63,000)
Earnings $0 ($23,576) ($42,799) ($67,013) ($75,583) ($72,770) ($68,715) ($71,364) ($61,658) ($55,432) ($54,515) ($41,033) ($25,030)
Total Capital $655,000 $631,424 $612,201 $587,987 $579,417 $582,230 $586,285 $583,636 $593,342 $599,568 $600,485 $613,967 $629,970
Total Liabilities and Capital $660,000 $657,200 $641,972 $634,507 $623,148 $636,406 $643,207 $651,117 $653,096 $666,075 $810,217 $812,456 $828,193
Net Worth $655,000 $631,424 $612,201 $587,987 $579,417 $582,230 $586,285 $583,636 $593,342 $599,568 $600,485 $613,967 $629,970