$1,050 – $1,200

Building a Financial Model (for Power Project Operations)

Event Information

Share this event

Date and Time

Location

Location

The Marquee Group

56 Temperance Street

Suite 200

Toronto, ON M5H 3V5

Canada

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

This course reviews project economic concepts and focuses on the skills required to design and create a financial model to help a power company decide whether it should invest in a new solar power project that has a power purchase agreement in place. The course material includes model design, logic, construction, financial concepts and accounting treatment. Various intermediate Excel tools along with helpful keyboard shortcuts will also be covered throughout the course.

Topics Include

Power Asset Dynamics and Economics

  • Review the unique modeling features required to evaluate a regulated entity
  • Discuss the specific revenue and cost drivers of a power project
  • Learn to create a model for which the returns to shareholders have been pre-set by the regulator

Design and Structure a Financial Model

  • Design and layout a financial model clearly and logically
  • Create clearly defined inputs and assumptions sections

Build Powerful Scenarios and Financial Statements

  • Use switches to create effective scenarios and value drivers
  • Forecast and build-up the project’s revenues and expenses
  • Design and incorporate a company’s income statement, balance sheet and cash flow statement
  • Construct all necessary schedules, including: Depreciation / CAPEX, Working Capital, Income Tax - Debt and Interest, Shareholders’ Equity

Evaluate the Project

  • Incorporate a schedule to evaluate the project’s returns: Net Present Value (NPV), Internal Rate of Return (IRR), Payback and Discounted Payback periods
  • Build a strong summary page to display the results
  • Set up print ranges to optimize the appearance of printed output

Who Will Benefit

This seminar is designed for anyone who wants to design and create a financial model to help decide whether a power company should invest in a new project.

Date & Time
May 23-24, 2018
8:30 am to 5:00 pm
Lunch will be provided

Special Instructions

  • Attendees must bring their own laptop with access to Excel.
  • Attendees should have a solid grasp of basic accounting fundamentals and proficiency with Excel prior to attending.
Share with friends

Date and Time

Location

The Marquee Group

56 Temperance Street

Suite 200

Toronto, ON M5H 3V5

Canada

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved