Urban apartment development in New York City featuring dual unit mix modeling and rent comps

Client

General Partner

Time Spanned

1 Week

About Project

Project Overview



A development team engaged Mayer Property Group to support feasibility planning for a new ground-up apartment project. The client wanted to evaluate how two different unit mix strategies would affect overall project performance, with inputs provided for rents, costs, lease-up timelines, and other key assumptions.



Objective



To compare projected outcomes under two distinct program structures using the same baseline cost and revenue assumptions — allowing the client to assess how unit composition would impact long-term performance and financing viability.



Scope of Work



1. Dual Scenario Modeling
We created two parallel financial models reflecting each unit mix strategy, adjusting absorption schedules, average rent profiles, and unit counts accordingly. Both models incorporated full development timelines and lease-up assumptions.


2. Client-Sourced Inputs
All assumptions — including construction cost per square foot, rent levels, expense ratios, and stabilization timelines — were provided by the client. Mayer Property Group focused on structuring those assumptions into a flexible, easy-to-compare framework.


3. Side-by-Side Analysis
The deliverables included clear financial outputs for each scenario: cash flow summaries, return metrics, and capital stack visuals. This enabled the client to weigh trade-offs in rent premiums, absorption pace, and buildout efficiency under each approach.



Outcome



The dual-scenario model gave the development team a sharper view of how unit mix decisions would impact financial feasibility, equity structure, and debt sizing. It served as a tool for both internal strategy refinement and external capital discussions.

Explore more our cases

Explore more our cases

New York real estate condo development with ground floor retail modeled by Mayer Property Group
New York real estate condo development with ground floor retail modeled by Mayer Property Group
New York real estate condo development with ground floor retail modeled by Mayer Property Group
New York real estate condo development with ground floor retail modeled by Mayer Property Group

Comprehensive financial modeling and underwriting for a ground-up mixed-use condominium project in New York. Included condo absorption analysis, sensitivity testing, and detailed cash flow modeling.

118-unit new multifamily property in California, modeled for acquisition underwriting and rent projections
118-unit new multifamily property in California, modeled for acquisition underwriting and rent projections
118-unit new multifamily property in California, modeled for acquisition underwriting and rent projections
118-unit new multifamily property in California, modeled for acquisition underwriting and rent projections

Pro forma adjustments for the acquisition of a stabilized multifamily asset in California. Included hold period and operating expense adjustments.

Adaptive reuse of commercial building into student housing in Ohio, with detailed underwriting and loan structure
Adaptive reuse of commercial building into student housing in Ohio, with detailed underwriting and loan structure
Adaptive reuse of commercial building into student housing in Ohio, with detailed underwriting and loan structure
Adaptive reuse of commercial building into student housing in Ohio, with detailed underwriting and loan structure

Scenario modeling and underwriting for the repositioning of an existing office building into student housing. Included adaptive reuse cost analysis, lease-up modeling, and exit strategy sensitivity.

Have a project you’re evaluating?

Contact us to learn more about how Mayer Property Group can support your project.

...or contact us via information below

Products Features

Resourses

Icon

©Mayer Property Group. 2025

The materials, financial models, and reports provided by Mayer Property Group are intended solely for informational and illustrative purposes. They are designed to present a transparent view of project-level financial structures, potential scenarios, and underwriting assumptions. These materials do not constitute investment advice, financial advice, tax advice, legal advice, or any other form of professional advisory service.


Mayer Property Group does not recommend, advise on, or endorse any specific investment, real estate transaction, or development project. The decision to proceed with any investment, acquisition, financing, or development opportunity rests entirely with the client or recipient of the materials. Mayer Property Group does not act as a fiduciary or advisor in connection with any transaction or investment strategy.


All financial models, projections, and scenario analyses provided by Mayer Property Group are based on market data, publicly available information, client-provided inputs, and various assumptions which may be subject to change. These models are intended to illustrate potential outcomes under certain conditions and should not be interpreted as guarantees of future performance. Clients are solely responsible for conducting their own due diligence and for consulting with their own legal, tax, financial, and investment advisors before making any investment decisions.


Mayer Property Group shall not be held liable for any actions taken, or decisions made, based on the content of its reports, models, or any related materials. The use of these materials is at the sole risk of the recipient.

Have a project you’re evaluating?

Contact us to learn more about how Mayer Property Group can support your project.

...or contact us via information below

Products Features

Resourses

Icon

©Mayer Property Group. 2025

The materials, financial models, and reports provided by Mayer Property Group are intended solely for informational and illustrative purposes. They are designed to present a transparent view of project-level financial structures, potential scenarios, and underwriting assumptions. These materials do not constitute investment advice, financial advice, tax advice, legal advice, or any other form of professional advisory service.


Mayer Property Group does not recommend, advise on, or endorse any specific investment, real estate transaction, or development project. The decision to proceed with any investment, acquisition, financing, or development opportunity rests entirely with the client or recipient of the materials. Mayer Property Group does not act as a fiduciary or advisor in connection with any transaction or investment strategy.


All financial models, projections, and scenario analyses provided by Mayer Property Group are based on market data, publicly available information, client-provided inputs, and various assumptions which may be subject to change. These models are intended to illustrate potential outcomes under certain conditions and should not be interpreted as guarantees of future performance. Clients are solely responsible for conducting their own due diligence and for consulting with their own legal, tax, financial, and investment advisors before making any investment decisions.


Mayer Property Group shall not be held liable for any actions taken, or decisions made, based on the content of its reports, models, or any related materials. The use of these materials is at the sole risk of the recipient.

Have a project you’re evaluating?

Contact us to learn more about how Mayer Property Group can support your project.

...or contact us via information below

Products Features

Resourses

Icon

©Mayer Property Group. 2025

The materials, financial models, and reports provided by Mayer Property Group are intended solely for informational and illustrative purposes. They are designed to present a transparent view of project-level financial structures, potential scenarios, and underwriting assumptions. These materials do not constitute investment advice, financial advice, tax advice, legal advice, or any other form of professional advisory service.


Mayer Property Group does not recommend, advise on, or endorse any specific investment, real estate transaction, or development project. The decision to proceed with any investment, acquisition, financing, or development opportunity rests entirely with the client or recipient of the materials. Mayer Property Group does not act as a fiduciary or advisor in connection with any transaction or investment strategy.


All financial models, projections, and scenario analyses provided by Mayer Property Group are based on market data, publicly available information, client-provided inputs, and various assumptions which may be subject to change. These models are intended to illustrate potential outcomes under certain conditions and should not be interpreted as guarantees of future performance. Clients are solely responsible for conducting their own due diligence and for consulting with their own legal, tax, financial, and investment advisors before making any investment decisions.


Mayer Property Group shall not be held liable for any actions taken, or decisions made, based on the content of its reports, models, or any related materials. The use of these materials is at the sole risk of the recipient.

Have a project you’re evaluating?

Contact us to learn more about how Mayer Property Group can support your project.

...or contact us via information below

Products Features

Resourses

Icon

©Mayer Property Group. 2025

The materials, financial models, and reports provided by Mayer Property Group are intended solely for informational and illustrative purposes. They are designed to present a transparent view of project-level financial structures, potential scenarios, and underwriting assumptions. These materials do not constitute investment advice, financial advice, tax advice, legal advice, or any other form of professional advisory service.


Mayer Property Group does not recommend, advise on, or endorse any specific investment, real estate transaction, or development project. The decision to proceed with any investment, acquisition, financing, or development opportunity rests entirely with the client or recipient of the materials. Mayer Property Group does not act as a fiduciary or advisor in connection with any transaction or investment strategy.


All financial models, projections, and scenario analyses provided by Mayer Property Group are based on market data, publicly available information, client-provided inputs, and various assumptions which may be subject to change. These models are intended to illustrate potential outcomes under certain conditions and should not be interpreted as guarantees of future performance. Clients are solely responsible for conducting their own due diligence and for consulting with their own legal, tax, financial, and investment advisors before making any investment decisions.


Mayer Property Group shall not be held liable for any actions taken, or decisions made, based on the content of its reports, models, or any related materials. The use of these materials is at the sole risk of the recipient.