Client

Investment Firm

Time Spanned

Ongoing

About Project

Project Overview



Mayer Property Group is providing ongoing financial modeling and underwriting support for the acquisition of a multifamily property in California. The client — a real estate investment firm — engaged us to evaluate deal feasibility, test capital structures, and refine underwriting as they navigate acquisition negotiations and early-stage diligence.



Project Objectives



  • Build a flexible 10-year acquisition model aligned with the firm’s investment thesis

  • Analyze in-place operations and forecast post-acquisition cash flows

  • Evaluate financing scenarios and support preliminary return analysis for LPs



Modeling Approach



We developed a full-scale acquisition model including operating cash flow projections, loan sizing, and equity return profiles. The model incorporates unit-level rent roll analysis, historical operating data, and forward-looking assumptions for rent growth, expense inflation, and exit valuation. Multiple capital structures — including interest-only and amortizing debt — were modeled to reflect financing options under consideration.



Key Focus Areas



Acquisition Underwriting
The model captures in-place and pro forma cash flows, blending real operating data with market assumptions to inform acquisition pricing and capital structure decisions.


Capital Structure Evaluation
Scenarios include different leverage levels, pref equity options, and refinancing pathways. All designed to align with investor return targets and risk tolerance.


Investor Return Modeling
Equity cash flows, IRRs, and equity multiples are broken out by partner class, providing the client with clear visibility for LP presentations and internal reviews.



Outcome



The model is serving as a live underwriting tool, updated continuously as new deal inputs are received. It has helped the investment team refine offer terms, assess sensitivity to financing variables, and prepare for internal and external investment committee discussions.



Impact



This engagement highlights Mayer Property Group’s ability to provide responsive, deal-specific underwriting support during critical acquisition windows. Our modeling framework ensures the client can adapt quickly to shifting deal terms while maintaining clarity around return drivers and risk exposure.

Explore more our cases

Explore more our cases

A modern, mid-rise hotel situated in New York. The 13-story building features a beige brick facade with dark window frames and balconies, blending contemporary design with the surrounding historic architecture. A clear blue sky and active urban street set the scene.
A modern, mid-rise hotel situated in New York. The 13-story building features a beige brick facade with dark window frames and balconies, blending contemporary design with the surrounding historic architecture. A clear blue sky and active urban street set the scene.
A modern, mid-rise hotel situated in New York. The 13-story building features a beige brick facade with dark window frames and balconies, blending contemporary design with the surrounding historic architecture. A clear blue sky and active urban street set the scene.
A modern, mid-rise hotel situated in New York. The 13-story building features a beige brick facade with dark window frames and balconies, blending contemporary design with the surrounding historic architecture. A clear blue sky and active urban street set the scene.

Financial modeling and scenario analysis for a hotel acquisition, focused on evaluating three distinct equity waterfall structures. Work supported negotiations between the sponsor, lender, and equity partner to determine the most balanced capital structure.

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.

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.