An Introduction to the Excel Environment, with Oil and Gas based Examples • A Quick-start Tutorial for Excel • Describing Data Sets using Statistics • Representing Data Sets Graphically • Understanding the Concept of Normal Distribution • Trend Analysis using Excel • Time Series Analysis • Mini-Case Studies Statistical Analysis (Applied to the Oil and Gas Industry) Using Excel • Use of Excel Functions for Statistical Analysis • Descriptive Statistics • Mean, Median, Standard Deviation, Skewness and Kurtosis • Use of Scatter Diagrams, Frequency and Histogram Distribution • Regression Techniques to Calculate Cost of Equity Financing • Analysis of Equity Returns of Oil and Gas Industry Companies • Mini-Case Studies Investment Appraisal Using Excel • Investment Appraisal using NPV, IRR and Payback as Applied to the Oil and Gas Industry • Use of Excel Functions for Investment Appraisal: IRR, PV and NPV • Modified Internal Rate of Return (MIRR) • Use of Scenario Analysis and Stress Testing • Predicting Financial Distress • Mini-Case Studies Financial Analysis in the Up and Down Stream Oil and Gas Industry • Introduction to Financial Statements • Ratio Analysis Applied to the Oil and Gas Industry • Ratios as a System – Pyramids of Ratios • Financial Modelling • Cashflow Forecasts using Excel • Mini-Case Studies Oil Product Spreads • Examining the Relationship between Energy Products • Differences between Data Sets • Correlation Analysis • Confidence Intervals • Analysis Of Variance (ANOVA) • Mini-Case Studies |