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

Client

Investment Firm

Time Spanned

1 Day

About Project

Project Overview



A client approached Mayer Property Group with an existing underwriting model for the acquisition of a stabilized multifamily asset. The original model had been built with preliminary operating assumptions and an outdated hold period that no longer aligned with their revised investment thesis. The property featured a mix of one- and two-bedroom units.



Objective



The goal was to improve the accuracy of the model by updating select underwriting assumptions and providing a clean, refined version for internal decision-making and external review.



Scope of Work



Our engagement focused on two primary adjustments:


1. Hold Period Revision
The original hold assumption was reevaluated based on the client's updated business plan. We adjusted cash flow schedules, exit timing, and debt payoff calculations to reflect a new five-year timeline.


2. Operating Expense Refinement
We reviewed each expense category and updated projections to reflect current market benchmarks and comparable asset performance. This included utilities, property management, repairs and maintenance, and insurance.



Outcome



The updated model gave the client a more accurate view of projected performance under the new hold strategy and helped them better assess both leveraged and unleveraged returns. The refinements supported internal investment committee review and improved alignment between the pro forma and current market trends.

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.

 A high-resolution image of a modern 3-story, 140-unit multifamily apartment complex in California, featuring Mediterranean-style architecture with beige stucco walls, brown accents, balconies, and a clean, landscaped exterior under a clear blue sky.
 A high-resolution image of a modern 3-story, 140-unit multifamily apartment complex in California, featuring Mediterranean-style architecture with beige stucco walls, brown accents, balconies, and a clean, landscaped exterior under a clear blue sky.
 A high-resolution image of a modern 3-story, 140-unit multifamily apartment complex in California, featuring Mediterranean-style architecture with beige stucco walls, brown accents, balconies, and a clean, landscaped exterior under a clear blue sky.
 A high-resolution image of a modern 3-story, 140-unit multifamily apartment complex in California, featuring Mediterranean-style architecture with beige stucco walls, brown accents, balconies, and a clean, landscaped exterior under a clear blue sky.

Comprehensive financial modeling and underwriting for the acquisition of a stabilized multifamily asset in California. Included rent roll analysis, operating forecast, and capital structure testing across multiple financing scenarios.

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.

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.