Risk Management (Part 2)
Risk Management (Part 2)
Risk Management (Part 2)
Sensitivity Analysis
Lesson Learning Outcome
At the end of the academic session, students should be able to:
𝐄𝐗 = 𝐱 𝐢 𝐏(𝐱 𝐢 )
𝐢=𝟏
Expected Value of Random Variable
Expected value of X is mathematically denoted as:
𝐄𝐗 = 𝐱 𝐢 𝐏(𝐱 𝐢 )
𝐢=𝟏
where
𝐸 𝑋 = expectation operator, read as “expectation of”
P(𝑥𝑖 ) = denotes P 𝑋 = 𝑥𝑖 , the unconditional probability associated with
variable 𝑋
Unconditional Probability: The probability that an event will occur, not contingent on any
prior or related results. An unconditional probability is the independent chance that a single
outcome results from a sample of possible outcomes
Standard Deviation of Random Variable
Since the outcomes of a random variable are probabilistic, it is
useful to measure the dispersion or variability of the outcomes.
𝐬𝟐 𝐗 = (𝐱 𝐢 − 𝐄{𝐗} )𝟐 𝐏(𝐱𝐢)
𝐢=𝟏
where
𝑠 2 𝑋 =Variance of 𝑋
The expected value of the discounted net cash flow (NPV) is also
referred to as the expected present value profit.
Sensitivity Analysis
Example 3
A proposed drilling prospect has been evaluated. A well will be drilled
on 160-acre prospect area. The evaluation is based on the conditions
that the company will be able to lease 60 acres adjacent to the
prospect. Basic data and economic analysis (net present value at 10%
that would be realized from the prospect for each option, net of taxes,
royalties, lease operating expense and costs of the well) of each
option for the prospect are given in Table 3. The company has
identified the following three options for participation in the deal, given
that the company has acquired the remaining 60 acres.
Example 3
1. Participate in the drilling with 37.5% (60 acres/160 acres x 100 =
37.5%) non-operating WI.
2. Farmout acreage while retaining 1/8th of 7/8th royalty interest 60
net acres.
3. Carry with a back-in privilege (37.5% WI) after 150% of the
investment by participating parties is recovered.
Based on the above options and the data in Table 3, calculate the
following.
Table 3
Expected Opportunity Loss (EOL)
Solution
The approach is to hold all aspects of the model constant and vary
each parameter while observing the influence of the changes upon
the optimal decision.
Recall Example 2 ; Simple case of two acts (drill or farm out) and
two events (dry hole or producer).
Sensitivity Analysis
The objective is to determine the dry hole probability when the
decision maker will be indifferent to the alternatives.
Solution
Sensitivity Analysis
The question is, at what dry hole probability the expected value of
the two alternatives will be equal. The probability is computed as:
EV {Drill} = EV {Farmout}
-$750,000𝑝 + $500,000 = – $50,000𝑝 + $50,000
-$700,000𝑝 = – $450,000
𝑝 = 0.6429 or 64.29%
Figure 2 illustrates if the probability of dry hole is less than 23%, the
drill with 37.5% WI option is the preferred option. If the probability of
dry hole is greater than 23%, then the back-in option is preferred.
𝐸{NPV}
E{PI} is given by: 𝐸𝑃𝐼 = 1 +
𝐸{𝑃𝑉 𝐶𝑎𝑝𝑖𝑡𝑎𝑙 𝐼𝑛𝑣𝑒𝑠𝑡𝑚𝑒𝑛𝑡}
The expected value of capital drilling cost (CAPEX) The EPI for Prospect A:
for Prospect A: 𝐸𝑀𝑉𝐴
𝐸{𝐶𝐴𝑃𝐸𝑋}𝐴 𝐸𝑃𝐼𝐴 = 1 +
𝐸{𝐶𝐴𝑃𝐸𝑋}𝐴
= [𝑃(𝐷𝑟𝑦 𝐻𝑜𝑙𝑒)𝐴 × 𝐶𝐴𝑃𝐸𝑋(𝐷𝑟𝑦 𝐻𝑜𝑙𝑒)𝐴 ]+
[𝑃(𝑃𝑟𝑜𝑑𝑢𝑐𝑒𝑟)𝐴 × 𝐶𝐴𝑃𝐸𝑋(𝑃𝑟𝑜𝑑𝑢𝑐𝑒𝑟)𝐴 ]
Solution
Prospect B Prospect C
Completed
$225,000 $45,000
Well Cost
Dry Hole
$150,000 $30,000
Cost
Outcome
Probability NPV EMV Probability NPV EMV
State
Dry Hole 0.35 -$150,000 -$52,500 0.25 -$30,000 -$7,500
100 Mstb 0.25 -$85,000 -$21,250 0.30 $25,000 $7,500
200 Mstb 0.20 $325,000 $65,000 0.25 $45,000 $11,250
300 Mstb 0.15 $520,000 $78,000 0.15 $62,000 $9,300
400 Mstb 0.05 $715,000 $35,750 0.05 $90,000 $4,500
1.00 $105,000 1.00 $25,050
E{Drilling} $198,750 $41,250
EPI 1.528 1.607
Solution
Summary of the expected profitability indicators arranged in
descending order of EPI:
∑E{CAPE
Prospect EMV EPI E{CAPEX}
X}
Prospect A $71,500 1.688 $104,000 $104,000 √
Prospect C $25,050 1.607 $41,250 $145,250 √
Prospect B $105,000 1.528 $198,750 $344,000
If prospects were mutually exclusive, Prospect B (with highest EMV)
would have been chosen to maximize the expected monetary value.
However, the budget for all three prospects (if all prospects are to be
drilled) will be the sum of the expected investments for each prospect
($344,000).
Performance Index
Incorporates the expected returns and the risks.
EOL rule states that the most economically viable alternative is the
one with the most preferred expected regret (EOL value).
From the Table, the minimum EOL is for the back-in option. It is
because it minimizes the expected opportunity loss.
The selection is consistent with the option selected using the EMV
decision rule (as in Example 3).
The EOL values also represent the cost of uncertainty for each
alternative.
Active Learning
Closure Reviews Pairs
Task: Recall what you learnt about each subtopics covered in the
lecture ( 5 minutes ) . In pairs, answer the following questions:
Subtopics :
Expected value and Standard Deviation of random variables
Expected Monetary Value
Sensitivity Analysis
Expected Profitability Index
Performance Index
Expected Opportunity Loss
THANK YOU
© 2013 INSTITUTE OF TECHNOLOGY PETRONAS SDN BHD
All rights reserved. No part of this document may be reproduced, stored in a retrieval system or transmitted in any form or by any means (electronic,
mechanical, photocopying, recording or otherwise) without the permission of the copyright owner.
Q&A
Session