Show findcourses.co.uk as: Mobile

Our annual L&D survey is now OPEN. Have your say in our short survey and receive exclusive pre-access to the report.

Financial Modelling for Renewables

F1F9
Course summary
4 days
1,259 - 1,900 GBP excl. VAT
English
Full time
Corporate Training for Teams
Next available date: 9, 21, 26 & 28 October (9am-3:30pm UK time) - Online courses
Course Dates
Online courses
1,259 GBP
9, 21, 26 & 28 October (9am-3:30pm UK time)

Dubai
1,900 GBP
Enquire for more information

London
1,900 GBP
Enquire for more information

Toronto
1,900 GBP
Enquire for more information
Financial Modelling for Renewables

Course description

Financial Modelling for Renewables

Financial Modelling for Renewables focuses on the challenges that arise in preparing financial models for renewables projects: construction vs operations, seasonality, monthly timelines, P90 / P50 forecasting and financing (including equity bridge loans and cash sweeps). It is a modular course for analysts and financiers in the renewables sector who need to build, modify, or run financial models. It is available as a 2-day intensive and immersive classroom course, or as interactive tutor-led distance learning over approximately 30 hours.

Suitability - Who should attend?

This course is suited to participants who already have some basic Excel skills and aspire to, have recently started or know they are going to start building financial models in the renewable energy sector. We also assume that participants have a basic familiarity with the layout of financial statements (income statement, balance sheet and cash flow) but not necessarily how they are modelled.

Based on a template financial model with a monthly timeline, participants will cover – step-by-step – the construction phase (costs, income and financing), model optimisation for lenders and sponsors, equity bridge loans, cash sweeps and debt refinancing.

Outcome / Qualification etc.

This course will teach you:

  • The concepts of P90 and P50 and how to apply those within the model’s financial forecasts
  • Approaches for taking annual inputs and implementing those into a monthly financial model and how to aggregate monthly models into broader timelines
  • Methods for selecting different draw down options and how construction phase revenues can impact funding
  • How to optimise financial models under both P50 and P90 cases
  • How to model Equity Bridge Loans, Cash Sweeps and Debt Refinancing, all integral parts of typical renewable project financings
  • About the challenges of converting a bid model into an operational model

Training Course Content

Revenue

  • tariff and power generation
  • timeline / time sheet design and construction
  • seasonality
  • degradation

EBITDA

  • operating costs
  • P50 vs P90 scenario selection

Construction costs

  • sources and uses of funds
  • construction finance: approaches to debt draw downs
  • concept of funding circularity

Fees during construction

  • financing fees
  • interest during construction

Linking construction and operations

  • conversion of the senior debt from construction debt to term loan
  • term loan calculations
  • accrued interest balances

Term loan

  • principal repayment profiles
  • debt service cover ratios
  • debt sculpting

Model optimisation

  • equity rate of return
  • model optimisation: concepts and objectives
  • optimising the model under P90 and P50
  • introduction of Visual Basic / macro coding
  • checks / check sheet

Refining the model

  • aggregation of monthly data for financial summaries
  • track sheet
  • pre-completion date revenues
  • bid model vs operational model

Adjusting the financing

  • equity bridge loan
  • term loan cash sweep

Expenses

Course fee is £1,295

Get Inspired! Watch the Video

About provider

F1F9

F1F9 training courses are designed to transform your financial modelling skills. We are financial modelling experts, and our instructors have taught thousands of people to build best practice financial models that can be easily adapted, shared and understood. Our post-course...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Financial Modelling for Renewables.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

F1F9

The Guild, High Street
BA1 5EB Bath

 Show phone number
www.f1f9.com

Reviews

Average rating 4.8

Based on 12 reviews.

M. Klepper
Very good instructor and teaching assistant. The audience was a very inhomognous group ranging from excel-illiterate to VBA programmer to head of project finance. Instructor and teaching assitant managed to overcome these obstacles very well!
J. Quint
In my opinion you could tell, that both Toby and Marcwere experts in the topics (the Excel part as well as the renewable energy sector) and were able to answer any arising questions. The requirements and difficulty of the topics/tasks were adequate and the instructor had a pleasant pace, so that we were able to get a lot of input but still under...
Show more
S. Thomas
very good course with a lot of useful explanations. Course was easy to follow.
Request Information

Find out more about this Financial Modelling for Renewables course - simply fill out your details:

Reviews
Course rating
(4.8)
Based on 12 reviews.
Not sure where to start?
Be Inspired - watch the videos