Net Income Available to Common

We will now set up our income statement to calculate net income available to common shareholders. However, we won’t be able to actually compute net income yet because we do not know the levels of debt, preferred stock, and cash upon which interest expense/income in each year is to be calculated. Note that dividends on preferred stock are deducted when calculating the net income available to common shareholders to reflect preferred stock’s priority over common equity in the capital structure. For simplicity, we have assumed that no dividends are paid on common stock. This makes sense, since all available income should normally be used to repay debt as quickly as possible, rather than distributed to shareholders. In fact, debt instrument term sheets may prohibit dividends to common shareholders until the company achieves specified leverage ratios or repays debt.

 

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
 

Note that in 2013, we assume noncontrolling (i.e. minority) interest remains a constant percent of sales. Technically, this isn’t a very good assumption because the minority shareholders would likely own only a stake in one or more subsidiaries of the target, rather than the consolidated target. It would be better to compute noncontrolling interest as a percent of the subsidiary’s sales alone. Without detailed subsidiary financial results, however, this is the best we can do.

Download Template

Download Template

Net Income Available to Common

Try Macabacus for free to accelerate financial modeling in Excel.

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