Palms and Bonds

Start your own business plan »

Business Development 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
All services 0% $8,500 $6,800 $10,800 $16,800 $25,800 $34,800 $40,800 $40,800 $40,800 $46,800 $46,800 $46,800
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $8,500 $6,800 $10,800 $16,800 $25,800 $34,800 $40,800 $40,800 $40,800 $46,800 $46,800 $46,800
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
All services $1,250 $1,500 $2,250 $3,000 $5,000 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $1,250 $1,500 $2,250 $3,000 $5,000 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500
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
Partners 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Internal Consultants 0% $0 $0 $0 $0 $0 $0 $0 $0 $4,000 $4,000 $4,000 $4,000
External Consultants 0% $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $4,000 $4,000 $4,000 $4,000
Office Manager 0% $0 $0 $0 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Personal Assistant 0% $600 $600 $600 $600 $800 $800 $800 $800 $800 $800 $800 $1,200
Secretarial Staff 0% $0 $0 $0 $400 $400 $400 $400 $400 $400 $400 $400 $400
Research Staff 0% $0 $0 $0 $500 $500 $500 $500 $500 $500 $500 $500 $500
Other 0% $0 $0 $0 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $600 $600 $600 $5,500 $5,700 $5,700 $5,700 $5,700 $11,700 $11,700 $11,700 $12,100
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 $8,500 $6,800 $10,800 $16,800 $25,800 $34,800 $40,800 $40,800 $40,800 $46,800 $46,800 $46,800
Direct Cost of Sales $1,250 $1,500 $2,250 $3,000 $5,000 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $1,250 $1,500 $2,250 $3,000 $5,000 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500
Gross Margin $7,250 $5,300 $8,550 $13,800 $20,800 $25,300 $31,300 $31,300 $31,300 $37,300 $37,300 $37,300
Gross Margin % 85.29% 77.94% 79.17% 82.14% 80.62% 72.70% 76.72% 76.72% 76.72% 79.70% 79.70% 79.70%
Expenses
Payroll $600 $600 $600 $5,500 $5,700 $5,700 $5,700 $5,700 $11,700 $11,700 $11,700 $12,100
Sales and Marketing and Other Expenses $1,500 $1,230 $1,230 $1,230 $1,230 $1,230 $1,230 $1,230 $1,230 $1,230 $1,230 $1,230
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Public Relations $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Utilities $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Payroll Taxes 0% $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 Operating Expenses $3,650 $3,380 $3,380 $8,280 $8,480 $8,480 $8,480 $8,480 $14,480 $14,480 $14,480 $14,880
Profit Before Interest and Taxes $3,600 $1,920 $5,170 $5,520 $12,320 $16,820 $22,820 $22,820 $16,820 $22,820 $22,820 $22,420
EBITDA $3,600 $1,920 $5,170 $5,520 $12,320 $16,820 $22,820 $22,820 $16,820 $22,820 $22,820 $22,420
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $1,080 $480 $1,293 $1,380 $3,080 $4,205 $5,705 $5,705 $4,205 $5,705 $5,705 $5,605
Net Profit $2,520 $1,440 $3,878 $4,140 $9,240 $12,615 $17,115 $17,115 $12,615 $17,115 $17,115 $16,815
Net Profit/Sales 29.65% 21.18% 35.90% 24.64% 35.81% 36.25% 41.95% 41.95% 30.92% 36.57% 36.57% 35.93%
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 $2,125 $1,700 $2,700 $4,200 $6,450 $8,700 $10,200 $10,200 $10,200 $11,700 $11,700 $11,700
Cash from Receivables $0 $213 $6,333 $5,200 $8,250 $12,825 $19,575 $26,250 $30,600 $30,600 $30,750 $35,100
Subtotal Cash from Operations $2,125 $1,913 $9,033 $9,400 $14,700 $21,525 $29,775 $36,450 $40,800 $42,300 $42,450 $46,800
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 $2,125 $1,913 $9,033 $9,400 $14,700 $21,525 $29,775 $36,450 $40,800 $42,300 $42,450 $46,800
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 $600 $600 $600 $5,500 $5,700 $5,700 $5,700 $5,700 $11,700 $11,700 $11,700 $12,100
Bill Payments $179 $5,359 $4,812 $6,350 $7,283 $11,048 $16,535 $17,985 $17,935 $16,535 $17,985 $17,982
Subtotal Spent on Operations $779 $5,959 $5,412 $11,850 $12,983 $16,748 $22,235 $23,685 $29,635 $28,235 $29,685 $30,082
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 $779 $5,959 $5,412 $11,850 $12,983 $16,748 $22,235 $23,685 $29,635 $28,235 $29,685 $30,082
Net Cash Flow $1,346 ($4,047) $3,620 ($2,450) $1,717 $4,778 $7,540 $12,765 $11,165 $14,065 $12,765 $16,718
Cash Balance $21,746 $17,699 $21,319 $18,869 $20,586 $25,363 $32,903 $45,668 $56,833 $70,898 $83,663 $100,381
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 $20,400 $21,746 $17,699 $21,319 $18,869 $20,586 $25,363 $32,903 $45,668 $56,833 $70,898 $83,663 $100,381
Accounts Receivable $0 $6,375 $11,263 $13,030 $20,430 $31,530 $44,805 $55,830 $60,180 $60,180 $64,680 $69,030 $69,030
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $20,400 $28,121 $28,961 $34,349 $39,299 $52,116 $70,168 $88,733 $105,848 $117,013 $135,578 $152,693 $169,411
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 $20,400 $28,121 $28,961 $34,349 $39,299 $52,116 $70,168 $88,733 $105,848 $117,013 $135,578 $152,693 $169,411
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 $5,201 $4,601 $6,112 $6,921 $10,498 $15,936 $17,386 $17,386 $15,936 $17,386 $17,386 $17,289
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 $5,201 $4,601 $6,112 $6,921 $10,498 $15,936 $17,386 $17,386 $15,936 $17,386 $17,386 $17,289
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $5,201 $4,601 $6,112 $6,921 $10,498 $15,936 $17,386 $17,386 $15,936 $17,386 $17,386 $17,289
Paid-in Capital $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000
Retained Earnings ($49,600) ($49,600) ($49,600) ($49,600) ($49,600) ($49,600) ($49,600) ($49,600) ($49,600) ($49,600) ($49,600) ($49,600) ($49,600)
Earnings $0 $2,520 $3,960 $7,838 $11,978 $21,218 $33,833 $50,948 $68,063 $80,678 $97,793 $114,908 $131,723
Total Capital $20,400 $22,920 $24,360 $28,238 $32,378 $41,618 $54,233 $71,348 $88,463 $101,078 $118,193 $135,308 $152,123
Total Liabilities and Capital $20,400 $28,121 $28,961 $34,349 $39,299 $52,116 $70,168 $88,733 $105,848 $117,013 $135,578 $152,693 $169,411
Net Worth $20,400 $22,920 $24,360 $28,238 $32,378 $41,618 $54,233 $71,348 $88,463 $101,078 $118,193 $135,308 $152,122