Avant-Garde Shop
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 | ||
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 |