Role Title: Associate ConsultantConsultant : Financial Modelling
Location: Gurgaon
Responsibilities
Your responsibilities will include
Support the specification / design of models and analysis tools.
• D evelop models (incl. integrated P&L;, Cash flow and Balance sheet models) from scratch.
Amend models developed by KPMG staff or by third parties.
Carry out financial analysis of the outputs of models.
Ensure the consistency in client models and create / maintain project documentation and data books.
Carry out testing of models as per KPMG quality control procedures.
Review models and feedback findings to clients using KPMG proprietary software.
Review and comment on revised models received from clients to verify whether review comments have been acted upon.
Document the operation of models and the findings from our work.
Document issues in a business model for inclusion in review reports and liaise with the project manager to fully explain the points raised.
Design and execute commercial analysis e.g. market sizing, market driver analysis, competitive benchmarking etc.
Develop business cases and business plans underpinned by robust financial analysis in support of strategic initiatives.
Skills and Qualifications: To succeed in this demanding role you will need to demonstrate the following skills and experience:
• 1+ years working experience of Financial Analysis, Business Modelling or Financial Modelling; building project finance models with transaction advisory experience. worked on Greenfield projects and have done PPP work.
Experience of debt sizing/sculpting mechanics, DCF construction
A valuable working knowledge of accounting, financial statements, and financial analysis;
Strong analytical and problem solving skills;
Advanced knowledge of Microsoft Excel;
A commercial outlook and a valuable understanding of the general business and economic workplace; and
Excellent communication and presentation skills
Ability to build effective networks internally and externally