Common Dividends

Now that we have projected shares outstanding in Step 17, we can compute common dividends. We begin by projecting common dividends per share equal to the dividends in the most recent period, unless we have a reason to believe that the dividend will be different going forward (e.g. the company announced a dividend increase since reporting results for its most recent period).


Create Financial Models 10x Faster with Macabacus

Gain access to 100+ shortcuts, formula auditing visualizations, easy Excel-to-PowerPoint linking and productivity tools to help you accelerate financial modeling and presentations.

Start your Free Trial

Next, we adjust common equity on the balance sheet to subtract dividends distributed to shareholders. Specifically, the dividend reduces the retained earnings component of common equity, which we do not break out from other common equity components in this model. Note that aggregate dividends are computed using basic shares outstanding, rather than fully diluted shares. This is because the shares that account for the difference between basic and fully diluted shares are hypothetical shares on which no actual dividends are paid.

Finally, we reflect the aggregate dividends in financing cash flows on the cash flow statement.

Discover more topics

Build an operating model
In this tutorial, we will walk through how to build a general industry business operating model.
Read more
Build an M&A model
In this section, we demonstrate how to model a merger of two public companies in Excel.
Read more
Build an LBO model
In this tutorial, we will walk you through building an LBO model in Excel.
Read more
Asset and Stock Deals
The first step in purchase price allocation, or PPA, is to determine the purchase price.
Read more