Portfolio Dividend Planner

Portfolio

The Portfolio sheet is the first sheet you should fill out. Replace the sample data with your actual data from your broker.

Stock/Fund
Enter the Stock or Fund name

Symbol
Enter the stock ticker symbol. Example: Apple's symbol is AAPL

Description
Enter a description for this stock or fund. Example: Energy Sector

Total Invested
Enter the amount you have invested into this stock or fund so far. Your broker's investing platform can give you this amount.

Weight %
Do not enter any data in this field. It is automatically calculated. If the value shown seems incorrect, verify that the formula looks similar to this: =(E13/Data!C3)

Shares
Enter the number of shares you own. Your broker's investing platform can give you this amount.

Avg Price
Enter your average share price. Your broker's investing platform can give you this amount.

Yield %
Do not enter any data in this field. It is automatically calculated. If the value shown seems incorrect, verify that the formula looks similar to this: =(J13/H13

Annual Dividend
Enter the total amount the stock or fund pays per year. For example, if an ETF pays 0.10 per month, enter $1.20

Annual Income
Do not enter any data in this field. It is automatically calculated. If the value shown seems incorrect, verify that the formula looks similar to this: =G13*J13

Monthly Income
Do not enter any data in this field. It is automatically calculated. If the value shown seems incorrect, verify that the formula looks similar to this: =K13/12

How to add additional rows

If you have more than 10 stocks or funds in your portfolio, you will need to add additional rows.
To add a row, right click anywhere in the last row and select 'Insert' and 'Table Row Below'.
Adjust the Weight % formula by entering =(E13/Data!C3) where E13 is actually the 'Total Invested' cell for the row you just created.

🟢Tip: See formulas for previous stocks/funds and simply continue the pattern.

How to delete a row

If you need to delete a row, right click on a row, and select 'Delete' and 'Table Rows'

Tracker

The Tracker sheet lets you manually track the amount of funds you receive each month. By doing so, you can easily how much each Stock or Fund is paying you per month. You can also see your total income amount by month. This data is also reflected in the Overview sheet. You may Add or Delete Columns in this sheet, depending on how many stocks or funds you own. Filling out the Tracker sheet is optional.

Overview

Once you have filled out the Portfolio & Tracker sheets, the Overview sheet will give you a clean, birds eye view of your Portfolio's status.
You don't need to input any information on this sheet - simply review the dashboard to understand the following:

🟢How much money have you invested into the market
🟢How much money is the marketing paying you
🟢What's your annual dividend yield
🟢How many positions are you holding
🟢How much weight does each position hold
🟢How much has each stock or fund paid you, based on the Tracker sheet
🟢How much have you received each month so far this year