| 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 | |||||||||||||
| Belgian Fries | 2% | 1,000 | 1,200 | 1,440 | 1,728 | 2,074 | 2,488 | 3,981 | 4,778 | 5,733 | 6,880 | 8,256 | 9,907 |
| Italian Soda | 2% | 650 | 780 | 936 | 1,123 | 1,348 | 1,617 | 2,426 | 2,790 | 3,209 | 3,690 | 4,243 | 4,880 |
| Merchandising | 2% | 100 | 120 | 144 | 160 | 180 | 220 | 299 | 358 | 430 | 516 | 619 | 743 |
| Signature Packaged Sauces | 1% | 100 | 118 | 139 | 150 | 150 | 150 | 270 | 319 | 376 | 444 | 523 | 618 |
| Total Unit Sales | 1,850 | 2,218 | 2,659 | 3,161 | 3,751 | 4,476 | 6,976 | 8,244 | 9,747 | 11,529 | 13,641 | 16,147 | |
| 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 | |
| Belgian Fries | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | |
| Italian Soda | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | |
| Merchandising | $8.50 | $8.50 | $8.50 | $8.50 | $8.50 | $8.50 | $8.50 | $8.50 | $8.50 | $8.50 | $8.50 | $8.50 | |
| Signature Packaged Sauces | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | |
| Sales | |||||||||||||
| Belgian Fries | $4,000 | $4,800 | $5,760 | $6,912 | $8,294 | $9,953 | $15,925 | $19,110 | $22,932 | $27,519 | $33,023 | $39,627 | |
| Italian Soda | $975 | $1,170 | $1,404 | $1,685 | $2,022 | $2,426 | $3,639 | $4,185 | $4,813 | $5,535 | $6,365 | $7,320 | |
| Merchandising | $850 | $1,020 | $1,224 | $1,360 | $1,530 | $1,870 | $2,538 | $3,046 | $3,655 | $4,386 | $5,263 | $6,316 | |
| Signature Packaged Sauces | $200 | $236 | $278 | $300 | $300 | $300 | $540 | $637 | $752 | $887 | $1,047 | $1,235 | |
| Total Sales | $6,025 | $7,226 | $8,666 | $10,257 | $12,146 | $14,549 | $22,642 | $26,978 | $32,152 | $38,326 | $45,697 | $54,498 | |
| 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 | |
| Belgian Fries | 20.00% | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 |
| Italian Soda | 10.00% | $0.15 | $0.15 | $0.15 | $0.15 | $0.15 | $0.15 | $0.15 | $0.15 | $0.15 | $0.15 | $0.15 | $0.15 |
| Merchandising | 45.00% | $3.83 | $3.83 | $3.83 | $3.83 | $3.83 | $3.83 | $3.83 | $3.83 | $3.83 | $3.83 | $3.83 | $3.83 |
| Signature Packaged Sauces | 50.00% | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 |
| Direct Cost of Sales | |||||||||||||
| Belgian Fries | $800 | $960 | $1,152 | $1,382 | $1,659 | $1,991 | $3,185 | $3,822 | $4,586 | $5,504 | $6,605 | $7,925 | |
| Italian Soda | $98 | $117 | $140 | $168 | $202 | $243 | $364 | $419 | $481 | $553 | $636 | $732 | |
| Merchandising | $383 | $459 | $551 | $612 | $689 | $842 | $1,142 | $1,371 | $1,645 | $1,974 | $2,368 | $2,842 | |
| Signature Packaged Sauces | $100 | $118 | $139 | $150 | $150 | $150 | $270 | $319 | $376 | $444 | $523 | $618 | |
| Subtotal Direct Cost of Sales | $1,380 | $1,654 | $1,982 | $2,313 | $2,700 | $3,225 | $4,961 | $5,930 | $7,088 | $8,474 | $10,133 | $12,117 | |
| 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 | ||
| Site Managers | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Cashiers | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
| Cook | 0% | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 |
| Busboy | 0% | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 12 | 12 | 12 | 12 | 12 | 12 | |
| Total Payroll | $4,900 | $4,900 | $4,900 | $4,900 | $4,900 | $4,900 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | |
| 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 | $6,025 | $7,226 | $8,666 | $10,257 | $12,146 | $14,549 | $22,642 | $26,978 | $32,152 | $38,326 | $45,697 | $54,498 | |
| Direct Cost of Sales | $1,380 | $1,654 | $1,982 | $2,313 | $2,700 | $3,225 | $4,961 | $5,930 | $7,088 | $8,474 | $10,133 | $12,117 | |
| Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $1,380 | $1,654 | $1,982 | $2,313 | $2,700 | $3,225 | $4,961 | $5,930 | $7,088 | $8,474 | $10,133 | $12,117 | |
| Gross Margin | $4,645 | $5,572 | $6,684 | $7,944 | $9,447 | $11,325 | $17,681 | $21,048 | $25,063 | $29,852 | $35,565 | $42,381 | |
| Gross Margin % | 77.10% | 77.11% | 77.13% | 77.45% | 77.77% | 77.84% | 78.09% | 78.02% | 77.95% | 77.89% | 77.83% | 77.77% | |
| Expenses | |||||||||||||
| Payroll | $4,900 | $4,900 | $4,900 | $4,900 | $4,900 | $4,900 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | |
| Marketing/Promotion | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | |
| Utilities | 15% | $125 | $125 | $125 | $125 | $125 | $125 | $300 | $300 | $300 | $300 | $300 | $300 |
| New location setup | $0 | $0 | $0 | $0 | $0 | $25,000 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $17,858 | $17,858 | $17,858 | $17,858 | $17,858 | $42,858 | $27,933 | $27,933 | $27,933 | $27,933 | $27,933 | $27,933 | |
| Profit Before Interest and Taxes | ($13,213) | ($12,286) | ($11,174) | ($9,914) | ($8,412) | ($31,534) | ($10,252) | ($6,885) | ($2,870) | $1,919 | $7,631 | $14,447 | |
| EBITDA | ($13,213) | ($12,286) | ($11,174) | ($9,914) | ($8,412) | ($31,534) | ($10,252) | ($6,885) | ($2,870) | $1,919 | $7,631 | $14,447 | |
| Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Profit | ($13,213) | ($12,286) | ($11,174) | ($9,914) | ($8,412) | ($31,534) | ($10,252) | ($6,885) | ($2,870) | $1,919 | $7,631 | $14,447 | |
| Net Profit/Sales | -219.30% | -170.03% | -128.94% | -96.66% | -69.25% | -216.74% | -45.28% | -25.52% | -8.93% | 5.01% | 16.70% | 26.51% | |
| 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 | $6,025 | $7,226 | $8,666 | $10,257 | $12,146 | $14,549 | $22,642 | $26,978 | $32,152 | $38,326 | $45,697 | $54,498 | |
| Subtotal Cash from Operations | $6,025 | $7,226 | $8,666 | $10,257 | $12,146 | $14,549 | $22,642 | $26,978 | $32,152 | $38,326 | $45,697 | $54,498 | |
| 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 | $6,025 | $7,226 | $8,666 | $10,257 | $12,146 | $14,549 | $22,642 | $26,978 | $32,152 | $38,326 | $45,697 | $54,498 | |
| 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 | $4,900 | $4,900 | $4,900 | $4,900 | $4,900 | $4,900 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | |
| Bill Payments | $478 | $14,347 | $14,623 | $14,952 | $15,284 | $16,509 | $40,580 | $23,127 | $24,102 | $25,268 | $26,663 | $28,332 | |
| Subtotal Spent on Operations | $5,378 | $19,247 | $19,523 | $19,852 | $20,184 | $21,409 | $50,380 | $32,927 | $33,902 | $35,068 | $36,463 | $38,132 | |
| 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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| 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 | $5,378 | $19,247 | $19,523 | $19,852 | $20,184 | $21,409 | $50,380 | $32,927 | $33,902 | $35,068 | $36,463 | $38,132 | |
| Net Cash Flow | $647 | ($12,021) | ($10,857) | ($9,595) | ($8,038) | ($6,859) | ($27,738) | ($5,949) | ($1,750) | $3,259 | $9,234 | $16,365 | |
| Cash Balance | $731,847 | $719,826 | $708,969 | $699,374 | $691,336 | $684,477 | $656,739 | $650,791 | $649,041 | $652,299 | $661,534 | $677,899 | |
| 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 | $731,200 | $731,847 | $719,826 | $708,969 | $699,374 | $691,336 | $684,477 | $656,739 | $650,791 | $649,041 | $652,299 | $661,534 | $677,899 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $731,200 | $731,847 | $719,826 | $708,969 | $699,374 | $691,336 | $684,477 | $656,739 | $650,791 | $649,041 | $652,299 | $661,534 | $677,899 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Assets | $731,200 | $731,847 | $719,826 | $708,969 | $699,374 | $691,336 | $684,477 | $656,739 | $650,791 | $649,041 | $652,299 | $661,534 | $677,899 |
| 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 | $13,860 | $14,125 | $14,443 | $14,762 | $15,136 | $39,810 | $22,325 | $23,261 | $24,381 | $25,721 | $27,324 | $29,242 |
| 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 | $13,860 | $14,125 | $14,443 | $14,762 | $15,136 | $39,810 | $22,325 | $23,261 | $24,381 | $25,721 | $27,324 | $29,242 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $0 | $13,860 | $14,125 | $14,443 | $14,762 | $15,136 | $39,810 | $22,325 | $23,261 | $24,381 | $25,721 | $27,324 | $29,242 |
| Paid-in Capital | $800,000 | $800,000 | $800,000 | $800,000 | $800,000 | $800,000 | $800,000 | $800,000 | $800,000 | $800,000 | $800,000 | $800,000 | $800,000 |
| Retained Earnings | ($68,800) | ($68,800) | ($68,800) | ($68,800) | ($68,800) | ($68,800) | ($68,800) | ($68,800) | ($68,800) | ($68,800) | ($68,800) | ($68,800) | ($68,800) |
| Earnings | $0 | ($13,213) | ($25,499) | ($36,674) | ($46,588) | ($55,000) | ($86,533) | ($96,785) | ($103,670) | ($106,540) | ($104,621) | ($96,990) | ($82,543) |
| Total Capital | $731,200 | $717,987 | $705,701 | $694,526 | $684,612 | $676,200 | $644,667 | $634,415 | $627,530 | $624,660 | $626,579 | $634,210 | $648,657 |
| Total Liabilities and Capital | $731,200 | $731,847 | $719,826 | $708,969 | $699,374 | $691,336 | $684,477 | $656,739 | $650,791 | $649,041 | $652,299 | $661,534 | $677,899 |
| Net Worth | $731,200 | $717,987 | $705,701 | $694,526 | $684,612 | $676,200 | $644,667 | $634,415 | $627,530 | $624,660 | $626,579 | $634,210 | $648,657 |