Reed Properties

Start your own business plan »

Real Estate 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
New homebuyers 0% $4,000 $5,000 $6,000 $7,000 $8,000 $10,000 $11,000 $12,000 $7,000 $5,000 $4,000 $4,000
Other homebuyers 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $4,000 $5,000 $6,000 $7,000 $8,000 $10,000 $11,000 $12,000 $7,000 $5,000 $4,000 $4,000
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
New homebuyers $200 $250 $300 $350 $400 $500 $550 $600 $350 $250 $200 $200
Other homebuyers $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $200 $250 $300 $350 $400 $500 $550 $600 $350 $250 $200 $200
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
Claudia Reed 0% $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Part Time Admin 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 1 1 1 1 1 1 1 1 1 1 1 1
Total Payroll $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,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 $4,000 $5,000 $6,000 $7,000 $8,000 $10,000 $11,000 $12,000 $7,000 $5,000 $4,000 $4,000
Direct Cost of Sales $200 $250 $300 $350 $400 $500 $550 $600 $350 $250 $200 $200
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $200 $250 $300 $350 $400 $500 $550 $600 $350 $250 $200 $200
Gross Margin $3,800 $4,750 $5,700 $6,650 $7,600 $9,500 $10,450 $11,400 $6,650 $4,750 $3,800 $3,800
Gross Margin % 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00%
Expenses
Payroll $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Sales and Marketing and Other Expenses $575 $575 $575 $575 $575 $575 $575 $575 $575 $575 $575 $575
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 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Insurance $300 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Payroll Taxes 15% $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $7,225 $6,925 $6,925 $6,925 $6,925 $6,925 $6,925 $6,925 $6,925 $6,925 $6,925 $6,925
Profit Before Interest and Taxes ($3,425) ($2,175) ($1,225) ($275) $675 $2,575 $3,525 $4,475 ($275) ($2,175) ($3,125) ($3,125)
EBITDA ($3,425) ($2,175) ($1,225) ($275) $675 $2,575 $3,525 $4,475 ($275) ($2,175) ($3,125) ($3,125)
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($3,425) ($2,175) ($1,225) ($275) $675 $2,575 $3,525 $4,475 ($275) ($2,175) ($3,125) ($3,125)
Net Profit/Sales -85.63% -43.50% -20.42% -3.93% 8.44% 25.75% 32.05% 37.29% -3.93% -43.50% -78.13% -78.13%
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,000 $1,250 $1,500 $1,750 $2,000 $2,500 $2,750 $3,000 $1,750 $1,250 $1,000 $1,000
Cash from Receivables $0 $100 $3,025 $3,775 $4,525 $5,275 $6,050 $7,525 $8,275 $8,875 $5,200 $3,725
Subtotal Cash from Operations $1,000 $1,350 $4,525 $5,525 $6,525 $7,775 $8,800 $10,525 $10,025 $10,125 $6,200 $4,725
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 $6,000 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $1,000 $1,350 $10,525 $5,525 $6,525 $7,775 $8,800 $10,525 $10,025 $10,125 $6,200 $4,725
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 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Bill Payments $114 $3,417 $3,177 $3,227 $3,277 $3,328 $3,427 $3,477 $3,517 $3,272 $3,173 $3,125
Subtotal Spent on Operations $4,114 $7,417 $7,177 $7,227 $7,277 $7,328 $7,427 $7,477 $7,517 $7,272 $7,173 $7,125
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 $4,114 $7,417 $7,177 $7,227 $7,277 $7,328 $7,427 $7,477 $7,517 $7,272 $7,173 $7,125
Net Cash Flow ($3,114) ($6,067) $3,348 ($1,702) ($752) $447 $1,373 $3,048 $2,508 $2,853 ($973) ($2,400)
Cash Balance $6,836 $769 $4,118 $2,416 $1,664 $2,111 $3,484 $6,533 $9,041 $11,894 $10,921 $8,521
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 $9,950 $6,836 $769 $4,118 $2,416 $1,664 $2,111 $3,484 $6,533 $9,041 $11,894 $10,921 $8,521
Accounts Receivable $0 $3,000 $6,650 $8,125 $9,600 $11,075 $13,300 $15,500 $16,975 $13,950 $8,825 $6,625 $5,900
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $9,950 $9,836 $7,419 $12,243 $12,016 $12,739 $15,411 $18,984 $23,508 $22,991 $20,719 $17,546 $14,421
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 $9,950 $9,836 $7,419 $12,243 $12,016 $12,739 $15,411 $18,984 $23,508 $22,991 $20,719 $17,546 $14,421
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 $3,311 $3,069 $3,118 $3,166 $3,214 $3,311 $3,359 $3,408 $3,166 $3,069 $3,021 $3,021
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 $3,311 $3,069 $3,118 $3,166 $3,214 $3,311 $3,359 $3,408 $3,166 $3,069 $3,021 $3,021
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $3,311 $3,069 $3,118 $3,166 $3,214 $3,311 $3,359 $3,408 $3,166 $3,069 $3,021 $3,021
Paid-in Capital $25,000 $25,000 $25,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000
Retained Earnings ($15,050) ($15,050) ($15,050) ($15,050) ($15,050) ($15,050) ($15,050) ($15,050) ($15,050) ($15,050) ($15,050) ($15,050) ($15,050)
Earnings $0 ($3,425) ($5,600) ($6,825) ($7,100) ($6,425) ($3,850) ($325) $4,150 $3,875 $1,700 ($1,425) ($4,550)
Total Capital $9,950 $6,525 $4,350 $9,125 $8,850 $9,525 $12,100 $15,625 $20,100 $19,825 $17,650 $14,525 $11,400
Total Liabilities and Capital $9,950 $9,836 $7,419 $12,243 $12,016 $12,739 $15,411 $18,984 $23,508 $22,991 $20,719 $17,546 $14,421
Net Worth $9,950 $6,525 $4,350 $9,125 $8,850 $9,525 $12,100 $15,625 $20,100 $19,825 $17,650 $14,525 $11,400