A seasoned financial modeller is requested to construct a sophisticated three statement Excel model projecting the acquisition, consolidation and value enhancement of multiple real estate properties housing established businesses. Raw inputs such as floor areas and rate cards for space will be provided, as some sites have documented costs while others require estimation. Central overheads must be intelligently allocated across properties. The dynamic model should ably switch acquisition targets on/off, flexibly adjust financing terms for equity and debt, and output key performance indicators. Success hinges on the model's ductility to represent alternative investment scenarios and facilitate presentation to capital sources on an accelerated timeline. Solid experience designing sophisticated real estate investment and portfolio models is essential.
