Intermediate Financial Modelling

£2,200.00

This is a full-venue event. Training tools, Certificates and refreshments will be provided. Should you be interested in the online version or your in-house delivery? Please contact us.

Description

Introduction

Financial models are necessary to evaluate a project’s economics, negotiations among stakeholders, and a crucial component of the final documentation.

While the development and analysis of project finance models are often delegated to external financial advisors, it is crucial for certain selected officials involved in a transaction not only to have an understanding of how financial models work but also to have the capability to manipulate the model.

Course Content

  • The Excel interface providing the Context for Limited Recourse Project Finance
  • Understanding and Developing the Different Building Blocks of Financial Models
  • Introducing Tax and Depreciation
  • Golden Rules of Model Design, Building a financial forecast
  • Building a Financial Model from a Blank Screen and Final Quiz
  • Forecasting the income statement and balance sheet
  • Linking up the cash flow statement
  • Working with Scenarios, Key Auditing Tools
  • The excel interface, Writing a model
  • Editing ‘without tears.’, Conditional logic, Dates & times in excel
  • Text formulae, Excel graphics & tables
  • Data analysis & database functions

Learning Outcomes

  • By the end of the course, participants will have learned about all the features typically used in financial models, describe the purpose and scope of project financial models (i.e. what a financial model is and why project stakeholders need it)
  • Identify the financial model’s key outputs and calculate them
  • Construct a semi-flexible financial model inclusive of key model building blocks
  • Design funding sheets with debt financing
  • Construct Pro-forma financial statements
  • Manage assumptions in a financial model to affect results
  • Design, set-up, and effectively label spreadsheet models for project financings

Event Details

NOTE: For our customised events all you need to do is provide us with what you want to achieve or tell us about the training requirements of the group and we will agree on a date, venue and produce a course proposal for you along with the costs. Discounts may be applicable for group booking or early birds.

Start date: 11 January 2021

End date: 15 January 2021

Start time: 09:00 BST

End time: 17:00 BST

Venue: London, UK

Phone: '+44 1582 414 144

Email: admin@prospectsds.com

Product Enquiry