We implemented a seven-step approach to address the client's needs by fostering close collaboration, embracing a holistic perspective, acquiring an in-depth understanding of their business, and working iteratively with the client on the development of the new model:
Evaluation of the current model: Assessing the existing model and conducting process and system investigations.
Data Collection: Gathering information on historical investments, evaluating data quality, and conducting stakeholder interviews for input.
Building Phase: Developing an Excel-based investment model, matching it with the client's financial terminology and structure, and evaluating potential additional features.
Testing and Adjustments: Testing the model, gathering feedback from the client, and making necessary adjustments for optimal quality.
Investment Evaluation: Assessing past investments in three projects.
Recommendations: Defining recommendations for investments and model development.
Training and Handover: Presenting results and next steps, as well as training and handing over the model to the client.