REPRESENTATIVE FINANCIAL PROJECTS
(Selected from lifetime project experience of Principals)

HOLISTIC APPROACH TO FINANCIAL MODELING

The model design approach combines training and experience in accounting with extensive broad based real estate experience to create financial models and analyses of project, business plans, debt and equity requests, loan administration and other requirements.

Financial models are driven by an Assumptions table.  Changes to an assumption automatically populate throughout the model and update the reports and metrics.

MULTI-LOCATION ROLLOUT FOR GROCER ANCHOR TENANT
(Representative project depicted below)

⁠The opportunity to participate in the grocer rollout was competitive both in financial terms and the speed at which  sites were presented and terms negotiated. To maximize our ability to address these parameters, I created the following process.

• Created unit cost data base for site development/utility infrastructure costs.

• Designed/implemented mapping system that estimated unit counts for multiple sites.

• Built financial model that incorporated the unit costs and mapped unit counts to allocate costs between landlord/ developer and grocer tenant to guide lease and site development agreement negotiations.  The financial model tracked 75 -100 line items and computed the share of costs and MUD reimbursement across multiple components and allocated the net costs to the applicable parties.

• Obtained buy-in from grocer tenant of the approach and resulting allocation of costs and responsibilities between landlord/developer and grocer tenant.

• ⁠Redesigned the site plan to enhance synergy of components.

• Re-entitled the project site plan and utility agreements.
  ⁠Renegotiated agreements between municipal development authority ("MDA") and private developer, including the Development and Disposition Agreement which documented the transfer of a portion of the site to the private developer and the private developer's obligations to construct and operate the public components.

• Built financial model to allocate costs between publicly and privately owned components.  Model also provided componentized costs and income for each element of the privately owned component.

• Model incorporated documentation and calculations of costs allocated to the multiple funding sources (state and local public equity, private equity and private debt) together with draw requests to each of the multiple sources.

• The componentized costs reports generated by the model were used to set rents for the tenants.

BUILT TO RENT SINGLE FAMILY SUBDIVISION PROJECT

• Created model that projected costs and rent income by phase over the entire project cycle from land acquisition to eventual sale of fully rented project.

• Model designed to have changes in individual assumptions to generate fully automatic scenario planning alternatives in real time.

• Implemented infrastructure mapping system to estimate unit counts for each phase of the project.

• Applied the unit counts by phase to the engineer's OPC to generate costs by phase.

• Model provided componentized costs, income and return metrics for each phase and consolidated for the entire project.