Question

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), 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

Incorrect
Mark 0.00 out of 1.00

NOA Answer Answer Answer Answer

Homework Answers

Answer #1

Note :

  • Net operating profit margin = (Net operating profit after tax) / sales
  • Net operating asset turnover = Sales / Net operating assets
  • Next Year sales = Current Year sales * (100 % + growth rate %)
2018 Est 2019 Est 2020 Est
Total revenue (unrounded) ($49,247 * 101 % ) = $49,739.47 ($49,739.47 * 102 %) = $50,734.26 ($50,734.26 * 102 % ) = $51,748.94 ($51,748.94 * 102 %) = $52,783.92
Total revenue (rounded) $49,739 $50,734 $51,749 $52,784
NOPAT (total revenue * 21.5%) ($49,739 * 21.5%) = $10,694 ($50,734 * 21.5%) = $10,908 ($51,749 * 21.5%) = $11,126 ($52,784 * 21.5%) = $11,349
NOA (total revenue / 1.86) ($49,739 / 1.86) = $26,741 ($50,734 / 1.86) = $27,276 ($51,749 / 1.86) = $27,822 ($52,784 / 1.86) = $28,378
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
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),...
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...
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...
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,...
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...
Compute and Interpret RNOA, Profit Margin, and Asset Turnover of Competitors Selected balance sheet and income...
Compute and Interpret RNOA, Profit Margin, and Asset Turnover of Competitors Selected balance sheet and income statement information for drug store retailers CVS Health Corp. and Walgreens Boots Alliance follows. 2015 Net 2014 Net 2015 Operating Operating Company ($ millions) Ticker 2015 Sales NOPAT Assets Assets CVS Health CVS $153,290 $5,758 $62,159 $48,338 Walgreens Boots Alliance WBA 103,444 3,642 42,683 22,461 a. Compute the 2015 return on net operating assets (RNOA) for each company. Round answers to two decimal places...
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...
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...