Finance Modeller

Job Description

Job descriptionRoles and Responsibilities
• Build, modify, audit and operate Microsoft Excel based Financial, Economic and Quantitative Models to support:
Business, operational and financial decision makingtechno-commercial feasibility studies for new projects or business diversification and business expansion projectsCost-benefit analysis for multiple options of business ventures and business investmentsOptimization of Capital Mix decisions (Debt, Equity, Working Capital, Fixed Capital etc.)Simulation analysis for different forecasting scenarios with respect to Macroeconomic factors, Market Environment and Industry specific Market Factors, internal technical and operational parameters and factors, business volumes or outputForecasting of Financial Statements (P&L A/C, Balance Sheet, Cash Flow / Fund Flow Statements etc.) and support Budgetary Control process
• Build excel based quantitative and financial models for Upstream, Midstream and Downstream Oil & Gas Businesses following the conditions and the logic as stipulated in the relevant commercial agreements and arrangements related to:
Cash Waterfall Sequencing (Revenue, Opex., Taxes, Transfer to designated reserve accounts, Cost Recovery, Financing Charges, Profit Distribution etc.)Funding of the Project and repayment of Debt Financing / Advance through Cost Recovery MechanismComputation of financing cost and payment of financing costComputation of various forms of taxes, depreciation schedules etc. (based on Contractual arrangements as well as relevant statutory provisions)Distribution of Surplus funds at various stages to various stakeholders such as Service Providers, Govt. Agencies, Financiers, Shareholders etc. as per the
• Provide relevant support to track, forecast and report on the progress of the payments and calculations relating to Cost Recovery and Compensation

Keyskills :
strategic supplier developmentfinancefinance controldirect materialsmake/buy decisions