Brokerage Budget

Build a projected monthly budget for a brokerage of your creation consisting of all the +/- cash flow you can find in your research for a small brokerage consisting of less than 20 employees to simulate realistically numbers. Sources will be required, add to your spreadsheet. Assumptions and formatting can be pre-prepped in the spreadsheet but all formulas, reasoning, and explanations must be explained. Excel sheets will also need to be formatted to look professional.

Sort your assumptions by fixed and variable costs:

For fixed costs:

If you list rent as being $500 a month you'll need a source backing up that price statement. For example, find a commercial property for sale to use as a source then calculate the monthly payment.

For variable costs:

Another brokerage which has their sources listed can be used. For example, if you find a financials showing $150 a month for electric, office supplies or then these numbers can be used.