Claremont Funding

Start your own business plan »

Mortgage Broker 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
First-Time Homeowners 0% $2,100 $2,200 $5,020 $8,000 $10,500 $15,000 $18,000 $22,000 $10,022 $5,210 $3,820 $2,800
Other Homebuyers 0% $1,050 $1,100 $2,510 $4,000 $5,250 $7,500 $9,000 $11,000 $5,011 $2,605 $1,910 $1,400
Residential Refinancing 0% $3,000 $3,000 $6,640 $10,000 $11,000 $14,000 $17,000 $20,000 $13,000 $4,322 $3,222 $2,655
Total Sales $6,150 $6,300 $14,170 $22,000 $26,750 $36,500 $44,000 $53,000 $28,033 $12,137 $8,952 $6,855
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
First-Time Homeowners $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Homebuyers $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Residential Refinancing $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
Joan Billings 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Maureen Shoe 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Admin Assistants 0% $3,000 $3,000 $3,000 $3,000 $5,000 $5,000 $5,000 $5,000 $5,000 $3,000 $3,000 $3,000
Total People 3 3 3 3 4 4 4 4 4 3 3 3
Total Payroll $13,000 $13,000 $13,000 $13,000 $15,000 $15,000 $15,000 $15,000 $15,000 $13,000 $13,000 $13,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 $6,150 $6,300 $14,170 $22,000 $26,750 $36,500 $44,000 $53,000 $28,033 $12,137 $8,952 $6,855
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 $6,150 $6,300 $14,170 $22,000 $26,750 $36,500 $44,000 $53,000 $28,033 $12,137 $8,952 $6,855
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 $13,000 $13,000 $13,000 $13,000 $15,000 $15,000 $15,000 $15,000 $15,000 $13,000 $13,000 $13,000
Sales and Marketing and Other Expenses $650 $650 $650 $650 $650 $650 $650 $650 $650 $650 $650 $650
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $200 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Insurance $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Rent $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Payroll Taxes 15% $1,950 $1,950 $1,950 $1,950 $2,250 $2,250 $2,250 $2,250 $2,250 $1,950 $1,950 $1,950
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $19,200 $19,000 $19,000 $19,000 $21,300 $21,300 $21,300 $21,300 $21,300 $19,000 $19,000 $19,000
Profit Before Interest and Taxes ($13,050) ($12,700) ($4,830) $3,000 $5,450 $15,200 $22,700 $31,700 $6,733 ($6,863) ($10,048) ($12,145)
EBITDA ($13,050) ($12,700) ($4,830) $3,000 $5,450 $15,200 $22,700 $31,700 $6,733 ($6,863) ($10,048) ($12,145)
Interest Expense $248 $246 $244 $279 $277 $275 $235 $233 $231 $229 $227 $225
Taxes Incurred ($3,989) ($3,884) ($1,522) $816 $1,552 $4,478 $6,739 $9,440 $1,951 ($2,128) ($3,083) ($3,711)
Net Profit ($9,309) ($9,062) ($3,552) $1,905 $3,621 $10,448 $15,725 $22,027 $4,551 ($4,965) ($7,193) ($8,659)
Net Profit/Sales -151.36% -143.84% -25.06% 8.66% 13.54% 28.62% 35.74% 41.56% 16.24% -40.90% -80.35% -126.32%
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 $1,538 $1,575 $3,543 $5,500 $6,688 $9,125 $11,000 $13,250 $7,008 $3,034 $2,238 $1,714
Cash from Receivables $0 $154 $4,616 $4,922 $10,823 $16,619 $20,306 $27,563 $33,225 $39,126 $20,627 $9,023
Subtotal Cash from Operations $1,538 $1,729 $8,159 $10,422 $17,511 $25,744 $31,306 $40,813 $40,233 $42,160 $22,865 $10,737
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 $4,500 $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 $12,000 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $1,538 $1,729 $20,159 $14,922 $17,511 $25,744 $31,306 $40,813 $40,233 $42,160 $22,865 $10,737
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 $13,000 $13,000 $13,000 $13,000 $15,000 $15,000 $15,000 $15,000 $15,000 $13,000 $13,000 $13,000
Bill Payments $10,082 $2,455 $2,441 $4,801 $7,130 $8,226 $11,127 $13,365 $15,724 $8,336 $4,070 $3,124
Subtotal Spent on Operations $23,082 $15,455 $15,441 $17,801 $22,130 $23,226 $26,127 $28,365 $30,724 $21,336 $17,070 $16,124
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 $4,500 $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 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
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 $23,332 $15,705 $15,691 $18,051 $22,380 $23,476 $30,877 $28,615 $30,974 $21,586 $17,320 $16,374
Net Cash Flow ($21,794) ($13,977) $4,468 ($3,129) ($4,869) $2,267 $430 $12,198 $9,260 $20,574 $5,546 ($5,637)
Cash Balance $18,156 $4,179 $8,647 $5,518 $649 $2,916 $3,346 $15,544 $24,803 $45,378 $50,923 $45,287
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 $39,950 $18,156 $4,179 $8,647 $5,518 $649 $2,916 $3,346 $15,544 $24,803 $45,378 $50,923 $45,287
Accounts Receivable $0 $4,613 $9,184 $15,195 $26,773 $36,013 $46,769 $59,463 $71,650 $59,450 $29,427 $15,513 $11,631
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 $59,950 $42,768 $33,363 $43,842 $52,291 $56,661 $69,685 $82,808 $107,194 $104,253 $94,804 $86,437 $76,918
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 $59,950 $42,768 $33,363 $43,842 $52,291 $56,661 $69,685 $82,808 $107,194 $104,253 $94,804 $86,437 $76,918
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 $10,000 $2,377 $2,283 $4,564 $6,859 $7,858 $10,684 $12,832 $15,441 $8,199 $3,965 $3,040 $2,430
Current Borrowing $0 $0 $0 $0 $4,500 $4,500 $4,500 $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 $10,000 $2,377 $2,283 $4,564 $11,359 $12,358 $15,184 $12,832 $15,441 $8,199 $3,965 $3,040 $2,430
Long-term Liabilities $30,000 $29,750 $29,500 $29,250 $29,000 $28,750 $28,500 $28,250 $28,000 $27,750 $27,500 $27,250 $27,000
Total Liabilities $40,000 $32,127 $31,783 $33,814 $40,359 $41,108 $43,684 $41,082 $43,441 $35,949 $31,465 $30,290 $29,430
Paid-in Capital $40,000 $40,000 $40,000 $52,000 $52,000 $52,000 $52,000 $52,000 $52,000 $52,000 $52,000 $52,000 $52,000
Retained Earnings ($20,050) ($20,050) ($20,050) ($20,050) ($20,050) ($20,050) ($20,050) ($20,050) ($20,050) ($20,050) ($20,050) ($20,050) ($20,050)
Earnings $0 ($9,309) ($18,371) ($21,922) ($20,018) ($16,397) ($5,949) $9,776 $31,803 $36,354 $31,389 $24,197 $15,538
Total Capital $19,950 $10,641 $1,579 $10,028 $11,932 $15,553 $26,001 $41,726 $63,753 $68,304 $63,339 $56,147 $47,488
Total Liabilities and Capital $59,950 $42,768 $33,363 $43,842 $52,291 $56,661 $69,685 $82,808 $107,194 $104,253 $94,804 $86,437 $76,918
Net Worth $19,950 $10,641 $1,579 $10,028 $11,932 $15,553 $26,001 $41,726 $63,753 $68,304 $63,339 $56,147 $47,488