Job Description
Roles and Responsibilities
- Build, modify, audit and operate Microsoft Excel based Financial, Economic and Quantitative Models to support:
• Business, operational and financial decision making
• techno-commercial feasibility studies for new projects or business diversification and business expansion projects
• Cost-benefit analysis for multiple options of business ventures and business investments
• Optimization 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 output
• Forecasting 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 Mechanism
• Computation of financing cost and payment of financing cost
• Computation 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
- Using the model, determine and advice on the likelihood of a shortfall in internal rate of return (IRR) related to the project
- Integration of Excel Models, as a Business and Financial Analyst, and not as an IT Database Specialist, with Corporate Data Warehouses and data from Transaction Processing and Business Intelligence Systems (ERP and BI Systems)
- Design, build and implement other financial & business models as may be directed by Senior Management
- Apply appropriate sensitivity and scenario analysis to support model outcomes and decisions
- Financial & Commercial Due Diligence on new deals and new projects
- Supporting Management review and approvals of new projects from financial and commercial perspectives
Desired Candidate Profile
CA with minimum 6-9 Years of Experience into Financial Modelling into Manufacturing company
Perks and Benefits
To be discussed on call