Business Solutions Consulting
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 | ||
| Unit Sales | |||||||||||||
| Business Plans | 0% | 12 | 13 | 13 | 14 | 15 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| Start-Up Consulting | 0% | 11 | 12 | 12 | 13 | 13 | 14 | 15 | 15 | 16 | 17 | 18 | 19 |
| Annual Reviews | 0% | 14 | 15 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| Other Ongoing Business Consulting | 0% | 14 | 15 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| Total Unit Sales | 51 | 54 | 56 | 59 | 62 | 65 | 68 | 72 | 75 | 79 | 83 | 87 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Business Plans | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | |
| Start-Up Consulting | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | |
| Annual Reviews | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | |
| Other Ongoing Business Consulting | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | |
| Sales | |||||||||||||
| Business Plans | $18,000 | $18,900 | $19,845 | $20,837 | $21,879 | $22,973 | $24,122 | $25,328 | $26,594 | $27,924 | $29,320 | $30,786 | |
| Start-Up Consulting | $16,500 | $17,325 | $18,191 | $19,101 | $20,056 | $21,059 | $22,112 | $23,217 | $24,378 | $25,597 | $26,877 | $28,221 | |
| Annual Reviews | $14,000 | $14,700 | $15,435 | $16,207 | $17,017 | $17,868 | $18,761 | $19,699 | $20,684 | $21,719 | $22,805 | $23,945 | |
| Other Ongoing Business Consulting | $21,000 | $22,050 | $23,153 | $24,310 | $25,526 | $26,802 | $28,142 | $29,549 | $31,027 | $32,578 | $34,207 | $35,917 | |
| Total Sales | $69,500 | $72,975 | $76,624 | $80,455 | $84,478 | $88,702 | $93,137 | $97,793 | $102,683 | $107,817 | $113,208 | $118,869 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Business Plans | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Start-Up Consulting | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Annual Reviews | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Other Ongoing Business Consulting | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Direct Cost of Sales | |||||||||||||
| Business Plans | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Start-Up Consulting | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Annual Reviews | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other Ongoing Business Consulting | $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 | |
| 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 | $69,500 | $72,975 | $76,624 | $80,455 | $84,478 | $88,702 | $93,137 | $97,793 | $102,683 | $107,817 | $113,208 | $118,869 | |
| Direct Cost of Sales | $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 | |
| Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Gross Margin | $69,500 | $72,975 | $76,624 | $80,455 | $84,478 | $88,702 | $93,137 | $97,793 | $102,683 | $107,817 | $113,208 | $118,869 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | |
| Sales and Marketing and Other Expenses | $18,050 | $18,050 | $18,050 | $18,050 | $18,050 | $18,050 | $18,050 | $18,050 | $18,050 | $18,050 | $18,050 | $18,050 | |
| Depreciation | 5% | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
| Utilities | 6% | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 |
| Payroll Taxes | 15% | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $76,150 | $76,150 | $76,150 | $76,150 | $76,150 | $76,150 | $76,150 | $76,150 | $76,150 | $76,150 | $76,150 | $76,150 | |
| Profit Before Interest and Taxes | ($6,650) | ($3,175) | $474 | $4,305 | $8,328 | $12,552 | $16,987 | $21,643 | $26,533 | $31,667 | $37,058 | $42,719 | |
| EBITDA | ($6,150) | ($2,675) | $974 | $4,805 | $8,828 | $13,052 | $17,487 | $22,143 | $27,033 | $32,167 | $37,558 | $43,219 | |
| Interest Expense | $808 | $783 | $758 | $733 | $708 | $683 | $658 | $633 | $608 | $583 | $558 | $533 | |
| Taxes Incurred | ($2,238) | ($990) | ($71) | $893 | $1,905 | $2,967 | $4,082 | $5,253 | $6,481 | $7,771 | $9,125 | $10,546 | |
| Net Profit | ($5,221) | ($2,969) | ($213) | $2,679 | $5,715 | $8,901 | $12,246 | $15,758 | $19,444 | $23,313 | $27,375 | $31,639 | |
| Net Profit/Sales | -7.51% | -4.07% | -0.28% | 3.33% | 6.76% | 10.03% | 13.15% | 16.11% | 18.94% | 21.62% | 24.18% | 26.62% | |
| 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 | $69,500 | $72,975 | $76,624 | $80,455 | $84,478 | $88,702 | $93,137 | $97,793 | $102,683 | $107,817 | $113,208 | $118,869 | |
| Subtotal Cash from Operations | $69,500 | $72,975 | $76,624 | $80,455 | $84,478 | $88,702 | $93,137 | $97,793 | $102,683 | $107,817 | $113,208 | $118,869 | |
| 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 | $69,500 | $72,975 | $76,624 | $80,455 | $84,478 | $88,702 | $93,137 | $97,793 | $102,683 | $107,817 | $113,208 | $118,869 | |
| 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 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | |
| Bill Payments | $1,807 | $24,262 | $25,474 | $26,368 | $27,309 | $28,298 | $29,337 | $30,429 | $31,576 | $32,782 | $34,049 | $35,380 | |
| Subtotal Spent on Operations | $51,807 | $74,262 | $75,474 | $76,368 | $77,309 | $78,298 | $79,337 | $80,429 | $81,576 | $82,782 | $84,049 | $85,380 | |
| 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 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
| 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 | $54,807 | $77,262 | $78,474 | $79,368 | $80,309 | $81,298 | $82,337 | $83,429 | $84,576 | $85,782 | $87,049 | $88,380 | |
| Net Cash Flow | $14,693 | ($4,287) | ($1,850) | $1,086 | $4,169 | $7,404 | $10,800 | $14,365 | $18,107 | $22,036 | $26,160 | $30,489 | |
| Cash Balance | $164,693 | $160,406 | $158,556 | $159,643 | $163,811 | $171,215 | $182,015 | $196,380 | $214,487 | $236,523 | $262,682 | $293,171 | |
| 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 | ||
| Owner / Consultants | 0% | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 |
| Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | |
| 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 | $150,000 | $164,693 | $160,406 | $158,556 | $159,643 | $163,811 | $171,215 | $182,015 | $196,380 | $214,487 | $236,523 | $262,682 | $293,171 |
| 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 | $170,000 | $184,693 | $180,406 | $178,556 | $179,643 | $183,811 | $191,215 | $202,015 | $216,380 | $234,487 | $256,523 | $282,682 | $313,171 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 |
| Accumulated Depreciation | $0 | $500 | $1,000 | $1,500 | $2,000 | $2,500 | $3,000 | $3,500 | $4,000 | $4,500 | $5,000 | $5,500 | $6,000 |
| Total Long-term Assets | $25,000 | $24,500 | $24,000 | $23,500 | $23,000 | $22,500 | $22,000 | $21,500 | $21,000 | $20,500 | $20,000 | $19,500 | $19,000 |
| Total Assets | $195,000 | $209,193 | $204,406 | $202,056 | $202,643 | $206,311 | $213,215 | $223,515 | $237,380 | $254,987 | $276,523 | $302,182 | $332,171 |
| 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 | $1,000 | $23,413 | $24,596 | $25,459 | $26,367 | $27,321 | $28,324 | $29,377 | $30,485 | $31,648 | $32,871 | $34,156 | $35,505 |
| 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 | $1,000 | $23,413 | $24,596 | $25,459 | $26,367 | $27,321 | $28,324 | $29,377 | $30,485 | $31,648 | $32,871 | $34,156 | $35,505 |
| Long-term Liabilities | $100,000 | $97,000 | $94,000 | $91,000 | $88,000 | $85,000 | $82,000 | $79,000 | $76,000 | $73,000 | $70,000 | $67,000 | $64,000 |
| Total Liabilities | $101,000 | $120,413 | $118,596 | $116,459 | $114,367 | $112,321 | $110,324 | $108,377 | $106,485 | $104,648 | $102,871 | $101,156 | $99,505 |
| Paid-in Capital | $99,500 | $99,500 | $99,500 | $99,500 | $99,500 | $99,500 | $99,500 | $99,500 | $99,500 | $99,500 | $99,500 | $99,500 | $99,500 |
| Retained Earnings | ($5,500) | ($5,500) | ($5,500) | ($5,500) | ($5,500) | ($5,500) | ($5,500) | ($5,500) | ($5,500) | ($5,500) | ($5,500) | ($5,500) | ($5,500) |
| Earnings | $0 | ($5,221) | ($8,190) | ($8,403) | ($5,724) | ($10) | $8,891 | $21,138 | $36,895 | $56,339 | $79,652 | $107,027 | $138,666 |
| Total Capital | $94,000 | $88,779 | $85,810 | $85,597 | $88,276 | $93,990 | $102,891 | $115,138 | $130,895 | $150,339 | $173,652 | $201,027 | $232,666 |
| Total Liabilities and Capital | $195,000 | $209,193 | $204,406 | $202,056 | $202,643 | $206,311 | $213,215 | $223,515 | $237,380 | $254,987 | $276,523 | $302,182 | $332,171 |
| Net Worth | $94,000 | $88,779 | $85,810 | $85,597 | $88,276 | $93,990 | $102,891 | $115,138 | $130,895 | $150,339 | $173,652 | $201,027 | $232,666 |
By 
