Our biggest savings of the year
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 |