Office Space Solutions

Start your own business plan »

Office Consulting 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
Sales
Start-Ups 0% $600 $1,002 $1,150 $1,288 $1,322 $1,534 $1,544 $1,722 $1,900 $2,245 $2,599 $2,700
Growing Businesses 0% $1,002 $1,200 $1,345 $1,688 $1,992 $2,512 $3,002 $3,600 $4,200 $5,023 $5,900 $6,700
Total Sales $1,602 $2,202 $2,495 $2,976 $3,314 $4,046 $4,546 $5,322 $6,100 $7,268 $8,499 $9,400
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
Start-Ups $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Growing Businesses $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
Owner 0% $2,000 $2,000 $2,000 $2,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Part-time assistant 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,000 $1,000 $1,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $2,000 $2,000 $2,000 $2,000 $3,000 $3,000 $3,000 $3,000 $3,000 $4,000 $4,000 $4,000
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% 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 $1,602 $2,202 $2,495 $2,976 $3,314 $4,046 $4,546 $5,322 $6,100 $7,268 $8,499 $9,400
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Production Expenses $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 $1,602 $2,202 $2,495 $2,976 $3,314 $4,046 $4,546 $5,322 $6,100 $7,268 $8,499 $9,400
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 $2,000 $2,000 $2,000 $2,000 $3,000 $3,000 $3,000 $3,000 $3,000 $4,000 $4,000 $4,000
Sales and Marketing and Other Expenses $305 $305 $205 $205 $205 $205 $205 $205 $205 $205 $205 $205
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 15% $300 $300 $300 $300 $450 $450 $450 $450 $450 $600 $600 $600
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $2,605 $2,605 $2,505 $2,505 $3,655 $3,655 $3,655 $3,655 $3,655 $4,805 $4,805 $4,805
Profit Before Interest and Taxes ($1,003) ($403) ($10) $471 ($341) $391 $891 $1,667 $2,445 $2,463 $3,694 $4,595
EBITDA ($1,003) ($403) ($10) $471 ($341) $391 $891 $1,667 $2,445 $2,463 $3,694 $4,595
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($301) ($121) ($3) $141 ($102) $117 $267 $500 $734 $739 $1,108 $1,379
Net Profit ($702) ($282) ($7) $330 ($239) $274 $624 $1,167 $1,712 $1,724 $2,586 $3,217
Net Profit/Sales -43.83% -12.81% -0.28% 11.08% -7.20% 6.76% 13.72% 21.93% 28.06% 23.72% 30.42% 34.22%
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 $881 $1,211 $1,372 $1,637 $1,823 $2,225 $2,500 $2,927 $3,355 $3,997 $4,674 $5,170
Cash from Receivables $0 $24 $730 $995 $1,130 $1,344 $1,502 $1,828 $2,057 $2,407 $2,763 $3,289
Subtotal Cash from Operations $881 $1,235 $2,102 $2,632 $2,953 $3,570 $4,003 $4,755 $5,412 $6,404 $7,437 $8,459
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 $881 $1,235 $2,102 $2,632 $2,953 $3,570 $4,003 $4,755 $5,412 $6,404 $7,437 $8,459
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,000 $2,000 $2,000 $2,000 $3,000 $3,000 $3,000 $3,000 $3,000 $4,000 $4,000 $4,000
Bill Payments $10 $310 $485 $507 $643 $560 $777 $930 $1,163 $1,394 $1,556 $1,922
Subtotal Spent on Operations $2,010 $2,310 $2,485 $2,507 $3,643 $3,560 $3,777 $3,930 $4,163 $5,394 $5,556 $5,922
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 $2,010 $2,310 $2,485 $2,507 $3,643 $3,560 $3,777 $3,930 $4,163 $5,394 $5,556 $5,922
Net Cash Flow ($1,129) ($1,075) ($383) $125 ($691) $10 $225 $825 $1,249 $1,010 $1,881 $2,537
Cash Balance $5,571 $4,496 $4,113 $4,239 $3,548 $3,558 $3,783 $4,608 $5,858 $6,868 $8,749 $11,286
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 $6,700 $5,571 $4,496 $4,113 $4,239 $3,548 $3,558 $3,783 $4,608 $5,858 $6,868 $8,749 $11,286
Accounts Receivable $0 $721 $1,688 $2,081 $2,425 $2,786 $3,262 $3,806 $4,372 $5,060 $5,924 $6,986 $7,927
Other Current Assets $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total Current Assets $8,700 $8,292 $8,184 $8,194 $8,663 $8,334 $8,820 $9,589 $10,981 $12,918 $14,792 $17,735 $21,213
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 $8,700 $8,292 $8,184 $8,194 $8,663 $8,334 $8,820 $9,589 $10,981 $12,918 $14,792 $17,735 $21,213
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 $294 $468 $485 $625 $534 $747 $892 $1,117 $1,342 $1,492 $1,849 $2,111
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 $0 $294 $468 $485 $625 $534 $747 $892 $1,117 $1,342 $1,492 $1,849 $2,111
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $294 $468 $485 $625 $534 $747 $892 $1,117 $1,342 $1,492 $1,849 $2,111
Paid-in Capital $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000
Retained Earnings ($3,300) ($3,300) ($3,300) ($3,300) ($3,300) ($3,300) ($3,300) ($3,300) ($3,300) ($3,300) ($3,300) ($3,300) ($3,300)
Earnings $0 ($702) ($984) ($991) ($662) ($900) ($627) ($3) $1,164 $2,876 $4,600 $7,186 $10,402
Total Capital $8,700 $7,998 $7,716 $7,709 $8,039 $7,800 $8,074 $8,697 $9,864 $11,576 $13,300 $15,886 $19,102
Total Liabilities and Capital $8,700 $8,292 $8,184 $8,194 $8,663 $8,334 $8,820 $9,589 $10,981 $12,918 $14,792 $17,735 $21,213
Net Worth $8,700 $7,998 $7,716 $7,709 $8,039 $7,800 $8,074 $8,697 $9,864 $11,576 $13,300 $15,886 $19,102