JAMES F. WRIGHT, Ph.D Ltd. Co.

Monte Carlo Risk Analysis -
A Solution for Technical Risk Analysis

New book: "Monte Carlo Risk Analysis and Due Diligence of New Business Ventures"

New service: Easy-Monte Carlo Pro Forma Analysis (US$475 & Up)
Just enter data from a Pro Forma and answer 6 easy business questions!



Navigation Bar

Place mouse on line with
symbol to expand menu.
















Purchase Dr. Wright's timely Report titled "The How & Why of Technical Due Diligence" for US$25.

Purchase Report Now



Read and Save Dr. Wright's Free pdf article titled "Technical Due Diligence, Errors & Uncertainty".

FREE "pdf" Report



Read about Dr. Wright's unique Program that saves both Time and Money - Lowers Risk!

Quick Question?
Quick Answer!




Read Dr. Wright's article published in the March 1, 2001, issue of "Expert-Zine.com".

Expert-Zine.com
Article (03/01/01)


RISK ANALYSIS USING
MONTE CARLO SIMULATION


If you are interested in Monte Carlo Simulation of scientific problems
rather than investments, please click on this green button:
.


Monte Carlo Simulation is a quick and cost-effective method to quantify your Risk in a New Project or Investment. NASA, the US nuclear weapons program, and important scientific endeavors throughout the world have used this technique extensively since the advent of computers. It is just now finding general acceptance in the field of Finance.

Contents
Click on the Section to
immediately Navigate to that Section

1. Risk Analysis Using Monte Carlo Simulation
  1. Monte Carlo Services Offered
  2. Sample Input for Monte Carlo Calculations
  3. Qualifications & Experience with Monte Carlo
  4. Easy-Monte Carlo Pro Forma Analysis (US$475 & Up)

2. The Monte Carlo Method
  1. What is it?
  2. Uncertainty in Business Plans & "TABU"
  3. Errors, Uncertainty & Monte Carlo
  4. Probability Distribution Functions
  5. Monte Carlo Theory Review



2.A. What is it?

Monte Carlo Simulation is named after the famous Casino in the Mediterranean Principality of Monaco. However, the use of the name "Monte Carlo" does not mean to imply that the method is either a "gamble" or "risky". It simply refers to the manner in which individual numbers are selected from valid "representative collections of input data" so they can be used in an iterative calculation process. These "representative collections of data" are typically called "Frequency Distribution Functions", or just "Distribution Functions", for short.

Monte Carlo Simulation methods are primarily used in situations where:
  1. The Input Data has Uncertainties that can be quantified;
  2. The "answer", or Output, must accurately represent the Input Data;
  3. The calculated uncertainty in the "answer", or Output, must accurately reflect the Uncertainty in the Input data; and
  4. The calculated uncertainty in the "answer", or Output, must be an accurate measure of the validity of the model.
The Monte Carlo Method has been successfully used in scientific applications for at least 75 years. The technique is a cornerstone of US programs involving Nuclear Weapon Design, all NASA Projects, and the solution of other basic and applied scientific and engineering programs across the world.

This is why Monte Carlo Simulation is the perfect tool for evaluating pro forma of Investment Opportunities.
  1. We know there is uncertainty in our Input since a pro forma is by definition, an estimation of performance.
  2. We know that the Monte Carlo will calculate "answers" that accurately represent the Input Data.
  3. The Calculated Uncertainty of the "answers" will accurately reflect the Uncertainty of the Input Data.
  4. Further, since we may be asked to invest in this project, the actual uncertainty in the final results of the pro forma are an accurate measure of the validity of the model. This is very important, if we want to make an informed investment decision!

To read more about Monte Carlo Theory, please press the Red Button Below.


Click Here to Read
About Monte Carlo Theory

Go to Top of Page





2.B. Uncertainty in Business Plans & "TABU"

The sources of Uncertainty in Business Plans make a long and scary list. However, most are a result of what I call the Technical Axiom of Business Uncertainty, or TABU, for short.
Technical Axiom of Business Uncertainty - The less you know about a Project, the higher your uncertainty regarding the Project.
Below I have listed some of my observations regarding the uncertainty in Business Plans, but you will probably notice that most are just "corollaries" of TABU.

  • All "surprises" will most certainly raise costs. In fact the bigger the surprise, the larger the cost increase (or, profit decrease).
  • Those that treat a pro forma as "fact" are telling you how little they know about the Project!
  • Cost estimations will most likely be high, rather than low.
  • Income estimations will most likely to be low, rather than high.
  • The further out in time your estimations, the larger the uncertainty.
  • Any Technology that has yet to be scaled to the size required in a Business Plan has two big sources of Uncertainty. One is the cost of R&D and the other is the cost of scaling.
  • The costs of Technologies will nearly always have to be repaid at the end of the project from increased sales or profits.
  • Technologies seldom lower required capital or construction costs.
  • Savings that are expected from operations in a less developed country will seldom be as high as predicted. Unexpected operating factors, long distances, and governmental graft will certainly raise costs.

I think you get the general idea! Knowledge about a project is required in order to reduce one's risk.

Go to Top of Page





2.C. Errors, Uncertainty & Monte Carlo

It is important to note the fundamental difference between "errors" and "uncertainty".
  • Errors are the difference between a "measured" (or determined!) value of a parameter and its "true" value. They include both Random Errors and Uncertainty.

  • Random Errors are an effect of chance and a function only of the physical system being analyzed. Further, these Random Errors of a system are not reducible through either further study or by further measurement.

  • Uncertainties of any system are due simply to the assessor's lack of knowledge about the system being studied. It is considered to subjective in nature since it may be redued by either further measurements or study.
Let's consider the "uncertainty" that exists in a prediction we have made. Predictions are based on taking a current value and then extrapolating it into the future. Therefore our "Uncertainty" has two parts. The first resulting from our inability to accurately measure the present value and the second coming from our inability to accurately predict the future. The difference between our "measured" present value and the "real" present value is the error in our "measurement" and it is part of the "uncertainty" as used in this methodology. In other words, if we measured a quantity more carefully we would therefore know more about it. Therefore, not only would the error be smaller, but our uncertainty would also be smaller. Hence, "Uncertainty" is the important quantity to measure and track in our calculations, as it is a measure of Risk!

In order to consider different ways to handle errors and uncertainty in calculations, let's return to our friend the "Area of a rectangle". The are three ways we might perform this calculation, and they are listed below.
  1. Analytical calculation using the equation A = L x W. This is the way most of the "general population" would perform the calculation. This is also the way the calculation would be performed if the error or uncertainty were not deemed to be important. In this case, we would simply ignore any potential error or uncertainty and just use the "best", or "most likely", values of the Length and Width to calculate the Area.

    A = L x W = 750 ft x 999 ft = 749,250 ft2

  2. If it were deemed to be important to account for any "deviation" in the Length and Width we could use standard differential calculus techniques to "propagate" the Standard Deviation from the Length and Width to the Area. This is what is taught and used in all university science and engineering laboratories. The Area would still be calculated as above.

    A = L x W = 749,250 ft

    In addition, we would "analyze" the data we have for the Length and Width and determine their "Standard Deviation". Notice that we have not really addressed error to this point. The fact of the matter is that we know that a certain fraction of our uncertainty is due to error, but we do not have to make that assessment at this time. Our main goal is to always reduce uncertainty. If we reduce uncertainty, we automatically reduce our risk! We can now calculate the Standard Deviation (or, we could just as easily use the Variance which is the square of the Standard Deviation) in the Area (SDA) as propagated from the SDL and SDW. In our case, the Standard Deviation for the Length is SDL = 46.9 ft and the Standard Deviation for the Width is SDW = 64.6 ft. If we use the standard differential calculus techniques, we get the propagated Standard Deviation of the Area to be:

    SDA = [(W x SDL)2 + (L x SDW)2]1/2 = 73,499 ft

    However, it must be noted that the partial derivative required for this calculation is sometimes difficult, if not impossible, to determine in a closed form. Therefore, Monte Carlo will even become the "method of choice" to propagate the Standard Deviation!

  3. Monte Carlo Calculation. We performed this calculation above in Part A, and found we could obtain a large set of numbers that provide an added measure of validity to the final calculated Area.
    • The "Most Likely" Area (The same as Methods 1 and 2, above)
    • The Standard Deviation of the Calculated Area (As in Method 1, above)
    • The Probability that the Area will be at least some Value.
    • The Probability that the Area will be less than some Value


Regular analytical calculations do not address either error or uncertainty. In our example of calculating the Area of rectangle, the Monte Carlo method would provide the most reliable measures of the validity of the calculated Area.

In summary, the most unique feature of the Monte Carlo simulation technique is that it takes Distribution Functions as input and calculates Distribution Functions as Output. These Distribution Functions provide a wealth of information to the analyst that is lost by the singe-valued Input and Output. The Probabilities that can be calculated as part of the Monte Carlo process, allows several important measures of the validity of "answers" to be calculated for the pro forma.

One more example is in order to demonstrate more fully the differences between the Monte Carlo Method and others.

Let's suppose that two different people want to determine the area of a "triangular-shaped" piece of land that is defined by "Metes and Bounds". This method is archaic and means that the property line is describe by its meeting or crossing certain physical landmarks. In our example, the property line starts at a "spring" on Farmer Jones' property and proceeds "approximately" north for 3500 rods to tree near Farmer Brown's Barn. The Property Line then proceeds southwest for 1600 rods to a large rock on the banks of Little Horn Creek. From this large rock, the property line proceeds back to the starting point. To make matters worse, the barn on Farmer Brown's property was torn down years ago and there is now a forest of trees near where the barn was once supposedly located. To add to the confusion, there are now two springs on Farmer Brown's property. As you can see, there are several sources of uncertainty in this project!

The first person (Mr. Black) might "guess" where the Tree was, where the "right" spring is located, and which big rock by the Creek is the one in the property description. He would then use geometry to calculate his area. However, since Mr. Black is an honest person, he would say that the property has an area of "approximately AAA acres".

The 2nd person, Ms. Harris, is an expert in Statistics and Monte Carlo simulation techniques and she therefore did the following:

  1. She determined "general areas" where the corners are supposed to be located.
  2. She determined the "absolutely longest possible" distances for each of the three sides.
  3. She also determined the "absolutely shortest possible" distances for each side.
  4. She then examined the local courthouse records and walked the property line so she could determine the "most likely" distance for each side. (Mr. Black may well have used this, or a similar method to determine the length of the 3 sides of the triangle.)
  5. With this information, she constructed a Distribution Function to represent the length of each side.
  6. Finally, she performed a Monte Carlo calculation using 5000 iterations to calculate a "distribution" of answers.

The difference between the answers that Mr. Black and Ms. Harris would give is quite significant. Mr. Black would give you a number but he has no idea of its numerical uncertainty. On the other hand, Ms. Harris would give some like "It has an area of XXX Acres with an uncertainty of x acres. Further, there is a 90% probability that the size is greater than YYY acres and a 50% Probability that the size is greater than ZZZ acres.


This may not seem like a worthwhile endeavor for a small piece of land (unless it is located on a small island named Manhattan!). However, if you are considering risking a sizable portion of your available Capital on a business venture, it should be very important for you to know as much about your projects as possible!

Go to Top of Page




| | Home | | Technical Due Diligence | | Process Chemistry & R&D | | Quick Answers | | Qualifications | | Search | | Contact | |
| | Links | | Credit Card Pay| | New Book Info | |

URL=http://www.drjfwright.com/d/tramcmeth.html
(Last Modified 04/14/03)