How To Calculate Annual Return On Stock In Excel. You will get the rate of return of the stock you bought. Suppose it's 2015, and you own shares (it doesn't matter how many) of the stock.
You will get the rate of return of the stock you bought. Like this, we can calculate the investment return (roi) in excel based on the numbers given. =xirr(b2:b6,a2:a6) #1 type the above formula in the formula box of cell c2, press enter key.