Modern managers need to possess and master a variety of short and long term financial decision-making techniques. This course will explore these techniques through a series of practical scenarios which illustrate how they can be used in the business environment. Excel is used extensively to develop a range of financial models to illustrate technique application.
The course will further explore the incorporation of risk and uncertainty into the decision making process by using more advanced Excel, and will also explore scenario modelling and sensitivity analysis using Excel.
Who should attend?
This practical and interactive course is aimed at mangers working in a variety of positions. Financial decision makers wishing to develop their Excel skills would benefit from this course. Managers with financial responsibilities wishing to develop their decision making capabilities would also benefit from attendance. Delegates wishing to attend should be competent in the use of Excel as the course is designed to improve delegates’ ability to use Excel to make decisions rather than to teach delegates to use Excel.
Decision making principles and effective use of Excel
- Decision making frameworks and levels
- Approaches to decision making
- How Excel can support effective decision making
Short term financial decision making using Excel
- Short term financial decision making and its
- Approaches to short term financial decision making
- Using Excel to improve short term financial decision making
Modelling capital l investment decisions using Excel
- Approaches to capital investment decisions
- Relevant cash flows and investment decision making
- Using excel to refine investment decision making
What if analysis and scenario modelling
- Changing the parameters of a financial model
- Sensitivity Analysis
- Using Excel to support scenario modelling
Decision making under risk and uncertainty
- The impact of risk and uncertainty on decision making
- Incorporating risk and uncertainty into decision making
- Using Excel to model risk and uncertainty