STOCKS - GAINS AND LOSSES USING MICROSOFT EXCEL

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.

STOCKS - GAINS AND LOSSES USING MICROSOFT EXCEL

Microsoft Excel Tutorials, Microsoft Excel Video Tutorials, Stocks - Gains and Losses, Formulas in Excel, Macros and Vba of Excel, Microsoft Excel 2007, 2010, 2013