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 TemplateDownload 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 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).
Simple form: Income from Operations x (1 – tax rate)
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.