House layout for every property model
Models built a different way for every deal take twice as long to review and hide errors in a new place each time. A fixed layout of cover, inputs, timeline, calculations, debt, returns and checks, in that order, means anyone who has seen one of your models can find any number in the next one within a minute. Set it before the next deal lands, because nobody standardises during a bid.
First tasks
- Open your last two models and list the tabs each one used
- Create the blank workbook with the eight standard tabs in order
- Write the flow and one-row-one-formula rules on the cover tab
- Rebuild one past deal in the new layout and compare the returns