| 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 | |||||||||||||
| Party Fees | 0% | $10,500 | $17,500 | $26,250 | $35,000 | $44,297 | $66,445 | $66,445 | $66,445 | $99,667 | $112,125 | $149,500 | $163,500 |
| Other Fees | 0% | $300 | $500 | $750 | $1,000 | $1,266 | $1,898 | $1,898 | $1,898 | $2,848 | $3,204 | $4,271 | $4,671 |
| Total Sales | $10,800 | $18,000 | $27,000 | $36,000 | $45,563 | $68,343 | $68,343 | $68,343 | $102,515 | $115,329 | $153,771 | $168,171 | |
| 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 | |
| Ingredients | $7,500 | $12,500 | $18,750 | $25,000 | $31,641 | $47,461 | $47,461 | $47,461 | $71,191 | $80,089 | $106,786 | $116,786 | |
| Other Supplies | $540 | $900 | $1,350 | $1,800 | $2,278 | $3,417 | $3,417 | $3,417 | $5,126 | $5,766 | $7,689 | $8,409 | |
| Subtotal Direct Cost of Sales | $8,040 | $13,400 | $20,100 | $26,800 | $33,919 | $50,878 | $50,878 | $50,878 | $76,316 | $85,856 | $114,474 | $125,194 | |
| 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 | ||
| Alan Kirby | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
| Kim Kirby | 0% | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 |
| Part-time cleaner | 0% | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Long-term Interest Rate | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Tax Rate | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.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 | $10,800 | $18,000 | $27,000 | $36,000 | $45,563 | $68,343 | $68,343 | $68,343 | $102,515 | $115,329 | $153,771 | $168,171 | |
| Direct Cost of Sales | $8,040 | $13,400 | $20,100 | $26,800 | $33,919 | $50,878 | $50,878 | $50,878 | $76,316 | $85,856 | $114,474 | $125,194 | |
| Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $8,040 | $13,400 | $20,100 | $26,800 | $33,919 | $50,878 | $50,878 | $50,878 | $76,316 | $85,856 | $114,474 | $125,194 | |
| Gross Margin | $2,760 | $4,600 | $6,900 | $9,200 | $11,644 | $17,466 | $17,466 | $17,466 | $26,198 | $29,473 | $39,297 | $42,977 | |
| Gross Margin % | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | |
| Expenses | |||||||||||||
| Payroll | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | |
| Sales and Marketing and Other Expenses | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
| Depreciation | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
| Rent | $4,442 | $4,442 | $4,442 | $4,442 | $4,442 | $4,442 | $4,442 | $4,442 | $4,442 | $4,442 | $4,442 | $4,442 | |
| Utilities | $980 | $1,030 | $1,030 | $1,030 | $1,030 | $980 | $980 | $980 | $1,280 | $1,280 | $1,280 | $1,280 | |
| Office Supplies | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Insurance | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
| Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Accountant | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
| Lawyer | $500 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $500 | |
| Bank Charges | $15 | $15 | $15 | $15 | $15 | $15 | $15 | $15 | $15 | $15 | $15 | $15 | |
| Website Payment Fees | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
| Website Hosting & Support | 0% | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 |
| Repairs and Maintenance | 15% | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $10,395 | $9,945 | $9,945 | $9,945 | $9,945 | $9,895 | $9,895 | $9,895 | $10,195 | $10,195 | $10,195 | $10,695 | |
| Profit Before Interest and Taxes | ($7,635) | ($5,345) | ($3,045) | ($745) | $1,698 | $7,570 | $7,570 | $7,570 | $16,003 | $19,278 | $29,102 | $32,282 | |
| EBITDA | ($7,285) | ($4,995) | ($2,695) | ($395) | $2,048 | $7,920 | $7,920 | $7,920 | $16,353 | $19,628 | $29,452 | $32,632 | |
| Interest Expense | $1,504 | $1,493 | $1,483 | $1,472 | $1,461 | $1,451 | $1,440 | $1,429 | $1,418 | $1,408 | $1,397 | $1,386 | |
| Taxes Incurred | ($2,193) | ($1,641) | ($1,087) | ($532) | $57 | $1,469 | $1,471 | $1,474 | $3,500 | $4,289 | $6,649 | $7,415 | |
| Net Profit | ($6,946) | ($5,198) | ($3,441) | ($1,685) | $180 | $4,651 | $4,659 | $4,667 | $11,084 | $13,581 | $21,056 | $23,481 | |
| Net Profit/Sales | -64.32% | -28.88% | -12.75% | -4.68% | 0.40% | 6.81% | 6.82% | 6.83% | 10.81% | 11.78% | 13.69% | 13.96% | |
| 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 | $10,800 | $18,000 | $27,000 | $36,000 | $45,563 | $68,343 | $68,343 | $68,343 | $102,515 | $115,329 | $153,771 | $168,171 | |
| Subtotal Cash from Operations | $10,800 | $18,000 | $27,000 | $36,000 | $45,563 | $68,343 | $68,343 | $68,343 | $102,515 | $115,329 | $153,771 | $168,171 | |
| 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 | $10,800 | $18,000 | $27,000 | $36,000 | $45,563 | $68,343 | $68,343 | $68,343 | $102,515 | $115,329 | $153,771 | $168,171 | |
| 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 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | $2,833 | |
| Bill Payments | $480 | $14,790 | $26,201 | $34,869 | $42,144 | $51,001 | $78,542 | $60,501 | $62,351 | $115,990 | $110,789 | $160,756 | |
| Subtotal Spent on Operations | $3,314 | $17,624 | $29,034 | $37,703 | $44,977 | $53,834 | $81,375 | $63,334 | $65,184 | $118,824 | $113,622 | $163,589 | |
| 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 | $1,840 | $1,840 | $1,840 | $1,840 | $1,840 | $1,840 | $1,840 | $1,840 | $1,840 | $1,840 | $1,840 | $1,840 | |
| 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,154 | $19,464 | $30,874 | $39,543 | $46,817 | $55,674 | $83,215 | $65,174 | $67,024 | $120,664 | $115,462 | $165,429 | |
| Net Cash Flow | $5,646 | ($1,464) | ($3,874) | ($3,543) | ($1,254) | $12,669 | ($14,872) | $3,169 | $35,491 | ($5,335) | $38,309 | $2,742 | |
| Cash Balance | $39,646 | $38,183 | $34,309 | $30,766 | $29,512 | $42,181 | $27,309 | $30,478 | $65,969 | $60,633 | $98,942 | $101,685 | |
| 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 | $34,000 | $39,646 | $38,183 | $34,309 | $30,766 | $29,512 | $42,181 | $27,309 | $30,478 | $65,969 | $60,633 | $98,942 | $101,685 |
| Inventory | $9,000 | $8,844 | $14,740 | $22,110 | $29,480 | $37,311 | $55,966 | $55,966 | $55,966 | $83,948 | $94,441 | $125,922 | $137,714 |
| Other Current Assets | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 |
| Total Current Assets | $51,000 | $56,490 | $60,923 | $64,419 | $68,246 | $74,822 | $106,146 | $91,274 | $94,444 | $157,917 | $163,075 | $232,864 | $247,399 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $42,000 | $42,000 | $42,000 | $42,000 | $42,000 | $42,000 | $42,000 | $42,000 | $42,000 | $42,000 | $42,000 | $42,000 | $42,000 |
| Accumulated Depreciation | $0 | $350 | $700 | $1,050 | $1,400 | $1,750 | $2,100 | $2,450 | $2,800 | $3,150 | $3,500 | $3,850 | $4,200 |
| Total Long-term Assets | $42,000 | $41,650 | $41,300 | $40,950 | $40,600 | $40,250 | $39,900 | $39,550 | $39,200 | $38,850 | $38,500 | $38,150 | $37,800 |
| Total Assets | $93,000 | $98,140 | $102,223 | $105,369 | $108,846 | $115,072 | $146,046 | $130,824 | $133,644 | $196,767 | $201,575 | $271,014 | $285,199 |
| 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,927 | $25,047 | $33,474 | $40,476 | $48,362 | $76,525 | $58,484 | $58,476 | $112,355 | $105,422 | $155,646 | $148,189 |
| 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,927 | $25,047 | $33,474 | $40,476 | $48,362 | $76,525 | $58,484 | $58,476 | $112,355 | $105,422 | $155,646 | $148,189 |
| Long-term Liabilities | $259,708 | $257,868 | $256,028 | $254,188 | $252,348 | $250,508 | $248,668 | $246,828 | $244,988 | $243,148 | $241,308 | $239,468 | $237,628 |
| Total Liabilities | $259,708 | $271,795 | $281,075 | $287,662 | $292,824 | $298,870 | $325,193 | $305,312 | $303,464 | $355,503 | $346,730 | $395,114 | $385,817 |
| Paid-in Capital | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 |
| Retained Earnings | ($196,708) | ($196,708) | ($196,708) | ($196,708) | ($196,708) | ($196,708) | ($196,708) | ($196,708) | ($196,708) | ($196,708) | ($196,708) | ($196,708) | ($196,708) |
| Earnings | $0 | ($6,946) | ($12,144) | ($15,585) | ($17,270) | ($17,090) | ($12,439) | ($7,780) | ($3,113) | $7,972 | $21,553 | $42,608 | $66,089 |
| Total Capital | ($166,708) | ($173,654) | ($178,852) | ($182,293) | ($183,978) | ($183,798) | ($179,147) | ($174,488) | ($169,821) | ($158,736) | ($145,155) | ($124,100) | ($100,619) |
| Total Liabilities and Capital | $93,000 | $98,140 | $102,223 | $105,369 | $108,846 | $115,072 | $146,046 | $130,824 | $133,644 | $196,767 | $201,575 | $271,014 | $285,199 |
| Net Worth | ($166,708) | ($173,654) | ($178,852) | ($182,293) | ($183,978) | ($183,798) | ($179,147) | ($174,488) | ($169,821) | ($158,736) | ($145,155) | ($124,100) | ($100,619) |