Timely Trucking
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 |