| 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 | ||
| Sales | |||||||||||||
| Law firms | 0% | $0 | $3,525 | $7,214 | $8,600 | $10,254 | $11,458 | $15,455 | $17,458 | $18,524 | $19,874 | $19,952 | $20,145 |
| Assorted customers | 0% | $0 | $954 | $1,245 | $1,154 | $1,547 | $2,154 | $2,658 | $2,014 | $2,147 | $2,200 | $2,314 | $2,454 |
| Total Sales | $0 | $4,479 | $8,459 | $9,754 | $11,801 | $13,612 | $18,113 | $19,472 | $20,671 | $22,074 | $22,266 | $22,599 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Law firms | $0 | $71 | $144 | $172 | $205 | $229 | $309 | $349 | $370 | $397 | $399 | $403 | |
| Assorted customers | $0 | $19 | $25 | $23 | $31 | $43 | $53 | $40 | $43 | $44 | $46 | $49 | |
| Subtotal Direct Cost of Sales | $0 | $90 | $169 | $195 | $236 | $272 | $362 | $389 | $413 | $441 | $445 | $452 | |
| 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 | ||
| Alwy Laate | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
| Dispatcher | 0% | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 |
| Messenger | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
| Messenger | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
| Messenger | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
| Messenger | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
| Messenger | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
| Messenger | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
| Messenger | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| 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 | |||||||||||||
| 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 | $0 | $4,479 | $8,459 | $9,754 | $11,801 | $13,612 | $18,113 | $19,472 | $20,671 | $22,074 | $22,266 | $22,599 | |
| Direct Cost of Sales | $0 | $90 | $169 | $195 | $236 | $272 | $362 | $389 | $413 | $441 | $445 | $452 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $0 | $90 | $169 | $195 | $236 | $272 | $362 | $389 | $413 | $441 | $445 | $452 | |
| Gross Margin | $0 | $4,389 | $8,290 | $9,559 | $11,565 | $13,340 | $17,751 | $19,083 | $20,258 | $21,633 | $21,821 | $22,147 | |
| Gross Margin % | 0.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | |
| Expenses | |||||||||||||
| Payroll | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | |
| Sales and Marketing and Other Expenses | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
| Depreciation | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | |
| Cellular service | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
| Utilities | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Insurance | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
| Rent | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
| Payroll Taxes | 15% | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 | $2,217 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | $18,772 | |
| Profit Before Interest and Taxes | ($18,772) | ($14,383) | ($10,482) | ($9,213) | ($7,207) | ($5,432) | ($1,021) | $311 | $1,486 | $2,861 | $3,049 | $3,375 | |
| EBITDA | ($18,647) | ($14,258) | ($10,357) | ($9,088) | ($7,082) | ($5,307) | ($896) | $436 | $1,611 | $2,986 | $3,174 | $3,500 | |
| Interest Expense | $411 | $405 | $399 | $392 | $386 | $380 | $374 | $367 | $361 | $354 | $348 | $341 | |
| Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Profit | ($19,183) | ($14,787) | ($10,881) | ($9,605) | ($7,593) | ($5,812) | ($1,395) | ($57) | $1,125 | $2,506 | $2,701 | $3,034 | |
| Net Profit/Sales | 0.00% | -330.14% | -128.63% | -98.48% | -64.34% | -42.70% | -7.70% | -0.29% | 5.44% | 11.35% | 12.13% | 13.42% | |
| 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 | $0 | $1,120 | $2,115 | $2,439 | $2,950 | $3,403 | $4,528 | $4,868 | $5,168 | $5,519 | $5,567 | $5,650 | |
| Cash from Receivables | $0 | $0 | $112 | $3,459 | $6,377 | $7,367 | $8,896 | $10,322 | $13,619 | $14,634 | $15,538 | $16,560 | |
| Subtotal Cash from Operations | $0 | $1,120 | $2,227 | $5,897 | $9,327 | $10,770 | $13,424 | $15,190 | $18,786 | $20,152 | $21,105 | $22,210 | |
| 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 | $0 | $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 | $0 | $1,120 | $2,227 | $5,897 | $9,327 | $10,770 | $13,424 | $15,190 | $18,786 | $20,152 | $21,105 | $22,210 | |
| 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 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | $14,780 | |
| Bill Payments | $143 | $4,280 | $4,364 | $4,435 | $4,456 | $4,490 | $4,522 | $4,604 | $4,624 | $4,642 | $4,663 | $4,660 | |
| Subtotal Spent on Operations | $14,923 | $19,060 | $19,144 | $19,215 | $19,236 | $19,270 | $19,302 | $19,384 | $19,404 | $19,422 | $19,443 | $19,440 | |
| 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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Long-term Liabilities Principal Repayment | $720 | $726 | $732 | $739 | $745 | $751 | $757 | $764 | $770 | $777 | $783 | $790 | |
| 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 | $0 | $0 | $0 | |
| Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Cash Spent | $15,643 | $19,787 | $19,876 | $19,954 | $19,980 | $20,021 | $20,059 | $20,147 | $20,174 | $20,199 | $20,226 | $20,230 | |
| Net Cash Flow | ($15,643) | ($18,667) | ($17,649) | ($14,057) | ($10,654) | ($9,252) | ($6,635) | ($4,958) | ($1,388) | ($46) | $879 | $1,980 | |
| Cash Balance | $85,557 | $66,890 | $49,241 | $35,184 | $24,530 | $15,279 | $8,644 | $3,686 | $2,298 | $2,252 | $3,131 | $5,111 | |
| 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 | $101,200 | $85,557 | $66,890 | $49,241 | $35,184 | $24,530 | $15,279 | $8,644 | $3,686 | $2,298 | $2,252 | $3,131 | $5,111 |
| Accounts Receivable | $0 | $0 | $3,359 | $9,592 | $13,448 | $15,922 | $18,765 | $23,453 | $27,736 | $29,620 | $31,542 | $32,703 | $33,092 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $101,200 | $85,557 | $70,249 | $58,832 | $48,632 | $40,453 | $34,043 | $32,097 | $31,422 | $31,918 | $33,794 | $35,834 | $38,203 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 |
| Accumulated Depreciation | $0 | $125 | $250 | $375 | $500 | $625 | $750 | $875 | $1,000 | $1,125 | $1,250 | $1,375 | $1,500 |
| Total Long-term Assets | $7,500 | $7,375 | $7,250 | $7,125 | $7,000 | $6,875 | $6,750 | $6,625 | $6,500 | $6,375 | $6,250 | $6,125 | $6,000 |
| Total Assets | $108,700 | $92,932 | $77,499 | $65,957 | $55,632 | $47,328 | $40,793 | $38,722 | $37,922 | $38,293 | $40,044 | $41,959 | $44,203 |
| 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 | $4,135 | $4,216 | $4,287 | $4,306 | $4,340 | $4,368 | $4,449 | $4,470 | $4,487 | $4,507 | $4,505 | $4,505 |
| Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $0 | $4,135 | $4,216 | $4,287 | $4,306 | $4,340 | $4,368 | $4,449 | $4,470 | $4,487 | $4,507 | $4,505 | $4,505 |
| Long-term Liabilities | $50,000 | $49,280 | $48,553 | $47,821 | $47,082 | $46,337 | $45,586 | $44,829 | $44,065 | $43,295 | $42,518 | $41,735 | $40,945 |
| Total Liabilities | $50,000 | $53,415 | $52,769 | $52,108 | $51,388 | $50,677 | $49,955 | $49,278 | $48,534 | $47,781 | $47,025 | $46,240 | $45,450 |
| Paid-in Capital | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 |
| Retained Earnings | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) | ($1,300) |
| Earnings | $0 | ($19,183) | ($33,970) | ($44,851) | ($54,456) | ($62,049) | ($67,861) | ($69,256) | ($69,313) | ($68,188) | ($65,682) | ($62,981) | ($59,947) |
| Total Capital | $58,700 | $39,517 | $24,730 | $13,849 | $4,244 | ($3,349) | ($9,161) | ($10,556) | ($10,613) | ($9,488) | ($6,982) | ($4,281) | ($1,247) |
| Total Liabilities and Capital | $108,700 | $92,932 | $77,499 | $65,957 | $55,632 | $47,328 | $40,793 | $38,722 | $37,922 | $38,293 | $40,044 | $41,959 | $44,203 |
| Net Worth | $58,700 | $39,517 | $24,730 | $13,849 | $4,244 | ($3,349) | ($9,161) | ($10,556) | ($10,613) | ($9,488) | ($6,982) | ($4,281) | ($1,247) |