Financial Modeling for Energy in Excel

January 18-19, 2024 | Live Streaming Online

Click Here to register $1195

If you are unable to attend at the scheduled date and time, we make recordings available to all registrants for three business days after the event

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
  • Discuss 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



1:00 – 4:00 p.m. Central Time

Short breaks will be taken throughout the course (15 minutes total)

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

Afternoon 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


9:00 a.m. – 4:00 p.m. Central Time

Short Breaks will be taken throughout the day (30 minutes total)

Introduction to Financial Modeling for Energy, Energy Derivatives

  • Energy Swaps and Futures
  • Spread Contracts
  • Options Contracts
  • Option Pricing Formulas

Morning Break

Introduction to Financial Modeling, Portfolio Valuation

  • Aggregating Positions
  • Connecting to Market Data
  • Position and MTM Reporting

Lunch Break

Introduction to Financial Modeling, Demand Forecasting

  • Historical analysis and seasonality
  • Scatter plots and trend lines
  • Linear regression
  • Multiple regression

Afternoon Break

Introduction to Financial Modeling, Risk Management

  • Scenario Testing
  • Value at Risk
  • Monte Carlo Simulation


Stephen Naehr, Co-Founder and Partner, Vine Advisors

Stephen is a specialist in financial modeling, analytics, and energy risk management, with over 16 years of experience at commodity hedge funds, a global investment bank, and consulting for companies both in and out of the energy industry.  He is a founding partner of Vine Advisors, a firm that provides risk management, finance, and analytics solutions.

Stephen has a passion for developing innovative mathematical models to solve challenging problems.  As a physics Ph.D., he built computational models to simulate space weather phenomena.  Today he develops financial modeling tools to understand markets, risk, and valuation.

Outside of his consulting practice, Stephen serves as President of the Association of Industry Analytics, a non-profit organization that fosters professional development and networking opportunities among analysts and data scientists in various industries.  Through his work with AIA he has led workshops and lectures on topics including financial modeling, risk management, and database applications.