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.

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

Download The 2024 State of M&A Transactions
Download this report for expert guidance on innovative structures, cost-effective financing, and antitrust strategies to accelerate deals.
Read more
DCF Excel Template
Elevate your investment analysis with our free DCF model template. Understand discounted cash flow principles and perform accurate valuations in Excel.
Read more
Operating Model Excel Template
Download our free operating model Excel template. Forecast revenue, expenses, and key financial metrics for better decision-making.
Read more
LBO Excel Model
Try LBO modeling with our comprehensive Excel template. Understand key concepts, calculate returns, and gain actionable insights.
Read more