NOPAT Template

NOPAT Template

This NOPAT template shows you how to calculate the net operating profit after tax using the income statement.

Below is a preview of the NOPAT template:

Download the Free Template

Enter your name and email in the form below and download the free template now!

NOPAT stands for Net Operating Profit After Tax and represents a company’s theoretical income from operations if it had no debt (no interest expense). NOPAT is used to make companies more comparable by removing the impact of their capital structure.  In this way, it’s easier to compare two companies in the same industry (i.e. one with no leverage and the other with significant leverage).

NOPAT Formula

Simple form: Income from Operations x (1 – tax rate)

or

Long form: [Net Income + Tax + Interest Expense + any Non-Operating Gains/Losses] x (1 – tax rate)

Use of NOPAT in Financial Modeling

In financial modeling, Net Operating Profit After Tax is used as the starting point for calculating unlevered free cash flow (a.k.a.free cash flow to the firm FCFF).

The most common approach to valuation is to calculate a firm’s enterprise value (as opposed to its equity value) so that the capital structure of the business is ignored and only the firm’s assets are used for determining its value.

More Free Templates

For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation, and Word document templates.

• Excel Modeling Templates
• PowerPoint Presentation Templates
• Transaction Document Templates
• See all financial modeling resources
• See all Excel resources