• 511K Members
• 3,319 Online
• 608K Conversations

## What If Analysis data table

Highlighted
Occasional Visitor

# What If Analysis data table

I am working on a homework problem and I am trying to use the What-If Analysis. I don't know if I do not have enough values or if I am not inputting them correctly.

The problem is as follows:

You have two investment options:

• Stock A with a price of \$10
• Stock B with a price of \$100

You plan on investing \$1,000

Stock A is pretty stable and the lowest it is expected to down to \$8 but some analysts believe it could go up to \$13

Stock B is more volatile.  The lowest it is expected to go is as low as \$65, but it could get as high as \$150.

Is anyone able to help me with the set up for this problem?

# Re: What If Analysis data table

Since you start with saying I am working on a homework problem and I am trying to use the What-If Analysis. I don't know if I do not have enough values or if I am not inputting them correctly, it seems reasonable to assume that you've made some tries already.

Why don't you upload what you've done so far so I or somebody else can comment on what you've done and not have to start from scratch.

Also, since you acknowledge it's a homework problem, I'm sure you'll agree that it makes more sense that you do most of the work....so if I end up being the one commenting, I might just offer one or two suggestions like...(1) write your formulas so they use a separate field called "assumed growth rate for S&P 500 overall" or something like that. (2) You clearly need a variable (better as a separate cell referenced in your "What-if" formulas) that would reflect that vague thing called "volatility".... and so forth.

Related Conversations
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies