Project modelling using Excel - Workshop 2017

This workshop is designed for accountants, finance professionals and managers who need to increase their knowledge of project finance. The workshop will provide you with a thorough understanding of how to build a robust financial model from start to finish.  You will consider drivers for revenue, operations and maintenance costs, capital expenditure, depreciation, debt and equity modelling and taxation.  During the workshop you will run a range of scenarios and adjust the timing of key events to culminate in the completion of a financial statement into the viability of the new project. 

Click on the image below for Marcus Small's biography.

Key topics:

  • A comprehensive overview of the theory of project modelling in Excel
  • The modelling of revenue, expenses, capital expenditure and finances
  • A thorough grounding in the tools and functions available in Excel including: INDEX, MATCH, VLOOKUP, SUMIFS, SUMPRODUCT, OFFSET, PPMT, XNPV, MIN, and nested IF Statements
  • The creation of a corkscrew account which will assists in modelling debt
  • Modelling revenue, expenses, capital expenditure and the finances to fund the project
  • Using the equity discount rate, the model will automate a project cost using Excel’s goal seek tool and some VBA (which will be provided)
  • A more streamlined method to calculate straight-line depreciation where the asset commissioning date drives the calculations
  • Map the impact of inflation on salary, operational and maintenance costs
  • Creating NPV and IRR calculations using both project and equity cash flow
  • Practical guidance on the layout and structuring of workbooks for analysis and project forecasting

Learning objectives

  • Follow a logical, structured and disciplined approach towards designing and building financial models
  • Build two distinct models from start to finish
  • Demonstrate project finance transactions, the types of models used and their layout
  • Define the meaning of the outputs of these models and translate to management
  • Add simple VBA code to a model to automate common Excel tasks which will aid with model calculations
  • Reduce modelling errors to make your models more robust

Audience

This workshop is designed specifically for finance and accounting professionals who use Excel in their day to day roles.

Participants will gain the maximum benefit from this course if they are already competent spreadsheets users. The course is designed for people who use Excel on a regular basis, and are comfortable with using its tools and functions.

Please bring a USB.

 

Looking for a customised learning solution for your organisation or team? Contact us today to discuss in-house learning options.

1 day

loading...