Absolute noob here, but have gotten an exercise that I need to do and I can't figure out how to go about it.
So I have a Group (A) that is investing in 3 stocks (X, Y, Z). This group is given $30,000 to start with. The group buys $10,000 of X, $15,000 of Y and $5,000 of Z. After this price for these stocks are taken at two different time periods (Time 1 and Time 2). Based on those prices, portfolio value is calculated (e.g. For stock X, portfolio value would be Price(Time 2)/Price (Time 1)*$10,000. In this way, values are calculated for all 3 stocks. So after these two time periods, the total portfolio value of the group has come down to 29,550. Now at the third time period (TIme 3), there is the option of readjusting the portfolio. So now Group (A) has decided to change to the following: $10,000 of X, $10,000 of Y and $10,000 of P. So with different values and a new stock added and the old stock Z removed, how do I adjust all this to correctly reflect my portfolio value?
I hope this is clear. If you guys need more info, I can send you the file for you to have a look.