NOPAT Template

NOPAT Template

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

Below is the preview of the NOPAT template:

NOPAT Template Screenshot

 

Download the Free Template

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

NOPAT Template

Download the free Excel template now to advance your finance knowledge!

 

NOPAT stands for Net Operating Profit After Tax and represents a company’s theoretical income from operations of 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.

Financial Analyst Certification

Become a certified Financial Modeling and Valuation Analyst (FMVA)™ by completing CFI’s online financial modeling classes and training program!