Financial Modelling with Excel

Summary

This course you will build a comprehensive and accurate finance Model that can be used as a decision-making tool.  Be able to communicate business and data insights with dashboards and understand how to use Excel’s NPV, IRR & MIRR Functions

Venue details:  
Belfast, 8-10 Amelia Street, Belfast
Start date & time:  
14 November 2019 09:30
End date & time:  
14 November 2019 16:30
Price: €270.53  (€257.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
10.00
CPD hours:  
7.00
Speaker details
First nameLast name
Mullan Training

Description

Product type:  
CPD course
Category:  
Information technology

Who should attend?

This course is not suitable for inexperienced Excel users. Delegates will be expected to be familiar with the following in Excel:

  • Linking Spreadsheets
  • IF Function & Nested IF Statements
  • And & Or Functions
  • Lookup Functions (Horizontal And Vertical Lookup)
  • Subtotals
  • Conditional Formatting 

Course overview 

  • The power of spreadsheets:
  • Forecast future cash flows
  • Ability to service debt repayments
  • Coordinate various revenue and expenditure budgets
  • How to avoid the pitfalls of a poorly designed spreadsheet:
  • Key variables and rules
  • End result of the model
  • Formatting of the spreadsheet
  • Data validation

Effectively using Pivot Tables to enhance the functionality of your Spreadsheet Model

  • When overseeing your financial model, you are expected to effectively manage revenues and costs and at the same time, consider the impact your decisions have on profitability and growth from both a strategic and tactical point of view.
  • Pivot tables are used to perform a cross-tabulation of data, summarising them into one or more classifications. By creating pivot charts, which combine all the same functionality of standard excel charts with the dynamic characteristics of pivot tables, you will be able to achieve a graphic report that updates data whenever it is changed.

Applying scenario techniques to determine alternatives and constraints in your financial model

  • By creating multiple scenarios for a single ‘what-if’ model, you will be able to assess each scenario with its own set of variables.
  • Understand relationships between scenarios, using scenario summary and pivot table reports by:
  • Defining scenarios in your spreadsheet
  • Understanding how to browse your scenarios
  • Adding, editing and deleting scenarios

Determining the appropriate capital budgeting models to formulate effective capital investment decisions

  • Discover how Excel can help you decide whether to undertake an investment project and correctly rank your projects.
  • Learn how and when to use Excel’s NPV, IRR and MIRR functions to assess your capital expenditure project by:
  • Understanding the NPV rule for judging investments and projects
  • Assessing the IRR rule for judging investments
  • Determining the appropriate method to use – NPV or IRR
  • Evaluating when IRR and NPV give the same answer
  • Establishing when to apply IRR and NPV for different project rankings
  • Using modified IRR (MIRR) to overcome the weaknesses of IRR

Key learning outcomes

  • Know how to adjust model variables and source data sets using dashboard interfaces (radio buttons, drop down lists, command buttons etc.)
  • Know how to effectively use Pivot Tables to enhance the functionality of your spreadsheet model
  • Know how to apply scenario techniques to determine alternatives and constraints in your Financial Model
  • Understand how Excel can help to decide whether to undertake an investment project
  • Know how and when to use Excel’s NPV, IRR & MIRR functions to assess your capitol