Security Analysis

Sensitivity analysis also known as?

• What if analysis

• Scenario analysis

• Security analysis

• Movement analysis

What is definition for sensitivity analysis?

• Measuring the impact changes in price has on demand

• Evaluating which direction demand will go based on some set criteria

• Process of estimating the expected value of a portfolio after a given change in the values of key factors take place.

• Predict the outcome of independent variable values that will impact particular dependent variable performed under certain conditions.

What is the definition of Output Variable?

• A. The numbers that the analyst inputs into the spreadsheet to generate a result or answer.

• B. the changes that a company wishes to observe.

• C. the requirements of a spreadsheet model that are necessary for generating the desired outcome.

• D. The result of an action in a spreadsheet.

What are the main elements in spreadsheet model?

I. Input Variable

II. Data Table

III. Model Requirement

IV. Data Label

• A. I, III, IV

• B. I, II, III

• C. I, II, IV

• D. II, III, IV

What is one of the disadvantages of scenario analysis?

• Helps companies manage risk proactively

• make realistic assumptions

• Modelling tools can help reduce time consuming

Which type of sensitivity analysis involves determining the sensitivity of the model or system at a specific point or range of points in the input space?

• One-way sensitivity analysis

• Two-way sensitivity analysis

• Global sensitivity analysis

• Local sensitivity analysis

What is spreadsheet modeling analysis used for?

• Analyzing financial statements

• Calculating statistical data

• Building mathematical models

• Creating charts and graphs

Which software application is commonly used for spreadsheet modeling analysis

• Microsoft word

• Microsoft Excel

• Adobe photoshop

• Google Chrome

Rearrange the steps for performing a scenario analysis:

I.

Evaluate the scenarios.

II.

Develop a scenario planning template.

III.

Define the issue.

IV.

Gather data and identify key factors

V.

Develop scenarios

• I, iv, v, iii, ii

• iii, ii, I, iv, v

• v, I, ii, iii, iv

• iii, iv, ii, v, i

Which of the following below is the types of scenario analysis?

• A) Multiple Scenario analysis

• B) most-likely scenarios

• C) Monte Carlo simulation

• D) Three-point estimates