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