Gains And Losses - Formulas In Excel - Microsoft Excel Tutorials

18.  Stocks — gains and losses

Imagine your stocks have fallen 11.5% in value in one day. What is the percentage of gain that will be needed the next day to compensate for the loss?

To determine the gain/loss of a stock:

1. Select cell C2 and type 1000.
2. Select cell B3 and type 11.50%.
3. Select cell C3 and type the following formula: =C2-(C2*$B$3).
4. Select cell B4 and type the following formula: =B3/(1-B3).
5. Select cell C4 and type the following formula: =C3+(C3*$B$4).
6. Be sure to format column C as Currency.

Watch the Video Tutorial - https://www.youtube.com/watch?v=ijTBVvJCNn0

Hope You Like This Tutorial - Give Comments