Finance Modelling Manager

Job Description : FINANCIAL MODELLING MANAGER NIGERIA · 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 • Optimisation 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 MBA/B.Tech with minimum 10 years of core experience into Financial modelling Industry Preference:- Oil& Gas/ Heavy Engineering/Big 4 Consulting/Petrochemical/Steel

---