| 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 | |||||||||||||
| Apparel | 0% | $2,720 | $2,747 | $2,775 | $2,802 | $2,830 | $2,859 | $2,887 | $2,916 | $2,945 | $2,975 | $3,005 | $3,035 |
| Stationary | 0% | $950 | $960 | $969 | $979 | $989 | $998 | $1,008 | $1,019 | $1,029 | $1,039 | $1,049 | $1,060 |
| Novelty | 0% | $1,750 | $1,768 | $1,785 | $1,803 | $1,821 | $1,839 | $1,858 | $1,876 | $1,895 | $1,914 | $1,933 | $1,952 |
| Accessories | 0% | $800 | $808 | $816 | $824 | $832 | $841 | $849 | $858 | $866 | $875 | $884 | $893 |
| Traditional Arts & Crafts | 0% | $300 | $303 | $306 | $309 | $312 | $315 | $318 | $322 | $325 | $328 | $331 | $335 |
| Books & Magazines | 0% | $400 | $404 | $408 | $412 | $416 | $420 | $425 | $429 | $433 | $437 | $442 | $446 |
| Others | 0% | $200 | $202 | $204 | $206 | $208 | $210 | $212 | $214 | $217 | $219 | $221 | $223 |
| Total Sales | $7,120 | $7,191 | $7,263 | $7,336 | $7,409 | $7,483 | $7,558 | $7,634 | $7,710 | $7,787 | $7,865 | $7,944 | |
| 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 | |
| Apparel | $805 | $805 | $805 | $805 | $805 | $805 | $805 | $805 | $805 | $805 | $805 | $805 | |
| Stationary | $281 | $281 | $281 | $281 | $281 | $281 | $281 | $281 | $281 | $281 | $281 | $281 | |
| Novelty | $518 | $518 | $518 | $518 | $518 | $518 | $518 | $518 | $518 | $518 | $518 | $518 | |
| Accessory | $237 | $237 | $237 | $237 | $237 | $237 | $237 | $237 | $237 | $237 | $237 | $237 | |
| Traditional Arts & Crafts | $89 | $89 | $89 | $89 | $89 | $89 | $89 | $89 | $89 | $89 | $89 | $89 | |
| Books & Magazines | $118 | $118 | $118 | $118 | $118 | $118 | $118 | $118 | $118 | $118 | $118 | $118 | |
| Others | $59 | $59 | $59 | $59 | $59 | $59 | $59 | $59 | $59 | $59 | $59 | $59 | |
| Subtotal Direct Cost of Sales | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | |
| 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 | ||
| Store Staff | 0% | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 |
| Marketing/Store Manager | 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 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,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 | $7,120 | $7,191 | $7,263 | $7,336 | $7,409 | $7,483 | $7,558 | $7,634 | $7,710 | $7,787 | $7,865 | $7,944 | |
| Direct Cost of Sales | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | |
| Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | $2,107 | |
| Gross Margin | $5,013 | $5,084 | $5,156 | $5,229 | $5,302 | $5,376 | $5,451 | $5,527 | $5,603 | $5,680 | $5,758 | $5,837 | |
| Gross Margin % | 70.41% | 70.70% | 70.99% | 71.28% | 71.56% | 71.85% | 72.12% | 72.40% | 72.67% | 72.94% | 73.21% | 73.48% | |
| Expenses | |||||||||||||
| Payroll | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | |
| Marketing/Promotion | $376 | $376 | $376 | $376 | $376 | $376 | $376 | $376 | $376 | $376 | $376 | $376 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | |
| Utilities | 15% | $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 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Total Operating Expenses | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | |
| Profit Before Interest and Taxes | ($763) | ($692) | ($620) | ($547) | ($474) | ($400) | ($325) | ($249) | ($173) | ($96) | ($18) | $60 | |
| EBITDA | ($763) | ($692) | ($620) | ($547) | ($474) | ($400) | ($325) | ($249) | ($173) | ($96) | ($18) | $60 | |
| 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 | ($763) | ($692) | ($620) | ($547) | ($474) | ($400) | ($325) | ($249) | ($173) | ($96) | ($18) | $60 | |
| Net Profit/Sales | -10.71% | -9.62% | -8.54% | -7.46% | -6.40% | -5.34% | -4.30% | -3.27% | -2.25% | -1.23% | -0.23% | 0.76% | |
| 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 | $7,120 | $7,191 | $7,263 | $7,336 | $7,409 | $7,483 | $7,558 | $7,634 | $7,710 | $7,787 | $7,865 | $7,944 | |
| Subtotal Cash from Operations | $7,120 | $7,191 | $7,263 | $7,336 | $7,409 | $7,483 | $7,558 | $7,634 | $7,710 | $7,787 | $7,865 | $7,944 | |
| 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 | $7,120 | $7,191 | $7,263 | $7,336 | $7,409 | $7,483 | $7,558 | $7,634 | $7,710 | $7,787 | $7,865 | $7,944 | |
| 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 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | |
| Bill Payments | $133 | $3,976 | $3,976 | $3,976 | $3,976 | $3,976 | $3,976 | $3,976 | $3,976 | $3,976 | $4,504 | $19,288 | |
| Subtotal Spent on Operations | $1,933 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $6,304 | $21,088 | |
| 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 | $1,933 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $5,776 | $6,304 | $21,088 | |
| Net Cash Flow | $5,187 | $1,415 | $1,487 | $1,559 | $1,633 | $1,707 | $1,782 | $1,857 | $1,934 | $2,011 | $1,561 | ($13,145) | |
| Cash Balance | $74,502 | $75,918 | $77,405 | $78,964 | $80,597 | $82,304 | $84,086 | $85,943 | $87,877 | $89,887 | $91,448 | $78,303 | |
| 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 | $69,315 | $74,502 | $75,918 | $77,405 | $78,964 | $80,597 | $82,304 | $84,086 | $85,943 | $87,877 | $89,887 | $91,448 | $78,303 |
| Inventory | $25,282 | $23,175 | $21,068 | $18,962 | $16,855 | $14,748 | $12,641 | $10,534 | $8,427 | $6,321 | $4,214 | $17,947 | $15,840 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $94,597 | $97,678 | $96,986 | $96,366 | $95,819 | $95,345 | $94,945 | $94,620 | $94,370 | $94,197 | $94,101 | $109,395 | $94,143 |
| 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 | $94,597 | $97,678 | $96,986 | $96,366 | $95,819 | $95,345 | $94,945 | $94,620 | $94,370 | $94,197 | $94,101 | $109,395 | $94,143 |
| 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 | $3,843 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $19,156 | $3,844 |
| 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 | $3,843 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $19,156 | $3,844 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $0 | $3,843 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $3,844 | $19,156 | $3,844 |
| Paid-in Capital | $166,597 | $166,597 | $166,597 | $166,597 | $166,597 | $166,597 | $166,597 | $166,597 | $166,597 | $166,597 | $166,597 | $166,597 | $166,597 |
| Retained Earnings | ($72,000) | ($72,000) | ($72,000) | ($72,000) | ($72,000) | ($72,000) | ($72,000) | ($72,000) | ($72,000) | ($72,000) | ($72,000) | ($72,000) | ($72,000) |
| Earnings | $0 | ($763) | ($1,455) | ($2,075) | ($2,622) | ($3,096) | ($3,496) | ($3,821) | ($4,070) | ($4,244) | ($4,340) | ($4,358) | ($4,297) |
| Total Capital | $94,597 | $93,834 | $93,142 | $92,522 | $91,975 | $91,501 | $91,101 | $90,776 | $90,527 | $90,353 | $90,257 | $90,239 | $90,300 |
| Total Liabilities and Capital | $94,597 | $97,678 | $96,986 | $96,366 | $95,819 | $95,345 | $94,945 | $94,620 | $94,370 | $94,197 | $94,101 | $109,395 | $94,143 |
| Net Worth | $94,597 | $93,834 | $93,142 | $92,522 | $91,975 | $91,501 | $91,101 | $90,776 | $90,527 | $90,353 | $90,257 | $90,239 | $90,300 |