I am working on a financial spreadsheet. One cell is a formula that equals the profit or loss of a given trade based on a number of assumptions.
One assumption in another cell (let's say B35) is the final stock price (i.e. in a few months...a prediction). However, I would like to create a column that is a series of potential final stock prices (maybe 100 prices or so) and then have the cell right next to each of those assumptions equal the profit/loss that the trade would then equal. I don't know how to take all these new assumed stock prices and plug them into the equation so my new profit/loss is based on the new assumption. I don't want to have to change the assumption each time. I want a bunch of assumptions and then the output for each of those assumptions.
This should be pretty simple to do but I don't know how to do it.
Thanks
Update: I posted my worksheet. Right now I input my assumed final stock price into B3 and then the total profit/loss from the trades (up to 4 calls, 4 puts, 1 long and 1 short) in cell B35.
However, I'd like to have this final profit/loss read out in cells B43:B443 based on each cell's respective assumed stock price (the cell right next to it in column A). e.g. since A97 is 13.50 and the two trades currently loaded in my worksheet would then equal a 1,722.22 profit, cell B97 should be a formula that reads 1,722.22.
thanks for any help
Bookmarks