Question

In: Accounting

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 $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

Solutions

Expert Solution


Related Solutions

Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA)...
Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 26, 2011, for Best Buy, Inc. Refer to the information in the table to answer the following requirements. Assume Reported Horizon Period (In millions) 2011 2012 2013 2014 2015 Terminal Period Sales $40,023 $44,577 $49,650 $55,300 $61,592 $62,208 NOPAT 1,448 1,637 1,808 2,014 2,224 2,257 NOA 5,287 5,893 6,539 7,282 8,140 8,193 Answer the following requirements assuming a discount rate (WACC)...
SALES - 49247; NOPAT - 10382.8 ; NOA- 26472 BALANCE SHEET - NCI = (1) If...
SALES - 49247; NOPAT - 10382.8 ; NOA- 26472 BALANCE SHEET - NCI = (1) If Cisco’s top management were optimistic about CISCO’s market growth opportunities and revised their sales growth rates up by 2%, please forecast Cisco's sales, NOPAT, and NOA for years 2017 through 2020 and the terminal period using the following assumptions: Sales growth (2017) - 4% Sales growth (2018-2020) -5% Terminal growth -1% Net operating profit margin 2016 rate rounded to three decimal places Net operating...
Compute and interpret the net-operating profit after tax (NOPAT) of the company for 2018 and 201
Balance sheet                                                                                           Items    2019     2018 Cash     8,313   11,604 Marketable securities        696        618 Account receivables   23,795   30,563 Inventory     1,619     1,682 Prepaid expenses     3,997     4,678 Net Fixed Assets   96,457   68,764 Investment in AB Co. stocks   17,309     5,473 Account payables   24,600   21,372 Wages and salaries payable   13,101   16,855 Bond payable (10 yrs.)   54,102   35,605 Notes payable (3 yrs.)   39,398   32,621 Total shareholders’ Equity Capital   20,985   16,929   B.   Income statement Items   2019    2018 Revenues   77,147   79,591 Cost of goods sold   40,659   42,655   Salaries...
Find Forecast Cisco's sales, NOPAT, and NOA for years 2017 through 2020 and the terminal period...
Find Forecast Cisco's sales, NOPAT, and NOA for years 2017 through 2020 and the terminal period using the following assumptions: Sales for 2016- $ 49247 Nopat 2016 - $ 10382.8 NOA 2016- $ 26476.88 Sales growth 2017 2% , Sales growth 2018-2020 3% , Terminal growth 1% [Net operating profit margin 2016 rate rounded to three decimal places Net operating asset turnover 2016 rate rounded to three decimal places] Assume a discount rate (WACC) of 10%, common shares outstanding of...
Estimating Share Value Using the DCF Model Following are forecasts of sales, net operating profit after...
Estimating Share Value Using the DCF Model Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 31, 2016, for Wal-Mart Stores, Inc. Reported Horizon Period $ millions 2016 2017 2018 2019 2020 Terminal Period Sales $482,130 $486,951 $491,821 $496,739 $501,706 $506,723 NOPAT 16,634 17,043 17,214 17,386 17,560 17,735 NOA 124,940 126,186 127,448 128,722 130,009 131,309 Answer the following requirements assuming a discount rate (WACC) of 7%, a terminal period growth...
Estimating Share Value Using the DCF Model Following are forecasts of sales, net operating profit after...
Estimating Share Value Using the DCF Model Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 26, 2011, for Best Buy, Inc. Assume Reported Horizon Period (In millions) 2011 2012 2013 2014 2015 Terminal Period Sales $50,272 $52,786 $55,425 $58,196 $61,106 $61,717 NOPAT 1,389 1,584 1,663 1,746 1,833 1,852 NOA 7,876 8,248 8,660 9,093 9,548 9,643 Answer the following requirements assuming a discount rate (WACC) of 11%, a terminal period...
Estimating Share Value Using the DCF Model Following are forecasts of sales, net operating profit after...
Estimating Share Value Using the DCF Model Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 26, 2011, for Best Buy, Inc. Assume Reported Horizon Period (In millions) 2011 2012 2013 2014 2015 Terminal Period Sales $50,272 $52,786 $55,425 $58,196 $61,106 $61,717 NOPAT 1,389 1,584 1,663 1,746 1,833 1,852 NOA 7,876 8,248 8,660 9,093 9,548 9,643 Answer the following requirements assuming a discount rate (WACC) of 11%, a terminal period...
Cisco Systems has total assets of $35.841 billion, total debt of $9.112 billion, and net sales...
Cisco Systems has total assets of $35.841 billion, total debt of $9.112 billion, and net sales of $22.835 billion. Its net profit margin for the year is 20 percent, while the operating profit margin is 30 percent. What are Cisco’s net income, EBIT ROA, ROA, and ROE? (Enter amount in billion. Round net income to 3 decimal places, e.g. 25.335. Round EBIT ROA, ROA and ROE to 1 decimal place, e.g.12.2%.) Net income $ billion EBIT ROA % ROA %...
Dimitra is projecting cash flows for her firm using the percentage of sales method. She projects...
Dimitra is projecting cash flows for her firm using the percentage of sales method. She projects that the sales will be growing at 5% per year from the current level of $1M (year 0). She also projects a constant $20K per year in depreciation for the next 5 years. The firm's Net PPE currently stands at $400K. What should be her forecast for Capital Investment in year 2? A. $44K B. $20K C. $41K D. $61K E. $20K
Last year, Ashley Inc. had a NOPAT of $700 and total net operating capital TNOC of...
Last year, Ashley Inc. had a NOPAT of $700 and total net operating capital TNOC of $1800. This year, Ashley's has a NOPAT $900 and total net operating capital TNOC of $2200. What is the free cash flow for this year? a) $300 b) $600 c) $400 d) $500 e) $700
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT