Business Solutions Consulting

Start your own business plan »

Consulting Planning Business Plan

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