What's For Dinner?
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 | |||||||||||||
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) |