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

- 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.

Skills demonstrated
- Excel
- Real Estate Finance
- Underwriting
- Capital Structure
- IRR Analysis
Downloads
Supporting files for reviewers who want the underlying detail.