Excel Financial Modelling

Course summary
2 days
Corporate Training for Teams
STL courses

Excel Financial Modelling

Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... This course will show you why Excel is an essential tool for financial modelling, guide you through some key models and also introduce the practice of rolling forecasting. There will also be the opportunity to explore tying up actual models with reporting.; ; You may also be interested in our finance for non financial manager or VBA courses.; ;

Suitability - Who should attend?

Anyone looking to learn or extend their knowledge of using Excel to assist with financial decision making in a business context.

Training Course Content

Fundamentals of financial modelling

Applications for financial models
Vital differences between financial models and spreadsheets
Best practice in developing and building financial models
Getting the best results with Excel

Financial models and techniques for forecasting

Using Excel’s data analysis toolkit
Avoiding common forecasting problems
Using moving averages to isolate trends in time series data
Using linear regression to isolate trends in time series data
Using exponential smoothing to forecast sales demand
Building a financial model to make sales forecast
Using Excel Solver to minimise forecast error
Using Excel correlation tools to identify links between variables
Building a financial model to forecast costs
Understanding the drivers of business cash flow
Building a financial model to forecast cash flow

Financial models for capital investment decision-making

Principles of capital budgeting
Common approaches to capital investment decision-making
Understanding the time value of money
Principles of discounted cash flow (DCF)
Understanding and using Excel DCF functions
Building a financial model for capital investment decision-making

Financial models for forecasting and improving business performance

The elements, structure and dynamics of financial statements
Understanding the shareholder value concept
Measuring profitability with Return on Net Assets (RONA)
Managing the key drivers of RONA
Understanding and managing business risk
Building a financial model to forecast financial statements
Using rolling forecasts in adaptive management processes
Building a financial model to make rolling forecasts

Financial models for business valuation

The need for and approaches to business valuation
Understanding the shareholder value added (SVA) method
Building a financial model for business valuation


Prices from £1484. Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....

Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Excel Financial Modelling.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award


We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL


Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number

Similar Courses

Request information

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

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here