Amerihall

Start your own business plan »

Real Estate Website 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
Unit Sales
Established Realtors 0% 200 300 600 800 1,050 1,500 1,800 1,900 2,150 2,350 2,550 2,800
New Realtors 0% 50 90 100 100 100 150 200 200 200 200 200 200
Old Timers 0% 0 0 6 10 20 20 20 20 20 20 20 20
Total Unit Sales 250 390 706 910 1,170 1,670 2,020 2,120 2,370 2,570 2,770 3,020
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Established Realtors $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00
New Realtors $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00
Old Timers $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00
Sales
Established Realtors $80,000 $120,000 $240,000 $320,000 $420,000 $600,000 $720,000 $760,000 $860,000 $940,000 $1,020,000 $1,120,000
New Realtors $15,000 $27,000 $30,000 $30,000 $30,000 $45,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000
Old Timers $0 $0 $1,500 $2,500 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Total Sales $95,000 $147,000 $271,500 $352,500 $455,000 $650,000 $785,000 $825,000 $925,000 $1,005,000 $1,085,000 $1,185,000
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Established Realtors 0.00% $65.00 $65.00 $65.00 $65.00 $65.00 $65.00 $65.00 $65.00 $65.00 $65.00 $65.00 $65.00
New Realtors 0.00% $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Old Timers 0.00% $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Direct Cost of Sales
Established Realtors $13,000 $19,500 $39,000 $52,000 $68,250 $97,500 $117,000 $123,500 $139,750 $152,750 $165,750 $182,000
New Realtors $3,000 $5,400 $6,000 $6,000 $6,000 $9,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000
Old Timers $0 $0 $360 $600 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Subtotal Direct Cost of Sales $16,000 $24,900 $45,360 $58,600 $75,450 $107,700 $130,200 $136,700 $152,950 $165,950 $178,950 $195,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
Secretary Corporate 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Director of Conventions/Sales 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,750 $3,750 $3,750
National Convention Staff 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,500 $5,000 $5,000
Online Help 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Director of Realest® Relations 0% $5,409 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417
Clerical Secretary 0% $0 $0 $0 $0 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667
Managing Director 0% $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833
Regional Sales Administrator 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Managing Broker 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Total People 4 4 4 4 5 5 5 5 5 7 7 7
Total Payroll $16,242 $16,250 $16,250 $16,250 $17,917 $17,917 $17,917 $17,917 $17,917 $24,167 $26,667 $26,667
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 $95,000 $147,000 $271,500 $352,500 $455,000 $650,000 $785,000 $825,000 $925,000 $1,005,000 $1,085,000 $1,185,000
Direct Cost of Sales $16,000 $24,900 $45,360 $58,600 $75,450 $107,700 $130,200 $136,700 $152,950 $165,950 $178,950 $195,200
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $16,000 $24,900 $45,360 $58,600 $75,450 $107,700 $130,200 $136,700 $152,950 $165,950 $178,950 $195,200
Gross Margin $79,000 $122,100 $226,140 $293,900 $379,550 $542,300 $654,800 $688,300 $772,050 $839,050 $906,050 $989,800
Gross Margin % 83.16% 83.06% 83.29% 83.38% 83.42% 83.43% 83.41% 83.43% 83.46% 83.49% 83.51% 83.53%
Expenses
Payroll $16,242 $16,250 $16,250 $16,250 $17,917 $17,917 $17,917 $17,917 $17,917 $24,167 $26,667 $26,667
Sales and Marketing and Other Expenses $3,420 $6,320 $6,320 $6,320 $6,320 $6,320 $6,320 $6,320 $6,320 $6,320 $6,320 $6,320
Depreciation $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Website $15,000 $15,000 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Utilities $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Insurance $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
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% $2,436 $2,438 $2,438 $2,438 $2,688 $2,688 $2,688 $2,688 $2,688 $3,625 $4,000 $4,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $41,198 $44,108 $31,608 $31,608 $33,525 $33,525 $33,525 $33,525 $33,525 $40,712 $43,587 $43,587
Profit Before Interest and Taxes $37,802 $77,993 $194,533 $262,293 $346,025 $508,775 $621,275 $654,775 $738,525 $798,338 $862,463 $946,213
EBITDA $38,002 $78,193 $194,733 $262,493 $346,225 $508,975 $621,475 $654,975 $738,725 $798,538 $862,663 $946,413
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $11,341 $19,498 $48,633 $65,573 $86,506 $127,194 $155,319 $163,694 $184,631 $199,584 $215,616 $236,553
Net Profit $26,461 $58,494 $145,899 $196,719 $259,519 $381,582 $465,957 $491,082 $553,894 $598,753 $646,847 $709,660
Net Profit/Sales 27.85% 39.79% 53.74% 55.81% 57.04% 58.70% 59.36% 59.53% 59.88% 59.58% 59.62% 59.89%
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 $95,000 $147,000 $271,500 $352,500 $455,000 $650,000 $785,000 $825,000 $925,000 $1,005,000 $1,085,000 $1,185,000
Subtotal Cash from Operations $95,000 $147,000 $271,500 $352,500 $455,000 $650,000 $785,000 $825,000 $925,000 $1,005,000 $1,085,000 $1,185,000
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 $95,000 $147,000 $271,500 $352,500 $455,000 $650,000 $785,000 $825,000 $925,000 $1,005,000 $1,085,000 $1,185,000
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 $16,242 $16,250 $16,250 $16,250 $17,917 $17,917 $17,917 $17,917 $17,917 $24,167 $26,667 $26,667
Bill Payments $1,737 $52,762 $73,292 $110,157 $140,598 $179,795 $251,989 $301,422 $317,041 $353,952 $382,860 $412,525
Subtotal Spent on Operations $17,979 $69,012 $89,542 $126,407 $158,515 $197,712 $269,906 $319,339 $334,958 $378,119 $409,527 $439,192
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 $5,000 $5,000 $5,000 $5,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $22,979 $74,012 $94,542 $131,407 $168,515 $207,712 $279,906 $329,339 $344,958 $388,119 $419,527 $449,192
Net Cash Flow $72,021 $72,988 $176,958 $221,093 $286,485 $442,288 $505,094 $495,661 $580,042 $616,881 $665,473 $735,808
Cash Balance $137,021 $210,009 $386,967 $608,061 $894,545 $1,336,833 $1,841,927 $2,337,588 $2,917,630 $3,534,511 $4,199,984 $4,935,792
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 $65,000 $137,021 $210,009 $386,967 $608,061 $894,545 $1,336,833 $1,841,927 $2,337,588 $2,917,630 $3,534,511 $4,199,984 $4,935,792
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $65,000 $137,021 $210,009 $386,967 $608,061 $894,545 $1,336,833 $1,841,927 $2,337,588 $2,917,630 $3,534,511 $4,199,984 $4,935,792
Long-term Assets
Long-term Assets $0 $5,000 $10,000 $15,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 $90,000 $100,000
Accumulated Depreciation $0 $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800 $2,000 $2,200 $2,400
Total Long-term Assets $0 $4,800 $9,600 $14,400 $19,200 $29,000 $38,800 $48,600 $58,400 $68,200 $78,000 $87,800 $97,600
Total Assets $65,000 $141,821 $219,609 $401,367 $627,261 $923,545 $1,375,633 $1,890,527 $2,395,988 $2,985,830 $3,612,511 $4,287,784 $5,033,392
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 $50,360 $69,654 $105,512 $134,686 $171,452 $241,958 $290,896 $305,275 $341,223 $369,150 $397,576 $433,524
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 $50,360 $69,654 $105,512 $134,686 $171,452 $241,958 $290,896 $305,275 $341,223 $369,150 $397,576 $433,524
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $50,360 $69,654 $105,512 $134,686 $171,452 $241,958 $290,896 $305,275 $341,223 $369,150 $397,576 $433,524
Paid-in Capital $125,050 $125,050 $125,050 $125,050 $125,050 $125,050 $125,050 $125,050 $125,050 $125,050 $125,050 $125,050 $125,050
Retained Earnings ($60,050) ($60,050) ($60,050) ($60,050) ($60,050) ($60,050) ($60,050) ($60,050) ($60,050) ($60,050) ($60,050) ($60,050) ($60,050)
Earnings $0 $26,461 $84,956 $230,855 $427,574 $687,093 $1,068,675 $1,534,632 $2,025,713 $2,579,607 $3,178,361 $3,825,208 $4,534,868
Total Capital $65,000 $91,461 $149,956 $295,855 $492,574 $752,093 $1,133,675 $1,599,632 $2,090,713 $2,644,607 $3,243,361 $3,890,208 $4,599,868
Total Liabilities and Capital $65,000 $141,821 $219,609 $401,367 $627,261 $923,545 $1,375,633 $1,890,527 $2,395,988 $2,985,830 $3,612,511 $4,287,784 $5,033,392
Net Worth $65,000 $91,461 $149,956 $295,855 $492,574 $752,093 $1,133,675 $1,599,632 $2,090,713 $2,644,607 $3,243,361 $3,890,208 $4,599,868