Green Investments

Start your own business plan »

Financial Services 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
<$1 million worth customers 0% $0 $0 $0 $2,500 $3,545 $4,545 $5,878 $6,335 $7,474 $7,558 $8,255 $8,656
>$1 million worth customers 0% $0 $0 $0 $0 $0 $2,136 $2,763 $2,977 $3,513 $3,552 $3,880 $4,068
Total Sales $0 $0 $0 $2,500 $3,545 $6,681 $8,641 $9,312 $10,987 $11,110 $12,135 $12,724
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
<$1 million worth customers $0 $0 $0 $375 $532 $682 $882 $950 $1,121 $1,134 $1,238 $1,298
>$1 million worth customers $0 $0 $0 $0 $0 $320 $414 $447 $527 $533 $582 $610
Subtotal Direct Cost of Sales $0 $0 $0 $375 $532 $1,002 $1,296 $1,397 $1,648 $1,667 $1,820 $1,909
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
Sarah 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Steve 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Account Manager 0% $0 $0 $1,500 $2,000 $2,500 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Administrative Assistant 0% $0 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Bookkeeper 0% $0 $0 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Research Assistant 0% $0 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Total People 2 3 6 6 6 6 6 6 6 6 6 6
Total Payroll $5,000 $5,750 $9,750 $10,250 $10,750 $11,250 $11,250 $11,250 $11,250 $11,250 $11,250 $11,250
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 $0 $0 $0 $2,500 $3,545 $6,681 $8,641 $9,312 $10,987 $11,110 $12,135 $12,724
Direct Cost of Sales $0 $0 $0 $375 $532 $1,002 $1,296 $1,397 $1,648 $1,667 $1,820 $1,909
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $375 $532 $1,002 $1,296 $1,397 $1,648 $1,667 $1,820 $1,909
Gross Margin $0 $0 $0 $2,125 $3,013 $5,679 $7,345 $7,916 $9,339 $9,444 $10,315 $10,816
Gross Margin % 0.00% 0.00% 0.00% 85.00% 85.00% 85.00% 85.00% 85.00% 85.00% 85.00% 85.00% 85.00%
Expenses
Payroll $5,000 $5,750 $9,750 $10,250 $10,750 $11,250 $11,250 $11,250 $11,250 $11,250 $11,250 $11,250
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $317 $317 $317 $317 $317 $317 $317 $317 $317 $317 $317 $317
Rent $650 $650 $650 $650 $650 $650 $650 $650 $650 $650 $650 $650
Utilities $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Insurance $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Payroll Taxes 15% $750 $863 $1,463 $1,538 $1,613 $1,688 $1,688 $1,688 $1,688 $1,688 $1,688 $1,688
Other $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Total Operating Expenses $7,167 $8,030 $12,630 $13,205 $13,780 $14,355 $14,355 $14,355 $14,355 $14,355 $14,355 $14,355
Profit Before Interest and Taxes ($7,167) ($8,030) ($12,630) ($11,080) ($10,766) ($8,676) ($7,010) ($6,439) ($5,016) ($4,911) ($4,040) ($3,539)
EBITDA ($6,850) ($7,713) ($12,313) ($10,763) ($10,449) ($8,359) ($6,693) ($6,122) ($4,699) ($4,594) ($3,723) ($3,222)
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $25 $25 $23
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($7,167) ($8,030) ($12,630) ($11,080) ($10,766) ($8,676) ($7,010) ($6,439) ($5,016) ($4,936) ($4,065) ($3,561)
Net Profit/Sales 0.00% 0.00% 0.00% -443.18% -303.70% -129.85% -81.13% -69.14% -45.65% -44.43% -33.50% -27.99%
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 $0 $0 $0 $2,500 $3,545 $6,681 $8,641 $9,312 $10,987 $11,110 $12,135 $12,724
Subtotal Cash from Operations $0 $0 $0 $2,500 $3,545 $6,681 $8,641 $9,312 $10,987 $11,110 $12,135 $12,724
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 $3,000 $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 $0 $0 $0 $2,500 $3,545 $6,681 $8,641 $9,312 $10,987 $14,110 $12,135 $12,724
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 $5,000 $5,750 $9,750 $10,250 $10,750 $11,250 $11,250 $11,250 $11,250 $11,250 $11,250 $11,250
Bill Payments $62 $1,854 $1,983 $2,578 $3,020 $3,262 $3,799 $4,087 $4,193 $4,437 $4,484 $4,636
Subtotal Spent on Operations $5,062 $7,604 $11,733 $12,828 $13,770 $14,512 $15,049 $15,337 $15,443 $15,687 $15,734 $15,886
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 $300
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 $5,062 $7,604 $11,733 $12,828 $13,770 $14,512 $15,049 $15,337 $15,443 $15,687 $15,734 $16,186
Net Cash Flow ($5,062) ($7,604) ($11,733) ($10,328) ($10,225) ($7,831) ($6,409) ($6,025) ($4,456) ($1,577) ($3,599) ($3,461)
Cash Balance $73,938 $66,335 $54,602 $44,275 $34,049 $26,218 $19,809 $13,785 $9,329 $7,752 $4,153 $692
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 $79,000 $73,938 $66,335 $54,602 $44,275 $34,049 $26,218 $19,809 $13,785 $9,329 $7,752 $4,153 $692
Other Current Assets $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000
Total Current Assets $86,000 $80,938 $73,335 $61,602 $51,275 $41,049 $33,218 $26,809 $20,785 $16,329 $14,752 $11,153 $7,692
Long-term Assets
Long-term Assets $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000
Accumulated Depreciation $0 $317 $634 $951 $1,268 $1,585 $1,902 $2,219 $2,536 $2,853 $3,170 $3,487 $3,804
Total Long-term Assets $19,000 $18,683 $18,366 $18,049 $17,732 $17,415 $17,098 $16,781 $16,464 $16,147 $15,830 $15,513 $15,196
Total Assets $105,000 $99,621 $91,701 $79,651 $69,007 $58,464 $50,316 $43,590 $37,249 $32,476 $30,582 $26,666 $22,888
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 $1,788 $1,897 $2,477 $2,912 $3,136 $3,663 $3,947 $4,045 $4,288 $4,330 $4,478 $4,561
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,000 $3,000 $2,700
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $1,788 $1,897 $2,477 $2,912 $3,136 $3,663 $3,947 $4,045 $4,288 $7,330 $7,478 $7,261
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,788 $1,897 $2,477 $2,912 $3,136 $3,663 $3,947 $4,045 $4,288 $7,330 $7,478 $7,261
Paid-in Capital $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000
Retained Earnings ($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)
Earnings $0 ($7,167) ($15,197) ($27,826) ($38,906) ($49,672) ($58,347) ($65,357) ($71,796) ($76,812) ($81,748) ($85,813) ($89,374)
Total Capital $105,000 $97,833 $89,804 $77,174 $66,095 $55,328 $46,653 $39,643 $33,204 $28,188 $23,252 $19,187 $15,626
Total Liabilities and Capital $105,000 $99,621 $91,701 $79,651 $69,007 $58,464 $50,316 $43,590 $37,249 $32,476 $30,582 $26,666 $22,888
Net Worth $105,000 $97,833 $89,804 $77,174 $66,095 $55,328 $46,653 $39,643 $33,204 $28,188 $23,252 $19,187 $15,626