MarketCamp
Appendix
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 | ||
Paul Berry | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $5,000 |
Commission | 0% | $50 | $400 | $623 | $911 | $1,019 | $1,559 | $1,163 | $1,163 | $1,703 | $2,547 | $3,035 | $3,179 |
Programmers | 0% | $0 | $0 | $0 | $0 | $1,200 | $1,400 | $1,800 | $2,500 | $3,000 | $3,000 | $3,300 | $3,700 |
Total People | 0 | 0 | 0 | 1 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | |
Total Payroll | $3,050 | $3,400 | $3,623 | $3,911 | $5,219 | $5,959 | $6,963 | $7,663 | $8,703 | $9,547 | $10,335 | $11,879 |
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 | $5,250 | $10,000 | $10,650 | $13,890 | $16,230 | $22,530 | $20,050 | $22,450 | $32,250 | $42,470 | $47,710 | $53,830 | |
Direct Cost of Sales | $1,300 | $1,600 | $2,063 | $2,639 | $3,093 | $4,047 | $4,149 | $4,746 | $6,003 | $7,707 | $9,227 | $10,609 | |
Other | 10% | $1,000 | $1,200 | $1,440 | $1,728 | $2,074 | $2,488 | $2,986 | $3,583 | $4,300 | $5,160 | $6,192 | $7,430 |
Total Cost of Sales | $2,300 | $2,800 | $3,503 | $4,367 | $5,166 | $6,536 | $7,135 | $8,329 | $10,303 | $12,867 | $15,418 | $18,039 | |
Gross Margin | $2,950 | $7,200 | $7,147 | $9,523 | $11,064 | $15,994 | $12,915 | $14,121 | $21,947 | $29,603 | $32,292 | $35,791 | |
Gross Margin % | 56.19% | 72.00% | 67.11% | 68.56% | 68.17% | 70.99% | 64.41% | 62.90% | 68.05% | 69.70% | 67.68% | 66.49% | |
Expenses | |||||||||||||
Payroll | $3,050 | $3,400 | $3,623 | $3,911 | $5,219 | $5,959 | $6,963 | $7,663 | $8,703 | $9,547 | $10,335 | $11,879 | |
Sales and Marketing and Other Expenses | $1,000 | $1,175 | $1,393 | $1,663 | $2,001 | $2,422 | $2,950 | $3,610 | $4,439 | $5,481 | $6,792 | $8,445 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Leased Equipment | 10% | $400 | $480 | $576 | $691 | $829 | $995 | $1,194 | $1,433 | $1,720 | $2,064 | $2,477 | $2,972 |
Utilities | 10% | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 |
Insurance | 10% | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 |
Rent | 10% | $0 | $0 | $0 | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Payroll Taxes | 20% | $610 | $680 | $725 | $782 | $1,044 | $1,192 | $1,393 | $1,533 | $1,741 | $1,909 | $2,067 | $2,376 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $5,410 | $6,085 | $6,666 | $7,398 | $9,443 | $10,919 | $14,850 | $16,589 | $18,953 | $21,351 | $24,021 | $28,022 | |
Profit Before Interest and Taxes | ($2,460) | $1,115 | $481 | $2,125 | $1,621 | $5,076 | ($1,935) | ($2,469) | $2,995 | $8,252 | $8,271 | $7,769 | |
EBITDA | ($2,460) | $1,115 | $481 | $2,125 | $1,621 | $5,076 | ($1,935) | ($2,469) | $2,995 | $8,252 | $8,271 | $7,769 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $167 | $167 | $167 | $167 | |
Taxes Incurred | ($738) | $279 | $120 | $531 | $405 | $1,269 | ($484) | ($617) | $707 | $2,021 | $2,026 | $1,900 | |
Net Profit | ($1,722) | $836 | $361 | $1,594 | $1,216 | $3,807 | ($1,451) | ($1,851) | $2,121 | $6,064 | $6,078 | $5,701 | |
Net Profit/Sales | -32.80% | 8.36% | 3.39% | 11.48% | 7.49% | 16.90% | -7.24% | -8.25% | 6.58% | 14.28% | 12.74% | 10.59% |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Cash from Receivables | $0 | $175 | $5,408 | $10,022 | $10,758 | $13,968 | $16,440 | $22,447 | $20,130 | $22,777 | $32,591 | $42,645 | |
Subtotal Cash from Operations | $0 | $175 | $5,408 | $10,022 | $10,758 | $13,968 | $16,440 | $22,447 | $20,130 | $22,777 | $32,591 | $42,645 | |
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 | $20,000 | $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 | $7,000 | $4,000 | $3,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $7,000 | $4,175 | $8,408 | $10,022 | $10,758 | $13,968 | $16,440 | $22,447 | $40,130 | $22,777 | $32,591 | $42,645 | |
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 | $3,050 | $3,400 | $3,623 | $3,911 | $5,219 | $5,959 | $6,963 | $7,663 | $8,703 | $9,547 | $10,335 | $11,879 | |
Bill Payments | $131 | $3,983 | $5,794 | $6,724 | $8,432 | $9,894 | $12,823 | $14,608 | $16,798 | $21,607 | $27,007 | $31,462 | |
Subtotal Spent on Operations | $3,181 | $7,383 | $9,417 | $10,635 | $13,651 | $15,853 | $19,786 | $22,271 | $25,501 | $31,154 | $37,342 | $43,341 | |
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 | $0 | $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 | $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 | $3,181 | $7,383 | $9,417 | $10,635 | $13,651 | $15,853 | $19,786 | $22,271 | $25,501 | $31,154 | $37,342 | $43,341 | |
Net Cash Flow | $3,819 | ($3,208) | ($1,009) | ($613) | ($2,893) | ($1,885) | ($3,346) | $176 | $14,629 | ($8,377) | ($4,751) | ($697) | |
Cash Balance | $23,819 | $20,611 | $19,602 | $18,989 | $16,096 | $14,211 | $10,865 | $11,041 | $25,670 | $17,293 | $12,541 | $11,845 |
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 | $20,000 | $23,819 | $20,611 | $19,602 | $18,989 | $16,096 | $14,211 | $10,865 | $11,041 | $25,670 | $17,293 | $12,541 | $11,845 |
Accounts Receivable | $0 | $5,250 | $15,075 | $20,317 | $24,185 | $29,657 | $38,219 | $41,829 | $41,832 | $53,952 | $73,645 | $88,764 | $99,950 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $20,000 | $29,069 | $35,686 | $39,919 | $43,174 | $45,753 | $52,430 | $52,694 | $52,873 | $79,622 | $90,938 | $101,306 | $111,795 |
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 | $20,000 | $29,069 | $35,686 | $39,919 | $43,174 | $45,753 | $52,430 | $52,694 | $52,873 | $79,622 | $90,938 | $101,306 | $111,795 |
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 | $3,791 | $5,572 | $6,444 | $8,105 | $9,469 | $12,339 | $14,053 | $16,084 | $20,712 | $25,964 | $30,254 | $35,041 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $20,000 | $20,000 | $20,000 | $20,000 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $0 | $3,791 | $5,572 | $6,444 | $8,105 | $9,469 | $12,339 | $14,053 | $16,084 | $40,712 | $45,964 | $50,254 | $55,041 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $3,791 | $5,572 | $6,444 | $8,105 | $9,469 | $12,339 | $14,053 | $16,084 | $40,712 | $45,964 | $50,254 | $55,041 |
Paid-in Capital | $23,500 | $30,500 | $34,500 | $37,500 | $37,500 | $37,500 | $37,500 | $37,500 | $37,500 | $37,500 | $37,500 | $37,500 | $37,500 |
Retained Earnings | ($3,500) | ($3,500) | ($3,500) | ($3,500) | ($3,500) | ($3,500) | ($3,500) | ($3,500) | ($3,500) | ($3,500) | ($3,500) | ($3,500) | ($3,500) |
Earnings | $0 | ($1,722) | ($886) | ($525) | $1,069 | $2,284 | $6,091 | $4,640 | $2,789 | $4,910 | $10,974 | $17,052 | $22,753 |
Total Capital | $20,000 | $25,278 | $30,114 | $33,475 | $35,069 | $36,284 | $40,091 | $38,640 | $36,789 | $38,910 | $44,974 | $51,052 | $56,753 |
Total Liabilities and Capital | $20,000 | $29,069 | $35,686 | $39,919 | $43,174 | $45,753 | $52,430 | $52,694 | $52,873 | $79,622 | $90,938 | $101,306 | $111,795 |
Net Worth | $20,000 | $25,278 | $30,114 | $33,475 | $35,069 | $36,284 | $40,091 | $38,640 | $36,789 | $38,910 | $44,974 | $51,052 | $56,753 |
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 | |||||||||||||
Monthly Revenue | 40% | $5,000 | $8,000 | $7,535 | $9,335 | $11,135 | $14,735 | $14,235 | $16,635 | $23,735 | $29,735 | $32,535 | $37,935 |
Commission Sales | 50% | $250 | $2,000 | $3,115 | $4,555 | $5,095 | $7,795 | $5,815 | $5,815 | $8,515 | $12,735 | $15,175 | $15,895 |
Total Sales | $5,250 | $10,000 | $10,650 | $13,890 | $16,230 | $22,530 | $20,050 | $22,450 | $32,250 | $42,470 | $47,710 | $53,830 | |
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 | |
Monthly Revenue | $1,250 | $1,200 | $1,440 | $1,728 | $2,074 | $2,488 | $2,986 | $3,583 | $4,300 | $5,160 | $6,192 | $7,430 | |
Commission Sales | $50 | $400 | $623 | $911 | $1,019 | $1,559 | $1,163 | $1,163 | $1,703 | $2,547 | $3,035 | $3,179 | |
Subtotal Direct Cost of Sales | $1,300 | $1,600 | $2,063 | $2,639 | $3,093 | $4,047 | $4,149 | $4,746 | $6,003 | $7,707 | $9,227 | $10,609 |