TransWikia.com

Calculating Dividends paid out and Div ratio from finance sheets

Personal Finance & Money Asked by Charco on December 4, 2020

So I was trying to calculate the dividends a company paid out from the balance / income sheet and the retained earnings (the delta between this and last period). I thought the dividends paid could be calculated by subtracting the delta in retained earnings from the net income but after trying to calculate the dividend payout ratio (i.e. dividend paid / net income) using this method the value was way too large. I know that some / most cashflow statements will have the dividends paid listed but even if I use the given div payout to calculate the dividend payout ratio I still get a number that is way too large.

Here is an example (Note values in millions) for LRCX Retained Earnings 11,521 (06/30/20) 9,931 (06/30/19) and net income is 2,252. Furthermore, there dividends paid is 656.84 and they have a dividend payout ratio (yield) of 4.60 ( 1.35%).

Can someone please show me how I am suppose to calculate the Dividend payout ratio (or even yield) from the above information ? I would prefer it be calculated from the retained earnings and net income data but I can’t even get the right ratio value using the Dividends paid from their cash flow statement. I feel like there is something I am not understanding here (not the simple math) so if someone could explain this I would be very grateful.

One Answer

The dividend payout ratio measures the percentage of net income that is distributed to the shareholders in a from of dividend. In order to calculate dividend payout ratio you need two things:

  1. Net Income for the period and
  2. Dividend Paid (amount) for the same period.

The dividend payout ratio can be calculated by the following formula:

Dividend Payout Ratio = Dividends Paid / Net Income

You can find those number on the cash flow statement of the company. In your example LRCX in the last quarterly report has:

Net Income of: $696M

Dividend paid: $168M

Dividend Payout ratio = $168/$696 = 24.13%

If you know the retention ratio of the company, you can also calculate the dividend payout ration as inverse of the retention ratio:

Dividend Payout Ratio = 1 − Retention Ratio

A longer explanation of the calculations and examples here: Dividend payout ratio article.

Answered by Dbrooks on December 4, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP