January 2013 Academic Enews: Illinois State's MBA Corporate Finance uses @RISK for Advanced Techniques

Wednesday, January 30, 2013 by DMUU Training Team

Palisade January 2013 Academic Enews
In This Issue

» Illinois State's MBA Corporate Finance uses @RISK for Advanced Techniques

"Just like Excel itself, @RISK does its work without involving you in its computational complexities. So students who may have been scared of stats and data analysis before can feel perfectly at ease creating their simulationsand so, they want to do more."
     Dr. Domingo Castelo Joaquin, College of Business, Illinois State University

» Recent School Adoptions

» Licensing Options

» Teaching Tips & Examples
   Hedging with Futures

» Tech Tip
   RiskCollect

» Textbook of the Month
   Statistics for Business and Economics

» Featured White Paper
   A participatory approach for integrating risk assessment into rural decision-making

» Academic Live Webcasts
   • Portfolio Management using @RISK
   • @RISK for Engineers

» Worldwide Training Schedule

» About Palisade and the DecisionTools Suite

» Story to Share?

 

Free Webcast this Thursday: "Portfolio Management using @RISK" with Matt Rosenberg

Monday, January 14, 2013 by Dan Bruffey

Join us this Thursday, January 17, 2012, for a free live webcast entitled, "Portfolio Management using @RISK " to be presented by Matthew H. Rosenberg.

This free live webcast is intended to show the benefits of using Monte Carlo simulation in the processes of portfolio construction, and portfolio management for individuals, families and institutional investors. Topics will include a general overview of the portfolio management processes, as well as specific examples showing the use of @RISK for risk management within these processes.

Mr. Rosenberg is Managing Partner for RoseCap Investment Advisors, LLC, a private investment management and financial planning firm in Grand Junction, CO.  Among other things, his responsibilities include portfolio management, formulating investment strategy, and development of financial models for use by the firm. Throughout his career Mr. Rosenberg has developed financial models for numerous large and small companies across multiple asset classes/sectors, investment vehicles, and asset types.

Prior to founding RoseCap, Mr. Rosenberg was Managing Director with Jackson Oats Shaw Corporate Real Estate, a privately held real estate firm in Atlanta, GA. Mr. Rosenberg also previously served as Vice President/AE with General Electric ‘s Commercial Finance Division. He started his career in investment banking, underwriting and syndicating leveraged loans and high yield bonds for Wachovia Securities in Charlotte, NC.

Mr. Rosenberg received his Masters degree in Accounting and Bachelor of Business Administration from The University of Texas, at Austin, where he was also a member of the 2002 National Championship baseball team. He enjoys reading and competing in numerous sports, and also serves as a lecturer of finance, investments, and accounting for Colorado Mesa University, in Grand Junction, CO.

» Register now (FREE)
» View archived webcasts

@RISK from Palisade plays key role in LEGO’s Enterprise Risk Management strategy

Wednesday, January 2, 2013 by DMUU Training Team

LEGO's Enterprise Risk Management strategyOperational risk management has been a key part of the LEGO Group’s strategy for many years. The approach is used to handle issues including supply disruptions, demand volatility, currencies, employee health and safety, and product quality and safety.

Today, the sophistication of LEGO’s Enterprise Risk Management (ERM) framework is widely recognised. It is one of the foremost companies to use Monte Carlo simulation to quantify risk and present key risk information to its board of directors for decision-making purposes. @RISK from Palisade helps the LEGO Group to manage much of the risk it faces. This gives the company a true understanding of the volatility that it believes is inherent in its activities, in order that it can act to pre-empt it.

The LEGO Group uses @RISK to consolidate its risk portfolio. The standard way to calculate overall risk is to multiply the likelihood with the impact for each risk, and add up the total for the portfolio giving an average loss. The LEGO Group however takes a more strategic approach, in the belief that risk management is about extremes, not averages. It wants to know what will happen in the 10% chance that something does occur, not the 90% chance that it doesn’t.

LEGO Risk Management therefore identifies all risks it faces which include factors such as competitor infringements, currency risk and vendor breakdown (if a packaging vendor suffers a strike or a fire, for example, this impacts LEGO’s ability to do business). It then quantifies the risks with @RISK so that each risk is assessed in terms of the chance of it happening and the cost / impact if it does.

Once management has defined figures for all risk factors, it adds up the total exposure that it faces using a Monte Carlo simulation. From this the 5% worst-case exposure is looked at, and compared to the risk tolerance that the company has set itself, based on its earnings, to see if this is acceptable. If it is above the risk exposure, risk handling needs to be addressed to reduce the risk. If it is below, the company is allowed to follow a more aggressive – or ‘risky’ - policy.

Knowing its risk tolerance and consolidated exposure against its actual tolerance enables management to make informed and intelligent decisions about its capacity to take on more risks or be more cautious.

Defining and addressing strategic and operational risks enable the company’s managers to take prudent and proactive mitigating actions, which result in better performance.

» Read the complete case study

 

Free Webcast this Thursday: “Good Practices and Common Mistakes”

Tuesday, December 4, 2012 by DMUU Training Team

Join us this Thursday, December 6, 2012, for a free live webcast entitled, "Good Practices and Common Mistakes" to be presented by Dr. Huybert Groenendaal. This was one of the favorite sessions last month at the Palisade Risk Conference in Las Vegas.

Ever question if your Monte Carlo model is correct? Ever wondered how other organizations use @RISK, how to get the most value out of @RISK, and what are some of the most important best practices? Then this is the right free live webcast for you!

An increasing number of organizations are using analytical techniques such as quantitative risk analysis, value at risk (VaR), and risked NPV to help them improve decision making. However, all too often, these techniques may not be used optimally or accurately and their full value may not be realized.

During this presentation, Dr. Huybert Groenendaal will share his hands-on experience through hundreds of projects, and will discuss the following topics:

  1. Good practices for the use of @RISK and risk modeling to support decision-making
  2. Common mistakes in Monte Carlo simulation and how to prevent them.

All good practices and common mistakes will be discussed with the use of real-life risk modeling case studies and models based on EpiX consulting work.

Dr. Huybert Groenendaal is a managing partner at EpiX Analytics, a consultancy that helps clients use Monte Carlo simulation and probabilistic modeling in a broad range of industries and fields, ranging from financial risk analysis, business development, marketing, budgeting, inventory optimization, and pricing, to risk analysis in health. Dr. Groenendaal has extensive experience in risk modeling and analysis for business development, financial valuation, R&D portfolios and portfolio evaluations in pharmaceuticals and medical devices. Dr. Groenendaal also teaches a variety of risk analysis training courses including Financial Risk Modeling for Pharmaceuticals, Quantitative Risk Analysis, and Corporate Finance Risk Analysis and customized on-site courses. He also lectures on the use of risks modeling in business at the executive MBA program at the Leeds School of Business, University of Colorado and teaches two online risk analysis courses at Statistics.com. Dr. Groenendaal has an MBA in Finance from the Wharton School of Business and PhD from Wageningen University and is an adjunct faculty at Colorado State University.

» View the recorded webcast "Good Practices and Common Mistakes"
» View webcast archive

Free Webcast this Thursday: “Multi-Dimensional Project Portfolio Optimization and @RISK”

Monday, April 23, 2012 by DMUU Training Team

Join us this Thursday, April 26, 2012, for a free live webcast entitled, "Multi-Dimensional Project Portfolio Optimization and @RISK" to be presented by Eric Torkia.

Many speak of organizational alignment, but how many tell you how to do it? Others present only the financial aspects of portfolio optimization but abstract from how this enables the organization to meets its business objectives.  We are going to present a practical method that enables organizations to quickly build and optimize a portfolio of initiatives based on multiple quantitative and qualitative dimensions: Revenue Potential, Value of Information, Financial & Operational Viability and Strategic Fit.
         
This free live webcast is going to present these approaches and how they can be combined to improve both tactical and strategic decision making. We will also cover how this approach can dramatically improve organizational focus and overall business performance.

We will discuss these topics as well as present practical models and applications using @RISK.

Discussion Topics

  •     Optimization Basics
    • Typical Optimization Applications
    • What is non-linear stochastic optimization
    • Objectives and constraints - things to know about optimization
  •     Quick Overview of Portfolio Theory
    • Overview of conventional portfolio methods (financial, strategic, IT...).
    • Markowitz and the efficient frontier
    • Viability/Fit method
  •     Optimizing with value of information and other critical dimensions
    • What is value of information (VOI)
    • How can VOI and portfolio methods be used to improve decision-making
    • How does the VOI impact portfolio decisions
  •     Building and running the model
    • Overview of the components of the portfolio model
    • Run a quick optimizations using different dimensions and discuss results
    • Questions and Answer Period


Eric Torkia MASc is a senior management consultant/trainer and business analyst.  He has collaborated with some of the world's most recognized organizations to ensure the optimal design and delivery of enterprise systems, analytics as well as new forecasting and decision making processes.

Eric combines a unique set of skills and competencies revolving around performance, risk and change management to bring about durable business performance improvements.

  • Financial and project based valuations
  • Project Risk Analysis on 1+ billion dollar projects
  • Performance Management business analysis and consulting
  • Spreadsheet Modeling and VBA automation for simulation, forecasting and optimization
  • Change Management consulting and training and instructional design relating to the adoption and implementation of enterprise analytics

Eric’s academic background includes a Master’s degree in information systems management from the University of Québec in Montreal as well as a BBA in international marketing and management from Northwood University Florida.

» Register now (FREE)
» View archived webcasts

2011 Risk Conferences Series: Amsterdam, Mexico City, Rio de Jaineiro, Sydney, and Las Vegas

Friday, May 27, 2011 by DMUU Training Team
“Another great conference - well done! It's always a stimulating and thought-provoking
experience, and great hospitality.” - Michael Brand, Captum Capital

Over 100 delegates attended the 2011 Palisade Risk Conference at the historic West Indische Huise in Amsterdam in March. Over the course of the two day conference, industry experts presented a selection of real-world case studies about innovative and interesting approaches to risk and decision analysis. This event included the ever-popular workshops and training given by Palisade consultants, as well as a sneak peek at what is in the pipeline of new software from Palisade.

We invite you to join us next week in Mexico City, June 1 -2. Delegates from Consultoría en Decisiones®, PEMEX, IMP and experts from other companies and universities will present case studies and discuss Monte Carlo techniques and risk in all its forms.

Palisade Risk Conferences showcase the latest methodologies for risk analysis and decision making under uncertainty. It is an opportunity to learn applications such as product pricing, production forecasting, cost estimation, risk quantification, portfolio risk management, environmental liability estimation, project management, and much more, while utilizing the user-friendly risk simulation software of @RISK and the DecisionTools Suite. These events are attended by professionals from industries as diverse as oil and gas, pharmaceuticals, insurance, healthcare, engineering, and banking.

Be sure to join us for a stimulating and thought provoking experience at one of our remaining 2011 Risk Conferences in Rio de Janeiro, Sydney or Las Vegas!

» 2011 Rio de Janeiro Conference
» 2011 Sydney Conference
» 2011 Las Vegas Conference

The Flash Crash

Sunday, January 16, 2011 by Holly Bailey
Last May 6, the Dow Jones Industrial Average made a rapid series of inexplicable drops, and, in fact, in one five-minute period fell more than 500 points.  Then, just as inexplicably, the market recovered.  The causes of the so-called Flash Crash remained mysterious until September, when the SEC issued a report on the rapid fluctuation of the market.  It found that a single "large fundamental trader" had used an algorithm to aggressively hedge its market position quickly.
 
Since then the role of neural networks and algorithms in automated transactions has received a good deal of attention from the media.  The online edition of this month's Wired offers a fascinating perspective on algorithms as investors.  It reveals how neural networks and other automated types of statistical analysis  can chew through news of the financial markets--essential a big pile of data-- to instantaneously produce a financial risk analysis, make a larger determination of the results of a prospective trade portfolio risk management terms, and make the trade.  The speed with which a computer can function as an investor is part of the problem. It produces a kind of feedback loop in which each instantaneous trade produces instantaneous responses from other computers trolling the markets. 
 
The trend toward computer control of financial markets, however, does not continue unfettered. The month after the Flash Crash, the SEC instituted some "circuit breakers," rules to stop trading when the feedback loops begun too intense and the markets fluctuate too rapidly.

All of this presents an interesting and larger question: How much control can we delegate to computers--not just in the financial realm but in our social and creative lives--before we have to scramble to catch up with them and regain control?   

Two Shapes of Bond Risk

Monday, January 10, 2011 by Holly Bailey
Baby Boomers are coming face to face with the realities of retirement, and their financial advisers are having to dig deep to come up with strategies that will calm their fears of a recurrence of the financial meltdown of 2008.  In this climate, one term that comes up repeatedly is fixed income, which usually means bonds.  Here, it is interesting to note that even fixed is not as certain as it sounds.  Prices and rates of return for bonds vary over time and in opposition to those of equities.  Even given this dynamic, the challenge for bond fund managers is essentially the same as for equity fund managers--how to diversify a portfolio's holdings to minimize risk and optimize return.  

In 2008 and early 2009 the the credit risk of corporate bonds was painfully in evidence, and since then financial planners have been sharpening their credit risk management tools to stabilize returns on bond portfolios.  It has been generally accepted by investment professionals that the greater the number of financial instruments in a portfolio, the broader the spread of credit risk.  A recent credit risk analysis by the BondDesk Group found, however, that spreading risk over an increasing number of investments is effective only up to a point, after which further investments offer no further protection against loss.
 
The BondDesk Group used Monte Carlo simulation software to determine two values, tail risk (loss of 20%) and black swan risk (loss at a catastrophic level of 50% or more), in portfolios that progressively increased in size from 2 to 50 bonds. Taken together the two measures of risk predicted which bonds would default.  Interestingly, the simulations revealed that both kinds of risk were reduced by increases in portfolio sizes up to 10 bonds, and in both cases, these benefits began to diminish with bond number 11.  
 
The group's credit risk analysis brings good news for both investment advisors--it simplifies their work--and investors--it reduces the cost of investing!  For the juicy details, go to the BondDesk website.

The Great Moderation and Tail Risk

Tuesday, September 21, 2010 by Holly Bailey
The so-called Great Moderation, the economic period that began in the late 1980s and ended with the financial crisis of 2007, was characterized by less volatility and more stability and predictability in the financial markets. I recently saw commentary that identified one of the causes of the economy's' plunge from moderation to recession as "Monte Carlo simulation" and the projections it produced.
 
Over time and a few blog entries it became apparent that what should have come under fire was not Monte Carlo as a statistical technique but the probability distributions on which the financial risk analysis models were based.  During the Great Moderation, apparently, many financial analysts involved in portfolio risk management relied on "normal" probability distributions and continued to rely on them even after tail risk events--events in which risk exceeded 3 standard deviations away from an asset's current price--began to occur much more frequently than "normal" accounted for.  This, of course, meant that actual investment returns were far from those predicted by the models.
 
Commenting on recession-proofing and tail risk, PIMCO's Richard H. Clarida observes that as we begin to leave the recession behind we are entering a period in which the New Normal is the paradigm distribution function for asset management.  The New Normal "is flatter and the tails are fatter."  As he sees it the long reach of risk has just gotten longer.  I recommend his essay, which stresses how important it is to "get the tails right."

Distributions aren't cast in concrete, and many Monte Carlo software packages allow you to fit the distribution to the demands of the questions you're addressing with your risk analysis model.  If you find  yourself in agreement with the New Normal, it shouldn't be that hard to get the tails right.    

Free Webcast This Thursday: The Use of the DecisionTools Suite in Biotechnology Project and Portfolio Decision Making

Monday, August 30, 2010 by DMUU Training Team
Vertex Pharmaceuticals, Inc. is a global biotechnology company based out of Cambridge, MA. The Company's strategy is to commercialize its products both independently and in collaboration with major pharmaceutical companies. Vertex's product pipeline is focused on viral diseases, cystic fibrosis, inflammation, autoimmune diseases, cancer, and pain.

Given the uncertainty of outcomes in the biotech industry, consideration of variability is an inherent part of the decision process. Often, the mean (average) is not a relevant decision criteria. This is especially true for smaller biotech companies like Vertex – the opportunity costs are extremely high because scarce capital resources would be invested elsewhere, with a higher probability of realistic return. For example, a company may reject a project which is profitable on average (positive Net Present Value) because some of the possible outcomes are unacceptable to the decision maker. Consideration of variability allows a decision maker to bring in their own risk tolerance into the decision. A similar argument applies when estimating a safety margin above a base case (e.g. in cost budgeting).

Vertex’s strategy and analytics group within the corporate finance division seeks to provide the senior management with dynamic revenue and profit forecasting methodology that helps to identify types of drugs that should be developed given a finite amount of cash and resources. A traditional financial view allows the user to identify scenarios and potential outcomes, but lacks the ability to show the range of potential values within each and every outcome. Vertex’s team uses the DecisonTools Suite to establish the average outcome, the variability of outcomes and to pressure-test risk and uncertainty of a particular scenario throughout the decision process.

Vertex’s team built a complex financial risk analysis model using @RISK to enhance its portfolio process. Monte Carlo simulation and optimization are used to analyze and optimize project and portfolio decisions, given short and long-term corporate strategy. @RISK is also frequently used throughout the business development process: simulating across multiple sales forecasts provides BD team with a range of potential outcomes, making it easy to pinpoint a particular scenario on a curve, along with its probability and value. TopRank turns the sensitivity analysis into a quick and seamless exercise, answering multiple what-if questions within minutes. Franchise and program leaders can now see a dollar effect of their program being delayed or advanced, adding supplementary indications to the development plan and even addressing the price uncertainties all at the same time. The simple interface of PrecisionTree along with tornado chart outputs makes it easy to explain the effect and importance of a particular assumption / decision to an audience with no finance background.

As the company continues to grow, adding more drugs and collaborations to its development pipeline, we will see in this free live webcast how the DecisionsTools Suite remains one of Vertex’s analytical tools of choice to enhance and guide the decision making process.

» Register now (FREE)
» View archived webcasts

Tackling the energy crisis by managing demand, using risk modeling software

Thursday, July 29, 2010 by DMUU Training Team
One of the side-effects of the recession appeared to be a reduction in the demand for electricity as businesses and consumers alike looked to make savings on their outgoings. However, economic recovery seems to render this trend as temporary, meaning that the global need to tackle energy-consumption is as pressing as ever.

BC Hydro, Canada's third largest electrical utility provides an interesting case study in how to  ascertain the most effective ways to tackle the gap between supply and demand of electricity in British Columbia. Trends such as an expanding population growth, and the increase in energy usage per customer, have led to a rise in the demand for electricity across the region. By legislation, BC Hydro must aim to meet these energy needs through implementing cost-effective energy conservation approaches before it can turn to increasing the supply. 

The company has set itself one of the most aggressive targets in North America, with a plan to meet almost 75 percent of its incremental load through Demand Side Management (DSM) over the next 20 years. DSM projects include compact fluorescent light promotions; subsidies for energy efficient appliances; variable speed motor promotions (for home furnaces); and promotional activity aimed at motivating customers to use less energy.

BC Hydro uses @RISK risk analysis software to measure the uncertainty around its energy conservation efforts, both at the project stage and at a higher portfolio level. Around 60 projects were analysed on a case-by-case basis, and a probability distribution around the forecast outcome was developed. @RISK helps BC Hydro to capture the level of uncertainty of the estimated savings for each individual DSM venture.

In recognition that projects do not operate in isolation, BC Hydro also uses @RISK to explore the interrelationships between key uncertainties: the participation and savings per participant, and the participation across projects. The analysis showed that if a 'conservation culture' was developed in the province, it would result in an increase in energy savings across all programmes. However, it also illustrated that, if this culture failed to materialise, the performance of all programmes will be dragged down.

Exploring uncertainty using @RISK allowed BC Hydro to find the best balance between the uncertainties of supply side resources and those of relying heavily on energy conservation. Employing Decision Making Under Uncertainty helps BC Hydro to meet both financial risk analysis and environmental risk analysis goals. As a result, it expects to meet the majority of its incremental load growth through conservation measures.

» Read the BC Hydro case study

Craig Ferri
EMEA Managing Director of Risk & Decision Analysis

Neural Nets vs. the Ripple Effect

Thursday, April 1, 2010 by Holly Bailey
About a week ago the Financial Times ran an article about a "new" investment analysis technique that could cut through turbulence in the financial markets: neural network analysis.  I thought okay, this isn't new but maybe the application is innovative.  Besides, I liked the metaphor the reporter used, a metal ball dropped in a vat of oil and the ensuing ripples that disturb the oil.
 
The article is about software developed by a Danish investment firm that turned its back on "linear" models to adopt a neural network approach that continually reclassifies investments in a portfolio and then makes suggestions about which equities to buy and which to sell. The proprietary software chews through a heap of data--prices, price-earnings ratio, and interest rates, for starters, and its performance bench mark is the Russell 1000 index. 
 
The test portfolio used to proof the method was acquired in 2007, just before the ball dropped into the oil.  For a time it seemed to hold up but then got caught in the turbulence and its undertow. It has now recovered nicely, ahead of the Russell 1000 in fact, and the asset managers are looking  for more investors. This is a sweet success story, especially given the demon turbulence looming over the project and the fact that the assets are apparently owned by the Danish state pension plan.

I understood the use of neural network software to counter nonlinear events like market turbulence, and I understood the continual classification and reclassification.  But I was intrigued that nowhere in the article was there a mention of risk, risk analysis, or even risk assessment.  Maybe it was there all the time, incorporated in the proprietary software, and maybe it just wasn't mentioned.  Certainly the asset managers who developed the program were aware they were at risk--they were chewing their nails as their fund slid down right beside all the other funds that were dropping in value.  But assessing risk doesn't seem to have been a factor in the firm's new defense against mayhem in the markets.  
 
So.  Is it time to shut down your Monte Carlo software?  I don't think so. . . .   

Making Optimal Choices, or Just Making Choices? Part 3

Friday, March 26, 2010 by DMUU Training Team
Part 2 of this blog ended with me very quickly stating that the MotoGP tipping comp optimiser was identical in structure to a portfolio optimisation problem, where the portfolio could contain stock or other assets, or even projects. Let’s look at this in a little more detail as I’m sure you’re reading this to find how to optimise your own decisions rather than wondering how I went in the tipping competition!

In my model there was a fixed budget (though less could be spent if desired) to spend on riders, with the aim of maximising their total points haul. In the real world you may have a total budget of say $100m to invest in a range of projects perhaps many hundreds of millions of dollars in total value each of which have certain expected returns. At its simplest this decision evaluation will find the most (expected) profitable portfolio of the projects. This is an inclusion/exclusion grouping model, but it is very simple to optimise assets with a continuous level e.g. the amount of money invested in various shares etc. Another real example I have seen when working with an investment company here in Australia was a model whose goal was simply to find the portfolio mix that came closest to the total allowable spend without exceeding it.

Further realism can be included by using constraints should there be the need. A resource constraint may mean there has to be a limit to the number of projects that can be run simultaneously. There may also be a minimum number of projects determined by management as a mitigation strategy. Such constraints are very simple to employ using Evolver and add value to the decision analysis without the need to provide specific risk analysis/Monte Carlo simulation information for the model.

A slightly more sophisticated method of turning an optimisation into a useful portfolio risk management tool where uncertainty hasn’t been specifically modelled is to estimate the possible downside of each asset and include it in the calculation of the portfolio’s ‘score’. The Evolver software comes standard with over twenty example spreadsheets for your educational pleasure, of which “Portfolio Mix.xls” gives one method for doing just this.
In the next (and final) instalment of the Making Optimal Choices blog I will explore the idea that not all optimisations no matter how mathematically correct will produce the same results in good time, and that elegant modelling should always be the goal prior to firing up Evolver.

And so you know, I came second in the competition. Next year I’m hoping to go one better!

» Making Optimal Choices, Part 1
» Making Optimal Choices, Part 2

Rishi Prabhakar
Trainer/Consultant

Making Optimal Choices, or Just Making Choices? Part 2

Thursday, March 18, 2010 by DMUU Training Team
In my last blog entry I introduced the notion that optimal decision making wasn’t ‘on the radar’ for many clients in Australasia, and laid out a couple of ideas why. I too once focussed on Monte Carlo simulation rather than decision evaluation, but last year the most obscure event changed that.

Call me a nerd of you will, but I like modelling problems in Excel. There is skill involved in setting up a problem such that the model assumptions aren’t too gross, and an art to making the model elegant. This elegance can be very important to optimisation problems, but more on that later. My first homemade optimisation problem was generated by motorcycle racing! MotoGP, to be precise. A friendly tipping competition with friends was formed at the start of the 2009 season with the following structure:
  • Entrants played the role of Team Manager.
  • Team Managers had a fixed budget to spend on riders.
  • Either a few good riders could be purchased, or many lesser riders, or something in between.
  • The team that had accumulated the most points at the end of the season was the winner and received kudos!

Although the future results could not be known of course so I set up and ran the optimisation with Evolver after the event to see what the optimal team selection would have been. Historical data could have been used to discover the type of rider mix that tended to be optimal and thus make an informed decision for this competition. The risk in having only a few riders was that any misfortune would have a big negative impact on the points won, whereas a team consisting of many (cheaper) riders was less likely to suffer such a fate. This downside scenario will be modelled into the 2010 MotoGP Team Manager predictive, optimised model (currently in production)!

What has this to do with the corporate world? Replace “team” with portfolio and “riders” with “assets”, “shares” or “projects” and you have a classic portfolio optimisation model. I hadn’t created this model with business applications in mind but I realised that was precisely what I was doing. An instant later I realised just how useful Evolver would be in many decision scenarios even though it doesn’t incorporate uncertainty (RISKOptimizer does).

In the next instalment I will further explore some practical applications for Evolver and you’ll see just how universally appropriate it can be.

» Making Optimal Choices, Part 1

Rishi Prabhakar
Trainer/Consultant

New Approaches to Risk and Decision Analysis

Wednesday, March 17, 2010 by DMUU Training Team


Risk analysis and decision-making tools are relevant to most organisations, in most industries around the world.  This is demonstrated by the speaker line-up at this year's European User Conference, an event at which we believe it is important to bring together customers from a wide range of market sectors.

We are holding 'New Approaches to Risk and Decision Analysis' at the Institute of Directors in central London on 14th and 15th April 2010.  As with previous years, the programme aims to provide everyone attending with practical advice to enhance the decision-making capabilities of their organisation.  Customer presentations, which offer insight into a wide variety of  business applications of risk and decision analysis, include:
  • CapGemini: Faldo's folly or Monty's Carlo – The Ryder Cup and Monte Carlo simulation
  • DTU Transport: New approaches to transport project assessment; reference scenario forecasting and quantitative risk analysis
  • Georg-August University Research: Benefits from weather derivatives in agriculture: a portfolio optimisation using RISKOptimizer
  • Graz University of Technology: Calculation of construction costs for building projects – application of the Monte Carlo method
  • Halcrow: Risk-based water distribution rehabilitation planning – impact modelling and estimation
  • Pricewaterhouse Coopers: PricewaterhouseCoopers and Palisade: an overview
  • Noven: Use of Monte Carlo simulations for risk management in pharmaceuticals
  • SLR Consulting: Risk sharing in waste management projects - @RISK and sensitivity analysis
  • Statoil: Put more science into cost risk analysis
  • Unilever: Succeeding in DecisionTools Suite 5 rollout – Unilever's story
We will also look at the recently-launched language versions of @RISK and DecisionTools Suite, which are now available in French, German, Spanish, Portuguese and Japanese.  Software training sessions will provide delegates with practical knowledge to ensure they can optimise their use of the tools and implement business best practise and methodologies.

With over 100 delegates from around the world attending, the event is also a good opportunity to network and knowledge-share with risk professionals from around the world.

» Complete programme schedule, more information on each presentation,
   and registration details



Data Issues Part 3

Tuesday, January 26, 2010 by DMUU Training Team
In Part 2 of this series I finished by asking what should be done with historical data, now that we have decided that storing it is probably a good idea. I won’t keep you waiting any longer.

Auditing and calibration of the model at both the micro and macro level. It’s as important as any other element of risk or statistical analysis, or indeed the model building itself. At the distribution level historical data helps to both parameterise the distributions and in fact select them in the first place. As a minimum a few data points will help you to understand possible central tendencies and variability for your risks, and also generate a list of feasible distributions to choose from. With a reasonable number of observations @RISK for Excel can be used to fit distributions to the data taking care of both distribution selection and parameterisation simultaneously. Only five data points are technically needed, but a reasonable fit will require either more than that or other holistic information to achieve validity.

At the macro level total project cost estimates are often ignored from the portfolio perspective. Commonly high percentiles are reported from such models to use in a ‘contingency’ calculation, such as the P90 or P95. Whilst a high percentile, the P90 (say) should still be exceeded 10% of the time! If your projects never go over this percentile then either there are some major mitigating factors not included in the model or the volatility is being consistently overstated. Likewise, the P10 for total cost (these ‘good’ percentiles are rarely if ever reported or considered in project cost estimation work) should be bettered in roughly 10% of projects. If this is not the case then the upside risk has been overstated. This may be due to misconceptions about the positive skewing present in most cost/delay risks or mistakes made in the parameterisation of the risks where the estimate (“most likely” etc.) is actually the “best case” or close to it, rather than a central tendency of the process over time. There could also be other possibilities.

No matter how you look at it, the collection and intelligent use of historical data is integral to effective and useful risk analysis and management, and critical to achieving valid Monte Carlo simulation results. If you aren’t currently recording everything you can get your hands on start right now!

 

» Part 1
» Part 2



Rishi Prabhakar
Trainer/Consultant

Interpretive and Ethical Issues in using Monte Carlo Simulations to Support Executive Decision-Making: How to avoid giving your boss impressive, but misleading guidance

Wednesday, October 14, 2009 by DMUU Training Team
Dr. Robert Ameo is principal of Market Modelers, LLC, with over 20 years’ experience in health care management, marketing and business development. Prior to founding Market Modelers, he served in the corporate development group at Johnson & Johnson. He is a recognized expert and innovator in the modeling and forecasting of new technology adoption and market share. Robert has extensive experience evaluating investment opportunities and their portfolio impact for mergers and acquisitions, venture investing, research development, and marketing efforts. Using his training as a psychologist and his extensive industry experience, he designs and executes targeted market and expert research experiments to quantify the defensible range of possibilities for new technology and product adoption. His forecasts are used both by start-up ventures to create a vision of their potential worth, and well-established biopharmaceutical and medical device companies to understand the true economic (uncertainty adjusted) value of their potential investments. Prior to his industry experience, Robert was VP of Clinical Operations and Utilization Management for a national managed care company. He holds a behavioral science PhD from the University of Miami.

Dr. Ameo will present a case study next week at the 2009 Palisade Conference: Risk Analysis, Applications, & Training,  21 - 22 October at the Hyatt Regency in Jersey City (10 minutes by PATH from Manhattan's Financial District).

See the abstract for his case study below, and see the full schedule for the Conference here.

Interpretive and Ethical Issues in using Monte Carlo Simulations to Support Executive Decision-Making: How to avoid giving your boss impressive, but misleading guidance

Simulations are proliferating throughout the business community powered by a troop of freshly minted MBAs armed with their requisite course on decision sciences and their student versions of @RISK.

Finance organizations are asking their analysts to “do a Monte Carlo.”  Dutifully, the analysts select a handful of “key” variables, assign triangular or Pert distributions, set iterations to 1000, push the simulate button. The laptop’s screen displays a colorful histogram and a sensitivity analysis to add to the PowerPoint.

Lo and behold, the simulation analysis supports the original scenario model showing the mean or median simulated output to be just about in the middle of the distribution. Mission accomplished. Senior leadership is assured that the model has been tested by simulating 1000 potential outcomes. Management moves forward in their pre-decided direction with confidence bolstered by a state of the art Monte Carlo analysis.

This scenario happens every day and for so many reasons it is very wrong.

Using simulations to support executive decision-making introduces ethical concerns that are not present in “most likely case” scenario modeling. In this presentation, Bob Ameo discusses the ethical responsibilities of using simulation models to inform executive decision-making. Specific recommendations are made how to appropriately conduct and present outcomes from simulation models.

Next Week: October 21-22 in NYC

Building on the success of last year’s record-breaking event, the conference will offer a wide range of software training, model building, and real-world case study sessions. Last year, the event drew over 150 practitioners and decision-makers from a broad spectrum of industries. The @RISK and DecisionTools software tracks were more popular than ever. This year, we’re expanding software training with sessions that let you walk through examples and try the tools directly. This will enable you to take some new tips back to the office. Please join us in October for a great opportunity to learn and connect with colleagues.

The Efficient Frontier and Monte Carlo Software, II

Friday, May 22, 2009 by Holly Bailey
Let's move on from yesterday's blog on the Efficient Frontier, formulated half a century ago by Harry Markowitz, to the New Frontier postulated by investment advisor Richard Machaud.  Michaud is the author of Efficient Asset Management:A Practical Guide to Stock Portfolio Optimization and Asset Allocation (Oxford University Press, 2008), among other works, and now heads up New Frontier Advisors, an institutional research and investment advisory company.
 
Michaud's New Frontier adds further sophistication to Markowitz's ideas about optimizing investment diversification to balance risk and return by introducing resampling to the optimization process.  Resampling is a method from statistical analysis that compensates for possible error by analyzing a dataset from which a subset has been portioned off and replacing values in the initial analysis with randomly sampled values from the subset.  
 
More specifically about the New Frontier technique,  Michaud adds resampling capability to Monte Carlo simulation.  According to one commentator, this "allows managers to assign a greater range of probabilities to various outcomes.  The goal is to produce a more realistic portfolio based on a more realistic frontier."

New Frontier now markets proprietary Monte Carlo software with a built-in resampling function to its institutional clients, and my own in-house experts tell me that resampling functionality is available in some commercial Monte Carlo Excel software as well. 

The Efficient Frontier and Monte Carlo Software, I

Thursday, May 21, 2009 by Holly Bailey
In my comments over the months since the economic sucker punch landed, I have been reiterating that Monte Carlo simulation is not to blame for the faulty risk assessment that brought down the derivatives markets. The assumptions that went into those risk simulation models were the source of the trouble, and that's too bad, because many versions of  Monte Carlo software are flexible enough to accommodate all kinds of probability functions and timelines.  
 
Today I came across a lucid article from IndexUniverse.com detailing just one of the ways Monte Carlo simulation can be tuned to the combined unfolding of time and risk.  Tomorrow, I'll look specifically at that variation of risk analysis, but first, today, a little background.  
 
Since Harry Markowitz won the Nobel Prize in Economics in 1990, the Efficient Frontier has been the line in the sand under which portfolio managers wiggle their toes. The efficient frontier is a major component of his Modern Portfolio Theory, which brought him the big prize.  In the 1950s Markowitz was researching the idea of the present value of investments in order to optimize the return across collection or portfolio of these, and he realized that the element that was missing from ideas about present value was risk.  This insight led, eventually, to his prescriptions for diversifying investments to maximize the return and minimize the risk across an entire portfolio.  
 
Portfolio diversification is now gospel among financial planners.  But gospel doesn't mean all investment advisors treat or even produce the same Monte Carlo Excel models of portfolio risk in the same way.  Tomorrow, one investment advisory firm's approach to Monte Carlo and the Efficient Frontier.     

Is Norway’s Pension Fund Adequately Diversified? Part II

Tuesday, April 7, 2009 by DMUU Training Team
In an earlier blog I allowed myself some raw speculation as to whether holistic risk management thinking is being adequately applied when it comes to the Norwegian government’s management of the state pension fund. This fund represents one of the world’s largest exercises in risk analysis in “retirement planning.” The Fund invests the oil wealth generated in the country in a mix of global equities and % bonds, and whose performance is essentially currently measured against a global benchmark portfolio of bonds and equities.

I specifically asked the question as to whether the fund should be devoting far more significant efforts to invest in non-traditional assets, as a way to mitigate some potential scenarios that could adversely affect both equity and bond investments. Investments that could potentially mitigate some of these scenarios could perhaps include very large positions in alternative energy technologies, and I noted however that although the costs and risks of such an investment strategy could be large (particularly as the scenario which it mitigates may never materialize), it could nevertheless be a prudent one, given the already very large fund that already exists for a small population base of about 5m people. Could it be so bad if 5%-10% of that fund were invested in such technologies (with such investments arguably supporting some of the fund’s other goals – such as ethical or social investments)?

It is therefore with interest that the Financial Times reported last Saturday  that the Norwegian government is planning to review the operations of its sovereign wealth fund after it lost €75bn ($100bn, £68bn) on investments last year. I await eagerly the results of this review, specifically of course to see whether such fundamentally new investment strategies will be implemented.


Dr. Michael Rees
Director of Training and Consulting