Purchase Solution

Risk Analysis and Sensitivity Analysis Example

Not what you're looking for?

Ask Custom Question

The following is an extract from a 2015 advertisement by a pensions company seeking investments in a "managed fund".

annual discount rate 0.10
Initial invest -40,000.00
return - I yr 12,000.00
return - 2nd year 13,000.00
return - 3rd year 12,500.00
NPV ?

Set up a spreadsheet to calculate the NPV of the investment. Also perform sensitivity analysis for the following cases:
i) Vary the rate between 9% and 10%(in steps of 0.1)
ii) Vary the Initial investment between 25,000 and 50,000 ( in steps of 5000)
iii) Simultaneously varying both rate and initial investment (Two variable sensitivity analysis)

Purchase this Solution
Solution Summary

The solutions shows how one can use excel to calculate NPV for various initial investment levels and discount rates.

Solution provided by:
Ashvini Ravi, PhD
Education
  • BPharm, Mumbai ,India
  • MMS, Mumbai, India
  • PhD, Madras, India
Recent Feedback
  • "Thank you so much"
  • "GREAT JOB...THANK YOU"
  • "GREAT JOB...THANK YOU"
  • "great job"
  • "thank you"
Purchase this Solution
Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Lean your Process

This quiz will help you understand the basic concepts of Lean.

View More Free Quizzes
Related BrainMass Solutions

  • Sensitivity Analysis Benefits

    What's at risk? The use of sensitivity analysis to measure your portfolio's risk. Retrieved from http://www.treasury-management.com/showarticle.php?

  • Sensitivity and Scenario Analysis

    Scenario analysis is another approach similar to sensitivity analysis which examines the risk in a particular scenario. This post discusses both these methods in detail with example.

  • Risk Assessment Sensitivity analysis

    Now that the risk assessment has been performed and the behavioral method has been identified, the sensitivity analysis begins.

  • Payback Period, Sensitivity Analysis

    What is a sensitivity analysis? How is it determined? How can risk be addressed in the capital budgeting process? What is an example of a capital budgeting project in an organization with which you are familiar?

  • Financial Management

    It renders the data about the estimated project parameters and assists in the estimation of risk and error involved in the project (Sensitivity Analysis, 2008).

  • Risk in Capital projects: What analyses would you request?

    The cost of capital may sometimes be adjusted downwards if the project entails less than normal risk. A company can also use sensitivity analysis and simulation techniques to measure and adjust the risk involved in a capital project.

  • Sensitivity Analysis vs. Scenario Analysis

    492907 Sensitivity Analysis vs. Scenario Analysis Explain the difference between sensitivity analysis and scenario analysis.

  • Advantages and disadvantages: sensitivity analysis

    333996 Advantages and disadvantages: sensitivity analysis As a tool for risk analysis; what are the advantages and disadvantages of sensitivity analysis?

  • Corporate risk mitigation

    Sensitivity analysis We can use sensitivity analysis to take care of the errors in forecasting. Sensitivity analysis is "What if "analysis and forecasts are done under different scenario.

View More Related Solutions