Financial Modelling with Excel 2010/2013/365
Enquire About This Course
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)
- Conditional Formatting
In this course you will build a comprehensive and accurate Finance Model that can be used as a decision making tool.
- Learn how to adjust model variables and source data sets using dashboard interfaces (radio buttons, drop down lists, command buttons etc.)
- Learn how to effectively use Pivot Tables to enhance the functionality of your spreadsheet model
- Learn how to apply scenario techniques to determine alternatives and constraints in your Financial Model
- Discover how Excel can help you decide whether to undertake an investment project
- Learn how and when to use Excel's NPV, IRR & MIRR functions to assess your capitol
- Having completed the training the attendees will be able to:
- Communicate business and data insights with dashboards
- Understand how to use Excel's NPV, IRR & MIRR Functions
- Build a Cash Flow statement
- Build a Valuation model from scratch
1. Spreadsheet: design and structure
Mastering key steps with practical exercises to practically design and structure your spreadsheet layout in order to achieve a well-constructed and error-free financial model.
Use tried and tested spreadsheet techniques for tracking company cash flow and monitoring profitability.
Master the key steps in successfully building a comprehensive and accurate finance model as a decision-making tool for understanding:
- What are financial modeling and its objectives?
- The power of spreadsheets:
- Forecast future cash flows
- 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
- The layout in designing an error-free financial model
- Data validation
2. Effectively using pivot tables to enhance the functionality of your spreadsheet model
- Use Pivot Tables to perform a cross-tabulation of data, summarizing 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.
Learn how to:
- Understand the key features of a Pivot Table
- Prepare a Pivot Table
3. 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
4. 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
Click here to download our Course Outline:
MS Financial Modeling With Excel 1 Day _11_
This course is for Advanced Excel users. Please complete our Excel Competency Checklist, return to us and we will advise if you are eligible to attend this course.
Excel Competency Checklist
Enquire About This Course