Gaming Futures, LLC

Start your own business plan »

Computer Programming Business Plan

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