← Portfolio

Real Estate Finance • Underwriting • Development Analysis

Commercial Real Estate Redevelopment Model

Evaluated the financial viability of a multifamily redevelopment project through acquisition analysis, financing structures, projected cash flows, and return analysis.

01 — Investment overview

Evaluating a multifamily redevelopment opportunity

This model evaluates the acquisition and redevelopment of a distressed restaurant and lounge property in downtown Lowell, Massachusetts into a multifamily residential development. The analysis incorporates development costs, financing assumptions, projected operating performance, and investor return metrics to determine project feasibility and long-term value creation.

02 — Financial analysis

Cost, capital stack, and projected returns

Pro-forma cash flow and returns summary from the CRE redevelopment model.
Leveraged and unleveraged return analysis including NOI growth, cash-on-cash returns, cap rates, debt service coverage, and projected investor cash flows.
  • 01Forecasted annual NOI growth and property cash flows across a 10-year investment horizon.
  • 02Modeled debt financing assumptions and analyzed debt service coverage throughout the hold period.
  • 03Calculated leveraged and unleveraged IRR to compare project returns under different capital structures.
  • 04Evaluated cash-on-cash returns and capitalization rates using projected operating performance.
  • 05Consolidated acquisition, operating, and financing assumptions into a complete redevelopment pro forma.

03 — Development cost breakdown

Sources, uses, and capex detail

The development budget was constructed using detailed assumptions for land acquisition, construction, soft costs, financing, contingency reserves, and lease-up expenses. Cost ranges were evaluated to estimate total project investment requirements and redevelopment feasibility.

Sources and uses table with development cost breakdown.
Detailed development budget including land acquisition, hard costs, soft costs, financing expenses, contingency reserves, and project sizing assumptions.

Skills demonstrated

  • Excel
  • Real Estate Finance
  • Underwriting
  • Capital Structure
  • IRR Analysis

Downloads

Supporting files for reviewers who want the underlying detail.

← Back to Portfolio