Excel Best Practices and Functions

URLS for The Certificate in Financial Modelling and Data Analysis

The Certificate in Financial Modelling and Data Analysis website is now accessible through more URLs!! For convenience, the core site has been built on www.certfm.com. However, we have now added the other urls that may be easeir to remember! Depending on whether you prefer one or two l’s for “modeling” or “modelling” … you can …

URLS for The Certificate in Financial Modelling and Data Analysis Read More »

Key Stages in Modelling Risk and Uncertainty

The modelling of risk and uncertainty should involve several stages. These are summarised in this note. It is important to note that each stage is important, and if not performed adequately, the quality of the results, conclusions and decisions could be severely affected to the point that the analysis is wrong, very inaccurate or misleading. …

Key Stages in Modelling Risk and Uncertainty Read More »

Some Challenges in Using IRR in Decision Support (Part I)

The use of the internal rate of return in decision-making can be rather subtle and may even be misleading. For example, the decision rule: “For independent projects, accept the project if the IRR is above the required rate of return” is often stated as the core rule. However, the following demonstrates the general principle that …

Some Challenges in Using IRR in Decision Support (Part I) Read More »

Scroll to Top
error: Alert: Content is protected !!