Assessing risk
This presentation is the property of its rightful owner.
Sponsored Links
1 / 20

Assessing Risk PowerPoint PPT Presentation


  • 115 Views
  • Uploaded on
  • Presentation posted in: General

Assessing Risk. FIL 341 Prepared by Keldon Bauer. Assessing Risks – Introduction. We have been assuming that future financial outcomes are more certain than they really are. To adjust for risks, we will be applying scenario analysis and some basic simulation.

Download Presentation

Assessing Risk

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Assessing risk

Assessing Risk

FIL 341

Prepared by Keldon Bauer


Assessing risks introduction

Assessing Risks – Introduction

  • We have been assuming that future financial outcomes are more certain than they really are.

  • To adjust for risks, we will be applying scenario analysis and some basic simulation.

  • Scenario analysis is not that much different from what we have done thus far.

    • Instead of forecasting sales once, we would forecast three times.


Scenario analysis

Scenario Analysis

  • Outcomes are estimated for Base, Worst, and Best case scenarios.

    • Base Case: All pro forma assumptions are set at their most likely levels.

    • Worst Case: All pro forma assumptions are set at their worst reasonably forecasted values.

    • Best Case: All pro forma assumptions are set at their best reasonably forecasted values.


Scenario analysis1

Scenario Analysis

  • NPV, IRR, and/or stock price are calculated for each case.

  • To assess risk versus returns, probabilities should be estimated of each “state” occurring.

    • This results in the ability to estimate an expected return, standard deviation, and coefficient of variation for the project.


Scenario analysis example

Scenario Analysis - Example

  • If a scenario analysis is used to assess the NPV of a project with the following resulting NPVs and their subjective probabilities (from the book’s example):


Scenario analysis example1

Scenario Analysis - Example


Scenario analysis2

Scenario Analysis

  • If the outcomes are assumed to be normally distributed, then probabilities of different outcomes can be estimated using the mean and standard deviations as inputs.

    • e.g. if we are interested in the probability of getting an NPV>7,500:

      • =1-NORMDIST(7500, 4475, 7630, 1) = 0.345882


Introduction stochastic models

Introduction – Stochastic Models

  • Up to this point we have assumed that all financial modeling inputs are known.

    • We have made static financial models.

  • The future is never certain.

    • It is more appropriate to make stochastic financial models.


Introduction stochastic models1

Introduction – Stochastic Models

  • Building a stochastic model (or simulation) must be accomplished in steps:

    • Determine which components of the model should be random, and which should be static (or statically dependent on a random variable).

    • Determine the probability distribution for the random variable.

    • Determine how to model any interdependencies.


Building stochastic models

Building Stochastic Models

  • In building useful simulations, the analyst should not (at least to begin with) allow too many variables to be random.

    • In the real world, variables tend to interact with one another, which is hard to adequately model in a financial model.

    • Most randomness can be appropriately captured by only allowing one or two variables to vary randomly (or dependently with others).


Building stochastic models1

Building Stochastic Models

  • For simplicity, we will only allow the sales to vary in our simulations.

  • The question now is: How do they vary?

  • If we call the random variable u:

    • Sales = a +b1x1 +b2x2 + b3x3 + b4x4 + u.

    • Sales = Average sales + u.

    • Next sales = Last sales + u.


Modeling random variables

Modeling Random Variables

  • The fundamental element of a stochastic model is generating a random variable.

  • Excel has a base random number generator built in:

    • To generate a random number between 0 and 1, type the following:

      • =rand() note the open and closed parentheses with nothing inside are part of the Excel argument!


Modeling random variables1

Modeling Random Variables

  • This random number come (approximately) from the uniform distribution.

    • Where any number between 0 and 1 are equally likely.

  • It can be scaled to any other outcomes by multiplying by the maximum outcome.

    • e.g. =rand()*100 will yield a uniform distributed random variable between 0 and 100.


Modeling random variables2

Modeling Random Variables

  • The mean (and median) of a uniform distribution is found by adding the max and min and dividing by two:


Modeling random variables3

Modeling Random Variables

  • To center uniform distributions around another number (mean), add or subtract an appropriate number.

    • In essence you would solve the mean equation from the last slide for the unknown, given the max, the min or the range desired.

    • e.g. if you wanted a random variable with a range of ten and mean of zero, you would type:

      • =rand()*10-5


Modeling random variables4

Modeling Random Variables

  • As it is, the uniform distribution acts a random cumulative probability, and therefore can act as a random input for any other probability distribution supported by Excel.

  • For instance, to generate a normally distributed random variable with mean m and standard deviation s, type in:

    • =norminv(rand(), m, s).


Modeling random variables5

Modeling Random Variables

  • For Excel to randomly assign a sales figure to a specific quarter, we would have to give it a specific formula, then add the random variable on the end.

    • For instance, if we use the sales forecast we used earlier in the semester (see Excel file), and if we expect the standard error of any estimate to be $2,557,581, we could stochastically estimate sales as follows:


Stochastic sales example

Stochastic Sales Example


Assessing risk using simulation

Assessing Risk using Simulation

  • So far, all we have been able to do is generate sales according to a predetermined random process.

  • To assess risk, we must first define what we are interested in.

    • NPV?

    • IRR?

    • Staying solvent?


Assessing risk using simulation1

Assessing Risk using Simulation

  • Once we have determined what we want to look for (e.g. NPV), we would set the computer to generate the random variable(s), resolve the necessary issues (balance the balance sheet), and assess the variables of interest (e.g. calculate the NPV).

  • Then we would capture that result, and run it again.

    • The process would be repeated a large number of times to assess the risk (usually as probability).


  • Login