Question

QUESTION 2 Incorrect Mark 0.00 out of 16.00 Flag question Question text Projecting NOPAT and NOA...

QUESTION 2

Incorrect

Mark 0.00 out of 16.00

Flag question

Question text

Projecting NOPAT and NOA Using Parsimonious Forecasting Method

Following are Cisco Systems’ sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its year ended July 31, 2016 ($ millions).

Sales $49,247
Net operating profit after tax (NOPAT) 10,575
Net operating assets (NOA) 26,472

Use the parsimonious method to forecast Cisco’s sales, NOPAT, and NOA for years 2017 through 2020 using the following assumptions.

Sales growth per year 1.0%

for 2017 and

2.0%

thereafter

Net operating profit margin (NOPM) 21.5%
Net operating asset turnover (NOAT), based on NOA at July 31, 2016 1.86

Rounding instructions:

Round total revenue "unrounded" to two decimal places.

Round total revenue "rounded", NOPAT and NOA answers to the nearest whole number.

For NOPAT and NOA computations, use total revenue "rounded".

$ millions

2017 Est 2018 Est. 2019 Est. 2020 Est.
Total revenue (unrounded) $Answer $Answer $Answer $Answer
Total revenue (rounded) Answer Answer Answer Answer
NOPAT Answer Answer Answer Answer
NOA Answer Answer Answer Answer

Homework Answers

Answer #1

Solution:

As per parsimonious method to forecast, forumulas to be used are:

Sales= Previous year sales*(1+growthrate/100)

NOPAT= Current year sales*(NOPM/100)

NOA= Current year sales/NOAT

$Milliion 2017 2018 2019 2020
Total revenue (unrounded)
49739.47 50734.26 51748.94 52783.92
Total revenue (rounded)
49739 50734 51749 52784
NOPAT
10694 10908 11126 11349
NOA
26741 27276 27822 28378

Note: All the amount are in $ Millions

To calculate NOPAT and NOA, rounded figure of current year sales has been taken

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Cisco Systems’ sales, net operating profit...
Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Cisco Systems’ sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its year ended July 31, 2016 ($ millions). Sales $51,469 Net operating profit after tax (NOPAT) 11,066 Net operating assets (NOA) 27,672 Use the parsimonious method to forecast Cisco’s sales, NOPAT, and NOA for years 2017 through 2020 using the following assumptions. Sales growth per year 1.0% for 2017 and 2.0% thereafter Net operating profit...
Following are Cisco Systems’ sales, net operating profit after tax (NOPAT), and net operating assets (NOA)...
Following are Cisco Systems’ sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its year ended July 31, 2016 ($ millions). Sales $49,247 Net operating profit after tax (NOPAT) 10,575 Net operating assets (NOA) 26,472 Use the parsimonious method to forecast Cisco’s sales, NOPAT, and NOA for years 2017 through 2020 using the following assumptions. Sales growth per year 1.0% for 2017 and 2.0% thereafter Net operating profit margin (NOPM) 21.5% Net operating asset turnover (NOAT),...
Following are Cisco Systems’ sales, net operating profit after tax (NOPAT), and net operating assets (NOA)...
Following are Cisco Systems’ sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its year ended July 31, 2016 ($ millions). Sales $48,136 Net operating profit after tax (NOPAT) 10,349 Net operating assets (NOA) 25,880 Use the parsimonious method to forecast Cisco’s sales, NOPAT, and NOA for years 2017 through 2020 using the following assumptions. Sales growth per year 1.0% for 2017 and 2.0% thereafter Net operating profit margin (NOPM) 21.5% Net operating asset turnover (NOAT),...
Following are the income statement and balance sheet for Cisco Sytems for the year ended July...
Following are the income statement and balance sheet for Cisco Sytems for the year ended July 30, 2016. Cisco Sytems Consolidated Statements of Income Years Ended December ($ millions) July 30, 2016 July 25, 2015 Revenue Product $37,254 $37,750 Service 11,993 11,411 Total revenue 49,247 49,161 Cost of sales Product 14,161 15,377 Service 4,126 4,103 Total cost of sales 18,287 19,480 Gross margin 30,960 29,681 Operating expenses Research and development 6,296 6,207 Sales and marketing 9,619 9,821 General and administrative...
Following are the income statement and balance sheet for Cisco Sytems for the year ended July...
Following are the income statement and balance sheet for Cisco Sytems for the year ended July 30, 2016. Cisco Sytems Consolidated Statements of Income Years Ended December ($ millions) July 30, 2016 July 25, 2015 Revenue Product $37,254 $37,750 Service 11,993 11,411 Total revenue 49,247 49,161 Cost of sales Product 14,161 15,377 Service 4,126 4,103 Total cost of sales 18,287 19,480 Gross margin 30,960 29,681 Operating expenses Research and development 6,296 6,207 Sales and marketing 9,619 9,821 General and administrative...
Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating...
Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 30, 2016 Reported Horizon Period Terminal $ millions 2016 2017 2018 2019 2020 Period Sales $74,340 $75,827 $77,344 $78,891 $80,469 $81,274 NOPAT 3,345 3,412 3,480 3,550 3,621 3,657 NOA 22,302 22,748 23,203 23,667 24,141 24,382 Answer the following requirements assuming a terminal period growth rate of 1%, a discount rate (WACC) of 6%, common shares outstanding of 602 million,...
Forecasting and Estimating Share Value Using the DCF Model Following are the income statement and balance...
Forecasting and Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Intel Corporation. INTEL CORPORATION Consolidated Statements of Income Year Ended (In millions) Dec. 25, 2010 Dec. 26, 2009 Dec. 27, 2008 Net revenue $ 43,623 $ 35,127 $ 37,586 Cost of sales 15,132 15,566 16,742 Gross margin 28,491 19,561 20,844 Research and development 6,576 5,653 5,722 Marketing, general and administrative 6,309 7,931 5,452 Restructuring and asset impairment charges -- 231 710 Amortization...
Reformulation for Multi-Year Capitalization of Operating Leases Use the information provided below for Southwest Airlines to...
Reformulation for Multi-Year Capitalization of Operating Leases Use the information provided below for Southwest Airlines to answer the requirements. $ millions 2013 2014 2015 Net operating assets (NOA) $ 7,337 $ 6,812 $ 7,818 Net nonoperating obligations (NNO) (332) (296) 127 Total stockholders' equity 7,669 7,108 7,691 Net nonoperating expenses (NNE) 119 118 106 Net operating profit after tax (NOPAT) 873 1,254 2,287 Net income 754 1,136 2,181 Revenue 18,810 19,716 20,931 Below are the adjustments that analysts would use...
Question text Estimating Share Value Using the DCF Model Following are the income statement and balance...
Question text Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Texas Roadhouse for the year ended December 29, 2015. a. Assume the following forecasts for TXRH’s sales, NOPAT, and NOA for 2016 through 2019. Forecast the terminal period values assuming a 1% terminal period growth rate for all three model inputs: Sales, NOPAT, and NOA. Round your answers to the nearest dollar. Reported Forecast Horizon Terminal $ thousands 2015 2016 2017 2018...
Estimating Share Value Using the DCF Model Following are forecasts of Abercrombie & Fitch's sales, net...
Estimating Share Value Using the DCF Model Following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29, 2011. (Current-year NOPAT is lower due to transitory items; we use a longer term estimate for NOPM of 8%.) Reported Horizon Period (In millions) 2011 2012 2013 2014 2015 Terminal Period Sales $ 3,469 $ 3,989 $ 4,587 $ 5,275 $ 6,066 $ 6,187 NOPAT 152 319 367 422 485...