Our solutions are tailored to each client’s strategic business drivers, technologies, corporate structure, and culture.
09/13/2024
Case Study: Investment and key financials for real estate developer and asset manager
CohnReznick helped a real estate developer and asset manager streamline processes and conducted a scenario analysis.
Background
The board requested the company to present projected financials at various cap rates across over 70 financial models.
What we did
We incorporated a control panel enabling their financial model in Excel to push the requested scenarios across the entire portfolio of models, and then consolidate key financials under each scenario, leveraging both VBA and Power Query.
Results
We enabled the client to streamline processes and conduct a powerful analysis which gave confidence to their board. In addition, the new, scalable automated process reduced the risk of error.
Antony Walker
FCA, CIRA, Principal, Financial Modeling & Decision Analytics Practice; Restructuring and Dispute Resolution Practice
Close
Contact
Let’s start a conversation about your company’s strategic goals and vision for the future.
Please fill all required fields*
Please verify your information and check to see if all require fields have been filled in.
Case Study
City and port sea level rise resilience project
Case Study
Real estate acquisition and disposal strategy for a Texas city
Case Study
Consolidating key financials for a renewable energy firm
Case Study
Residential and commercial solar company updates quarterly financials using automation
Case Study
Assessing growth opportunities for a luxury restaurant
Related services
Receive CohnReznick insights and event invitations on topics relevant to your business and role.
This has been prepared for information purposes and general guidance only and does not constitute legal or professional advice. You should not act upon the information contained in this publication without obtaining specific professional advice. No representation or warranty (express or implied) is made as to the accuracy or completeness of the information contained in this publication, and CohnReznick LLP, its partners, employees and agents accept no liability, and disclaim all responsibility, for the consequences of you or anyone else acting, or refraining to act, in reliance on the information contained in this publication or for any decision based on it.