H4 Partners

Creation of a profitability model

Financial management system abstract concept vector illustration. Control system, open source software, business management tool, financial information, corporate budget planning abstract metaphor.

Context

  • 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
  • Quality and structure of the designed model

Tools used

  • Excel, Power Query

Our other customer cases

Implementation of management control in a multi activity SME Financial and operational piloting | Implementation of piloting | Start-up and SME
Detailed business plan modelling Start-Up and SME development | Business plan and valorisation | Search for funding | Start-up and SME
Improvement of the CSR reporting process of a large group Transformation Finance | Management of non-financial information and CSR reporting
Power BI Training for finance team Transformation Finance | Training & Talent Management | ETI and Large Group
Structuring of the finance function Transformation Finance | Organization Review and Change Management | Start-up and SME
Design of an interactive procedure pack for a large Group Audit and internal control | Internal control improvement | ETI and large group