Portfolio Financial Modeler Analyst AMEA Power

Update and maintain financial models in AMEA portfolio

• Model Updates: Regularly update the existing financial models with actual historical costs, revenues, production and other parameters, ensuring the alignment with the (un-)audited financial statements while maintaining the forward-looking mechanics and projections for valuing, monitoring, reporting and forecasting portfolio investments.
• Data Management: Ensure accuracy of input data, maintain data integrity and model mechanics functionality, and update assumptions (e.g., inflation, FX rates) regularly.
• Ratio Calculation: Regularly carry out calculation of debt service ratios, estimation of distributable cashflow as per signed financing agreements. Share and discuss calculations with lenders (and auditors).
• Distributions estimation: Regularly estimate the distributable cash amount allowed under the financing agreements. Calculate and optimize the timing, amount and sequence of different types of distributions: dividends, principal and interest of shareholder loans, development fees, technical and asset management fees, share capital reductions, etc.
• Reporting: Prepare financial reports, debt service ratios and covenants certificates for internal management reporting and for lenders. Create and present detailed investment reports for stakeholders and management to support decision-making.
• Performance Analysis: Conduct portfolio valuations, track cash flows (IRR, NPV), and evaluate performance against benchmarks.
• Scenario Planning: Perform stress testing and scenario analysis to assess risk exposure based on micro/macroeconomic factors and operating conditions.
• Collaboration: Work with corporate finance team, project finance team, legal team, technical team and SPV local teams to align models with operational results and (un-)audited financial statements.
• Assist in negotiations and execution of any re-structuring & re-financing activities of portfolio projects.
• Support due diligence, financial modeling and risk analysis for portfolio projects.
• Provide financial modeling and analytical support for discussions with various stakeholders: Internal (e.g. work streams, Executive Management Team); and External (e.g. co-developers/shareholders and Lenders).
• Contribute to negotiations of MOUs, JDAs, PPAs, Concession Agreements, Tax / Investment Conventions, etc.
• When needed, interface and lead external advisors and consultants.
• Assist in updating project documentation to satisfy investors and management.

Assist in optimizing returns

• Assist in evaluation and decision-making on technical and engineering optimization of operating projects.
• Assist in financial engineering schemes to improve project economics.
• Contribute to risk analysis of projects.

Support valuation of projects

• Effectively use valuation tools for different project types and stages.
• Possess and actively use expertise in financial modeling and financial analysis.