Visit our US site at: www.bplans.comhide this bar
 
Edit This Plan

Real Estate Brokerage Business Plan

RJ Wagner and Assoc. Realty

This sample business plan can be edited directly in Business Plan Pro software.

previous
next
Page 1   2   3   4   5   6   7   8  

Appendix

Sales Forecast
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May
Sales
Agent Sales - 25% To Company 0% £0 £2,375 £8,125 £11,250 £4,500 £4,500 £4,500 £3,375 £3,375 £12,375 £14,625 £14,625
Broker Sales - 100% To Company 0% £3,389 £3,731 £6,750 £0 £3,375 £3,375 £3,375 £0 £0 £4,500 £7,875 £7,875
Photo Service - 100% To Company 0% £0 £480 £480 £480 £480 £480 £480 £480 £480 £480 £480 £480
Referrals - 25% Agent/25% Company 0% £187 £187 £187 £187 £187 £187 £187 £187 £187 £187 £187 £187
Total Sales £3,576 £6,773 £15,542 £11,917 £8,542 £8,542 £8,542 £4,042 £4,042 £17,542 £23,167 £23,167
Direct Cost of Sales Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May
Agent Sales - 25% To Company £0 £238 £813 £1,125 £450 £450 £450 £338 £338 £1,238 £1,463 £1,463
Broker Sales - 100% To Company £339 £373 £675 £1,350 £675 £1,350 £675 £1,350 £1,350 £1,350 £675 £675
Photo Service - 100% To Company £0 £40 £40 £40 £40 £40 £40 £40 £40 £40 £40 £40
Referrals - 25% Agent/25% Company £0 £30 £30 £30 £30 £30 £30 £30 £30 £30 £30 £30
Subtotal Direct Cost of Sales £339 £681 £1,558 £2,545 £1,195 £1,870 £1,195 £1,758 £1,758 £2,658 £2,208 £2,208
Personnel Plan
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May
Wagner 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
Other 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
General Assumptions
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May
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
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May
Sales £3,576 £6,773 £15,542 £11,917 £8,542 £8,542 £8,542 £4,042 £4,042 £17,542 £23,167 £23,167
Direct Cost of Sales £339 £681 £1,558 £2,545 £1,195 £1,870 £1,195 £1,758 £1,758 £2,658 £2,208 £2,208
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £339 £681 £1,558 £2,545 £1,195 £1,870 £1,195 £1,758 £1,758 £2,658 £2,208 £2,208
Gross Margin £3,237 £6,093 £13,985 £9,372 £7,347 £6,672 £7,347 £2,285 £2,285 £14,885 £20,960 £20,960
Gross Margin % 90.52% 89.95% 89.98% 78.64% 86.01% 78.11% 86.01% 56.52% 56.52% 84.85% 90.47% 90.47%
Expenses
Payroll £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Marketing/Promotion £200 £200 £600 £700 £1,000 £700 £700 £900 £700 £700 £1,000 £700
Depreciation £150 £150 £150 £150 £125 £90 £75 £75 £75 £75 £75 £80
Utilities £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150
Rent £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300
Insurance £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150
Office Supplies £100 £100 £200 £200 £300 £300 £300 £300 £300 £300 £300 £300
Business Software £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £1,000
Leased Equipment £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250
Payroll Taxes 15% £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 £5,300 £5,300 £5,800 £5,900 £6,275 £5,940 £5,925 £6,125 £5,925 £5,925 £6,225 £6,930
Profit Before Interest and Taxes (£2,063) £793 £8,185 £3,472 £1,072 £732 £1,422 (£3,841) (£3,641) £8,960 £14,735 £14,030
EBITDA (£1,913) £943 £8,335 £3,622 £1,197 £822 £1,497 (£3,766) (£3,566) £9,035 £14,810 £14,110
Interest Expense £4 £8 £13 £17 £21 £25 £29 £33 £38 £42 £46 £50
Taxes Incurred (£620) £196 £2,043 £864 £263 £177 £348 (£968) (£920) £2,229 £3,672 £3,495
Net Profit (£1,447) £588 £6,129 £2,592 £788 £530 £1,045 (£2,905) (£2,759) £6,688 £11,017 £10,485
Net Profit/Sales -40.46% 8.68% 39.44% 21.75% 9.23% 6.21% 12.23% -71.88% -68.25% 38.13% 47.55% 45.26%
Pro Forma Cash Flow
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May
Cash Received
Cash from Operations
Cash Sales £3,218 £6,096 £13,988 £10,725 £7,688 £7,688 £7,688 £3,638 £3,638 £15,788 £20,850 £20,850
Cash from Receivables £0 £12 £368 £707 £1,542 £1,180 £854 £854 £839 £404 £449 £1,773
Subtotal Cash from Operations £3,218 £6,108 £14,356 £11,432 £9,230 £8,868 £8,542 £4,492 £4,477 £16,192 £21,300 £22,623
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 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
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 £3,718 £6,608 £14,856 £11,932 £9,730 £9,368 £9,042 £4,992 £4,977 £16,692 £21,800 £23,123
Expenditures Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May
Expenditures from Operations
Cash Spending £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Bill Payments £10,062 £1,912 £3,142 £6,260 £6,124 £4,638 £4,905 £4,404 £3,867 £3,861 £7,822 £9,093
Subtotal Spent on Operations £13,062 £4,912 £6,142 £9,260 £9,124 £7,638 £7,905 £7,404 £6,867 £6,861 £10,822 £12,093
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 £13,062 £4,912 £6,142 £9,260 £9,124 £7,638 £7,905 £7,404 £6,867 £6,861 £10,822 £12,093
Net Cash Flow (£9,344) £1,696 £8,714 £2,672 £606 £1,730 £1,137 (£2,412) (£1,890) £9,831 £10,978 £11,030
Cash Balance £412 £2,108 £10,821 £13,493 £14,099 £15,829 £16,966 £14,554 £12,663 £22,495 £33,472 £44,503
Pro Forma Balance Sheet
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May
Assets Starting Balances
Current Assets
Cash £9,756 £412 £2,108 £10,821 £13,493 £14,099 £15,829 £16,966 £14,554 £12,663 £22,495 £33,472 £44,503
Accounts Receivable £0 £358 £1,023 £2,209 £2,694 £2,006 £1,680 £1,680 £1,230 £795 £2,145 £4,012 £4,556
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 £29,756 £20,770 £23,131 £33,030 £36,187 £36,105 £37,509 £38,646 £35,784 £33,458 £44,640 £57,485 £69,059
Long-term Assets
Long-term 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
Accumulated Depreciation £0 £150 £300 £450 £600 £725 £815 £890 £965 £1,040 £1,115 £1,190 £1,270
Total Long-term Assets £7,000 £6,850 £6,700 £6,550 £6,400 £6,275 £6,185 £6,110 £6,035 £5,960 £5,885 £5,810 £5,730
Total Assets £36,756 £27,620 £29,831 £39,580 £42,587 £42,380 £43,694 £44,756 £41,819 £39,418 £50,525 £63,295 £74,789
Liabilities and Capital Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May
Current Liabilities
Accounts Payable £10,000 £1,811 £2,934 £6,054 £5,970 £4,474 £4,758 £4,275 £3,743 £3,601 £7,519 £8,773 £9,282
Current Borrowing £0 £500 £1,000 £1,500 £2,000 £2,500 £3,000 £3,500 £4,000 £4,500 £5,000 £5,500 £6,000
Other Current Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Current Liabilities £10,000 £2,311 £3,934 £7,554 £7,970 £6,974 £7,758 £7,775 £7,743 £8,101 £12,519 £14,273 £15,282
Long-term Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Liabilities £10,000 £2,311 £3,934 £7,554 £7,970 £6,974 £7,758 £7,775 £7,743 £8,101 £12,519 £14,273 £15,282
Paid-in Capital £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000
Retained Earnings (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244)
Earnings £0 (£1,447) (£859) £5,270 £7,862 £8,650 £9,180 £10,225 £7,319 £4,561 £11,249 £22,266 £32,750
Total Capital £26,756 £25,309 £25,897 £32,026 £34,618 £35,406 £35,936 £36,981 £34,075 £31,317 £38,005 £49,022 £59,506
Total Liabilities and Capital £36,756 £27,620 £29,831 £39,580 £42,587 £42,380 £43,694 £44,756 £41,819 £39,418 £50,525 £63,295 £74,789
Net Worth £26,756 £25,309 £25,897 £32,026 £34,618 £35,406 £35,936 £36,981 £34,075 £31,317 £38,005 £49,022 £59,506
previous
next
Edit This Plan
Sales Forecast
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May
Sales
Agent Sales - 25% To Company