Purchase Solution

Sensitivity analysis

Not what you're looking for?

Ask Custom Question

You need to decide how to invest a graduation gift of $1000. The annual rate of return is given in the next table for each of the three different types of investments and three different states of the economy.

Recession Stable Economy Expansion
Investment A 2.5% 2.5% 2.5%
Investment B 2% 4% 5%
Investment C -2% 4% 10%

Create a table that gives the amount of money for each type of account and state of the economy after one year, if interest is compounded monthly.

Compute the expected value of your account at the end of one year for each of the investment types, if the probability of a recession is 0.5 and the probability of a stable economy is 0.3.

What investment would you choose? Why?

Purchase this Solution

Solution Summary

This solution provides a sample of the given finance problem calculated in Excel.

Solution Preview

** Please see the attached file for the complete solution response **

Recession Stable Expansion
Investment A 2.50% 2.50% 2.50%
Investment B 2% 4% 5%
Investment ...

Purchase this Solution


Free BrainMass Quizzes
Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.