All About People
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 | |||||||||||||
Placement Fees | 0% | $3,660 | $4,769 | $5,965 | $7,226 | $9,471 | $12,554 | $12,237 | $10,216 | $3,692 | $7,458 | $7,059 | $9,941 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $3,660 | $4,769 | $5,965 | $7,226 | $9,471 | $12,554 | $12,237 | $10,216 | $3,692 | $7,458 | $7,059 | $9,941 | |
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 | |
Placement Fees | $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 | ||
Placed Employees Personnel | |||||||||||||
Placed Workers at 2/3 of Sales | $2,013 | $2,623 | $3,281 | $3,974 | $5,209 | $6,905 | $6,730 | $5,619 | $2,031 | $4,102 | $3,882 | $5,467 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $2,013 | $2,623 | $3,281 | $3,974 | $5,209 | $6,905 | $6,730 | $5,619 | $2,031 | $4,102 | $3,882 | $5,467 | |
General and Administrative Personnel | |||||||||||||
Office Employees | $0 | $213 | $350 | $350 | $350 | $466 | $700 | $1,500 | $1,750 | $1,750 | $1,750 | $1,750 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $0 | $213 | $350 | $350 | $350 | $466 | $700 | $1,500 | $1,750 | $1,750 | $1,750 | $1,750 | |
Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Total Payroll | $2,013 | $2,836 | $3,631 | $4,324 | $5,559 | $7,371 | $7,430 | $7,119 | $3,781 | $5,852 | $5,632 | $7,217 |
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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.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 | $3,660 | $4,769 | $5,965 | $7,226 | $9,471 | $12,554 | $12,237 | $10,216 | $3,692 | $7,458 | $7,059 | $9,941 | |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Placed Employees Payroll | $2,013 | $2,623 | $3,281 | $3,974 | $5,209 | $6,905 | $6,730 | $5,619 | $2,031 | $4,102 | $3,882 | $5,467 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $2,013 | $2,623 | $3,281 | $3,974 | $5,209 | $6,905 | $6,730 | $5,619 | $2,031 | $4,102 | $3,882 | $5,467 | |
Gross Margin | $1,647 | $2,146 | $2,684 | $3,252 | $4,262 | $5,649 | $5,507 | $4,597 | $1,661 | $3,356 | $3,177 | $4,474 | |
Gross Margin % | 45.00% | 45.00% | 45.00% | 45.00% | 45.00% | 45.00% | 45.00% | 45.00% | 44.99% | 45.00% | 45.01% | 45.00% | |
Operating Expenses | |||||||||||||
Sales and Marketing Expenses | |||||||||||||
Sales and Marketing Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Advertising/Promotion | $12 | $0 | $0 | $23 | $10 | $111 | $27 | $72 | $30 | $599 | $102 | $179 | |
Bank Service Charges | $0 | $57 | $3 | $73 | $539 | $106 | $38 | $3 | $8 | $48 | $129 | $15 | |
Contributions | $0 | $0 | $0 | $100 | $5 | $0 | $0 | $100 | $0 | $0 | $0 | $50 | |
Dues & Subscriptions | $43 | $30 | $54 | $0 | $0 | $21 | $275 | $94 | $0 | $250 | $60 | $60 | |
Total Sales and Marketing Expenses | $55 | $87 | $57 | $196 | $554 | $239 | $340 | $268 | $38 | $897 | $291 | $304 | |
Sales and Marketing % | 1.50% | 1.82% | 0.95% | 2.71% | 5.85% | 1.90% | 2.78% | 2.63% | 1.02% | 12.03% | 4.12% | 3.06% | |
General and Administrative Expenses | |||||||||||||
General and Administrative Payroll | $0 | $213 | $350 | $350 | $350 | $466 | $700 | $1,500 | $1,750 | $1,750 | $1,750 | $1,750 | |
Marketing/Promotion | $213 | $236 | $331 | $691 | $756 | $656 | $592 | $441 | $154 | $1,149 | $784 | $514 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Telephone & Pager | $226 | $88 | $416 | $125 | $374 | $220 | $439 | $638 | $697 | $240 | $616 | $90 | |
Recruitment | $115 | $77 | $189 | $220 | $71 | $147 | $106 | $251 | $45 | $192 | $65 | $95 | |
Referral Fees | $0 | $20 | $0 | $50 | $0 | $100 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rent | $195 | $195 | $195 | $195 | $195 | $195 | $983 | $788 | $788 | $788 | $788 | $798 | |
Office Supplies | $92 | $188 | $96 | $197 | $49 | $62 | $116 | $442 | $24 | $670 | $177 | $0 | |
Postage | $9 | $49 | $55 | $107 | $133 | $94 | $36 | $99 | $8 | $175 | $89 | $209 | |
Printing | $0 | $2 | $669 | $26 | $290 | $350 | $175 | $224 | $832 | $179 | $520 | $94 | |
Professional Fees | $240 | $170 | $664 | $988 | $367 | $270 | $0 | $528 | $844 | $342 | $2,013 | $516 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Maintenance and Repairs | $0 | $0 | $103 | $100 | $0 | $25 | $0 | $39 | $0 | $0 | $44 | $0 | |
Total General and Administrative Expenses | $1,090 | $1,239 | $3,068 | $3,049 | $2,585 | $2,585 | $3,146 | $4,949 | $5,142 | $5,485 | $6,845 | $4,065 | |
General and Administrative % | 29.77% | 25.97% | 51.43% | 42.19% | 27.30% | 20.59% | 25.71% | 48.45% | 139.28% | 73.55% | 96.97% | 40.90% | |
Other Expenses: | |||||||||||||
Other Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Consultants | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Misc. | $40 | $0 | $44 | $244 | $90 | $240 | $159 | $0 | $40 | $20 | $173 | $0 | |
Total Other Expenses | $40 | $0 | $44 | $244 | $90 | $240 | $159 | $0 | $40 | $20 | $173 | $0 | |
Other % | 1.09% | 0.00% | 0.74% | 3.38% | 0.95% | 1.91% | 1.30% | 0.00% | 1.08% | 0.27% | 2.45% | 0.00% | |
Total Operating Expenses | $1,185 | $1,325 | $3,168 | $3,488 | $3,229 | $3,064 | $3,645 | $5,218 | $5,220 | $6,403 | $7,309 | $4,369 | |
Profit Before Interest and Taxes | $462 | $821 | ($484) | ($236) | $1,033 | $2,585 | $1,862 | ($621) | ($3,559) | ($3,047) | ($4,132) | $104 | |
EBITDA | $462 | $821 | ($484) | ($236) | $1,033 | $2,585 | $1,862 | ($621) | ($3,559) | ($3,047) | ($4,132) | $104 | |
Interest Expense | $283 | $281 | $260 | $258 | $256 | $254 | $251 | $245 | $243 | $241 | $238 | $236 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | $180 | $540 | ($744) | ($494) | $777 | $2,332 | $1,610 | ($866) | ($3,802) | ($3,287) | ($4,370) | ($132) | |
Net Profit/Sales | 4.90% | 11.32% | -12.48% | -6.84% | 8.21% | 18.57% | 13.16% | -8.47% | -102.97% | -44.08% | -61.91% | -1.33% |
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 | $915 | $1,192 | $1,491 | $1,807 | $2,368 | $3,139 | $3,059 | $2,554 | $923 | $1,865 | $1,765 | $2,485 | |
Cash from Receivables | $0 | $92 | $2,773 | $3,607 | $4,505 | $5,476 | $7,180 | $9,408 | $9,127 | $7,499 | $2,863 | $5,584 | |
Subtotal Cash from Operations | $915 | $1,284 | $4,264 | $5,413 | $6,873 | $8,614 | $10,240 | $11,962 | $10,050 | $9,363 | $4,628 | $8,069 | |
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 | $10,000 | |
Subtotal Cash Received | $915 | $1,284 | $4,264 | $5,413 | $6,873 | $8,614 | $10,240 | $11,962 | $10,050 | $9,363 | $4,628 | $18,069 | |
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 | $2,013 | $2,836 | $3,631 | $4,324 | $5,559 | $7,371 | $7,430 | $7,119 | $3,781 | $5,852 | $5,632 | $7,217 | |
Bill Payments | $193 | $1,465 | $1,449 | $3,089 | $3,388 | $3,125 | $2,863 | $3,222 | $3,954 | $3,752 | $4,923 | $5,699 | |
Subtotal Spent on Operations | $2,206 | $4,301 | $5,080 | $7,413 | $8,947 | $10,496 | $10,293 | $10,341 | $7,735 | $9,604 | $10,555 | $12,916 | |
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 | $2,220 | $0 | $0 | $0 | $0 | $500 | $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 | $375 | $375 | $375 | $375 | $375 | $375 | $375 | $375 | $375 | $375 | $375 | $375 | |
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 | $2,581 | $4,676 | $7,675 | $7,788 | $9,322 | $10,871 | $10,668 | $11,216 | $8,110 | $9,979 | $10,930 | $13,291 | |
Net Cash Flow | ($1,666) | ($3,392) | ($3,411) | ($2,375) | ($2,449) | ($2,257) | ($428) | $745 | $1,940 | ($616) | ($6,303) | $4,777 | |
Cash Balance | $44,334 | $40,942 | $37,530 | $35,156 | $32,707 | $30,450 | $30,022 | $30,767 | $32,707 | $32,091 | $25,789 | $30,566 |
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 | $46,000 | $44,334 | $40,942 | $37,530 | $35,156 | $32,707 | $30,450 | $30,022 | $30,767 | $32,707 | $32,091 | $25,789 | $30,566 |
Accounts Receivable | $0 | $2,745 | $6,230 | $7,931 | $9,744 | $12,342 | $16,282 | $18,279 | $16,534 | $10,176 | $8,270 | $10,701 | $12,573 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $46,000 | $47,079 | $47,172 | $45,462 | $44,900 | $45,049 | $46,732 | $48,301 | $47,301 | $42,883 | $40,361 | $36,490 | $43,139 |
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 | $46,000 | $47,079 | $47,172 | $45,462 | $44,900 | $45,049 | $46,732 | $48,301 | $47,301 | $42,883 | $40,361 | $36,490 | $43,139 |
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 | $144 | $1,419 | $1,347 | $2,976 | $3,283 | $3,030 | $2,756 | $3,090 | $3,831 | $3,589 | $4,730 | $5,604 | $2,761 |
Current Borrowing | $2,720 | $2,720 | $2,720 | $500 | $500 | $500 | $500 | $500 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $2,864 | $4,139 | $4,067 | $3,476 | $3,783 | $3,530 | $3,256 | $3,590 | $3,831 | $3,589 | $4,730 | $5,604 | $2,761 |
Long-term Liabilities | $45,000 | $44,625 | $44,250 | $43,875 | $43,500 | $43,125 | $42,750 | $42,375 | $42,000 | $41,625 | $41,250 | $40,875 | $40,500 |
Total Liabilities | $47,864 | $48,764 | $48,317 | $47,351 | $47,283 | $46,655 | $46,006 | $45,965 | $45,831 | $45,214 | $45,980 | $46,479 | $43,261 |
Paid-in Capital | $7,600 | $7,600 | $7,600 | $7,600 | $7,600 | $7,600 | $7,600 | $7,600 | $7,600 | $7,600 | $7,600 | $7,600 | $17,600 |
Retained Earnings | ($9,464) | ($9,464) | ($9,464) | ($9,464) | ($9,464) | ($9,464) | ($9,464) | ($9,464) | ($9,464) | ($9,464) | ($9,464) | ($9,464) | ($9,464) |
Earnings | $0 | $180 | $719 | ($25) | ($519) | $258 | $2,590 | $4,200 | $3,334 | ($467) | ($3,755) | ($8,125) | ($8,257) |
Total Capital | ($1,864) | ($1,684) | ($1,145) | ($1,889) | ($2,383) | ($1,606) | $726 | $2,336 | $1,470 | ($2,331) | ($5,619) | ($9,989) | ($121) |
Total Liabilities and Capital | $46,000 | $47,079 | $47,172 | $45,462 | $44,900 | $45,049 | $46,732 | $48,301 | $47,301 | $42,883 | $40,361 | $36,490 | $43,139 |
Net Worth | ($1,864) | ($1,684) | ($1,145) | ($1,889) | ($2,383) | ($1,606) | $726 | $2,336 | $1,470 | ($2,331) | ($5,619) | ($9,989) | ($121) |