Mike's Trucking Service

Start your own business plan »

General Freight Trucking Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Trucking Services 0% $6,000 $6,000 $7,000 $7,000 $8,000 $8,000 $9,000 $9,000 $10,000 $10,000 $10,000 $10,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $6,000 $6,000 $7,000 $7,000 $8,000 $8,000 $9,000 $9,000 $10,000 $10,000 $10,000 $10,000
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Trucking Services $1,200 $1,200 $1,400 $1,400 $1,600 $1,600 $1,800 $1,800 $2,000 $2,000 $2,000 $2,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $1,200 $1,200 $1,400 $1,400 $1,600 $1,600 $1,800 $1,800 $2,000 $2,000 $2,000 $2,000
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Mike Smith 0% $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Joan Rose 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 2 2 2 2 2 2 2 2 2 2 2 2
Total Payroll $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
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 $6,000 $6,000 $7,000 $7,000 $8,000 $8,000 $9,000 $9,000 $10,000 $10,000 $10,000 $10,000
Direct Cost of Sales $1,200 $1,200 $1,400 $1,400 $1,600 $1,600 $1,800 $1,800 $2,000 $2,000 $2,000 $2,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $1,200 $1,200 $1,400 $1,400 $1,600 $1,600 $1,800 $1,800 $2,000 $2,000 $2,000 $2,000
Gross Margin $4,800 $4,800 $5,600 $5,600 $6,400 $6,400 $7,200 $7,200 $8,000 $8,000 $8,000 $8,000
Gross Margin % 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00%
Expenses
Payroll $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Sales and Marketing and Other Expenses $590 $590 $590 $590 $590 $590 $590 $590 $590 $590 $590 $590
Depreciation $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Fuel & Maintenance $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Insurance $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Payroll Taxes 15% $375 $375 $375 $375 $375 $375 $375 $375 $375 $375 $375 $375
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $4,965 $4,965 $4,965 $4,965 $4,965 $4,965 $4,965 $4,965 $4,965 $4,965 $4,965 $4,965
Profit Before Interest and Taxes ($165) ($165) $635 $635 $1,435 $1,435 $2,235 $2,235 $3,035 $3,035 $3,035 $3,035
EBITDA $235 $235 $1,035 $1,035 $1,835 $1,835 $2,635 $2,635 $3,435 $3,435 $3,435 $3,435
Interest Expense $371 $367 $363 $358 $1,398 $1,383 $1,368 $1,353 $1,338 $1,323 $1,308 $1,293
Taxes Incurred ($161) ($133) $68 $69 $9 $13 $217 $221 $424 $428 $432 $436
Net Profit ($375) ($399) $204 $208 $28 $39 $651 $662 $1,273 $1,284 $1,296 $1,307
Net Profit/Sales -6.25% -6.65% 2.92% 2.96% 0.35% 0.49% 7.23% 7.35% 12.73% 12.84% 12.96% 13.07%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $4,800 $4,800 $5,600 $5,600 $6,400 $6,400 $7,200 $7,200 $8,000 $8,000 $8,000 $8,000
Cash from Receivables $5,000 $5,040 $1,200 $1,207 $1,400 $1,407 $1,600 $1,607 $1,800 $1,807 $2,000 $2,000
Subtotal Cash from Operations $9,800 $9,840 $6,800 $6,807 $7,800 $7,807 $8,800 $8,807 $9,800 $9,807 $10,000 $10,000
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 $125,000 $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 $9,800 $9,840 $6,800 $6,807 $132,800 $7,807 $8,800 $8,807 $9,800 $9,807 $10,000 $10,000
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Bill Payments $3,616 $3,476 $3,512 $3,896 $3,932 $5,072 $5,074 $5,449 $5,451 $5,827 $5,815 $5,804
Subtotal Spent on Operations $6,116 $5,976 $6,012 $6,396 $6,432 $7,572 $7,574 $7,949 $7,951 $8,327 $8,315 $8,304
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 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $200 $200 $200 $200 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
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 $60,000 $65,000 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $6,616 $6,476 $6,512 $6,896 $6,732 $69,372 $74,374 $9,749 $9,751 $10,127 $10,115 $10,104
Net Cash Flow $3,184 $3,364 $288 ($89) $126,068 ($61,565) ($65,574) ($942) $49 ($320) ($115) ($104)
Cash Balance $3,684 $7,048 $7,336 $7,247 $133,316 $71,751 $6,177 $5,235 $5,284 $4,964 $4,849 $4,745
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $500 $3,684 $7,048 $7,336 $7,247 $133,316 $71,751 $6,177 $5,235 $5,284 $4,964 $4,849 $4,745
Accounts Receivable $10,000 $6,200 $2,360 $2,560 $2,753 $2,953 $3,147 $3,347 $3,540 $3,740 $3,933 $3,933 $3,933
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $10,500 $9,884 $9,408 $9,896 $10,001 $136,269 $74,897 $9,524 $8,775 $9,024 $8,897 $8,782 $8,678
Long-term Assets
Long-term Assets $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $100,000 $165,000 $165,000 $165,000 $165,000 $165,000 $165,000
Accumulated Depreciation $4,000 $4,400 $4,800 $5,200 $5,600 $6,000 $6,400 $6,800 $7,200 $7,600 $8,000 $8,400 $8,800
Total Long-term Assets $36,000 $35,600 $35,200 $34,800 $34,400 $34,000 $93,600 $158,200 $157,800 $157,400 $157,000 $156,600 $156,200
Total Assets $46,500 $45,484 $44,608 $44,696 $44,401 $170,269 $168,497 $167,724 $166,575 $166,424 $165,897 $165,382 $164,878
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $3,500 $3,359 $3,382 $3,766 $3,763 $4,903 $4,892 $5,268 $5,257 $5,633 $5,622 $5,611 $5,600
Current Borrowing $20,000 $19,700 $19,400 $19,100 $18,800 $18,500 $18,200 $17,900 $17,600 $17,300 $17,000 $16,700 $16,400
Other Current Liabilities $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Subtotal Current Liabilities $24,000 $23,559 $23,282 $23,366 $23,063 $23,903 $23,592 $23,668 $23,357 $23,433 $23,122 $22,811 $22,500
Long-term Liabilities $25,000 $24,800 $24,600 $24,400 $24,200 $149,200 $147,700 $146,200 $144,700 $143,200 $141,700 $140,200 $138,700
Total Liabilities $49,000 $48,359 $47,882 $47,766 $47,263 $173,103 $171,292 $169,868 $168,057 $166,633 $164,822 $163,011 $161,200
Paid-in Capital $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Retained Earnings ($2,500) ($2,500) ($2,500) ($2,500) ($2,500) ($2,500) ($2,500) ($2,500) ($2,500) ($2,500) ($2,500) ($2,500) ($2,500)
Earnings $0 ($375) ($774) ($569) ($362) ($334) ($294) $356 $1,018 $2,291 $3,576 $4,871 $6,178
Total Capital ($2,500) ($2,875) ($3,274) ($3,069) ($2,862) ($2,834) ($2,794) ($2,144) ($1,482) ($209) $1,076 $2,371 $3,678
Total Liabilities and Capital $46,500 $45,484 $44,608 $44,696 $44,401 $170,269 $168,497 $167,724 $166,575 $166,424 $165,897 $165,382 $164,878
Net Worth ($2,500) ($2,875) ($3,274) ($3,069) ($2,862) ($2,834) ($2,794) ($2,144) ($1,482) ($209) $1,076 $2,371 $3,678