NOPAT Template
NOPAT Template
The following 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 NOPAT 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 Tutorial
To master the art of Excel, check out CFI’s Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Launch CFI’s Excel Crash Course now to take your career to the next level and move up the ladder!
