Stock Market Day Two
Today you will need to add columns G, H, and I. New Price Day Two, New Net Worth, and Profit or Loss. Again use the text wrap feature to make yours look as close to the example as possible.
Today you will check your investments for day 2. You will find the price for each of your stocks and enter them in to the New Price Day Two column. You will then enter a formula in column H that will multiply the original number bought (Col E) times the new price (Col G), this will give you the new net worth of your investment. To calculate if you are making a profit or loss your will place a formula in col I that subtracts the original amount spent (Col F) from the new net worth (Col H). You will need to place formulas for totals at the bottom and format all of your information accordingly. Any thing that is a $$$ should be formatted for currency and 2 decimal places anything else should be for general and 0 decimals.
"Life is like a box of Chocolates..."
Forrest Gump
No comments:
Post a Comment