Dividend Increase % and Amount

[divinest]

HI Mark, Assuming we have at least past 12 months of more transactions, if there a way to use custom formulas to calculate the dividend increase the dollar amount and / or percentage increases for each holdings? thanks in advance.

[Mark]

Hi divenest,

Can you describe in a bit more specifics, with maybe some example numbers, what you want to calculate?

[divinest]

Sure. Lets say for instance LMT paid 1.82 per quarter for last year. Now their dividend is 2 dollars per quarter. So they have increased the dividend by 72 cents annualized or 10%. So wanted to see if there is a way to calculate that. Here is an example email from LMT press release

https://news.lockheedmartin.com/2017-09 ... 7-Dividend

Another example GPC

In this case GPC increases the dividend by 7% by 18 cents annualized so looking for a report that would show based on the report dates. Helps to update the income field as well as how the rate of increases are.

- Dividend for 2018 Increased by 7% -
ATLANTA, Feb. 20, 2018 /PRNewswire/ -- Genuine Parts Company (NYSE: GPC) announced today a 7% increase in the regular quarterly cash dividend for 2018. The Board of Directors of the Company, at its February 19, 2018 Board meeting, increased the cash dividend payable to an annual rate of $2.88 per share compared with the previous dividend of $2.70 per share. The quarterly cash dividend of seventy-two cents ($0.72) per share is payable April 2, 2018 to shareholders of record March 9, 2018. GPC has paid a cash dividend every year since going public in 1948, and 2018 marks the 62nd consecutive year of increased dividends paid to shareholders.

[Mark]

Hi divinest,

Yes, you can do this with a user-defined field. You would use the EVAL function and get the distribution amounts from last year for a particular period you want, and then use it again to get the same field for the recent quarter. Subtract the two for a difference, or divide to get a percentage.

For the field in question, you'd probably want to use Divdist_btw.

[divinest]

Thanks Mark for the idea, any suggestion how to get the last qtr or last year based on the report end date, i am trying something like this, however that is not abs qtr instead its last 90 dates
Do you have any examples that i can see for deriving last year etc.

EVAL(ENDDAYS()-90,ENDDAYS(),Distdist_s_btw)

[divinest]

Hi Mark, Looking at some of the forum examples and question answered in the past
Appears this should get the last year based on the end report date. However, does the report ranges selected in the report dates field override the following ?

EVAL(DELTADAYS(ENDDAYS(), -1, 0, 0) + 1, ENDDAYS(), Divdist_btw)

For example, the way i understood is that irrespective to the report selection dates, the above custom formula would always return the dividend for last 366 days?

Any suggestions on how to get the dividend paid per share the one before the last dividend payment?

Thanks much!

[Mark]

Hi divinest,

Your equation does the last year, relative to the report's ending date. The ENDDAYS() function is the report's ending date. The starting date of the report wouldn't matter in the calculation of that field.

There aren't really fields for getting specific transaction details, like the per share amount of a particular dividend transaction. You could use the "Dividend distributions per share (between)" field, and if there was only 1 dividend in the date range, then you would have the number you're looking for.

Another way to get date values is from some of the built in fields. For example, if you used "Next income date" that will give you a "days" number for the next upcoming dividend, based on your "Income" properties in the investment. You could make an EVAL relative to this date to get whatever quarter's numbers you want, relative to the next date. For example:

EVAL(Nextincome_date - 91, Nextincome_date - 1, Divdist_btw)
EVAL(Nextincome_date - 181, Nextincome_date - 92, Divdist_btw)

[divinest]

Thanks Mark for the suggestion, so i included the following calculation

EVAL(DELTADAYS(ENDDAYS(), -1, 0, 0) + 1, ENDDAYS(), Divdist_btw)

would this calculate the total divdist_btw the report end date and one year earlier, irrespective to the report start date selected to run the report? I tried with YTD on the report date the results were the dividends paid only YTD versus the last 366 days.

[Mark]

Hi divinest,

would this calculate the total divdist_btw the report end date and one year earlier, irrespective to the report start date selected to run the report?

Yes, that is correct. You could double check by running a report with the Dividend Distributions (between) field, and setting the report dates to 1 year ago to today. Maybe you don't have earlier dividends recorded?