There are few tools that are simpler and more versatile than Excel when it comes to business analysis and financial modeling. The Financial Modeling for Energy in Excel course will teach attendees how to leverage Excel to do both basic and intermediate financial calculations, with a focus on the Energy Sector. Along with key functions and features, students will learn best practices for the layout of inputs and the visualization of your outputs for various financial functions.
The course covers crucial topics including operational function and analysis, financial mechanics, and valuation metrics. Financial Modeling for Energy in Excel will teach the skills needed to calculate and analyze financial models for the energy sector effectively and efficiently.
Learning Outcomes
- Review the principles of intuitive model creation
- Build simple models with clean data, inputs, and outputs
- Use built-in Excel functions to perform common financial calculations
- Engage pivot tables to manipulate data
- Employ lookup functions
- Create intuitive visualizations for your data and model outputs
- Use Excel to do intermediate level valuations such as Internal Rate of Return and Discounted Cash Flow analysis
- Understand option principles and walk-through pricing examples
- Evaluate aggregate positions and mark-to-market value in a portfolio of energy contracts
- Create demand forecasting models using the linear regression capabilities of Excel
- Evaluate market risk in a project or portfolio
THURSDAY, DECEMBER 2, 2021
9:00 a.m. – 4:00 p.m. Central Time
Short breaks will be taken throughout the course
Financial Modeling Course Introduction
Introduction to Excel
- Model Principles
- Formatting Inputs and Outputs for Intuitive Use
- Basic Formulas for Finance
- Placement of Data and Lookups
- Pivot Tables
- Visualizing your Data
Morning Break
Introduction to Excel and Financial Modeling, Project Valuation
- Valuation Metrics
- Discount Factors, Weighted Average Cost of Capital (WACC)
- Internal Rate of Return
- Discounted Cash Flow Analysis
12:00 – 12:30 p.m. :: Lunch Break
Introduction to Financial Modeling for Energy, Energy Derivatives
- Energy Swaps and Futures
- Spread Contracts
- Options Contracts
- Option Pricing Formulas
Afternoon Break
Introduction to Financial Modeling, Portfolio Valuation
- Aggregating Positions
- Connecting to Market Data
- Position and MTM Reporting
FRIDAY, DECEMBER 3, 2021
9:00 a.m. – 12:00 p.m. Central Time
Short breaks will be taken throughout the course
Introduction to Financial Modeling, Demand Forecasting
- Historical analysis and seasonality
- Scatter plots and trend lines
- Linear regression
- Multiple regression
Morning Break
Introduction to Financial Modeling, Risk Management
- Scenario Testing
- Value at Risk
- Monte Carlo Simulation