Calculate NOPAT Automatically in Excel in Under 5 Minutes with 3 Simple Steps

Stop spending precious time manually calculating Net Operating Profit After Tax (NOPAT) and start saving time by automatically calculating this in Excel in under two minutes.

In this short process, we’ll show you how to pull NOPAT for US publicly traded companies without doing manual calculations, which is possible through the Intrinio Excel Add-In.

Getting Started

Before you can pull the NOPAT, you will need to follow the following steps:

  1. Create a free Intrinio account by signing up here.
  2. Take a trial, or subscribe, to either/or both of the following Intrinio data feeds: US Fundamentals or US Sector and Industry.
  3. Download and install the free Excel Add-In. For help with downloading/installing the add-in, check out the Excel Tutorial.

 

Calculating NOPAT

Now, in just three steps, you will be able to pull NOPAT using the API Explorer and the Excel Add-In.

  1. Go to the NOPAT data tag page
  2. Scroll down to the API Explorer and copy the formula by clicking the notepad icon Intrinio NOPAT formula
  3. Paste the function into the excel sheet, change the company ticker to the cell in which the ticker is written, for instance, on the example below, “AAPL” was changed to be A2. This will allow you to update a whole list of tickers without manually changing the ticker on each formula. Intrinio NOPAT Excel formula

 

How Intrinio Calculates NOPAT

We calculate NOPAT by using the total pre-tax income minus the total non-operating income, then multiplied by, 1 minus the income tax expense total pre-tax income. Intrinio NOPAT calculation

 

Additional NOPAT Calculations

You can pull additional NOPAT related calculations just as easily as pulling NOPAT.

  1. Visit the Data Tag Directory
  2. Search ‘NOPAT’
  3. Select the calculation
  4. Follow steps 2 & 3 from the NOPAT tutorial above
  5. Repeat for as many calculations as you’re interested in!

Here are some examples of additional calculations

Intrinio NOPAT Calculations

Follow the same process as you did to pull NOPAT, for other calculations such as EV to NOPAT, LT to Debt NOPAT, Net Debt to NOPAT, Debt to NOPAT, NOPAT Growth, and more.

 

Historical NOPAT Calculations

If you’re interested in learning how to pull the NOPAT calculation with historical data, check out our NOPAT video tutorial!