Kathy Myers frequently purchases stocks and bonds, but she is uncertain how to determine the rate of return that she is earning. For example, three years ago she paid $18,000 for 920 shares of Malti Companys common stock. She received a $718 cash dividend on the stock at the end of each year for three years. At the end of three years, she sold the stock for $21,000. Kathy would like to earn a return of at least 16% on all of her investments. She is not sure whether the Malti Company stock provided a 16% return and would like some help with the necessary computations.

Required:

1. Compute the net present value that Kathy earned on her investment in Malti Company stock using Excel.

2. Did the Malti Company stock provide a 16% return?