Question

In: Accounting

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 5,029 million, and net nonoperating obligations (NNO) of $(37,113) million (NNO is negative which means that Cisco has net nonoperating investments). (f) Estimate the value of a share of Cisco common stock as of July 30, 2016 using the discounted cash flow (DCF) model and sales, NOPAT and NOA forecast in the sum above

Solutions

Expert Solution

Reported Forecast horizon
$ millions 2016 2017 2018 2019 2020 Terminal period
Sales $49,247.000 $50,231.940 $51,738.898 $53,291.065 $54,889.797 $55,438.695
NOPAT $10,382.800 $10,590.456 $10,908.169 $11,235.415 $11,572.477 $11,688.202
NOA $26,478.880 $27,006.418 $27,816.610 $28,651.109 $29,510.642
Estimated value of target common stock:
Increase in NOA

$529.538

$810.192 $834.499 $859.533 $295.106
FCPF(NOPAT-increase in NOA) $10,060.918 $10,097.977 $10,400.916 $10,712.944 $11,393.096
DCF @10% 0.9091 0.8264 0.7513 0.6830
Present value of horizon FCFF $9,146.380 $8,344.968 $7,814.208 $7,316.940
Cumulative present value of horizon FCFF $31,992.496
Terminal FCFF [11393.096/(0.10-0.01)] $126,589.955
Present value of terminal FCF(126589.955*0.6830) $86,460.939
Total firm value $11,8453.435
NNO $37,113.000
Firm equity value $155,566.435
Shares outstanding in million $5029.000
Stock price per share $30.934

Related Solutions

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...
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)...
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...
Develop a three-period moving average forecast for April 2019 through January 2020. Calculate the MFE, MAD,...
Develop a three-period moving average forecast for April 2019 through January 2020. Calculate the MFE, MAD, and MAPE values for April through December 2019. LOADING... Click the icon to view the time series data. Develop a three-period moving average and fill-in the table below (enter your responses rounded to one decimal place). Month Demand Forecast January 2019 123123 February 7474 March 114114 April 7777 103.66103.66 May 9898 88.3388.33 June 136136 96.3396.33 July 103103 103.66103.66 August 106106 112.33112.33 September 100100 103103...
As for the sales forecast for Year 1 through Year 3, these are some important variables...
As for the sales forecast for Year 1 through Year 3, these are some important variables I will go to consider for sales: Economy: The economic condition of the city, the province and the country are variables I need to consider for a sales forecast. If conditions are poor, people will spend less money on consumption. If economic conditions are great, then more people will have extra money to spend. Competition: I need to consider the level of competition I...
. Using only the New York sales data: 1a. Forecast sales for January 5th through January...
. Using only the New York sales data: 1a. Forecast sales for January 5th through January 30th using exponential smoothing with alpha set to 0.6. Assume the sales forecast for January 4th was 456. 1b. Using your forecasts from 1a, find the mean absolute deviation of the sales forecasts for January 5th through January 29th. Again, you should not include the forecast for January 30 since there is no corresponding sales figure for that date. 1c. Using your forecasts from...
The following are transactions for the account period of 5/1/2020 through 5/31/2020 for the Sandy’s East...
The following are transactions for the account period of 5/1/2020 through 5/31/2020 for the Sandy’s East Coast Kites and Novelties, a sole proprietorship owned by Windy Uberflier. Create a trial balance, Income Statement, Statement of Owners Equity, and Balance Sheet at the end of day on 5/31/20. Don’t forget to adjust accounts. 5/1/20 - Deposited $53,000 into a business bank account for the company. 5/1/20 - Signed a lease for retail and manufacturing space and paid cash for the first...
Period Sales ($million) 2017 Q1 2874 2017 Q2 3000 2017 Q3 2913 2017 Q4 2916 2918...
Period Sales ($million) 2017 Q1 2874 2017 Q2 3000 2017 Q3 2913 2017 Q4 2916 2918 Q1 2910 2018 Q2 3052 2018 Q3 3116 2018 Q4 3210 2019 Q1 3243 2019 Q2 3351 2019 Q3 3305 2019 Q4 3267 The above table represents the quarterly sales (measured in millions of dollars) for the Goodyear Tire from 2017 to 2019. Compute the 4-quarter moving average. Put your answers onto the table. Compute the 4-quarter centered moving average. Put your answers onto...
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and...
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and you know that sales will be decreasing every period for the foreseeable future. What of the following would be the best set of weights to use? (listed in order from the most recent period to four periods? ago, respectively)? A.0.00, 0.00,? 0.00, 1.00 B.?0.25, 0.25,? 0.25, 0.25 C.?1.00, 0.00,? 0.00, 0.00 D.0.10, 0.20,? 0.30, 0.40 E. ?0.40, 0.30,? 0.20, 0.10
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and...
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and you know that sales will be decreasing every period for the foreseeable future. What of the following would be the best set of weights to use? (listed in order from the most recent period to four periods? ago, respectively)? A.0.00, 0.00,? 0.00, 1.00 B.?0.25, 0.25,? 0.25, 0.25 C.?1.00, 0.00,? 0.00, 0.00 D.0.10, 0.20,? 0.30, 0.40 E. ?0.40, 0.30,? 0.20, 0.10
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT