Sample #1) Mall Redevelopment – Internal and External Analysis: Designed to show the impact of a standalone redevelopment and the financial impact of potential subsidy captures. Contains several pages for both the developer and Municipality's respective assessments of the project's long term impact.

Sample #2) New Construction – Single Development: CCG’s primary model developed to analyze a single building, multi-unit development, or project phase.  It includes cost, revenue, and return metrics broken down by use (if applicable), ability to specify timing, cost, and lease information down to individual inline spaces, and the ability to input specific scenarios for sensitivity analysis purposes.

Sample #3) Existing Operating Asset – Sale vs. Hold Analysis: Designed to assess several project factors (including specific transactional tax implications) in order to assist ownership with making an optimal sale versus hold decision.

Sample #4) Multi-Proforma Consolidation into Single Project or Phase Analysis: Tool developed in order to collectively analyze several fragmented proformas to obtain a high-level view and better assess the performance of the project as a whole.  The individual project proformas include build-to-suits, ground leases, and for-sale pad sites.  In looking at the project as a whole (compared to individual site proformas), the developer has a better sense of overall cash needs, the impact of loss leaders, and cumulative effects of leasing negotiations throughout the development cycle.

Sample #5) Multi-Phase Project Consolidation & Analysis: Due to the time-value of money effect on IRR, merely analyzing the individual rates of return for independent phases is not an effective diligence approach.  By layering all project phases with their corresponding build-out timelines, this worksheet allows for analysis of project-wide (as opposed to phase by phase) return and cash flow needs.  The page can also be used to determine the impact of toggling on or off certain phases or changing the timing impact of individual phases.

Sample #6) City Impact Projection Analysis: Designed for external consumption by a local government, these sheets consist of two presentation pages of a large, mixed-use development proforma.  The calculations were created to illustrate the incremental revenue benefits of a local Municipality directly resulting from a proposed development.  An objective and easy-to-understand analysis of a project’s tax base improvements can be a crucial factor in garnering the support for a development in the local community.

Sample #7) Proposed Redevelopment Options Matrix: This matrix of examples was based on several project proformas completed for a local bank redevelopment RFP.   Four different development options (and their respective financial metrics) were created and presented.  This worksheet served to consolidate and efficiently compare the various options for easy and objective dissemination by the client.