Dividends form a very important part of investment returns, especially high-dividend paying stocks. By entering dividends, you keep your performance statistics accurate.
Partial screenshot of Dividends tab
Manual User Cells: • Dividend History and 6 respective columns • Dividend Reinvestment - Dividend Payout frequency • Dividend Reinvestment - DRP on/off status
Entering Dividends into the Dividends tab automatically filters through to the ETF, Stock and Managed Funds tab (if applicable). This in turn factors into your Total Return and Dividends figures ensuring your total return figures are accurate.
To enter a dividend, fill out a new row according to the below:
Crypto staking is planned for a future Sheet version.
The Sheet can help you determine and calculate how long it will take for your reinvested dividends to purchase one whole unit. This is based on yields and how often Dividends are paid. Dividends Freq (m) refers to how often a particular holding pays Dividends. Please see the holding website for this information. This may be quarterly, annually or twice annually for example. Enter this figure in terms of months (ie. 3,6,12).