Become a Pro in Excel, Oil & Gas Financial Valuation Modeling Analysis and Oil & Gas Accounting in 7 weeks
I'm actually a freelance Financial Analyst. I participated (partially) recently to the 2019 Global Financial Modeling Competition (www.financialmodeling.org ) and won a prize 23 months ago in the context of the Fintech Partner Search challenge (proposed by Norma Piche on Herox, a Crowdsourcing platform based in Vancouver, British Columbia) which consisted, by the time, to build an efficient Financial Planning Software ( https://herox.com/fintech-partner-search/update/1699 ). On the other hand, I have been before a Tax Evasion Research Consultant in my homeland (Congo) back in November 2009, an Accountant Analyst for SOLAS (a ENI subcontractor by the time), a Corporate Finance Consultant for a small SME which was a TOTAL EP subcontractor by the time for the pipeline cathodic protection activity, a Production Sharing Agreement and Reporting Accountant (Chevron), and; an IAC Consultant (www.internationalanticorruption.com ) tracking financial transactions within the O&G industry which could be eligible for the Dodd Franck Act Reward Program sponsored worldwide by SEC (www.sec.gov).
Starting November 30th, I'm sharing my experience and findings in tracking O&G figures through 2 modules: "Oil & Gas Mergers & Acquisitions Financial Modeling best practices" and "Oil & Gas Accounting best practices per the Successful Efforts Method". These courses will likely be associated to some Advanced Excel Formulas and tips for those ones who would like to upgrade their skills (Note that Advanced Excel is a pre-requisite to fully understand the courses pre quoted). The goal behind this approach is not to metamorphose you in a O&G FinMo guru. I just aim to share some of the best practices I have learned these last years as an employee and a Consultant...
For instance, after collecting some data from some of O&G majors, I notice their Financial Analysts used to count some costs carried on behalf of third-parties as "purchases" when it comes to payback those ones in "kind"; they naturally count the interest charged on those costs as an interest income. Reimbursements in kind are generally offset by a "fictive asset" specially created for that purpose. However, it seems like this practice violates FAS 19 (issued in December 1977 to regulate Financial Accounting and Reporting by Oil and Gas "producing companies")... IFRS accounting policy approximately aligns with this... What's the best thing to do to avoid any negative P/L impact? How to model this issue and sort out it in Excel? An another example is more strategic: "As a Financial Planning Analyst, what do you think is a better investment between leasing a rig (assuming this option typically costs $200k-$700k per day!) or buy it during the exploration phase (I mean before FEED and FID) when some contingencies may be determinant to impact the future of the project?".
These are just two examples of some tremendous things you'll learn once you enrolled the program. Courses are initially in English. Translators are working hard day and night to make them available in French.
To enroll a module, just e-mail me through this blog and download Bluejeans to start acquiring new skills.
Thanks