Financial Modeller

Job Description : FINANCIAL MODELLER 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 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 excels 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 • Identify key financial and non-financial risks and recommend actions for mitigating those risk • Apply appropriate sensitivity and scenario analysis to support model outcomes and decisions • Financial & Commercial Due Diligence on new deals and new projects • Developing, reviewing and negotiating financial and commercial terms and conditions in agreements • Financial and cost management of new projects • Supporting vendor, partner, customer negotiations as a financial and commercial specialist • Supporting Management review and approvals of new projects from financial and commercial perspectives Desired Candidate Profile Age Profile 35+ Years -15 years of relevant specialist experience as a Senior Financial Modeler, additional generic experience in financial controllership and accounting functions is desirable. Prior experience in large Upstream oil and gas industry companies or in a reputed investment bank or a Big 4 Consulting Organization will be highly desirable Strong problem solving and decision-making skills, with ability to evaluate alternatives and provide recommendations on key business issues. Deep and advanced Excel modelling skills. Proficiency in VBA (added advantage) Statistical Analysis Tools like SAAS etc additional advantage Must be a good team player with positive energy. Well-developed written and oral communication skills. & Good attention to details Fluency in English, orally and in writing, is a must and other languages such as French will be an asset.

---