Timely Trucking general motor freight trucking business plan appendix. Timely Trucking is a new medium- and long-haul dry van trucking business based in Portland, Oregon.

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

Get the Bplans newsletter:

Expert business tips and advice delivered weekly.

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
Timely Trucking general motor freight trucking business plan appendix. Timely Trucking is a new medium- and long-haul dry van trucking business based in Portland, Oregon.
\n