There are 4 fictitious companies listed for examples. It will show you how the format looks as well as how the formulas will work for you.
Portfolio of Stocks
Here we have the first sheet which is the Portfolio of Stocks. On this sheet you can list your stocks, quantity, cost basis, current value and dividend per share. When you input this information the spreadsheet will calculate all of the other values for you. It will allow you to monitor your portfolio.
When I apply this formatted spreadsheet on to Google Sheets I have it automatically update my current price so that it is always up to date when I look at it.
Here we have the second sheet which is the Dividend Income. On this sheet it imports the data from the Portfolio of Stocks. It calculates your projected dividend income based on your number of shares and the dividends paid per share.
This is a new sheet in version1.5. The information is automatically populated on this page from the Portfolio of Stocks and Dividend Income Pages.
If you enjoy this spreadsheet and find it useful. Please consider making a donation!