Discover Productions
Appendix
Personnel Plan | |||||||||||||
Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
All departments | 0% | $36,231 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | |
Total Payroll | $36,231 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 |
Sales Forecast | |||||||||||||
Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
Sales | |||||||||||||
Hosting Services | 0% | $13,953 | $13,953 | $16,279 | $19,767 | $23,255 | $23,255 | $23,255 | $23,255 | $23,255 | $23,255 | $23,255 | $23,255 |
Internet Sales | 0% | $18,140 | $18,140 | $21,163 | $25,698 | $30,233 | $30,233 | $30,233 | $30,233 | $30,233 | $30,233 | $30,233 | $30,233 |
Computing Solutions | 0% | $27,907 | $27,907 | $32,558 | $39,535 | $46,512 | $46,512 | $46,512 | $46,512 | $46,512 | $46,512 | $46,512 | $46,512 |
Total Sales | $60,000 | $60,000 | $70,000 | $85,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | |
Direct Cost of Sales | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
Hosting Services | $1,298 | $1,298 | $1,514 | $1,839 | $2,163 | $2,163 | $2,163 | $2,163 | $2,163 | $2,163 | $2,163 | $2,163 | |
Internet Sales | $1,687 | $1,687 | $1,969 | $2,390 | $2,813 | $2,813 | $2,813 | $2,813 | $2,813 | $2,813 | $2,813 | $2,812 | |
Computing Solutions | $2,595 | $2,595 | $3,028 | $3,677 | $4,327 | $4,327 | $4,327 | $4,327 | $4,327 | $4,327 | $4,327 | $4,327 | |
Subtotal Direct Cost of Sales | $5,580 | $5,580 | $6,511 | $7,906 | $9,303 | $9,303 | $9,303 | $9,303 | $9,303 | $9,303 | $9,303 | $9,302 |
General Assumptions | |||||||||||||
Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
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 Cash Flow | |||||||||||||
Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $15,000 | $15,000 | $17,500 | $21,250 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | |
Cash from Receivables | $20,000 | $21,500 | $45,000 | $45,250 | $52,875 | $64,125 | $75,000 | $75,000 | $75,000 | $75,000 | $75,000 | $75,000 | |
Subtotal Cash from Operations | $35,000 | $36,500 | $62,500 | $66,500 | $77,875 | $89,125 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | |
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 | $914,900 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $3,000,000 | $0 | $0 | $0 | |
Subtotal Cash Received | $949,900 | $36,500 | $62,500 | $66,500 | $77,875 | $89,125 | $100,000 | $100,000 | $3,100,000 | $100,000 | $100,000 | $100,000 | |
Expenditures | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
Expenditures from Operations | |||||||||||||
Cash Spending | $36,231 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | |
Bill Payments | $32,126 | $63,773 | $63,771 | $63,750 | $65,140 | $66,491 | $66,491 | $66,491 | $66,491 | $66,491 | $66,491 | $66,491 | |
Subtotal Spent on Operations | $68,357 | $100,005 | $100,003 | $99,982 | $101,372 | $102,723 | $102,723 | $102,723 | $102,723 | $102,723 | $102,723 | $102,723 | |
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 | $0 | $0 | $0 | $646 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Long-term Assets | $22,000 | $30,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $90,357 | $130,005 | $200,003 | $200,628 | $201,372 | $202,723 | $202,723 | $202,723 | $202,723 | $202,723 | $202,723 | $202,723 | |
Net Cash Flow | $859,543 | ($93,505) | ($137,503) | ($134,128) | ($123,497) | ($113,598) | ($102,723) | ($102,723) | $2,897,277 | ($102,723) | ($102,723) | ($102,723) | |
Cash Balance | $889,543 | $796,038 | $658,535 | $524,407 | $400,910 | $287,312 | $184,589 | $81,866 | $2,979,144 | $2,876,421 | $2,773,698 | $2,670,975 |
Pro Forma Profit and Loss | |||||||||||||
Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
Sales | $60,000 | $60,000 | $70,000 | $85,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | |
Direct Cost of Sales | $5,580 | $5,580 | $6,511 | $7,906 | $9,303 | $9,303 | $9,303 | $9,303 | $9,303 | $9,303 | $9,303 | $9,302 | |
Other | $4,000 | $4,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Total Cost of Sales | $9,580 | $9,580 | $9,511 | $10,906 | $12,303 | $12,303 | $12,303 | $12,303 | $12,303 | $12,303 | $12,303 | $12,302 | |
Gross Margin | $50,420 | $50,420 | $60,489 | $74,094 | $87,697 | $87,697 | $87,697 | $87,697 | $87,697 | $87,697 | $87,697 | $87,698 | |
Gross Margin % | 84.03% | 84.03% | 86.41% | 87.17% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | |
Expenses | |||||||||||||
Payroll | $36,231 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | |
Sales and Marketing and Other Expenses | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | |
Depreciation | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Utilities | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Insurance | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | |
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 | |
Utilities | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Continuing Education | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Payroll Taxes | 15% | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $92,966 | $92,967 | $92,967 | $92,967 | $92,967 | $92,967 | $92,967 | $92,967 | $92,967 | $92,967 | $92,967 | $92,967 | |
Profit Before Interest and Taxes | ($42,546) | ($42,547) | ($32,478) | ($18,873) | ($5,270) | ($5,270) | ($5,270) | ($5,270) | ($5,270) | ($5,270) | ($5,270) | ($5,269) | |
EBITDA | ($39,546) | ($39,547) | ($29,478) | ($15,873) | ($2,270) | ($2,270) | ($2,270) | ($2,270) | ($2,270) | ($2,270) | ($2,270) | ($2,269) | |
Interest Expense | $458 | $458 | $458 | $453 | $453 | $453 | $453 | $453 | $453 | $453 | $453 | $453 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($43,004) | ($43,005) | ($32,936) | ($19,326) | ($5,723) | ($5,723) | ($5,723) | ($5,723) | ($5,723) | ($5,723) | ($5,723) | ($5,722) | |
Net Profit/Sales | -71.67% | -71.68% | -47.05% | -22.74% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% |
Pro Forma Balance Sheet | |||||||||||||
Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $30,000 | $889,543 | $796,038 | $658,535 | $524,407 | $400,910 | $287,312 | $184,589 | $81,866 | $2,979,144 | $2,876,421 | $2,773,698 | $2,670,975 |
Accounts Receivable | $40,000 | $65,000 | $88,500 | $96,000 | $114,500 | $136,625 | $147,500 | $147,500 | $147,500 | $147,500 | $147,500 | $147,500 | $147,500 |
Other Current Assets | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Total Current Assets | $75,000 | $959,543 | $889,538 | $759,535 | $643,907 | $542,535 | $439,812 | $337,089 | $234,366 | $3,131,644 | $3,028,921 | $2,926,198 | $2,823,475 |
Long-term Assets | |||||||||||||
Long-term Assets | $100,000 | $122,000 | $152,000 | $252,000 | $352,000 | $452,000 | $552,000 | $652,000 | $752,000 | $852,000 | $952,000 | $1,052,000 | $1,152,000 |
Accumulated Depreciation | $20,000 | $23,000 | $26,000 | $29,000 | $32,000 | $35,000 | $38,000 | $41,000 | $44,000 | $47,000 | $50,000 | $53,000 | $56,000 |
Total Long-term Assets | $80,000 | $99,000 | $126,000 | $223,000 | $320,000 | $417,000 | $514,000 | $611,000 | $708,000 | $805,000 | $902,000 | $999,000 | $1,096,000 |
Total Assets | $155,000 | $1,058,543 | $1,015,538 | $982,535 | $963,907 | $959,535 | $953,812 | $948,089 | $942,366 | $3,936,644 | $3,930,921 | $3,925,198 | $3,919,475 |
Liabilities and Capital | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
Current Liabilities | |||||||||||||
Accounts Payable | $30,000 | $61,647 | $61,647 | $61,581 | $62,924 | $64,274 | $64,274 | $64,274 | $64,274 | $64,274 | $64,274 | $64,274 | $64,273 |
Current Borrowing | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $35,000 | $66,647 | $66,647 | $66,581 | $67,924 | $69,274 | $69,274 | $69,274 | $69,274 | $69,274 | $69,274 | $69,274 | $69,273 |
Long-term Liabilities | $50,000 | $50,000 | $50,000 | $50,000 | $49,354 | $49,354 | $49,354 | $49,354 | $49,354 | $49,354 | $49,354 | $49,354 | $49,354 |
Total Liabilities | $85,000 | $116,647 | $116,647 | $116,581 | $117,278 | $118,628 | $118,628 | $118,628 | $118,628 | $118,628 | $118,628 | $118,628 | $118,627 |
Paid-in Capital | $25,000 | $939,900 | $939,900 | $939,900 | $939,900 | $939,900 | $939,900 | $939,900 | $939,900 | $3,939,900 | $3,939,900 | $3,939,900 | $3,939,900 |
Retained Earnings | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 |
Earnings | $0 | ($43,004) | ($86,009) | ($118,945) | ($138,271) | ($143,994) | ($149,717) | ($155,439) | ($161,162) | ($166,885) | ($172,608) | ($178,330) | ($184,052) |
Total Capital | $70,000 | $941,896 | $898,891 | $865,955 | $846,629 | $840,906 | $835,184 | $829,461 | $823,738 | $3,818,015 | $3,812,293 | $3,806,570 | $3,800,848 |
Total Liabilities and Capital | $155,000 | $1,058,543 | $1,015,538 | $982,535 | $963,907 | $959,535 | $953,812 | $948,089 | $942,366 | $3,936,644 | $3,930,921 | $3,925,198 | $3,919,475 |
Net Worth | $70,000 | $941,896 | $898,891 | $865,955 | $846,629 | $840,906 | $835,183 | $829,461 | $823,738 | $3,818,015 | $3,812,293 | $3,806,570 | $3,800,848 |