Financial Modeling - Infrastructure Advisory : Project Finance

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 good 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 good understanding of the general business and economic environment; and

• Excellent communication and presentation skills

• Ability to build effective networks internally and externally