Business plan for real estate brokerage

Question:
I am attempting to create a real estate brokerage business plan. Business concept; a commission is paid for a property contracted(listed) to sell. The The commissions varies with each sale depending on who sells the property. Example; a property is listed to sell and and the lising broker earns a commission if the property is sold durning the term of the contract by anyone. The listing broker gets 1/2 and the selling broker gets 1/2.

Had the property been also sold by the listing brokerage they would retain 100% of the commission and pay is sales agent 25%.

Simple, but I cannot make it fit into your program and make the tables work.

Answer:
If I'm understanding correctly then your first option is to set your sales forecast (in the table settings wizard) for values instead of units, and project the expected commissions by month. Since you can have as many lines as you want, you can project commissions according to whether they are full, or what percentage, and just put in the dollars that result.

You could also choose to project your sales by units, and then have the lines in your forecast break houses down by the commission types and you put into the revenue per unit whatever your average would be for that commission level.

In either case you end up with a valid forecast structure, and the numbers are an estimate of the actual dollars coming into your profit and loss statement.

-- Tim