A tool to calculate annualized returns (IRR) from Stock investments

Click Here to access my google spreadsheet. This is not created by me but I have modified it completely to make it work for me. Frankly, I dont remember the source otherwise I would give full credit to them.

I am sharing a view only link and you have to be logged into a google account to save a copy for yourself. Once you save a copy for yourself, you can change it to suit your needs.

You can add buy and sell transactions, stock splits/bonus and dividends and works with any ticker that google finance provides a quote.
You can also make multiple portfolios work with this and you need to be little creative for this to make it work.
CAGR is calculated at stock level and if you can fill your capital intake and outtake under capital sheet, you can also track CAGR at portfolio level.

Google Spreadsheets is much better than Excel for tracking a portfolio.

I will do my best to answer any questions but most questions can be answered by a simple google search.

2 Likes