Gaming Futures, LLC
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 | |||||||||||||
Projects | 0% | $0 | $0 | $10,000 | $15,000 | $17,000 | $24,000 | $28,000 | $30,000 | $30,000 | $35,000 | $40,000 | $50,000 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $0 | $0 | $10,000 | $15,000 | $17,000 | $24,000 | $28,000 | $30,000 | $30,000 | $35,000 | $40,000 | $50,000 | |
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 | |
Projects | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
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 | ||
Bill Kerl | 0% | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Diane Huber | 0% | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Marcus Hathcock | 0% | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Jillian Daley | 0% | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Jeremy Lang | 0% | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
President | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
Total Payroll | $0 | $0 | $0 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 |
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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | $0 | $0 | $10,000 | $15,000 | $17,000 | $24,000 | $28,000 | $30,000 | $30,000 | $35,000 | $40,000 | $50,000 | |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Gross Margin | $0 | $0 | $10,000 | $15,000 | $17,000 | $24,000 | $28,000 | $30,000 | $30,000 | $35,000 | $40,000 | $50,000 | |
Gross Margin % | 0.00% | 0.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
Expenses | |||||||||||||
Payroll | $0 | $0 | $0 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | |
Sales and Marketing and Other Expenses | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Depreciation | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Insurance | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Rent | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $4,033 | $4,033 | $4,033 | $21,283 | $21,283 | $21,283 | $21,283 | $21,283 | $21,283 | $21,283 | $21,283 | $21,283 | |
Profit Before Interest and Taxes | ($4,033) | ($4,033) | $5,967 | ($6,283) | ($4,283) | $2,717 | $6,717 | $8,717 | $8,717 | $13,717 | $18,717 | $28,717 | |
EBITDA | ($3,200) | ($3,200) | $6,800 | ($5,450) | ($3,450) | $3,550 | $7,550 | $9,550 | $9,550 | $14,550 | $19,550 | $29,550 | |
Interest Expense | $820 | $807 | $793 | $780 | $767 | $753 | $740 | $727 | $713 | $700 | $687 | $673 | |
Taxes Incurred | ($1,456) | ($1,452) | $1,552 | ($2,119) | ($1,515) | $589 | $1,793 | $2,397 | $2,401 | $3,905 | $5,409 | $8,413 | |
Net Profit | ($3,397) | ($3,388) | $3,622 | ($4,944) | ($3,535) | $1,375 | $4,184 | $5,593 | $5,603 | $9,112 | $12,621 | $19,631 | |
Net Profit/Sales | 0.00% | 0.00% | 36.22% | -32.96% | -20.79% | 5.73% | 14.94% | 18.64% | 18.68% | 26.03% | 31.55% | 39.26% |
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 | $0 | $0 | $2,500 | $3,750 | $4,250 | $6,000 | $7,000 | $7,500 | $7,500 | $8,750 | $10,000 | $12,500 | |
Cash from Receivables | $0 | $0 | $0 | $250 | $7,625 | $11,300 | $12,925 | $18,100 | $21,050 | $22,500 | $22,625 | $26,375 | |
Subtotal Cash from Operations | $0 | $0 | $2,500 | $4,000 | $11,875 | $17,300 | $19,925 | $25,600 | $28,550 | $31,250 | $32,625 | $38,875 | |
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 | $0 | $0 | $2,500 | $4,000 | $11,875 | $17,300 | $19,925 | $25,600 | $28,550 | $31,250 | $32,625 | $38,875 | |
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 | $0 | $0 | $0 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | |
Bill Payments | $85 | $2,564 | $2,654 | $5,498 | $4,131 | $4,771 | $6,832 | $8,003 | $8,573 | $8,614 | $10,105 | $11,645 | |
Subtotal Spent on Operations | $85 | $2,564 | $2,654 | $20,498 | $19,131 | $19,771 | $21,832 | $23,003 | $23,573 | $23,614 | $25,105 | $26,645 | |
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,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | |
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,685 | $4,164 | $4,254 | $22,098 | $20,731 | $21,371 | $23,432 | $24,603 | $25,173 | $25,214 | $26,705 | $28,245 | |
Net Cash Flow | ($1,685) | ($4,164) | ($1,754) | ($18,098) | ($8,856) | ($4,071) | ($3,507) | $997 | $3,377 | $6,036 | $5,920 | $10,630 | |
Cash Balance | $59,015 | $54,851 | $53,096 | $34,999 | $26,143 | $22,071 | $18,564 | $19,562 | $22,938 | $28,974 | $34,894 | $45,524 |
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 | $60,700 | $59,015 | $54,851 | $53,096 | $34,999 | $26,143 | $22,071 | $18,564 | $19,562 | $22,938 | $28,974 | $34,894 | $45,524 |
Accounts Receivable | $0 | $0 | $0 | $7,500 | $18,500 | $23,625 | $30,325 | $38,400 | $42,800 | $44,250 | $48,000 | $55,375 | $66,500 |
Other Current Assets | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 |
Total Current Assets | $80,700 | $79,015 | $74,851 | $80,596 | $73,499 | $69,768 | $72,396 | $76,964 | $82,362 | $87,188 | $96,974 | $110,269 | $132,024 |
Long-term Assets | |||||||||||||
Long-term Assets | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 |
Accumulated Depreciation | $0 | $833 | $1,666 | $2,499 | $3,332 | $4,165 | $4,998 | $5,831 | $6,664 | $7,497 | $8,330 | $9,163 | $9,996 |
Total Long-term Assets | $70,000 | $69,167 | $68,334 | $67,501 | $66,668 | $65,835 | $65,002 | $64,169 | $63,336 | $62,503 | $61,670 | $60,837 | $60,004 |
Total Assets | $150,700 | $148,182 | $143,185 | $148,097 | $140,167 | $135,603 | $137,398 | $141,133 | $145,698 | $149,691 | $158,644 | $171,106 | $192,028 |
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 | $2,479 | $2,470 | $5,361 | $3,974 | $4,545 | $6,566 | $7,717 | $8,288 | $8,279 | $9,720 | $11,161 | $14,052 |
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 | $2,479 | $2,470 | $5,361 | $3,974 | $4,545 | $6,566 | $7,717 | $8,288 | $8,279 | $9,720 | $11,161 | $14,052 |
Long-term Liabilities | $100,000 | $98,400 | $96,800 | $95,200 | $93,600 | $92,000 | $90,400 | $88,800 | $87,200 | $85,600 | $84,000 | $82,400 | $80,800 |
Total Liabilities | $100,000 | $100,879 | $99,270 | $100,561 | $97,574 | $96,545 | $96,966 | $96,517 | $95,488 | $93,879 | $93,720 | $93,561 | $94,852 |
Paid-in Capital | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 |
Retained Earnings | ($124,300) | ($124,300) | ($124,300) | ($124,300) | ($124,300) | ($124,300) | ($124,300) | ($124,300) | ($124,300) | ($124,300) | ($124,300) | ($124,300) | ($124,300) |
Earnings | $0 | ($3,397) | ($6,785) | ($3,163) | ($8,107) | ($11,642) | ($10,268) | ($6,084) | ($490) | $5,112 | $14,224 | $26,845 | $46,476 |
Total Capital | $50,700 | $47,303 | $43,915 | $47,537 | $42,593 | $39,058 | $40,432 | $44,616 | $50,210 | $55,812 | $64,924 | $77,545 | $97,176 |
Total Liabilities and Capital | $150,700 | $148,182 | $143,185 | $148,097 | $140,167 | $135,603 | $137,398 | $141,133 | $145,698 | $149,691 | $158,644 | $171,106 | $192,028 |
Net Worth | $50,700 | $47,303 | $43,915 | $47,537 | $42,593 | $39,058 | $40,432 | $44,616 | $50,210 | $55,812 | $64,924 | $77,545 | $97,176 |