Forward looking models

Summary

This advanced course will teach you how to build forward-looking models in Excel, incorporating tools such as decision trees and scenario analysis into the final solution. The course examines a fictional company that needs to make an important investment decision on a new technology.   Created & customized for Chartered Accountants Ireland by kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €75.00  (€75.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.00
CPD hours:  
3.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

Who Should Attend?

This course is suitable for advanced learners who are very familiar with writing formulas and performing analysis in Microsoft Excel. It is best suited to accountants, management consultants, analysts and other business professionals.

Course Overview

This Kubicle course contains 18 lessons, 4 exercises and 1 Exam. It covers the following topics:

  • Forward-Looking Models
  • Decision Trees
  • Building an Influence Diagram 
  • Structuring Your Model in Excel
  • Making Your Model Responsive
  • Shortening Formulas with New Variables
  • Risk-Weighted Cashflows
  • Tornado Charts
  • Updating Warnings for Charts 
  • Adding Taxes
  • Building Multiple Scenarios 
  • Analyzing Our Scenarios
  • Formula Auditing with Colorize

Key Outcomes

Once you have completed this course you will know how to approach a very common business problem, should we make an investment in a new venture? You will know how diagram this type of problem, build a simplified financial model in Excel and analyse the results of the model so as to make an informed decision. This ability is hugely valuable to organisations who methods for making better decisions that lead ultimately, to better financial results.