Question: Stock initially trades for \$120 per share. An investor decides to purchase 1300 shares. After 5 years, the portfolio is worth \$245,570.00. At that time, the investor decides to purchase an additional 120 shares. At the end of year 10, the portfolio is now worth \$286,130.00. The investor then decides to sell 140 shares. At the end of year 15, the portfolio is now worth \$415,372.80. a) Find the dollar weighted rate of return b) Find the time weighted rate of return
Okay I have tried using Excel to solve this but each time my results have been wrong, how do I set this up? Any help is greatly appreciated!