Forecasting with the Parsimonious Method and Estimating Share Value Using the DCF Model

Following are income statements and balance sheets for Cisco Systems.

Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places.

$\backslash$table$[[$Cisco Systems$],[\backslash$table$[[$Consolidated Statements of Income$],[$Julv $27.$ July $28.]],$July $27.,$July $28,],[$Years Ended December $($S millions$),,],[$Revenue$],[$Product$,$$$42,906,$$$40,380$