Studio67
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 | ||
Unit Sales | |||||||||||||
Meals | 0% | 779 | 1,053 | 1,505 | 1,553 | 1,652 | 1,633 | 1,173 | 1,520 | 2,066 | 2,602 | 3,451 | 3,835 |
Drinks | 50% | 390 | 527 | 753 | 777 | 826 | 817 | 587 | 760 | 1,033 | 1,301 | 1,726 | 1,918 |
Other | 0% | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 |
Total Unit Sales | 1,189 | 1,600 | 2,278 | 2,350 | 2,498 | 2,470 | 1,780 | 2,300 | 3,119 | 3,923 | 5,197 | 5,773 | |
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 | |
Meals | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | |
Drinks | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | |
Other | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | |
Sales | |||||||||||||
Meals | $11,685 | $15,795 | $22,575 | $23,295 | $24,780 | $24,495 | $17,595 | $22,800 | $30,990 | $39,030 | $51,765 | $57,525 | |
Drinks | $780 | $1,054 | $1,506 | $1,554 | $1,652 | $1,634 | $1,174 | $1,520 | $2,066 | $2,602 | $3,452 | $3,836 | |
Other | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Total Sales | $12,665 | $17,049 | $24,281 | $25,049 | $26,632 | $26,329 | $18,969 | $24,520 | $33,256 | $41,832 | $55,417 | $61,561 | |
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 | |
Meals | 0.00% | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 |
Drinks | 0.00% | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 |
Other | 0.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 | |||||||||||||
Meals | $1,558 | $2,106 | $3,010 | $3,106 | $3,304 | $3,266 | $2,346 | $3,040 | $4,132 | $5,204 | $6,902 | $7,670 | |
Drinks | $195 | $264 | $377 | $389 | $413 | $409 | $294 | $380 | $517 | $651 | $863 | $959 | |
Other | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | |
Subtotal Direct Cost of Sales | $1,773 | $2,390 | $3,407 | $3,515 | $3,737 | $3,695 | $2,660 | $3,440 | $4,669 | $5,875 | $7,785 | $8,649 |
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 | ||
Manager | 0% | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Hostess | 0% | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
Chef | 0% | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 |
Cleaning | 0% | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Waiters | 0% | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
Other | 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 |
Total People | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
Total Payroll | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 |
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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | $12,665 | $17,049 | $24,281 | $25,049 | $26,632 | $26,329 | $18,969 | $24,520 | $33,256 | $41,832 | $55,417 | $61,561 | |
Direct Cost of Sales | $1,773 | $2,390 | $3,407 | $3,515 | $3,737 | $3,695 | $2,660 | $3,440 | $4,669 | $5,875 | $7,785 | $8,649 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $1,773 | $2,390 | $3,407 | $3,515 | $3,737 | $3,695 | $2,660 | $3,440 | $4,669 | $5,875 | $7,785 | $8,649 | |
Gross Margin | $10,892 | $14,660 | $20,875 | $21,535 | $22,895 | $22,635 | $16,310 | $21,080 | $28,588 | $35,958 | $47,632 | $52,912 | |
Gross Margin % | 86.00% | 85.98% | 85.97% | 85.97% | 85.97% | 85.97% | 85.98% | 85.97% | 85.96% | 85.96% | 85.95% | 85.95% | |
Expenses | |||||||||||||
Payroll | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | |
Sales and Marketing and Other Expenses | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | |
Depreciation | 5% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Utilities | 5% | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 |
Payroll Taxes | 15% | $3,525 | $3,525 | $3,525 | $3,525 | $3,525 | $3,525 | $3,525 | $3,525 | $3,525 | $3,525 | $3,525 | $3,525 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $29,375 | $29,375 | $29,375 | $29,375 | $29,375 | $29,375 | $29,375 | $29,375 | $29,375 | $29,375 | $29,375 | $29,375 | |
Profit Before Interest and Taxes | ($18,483) | ($14,716) | ($8,501) | ($7,841) | ($6,480) | ($6,741) | ($13,066) | ($8,295) | ($788) | $6,583 | $18,257 | $23,537 | |
EBITDA | ($18,483) | ($14,716) | ($8,501) | ($7,841) | ($6,480) | ($6,741) | ($13,066) | ($8,295) | ($788) | $6,583 | $18,257 | $23,537 | |
Interest Expense | $829 | $825 | $821 | $817 | $813 | $808 | $804 | $800 | $795 | $791 | $787 | $782 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($19,312) | ($15,541) | ($9,322) | ($8,657) | ($7,293) | ($7,549) | ($13,870) | ($9,095) | ($1,583) | $5,791 | $17,470 | $22,755 | |
Net Profit/Sales | -152.49% | -91.15% | -38.39% | -34.56% | -27.38% | -28.67% | -73.12% | -37.09% | -4.76% | 13.84% | 31.53% | 36.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 | $12,665 | $17,049 | $24,281 | $25,049 | $26,632 | $26,329 | $18,969 | $24,520 | $33,256 | $41,832 | $55,417 | $61,561 | |
Subtotal Cash from Operations | $12,665 | $17,049 | $24,281 | $25,049 | $26,632 | $26,329 | $18,969 | $24,520 | $33,256 | $41,832 | $55,417 | $61,561 | |
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 | $12,665 | $17,049 | $24,281 | $25,049 | $26,632 | $26,329 | $18,969 | $24,520 | $33,256 | $41,832 | $55,417 | $61,561 | |
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 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | |
Bill Payments | $1,283 | $8,498 | $9,123 | $10,106 | $10,214 | $10,423 | $10,343 | $9,365 | $10,156 | $11,379 | $12,604 | $14,475 | |
Subtotal Spent on Operations | $24,783 | $31,998 | $32,623 | $33,606 | $33,714 | $33,923 | $33,843 | $32,865 | $33,656 | $34,879 | $36,104 | $37,975 | |
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 | $488 | $492 | $496 | $500 | $505 | $509 | $513 | $517 | $522 | $526 | $530 | $535 | |
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 | $25,271 | $32,490 | $33,119 | $34,106 | $34,219 | $34,432 | $34,356 | $33,382 | $34,178 | $35,405 | $36,634 | $38,510 | |
Net Cash Flow | ($12,606) | ($15,441) | ($8,838) | ($9,057) | ($7,587) | ($8,103) | ($15,387) | ($8,862) | ($922) | $6,427 | $18,783 | $23,051 | |
Cash Balance | $75,394 | $59,954 | $51,115 | $42,058 | $34,472 | $26,369 | $10,981 | $2,120 | $1,198 | $7,625 | $26,408 | $49,459 |
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 | $88,000 | $75,394 | $59,954 | $51,115 | $42,058 | $34,472 | $26,369 | $10,981 | $2,120 | $1,198 | $7,625 | $26,408 | $49,459 |
Other Current Assets | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 |
Total Current Assets | $138,000 | $125,394 | $109,954 | $101,115 | $92,058 | $84,472 | $76,369 | $60,981 | $52,120 | $51,198 | $57,625 | $76,408 | $99,459 |
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 | $138,000 | $125,394 | $109,954 | $101,115 | $92,058 | $84,472 | $76,369 | $60,981 | $52,120 | $51,198 | $57,625 | $76,408 | $99,459 |
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 | $1,000 | $8,195 | $8,787 | $9,766 | $9,866 | $10,077 | $10,032 | $9,027 | $9,778 | $10,961 | $12,123 | $13,965 | $14,796 |
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 | $1,000 | $8,195 | $8,787 | $9,766 | $9,866 | $10,077 | $10,032 | $9,027 | $9,778 | $10,961 | $12,123 | $13,965 | $14,796 |
Long-term Liabilities | $100,000 | $99,512 | $99,020 | $98,524 | $98,024 | $97,519 | $97,010 | $96,497 | $95,980 | $95,458 | $94,932 | $94,402 | $93,867 |
Total Liabilities | $101,000 | $107,707 | $107,807 | $108,290 | $107,890 | $107,596 | $107,042 | $105,524 | $105,758 | $106,419 | $107,055 | $108,367 | $108,663 |
Paid-in Capital | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 |
Retained Earnings | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) |
Earnings | $0 | ($19,312) | ($34,853) | ($44,174) | ($52,832) | ($60,124) | ($67,673) | ($81,543) | ($90,638) | ($92,221) | ($86,429) | ($68,959) | ($46,204) |
Total Capital | $37,000 | $17,688 | $2,147 | ($7,174) | ($15,832) | ($23,124) | ($30,673) | ($44,543) | ($53,638) | ($55,221) | ($49,429) | ($31,959) | ($9,204) |
Total Liabilities and Capital | $138,000 | $125,394 | $109,954 | $101,115 | $92,058 | $84,472 | $76,369 | $60,981 | $52,120 | $51,198 | $57,625 | $76,408 | $99,459 |
Net Worth | $37,000 | $17,688 | $2,147 | ($7,174) | ($15,832) | ($23,124) | ($30,673) | ($44,543) | ($53,638) | ($55,221) | ($49,429) | ($31,959) | ($9,204) |