Financial Modeling for Energy in Excel
November 14-15, 2024 | Online :: Central Time
“This is an excellent training, the materials being put together is valuable for beginners who wants to dive into the energy markets. Using excel to model it makes it clear to see how the computation is done, in a simple and clean way.” Software Development Manager, Power Costs, Inc.
“The course really opened my knowledge on new ways of using spreadsheets.” Analyst, Brookfield Renewable
“Excellent training for anyone new to financial modeling for the energy sector. The presenter starts with foundational concepts and builds upon that foundation. The Excel exercises are particularly helpful and provide great templates for anyone looking to learn some basic modeling techniques.” Accounting Manager, Glidepath Power Solutions LLC
“Great courses and excellent instruction. Highly recommend!!” Risk Consultant, APS
There are few tools that are simpler, more versatile, and more broadly used 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 their outputs for various financial situations and scenarios. The course will cover crucial topics including the following:
- Operational function and analysis
- Financial mechanics
- Valuation metrics
Financial Modeling for Energy in Excel will teach the skills needed to build financial models, analyze operational and financial scenarios and calculate solutions to typical energy sector issues, 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 with focus on concise presentation of results to leadership
- Use Excel to do intermediate level valuations such as Internal Rate of Return and Discounted Cash Flow analysis
- Build proforma financial statements with financial metrics and discuss how they impact project/investment decisions
- Develop and analyze a capital budget
- Review basic treasury functions and calculation of related credit metrics
- Discuss basic tax topics impacting the energy sector
- Review regulatory planning topics for utilities and financial challenges for investor-owned utilities
- Discuss option principles and walk-through pricing examples
- Evaluate aggregate positions and mark-to-market value in a portfolio of energy contracts
Thursday, November 14, 2024 : Central Time
8:45 – 9:00 a.m.
Log In and Welcome
12:00 – 12:30 p.m.
Lunch Break
9:00 a.m. – 4:00 p.m.
Course Timing
Financial Modeling Course Introduction
- Course objectives
- Introduction to Energy Industry Financial Terminology
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
Introduction to Financial Statement Analysis
- Review Project Financial Statements
- Analyze and Build a Capital Budget
- Build an Original Proforma Financial Statement
Introduction to Treasury Analysis
- Building and Analyzing Capital Structures
- Discount Rates, Weighted Average Cost of Capital (WACC)
- Calculation of Credit Metrics and Rating Agency Considerations
Basic Tax Topics Impacting Financial Valuations
- Deferred Taxes and Cash Flows
- Investment and Production Tax Credits
Introduction to Excel and Financial Modeling – Project Valuation
- Valuation Metrics
- Internal Rate of Return
- Discounted Cash Flow Analysis
Friday, November 15, 2024 : Central Time
8:45 – 9:00 a.m.
Log In
9:00 a.m. – 12:00 p.m.
Course Timing
Regulatory Planning Overview
- Building a Rate Base
- Simple Cost of Service Model
- Regulatory Return Background
- Financial Challenges of Investor-Owned Utilities
Introduction to Financial Modeling for Energy – Energy Derivatives
- Energy Swaps and Futures
- Spread Contracts
- Option Contracts
- Option Pricing Formulas
Introduction to Financial Modeling – Portfolio Valuation
- Aggregating Positions
- Connecting to Market Data
- Position and MTM Reporting
Amanda Morton, Business Development Manager – Distribution Solar, Dominion Energy
Amanda Morton began her career in the energy finance industry twenty-five years ago after graduating with a Masters in Business Administration with a concentration in finance from The College of William and Mary in Virginia. Prior to that, she attended George Mason University, outside of Washington DC, studying Economics and then completing undergraduate coursework at Virginia Commonwealth University with a Bachelor of Science in Finance, minoring in Economics.
Amanda has enjoyed an extensive career at Dominion Energy, focusing on numerous financial roles including financial analysis, financial planning and budgeting, financial modeling, treasury and short-term funding, risk management and most recently a role outside of finance in business development, acquiring renewable assets for Dominion. Her numerous financial roles have covered the power generation business with focus on nuclear and renewable assets, natural gas distribution and transmission, electric distribution, and transmission along with numerous corporate level finance roles. During her time in Treasury, she managed Dominion’s commercial paper programs totaling $4.5 billion in capacity. While at Dominion, Amanda earned her Chartered Financial Analysts certification along with a Certified Treasury Professional designation. Amanda currently is a guest lecturer at Virginia Commonwealth University where she leads students in a capstone case study she wrote pertaining to financial modeling for a start-up renewable energy business.
We will be using Microsoft Teams to facilitate your participation in the upcoming event. You do not need to have an existing Teams account in order to participate in the broadcast – the course will play in your browser and you will have the option of using a microphone to speak with the room and ask questions, or type any questions in via the chat window and our on-site representative will relay your question to the instructor.
- Microsoft recommends downloading and installing the Teams app if possible. You may also use the Edge browser or Chrome.
- You will receive a separate email with a unique link to a personalized landing page which will include links to join all sessions of this event.
- If you are using a microphone, please ensure that it is muted until such time as you need to ask a question.
- The remote meeting connection will be open approximately 30 minutes before the start of the course. We encourage you to connect as early as possible in case you experience any unforeseen problems.
Please Note: This event is being conducted entirely online. All attendees will connect and attend from their computer, one connection per purchase. For details please see our FAQ
If you are unable to attend at the scheduled date and time, we make recordings available to all attendees for 7 days after the event
REGISTER NOW FOR THIS EVENT:
Financial Modeling for Energy in Excel
November 14-15, 2024 | Online
Individual attendee(s) - $ 1195.00 each | |
Volume pricing also availableIndividual attendee tickets can be mixed with ticket packs for complete flexibility |
|
Pack of 5 attendees - $ 4,780.00 (20% discount) | |
Pack of 10 attendees - $ 8,365.00 (30% discount) | |
Pack of 20 attendees - $ 14,340.00 (40% discount) | |
Your registration may be transferred to a member of your organization up to 24 hours in advance of the event. Cancellations must be received on or before October 11, 2024 in order to be refunded and will be subject to a US $195.00 processing fee per registrant. No refunds will be made after this date. Cancellations received after this date will create a credit of the tuition (less processing fee) good toward any other EUCI event. This credit will be good for six months from the cancellation date. In the event of non-attendance, all registration fees will be forfeited. In case of conference cancellation, EUCIs liability is limited to refund of the event registration fee only. For more information regarding administrative policies, such as complaints and refunds, please contact our offices at 303-770-8800
Credits
EUCI is accredited by the International Accreditors for Continuing Education and Training (IACET) and offers IACET CEUs for its learning events that comply with the ANSI/IACET Continuing Education and Training Standard. IACET is recognized internationally as a standard development organization and accrediting body that promotes quality of continuing education and training.
EUCI is authorized by IACET to offer 1.0 CEUs for this event.
Upon successful completion of this event, program participants interested in receiving CPE credits will receive a certificate of completion.
Requirements for Successful Completion of Program
Participants must log in each day and be in attendance for the entirety of the course.
Instructional Methods
This program will use PowerPoint presentations, Excel demonstrations, group discussions, as well as active participation.
Upon successful completion of this event, program participants interested in receiving CPE credits will receive a certificate of completion.
Course CPE Credits: 11.0
There is no prerequisite for this Course.
Program field of study: Specialized Knowledge
Program Level: Basic
Delivery Method: Group Internet Based
Advanced Preparation: None
EUCI is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its web site: www.nasbaregistry.org
Who Should Attend
- Utility Capital Planners
- Project Managers
- Financial Reporting Analysts
- Accountants
- Budget Analysts
- Other employees of utilities looking to gain more of a finance education for utilities (e.g., finance support staff in IT, long-term planning, or elsewhere)
- Consultants in the utility industry looking to broaden their finance knowledge