Real estate developer lacking a profitability analysis (IRR) to make decisions during pre-investment committees and thus engage potential investors
Existing software with detailed financial statement and cash flow plan but only adapted to project follow-up and not to profitability simulations
Objectives
Provide users with a simple and standardized model to analyze the profitability (IRR: Internal Rate of Return) of each real estate project in the context of investment committees.
Deliverables achieved
Complete standardized financial analysis for each new project (input data, financial statement, cash flow and IRR)
Tool implemented and used by all developers and management
User’s manual for users
Key success factors
H4 Partners experience in financial modeling
Work closely with management to meet the needs of the investment committee
Tests of the model with users to take into account the requirements and constraints of end users
Development of an application with a validation workflow for managing annual restatements. Finance transformation | Transformation of the finance function | Mid-cap and large group
Creation of investor reports and monitoring of valuations using Power BI. Development of Power BI dashboards | Modelling and performance analysis | Funds
