a. Calculate the Revenue Growth Rate

b. Calculate the Operating Margin

c. Calculate the Net Operating Profit After Tax (NOPAT) for Intel

What is the interpretation of NOPAT?

Explain how would you forecast the NOPAT for the next 5 years? Which are options?

Build two charts (one with the absolute values and another one with the growth rates) capturing the Revenue vs Operating Income vs NOPAT Forecasts and show how to excel

show all excel formulas and working out

7. To answer this question, go to Thomson Reuters'Eikon and gather the data for the past 5 years for Intel (2015 through 2019) (4 points) a. Calculate the Revenue Growth Rate b. Calculate the Operating Margin a. Calculate the Net Operating Profit After Tax (NOPAT) for Intel What is the interpretation of NOPAT? Net operating profit after tax (NOPAT) is a measure of profit that excludes the costs and tax benefits of debt financing. Put another way, NOPAT is the earnings before interest and taxes (EBIT) adjusted for the impact of taxes. Item 2015 55355 2016 59,387 2017 62,761 2018 70,848 2019 71965 Revenue Growth Rate 14002 13,133 18,050 23,316 22035 Operating Income Operating Margin 14212 Income before Taxes Effective Tax Rate Taxes 19.65% 2792 12936 20.25% 2,620.00 20352 26.29% 5,351.00 23317 11.00% 2,564.00 24058 12.51% 3010 NOPAT Explain how would you forecast the NOPAT for the next 5 years? Which are options? Build two charts (one with the absolute values and another one with the growth rates) capturing the Revenue vs Operating Income vs NOPAT Forecasts