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. Cisco Systems Consolidated Statements of Income Years Ended December ($ millions)July 27, 2019July 28, 2018 Revenue Product$39,005$36,709 Service12,89912,621 Total revenue51,90449,330 Cost of sales Product14,86314,427 Service4,3754,297 Total cost of sales19,23818,724 Gross margin32,66630,606 Operating expenses Research and development6,5776,332 Sales and marketing9,5719,242 General and administrative1,8272,144 Amortization of purchased intangible assets150221 Restructuring and other charges322358 Total operating expenses18,44718,297 Operating income14,21912,309 Interest income1,3081,508 Interest expense(859)(943) Other income (loss), net(97)165 Interest and other income (loss), net352730 Income before provision for income taxes14,57113,039 Provision for income taxes2,95012,929 Net income$11,621$110 Cisco Systems Inc. Consolidated Balance Sheets In millions, except par valueJuly 27, 2019July 28, 2018 Assets Current assets Cash and cash equivalents$11,750$8,934 Investments21,66337,614 Accounts receivable, net of allowance for doubtful accounts5,4915,554 Inventories1,3831,846 Financing receivables, net5,0954,949 Other current assets2,3732,940 Total current assets47,75561,837 Property and equipment, net2,7893,006 Financing receivables, net4,9584,882 Goodwill33,52931,706 Purchased intangible assets, net2,2012,552 Deferred tax assets4,0653,219 Other assets2,4961,582 Total assets$97,793$108,784 Liabilities and equity Current liabilities Short-term debt$10,191$5,238 Accounts payable2,0591,904 Income taxes payable1,1491,004 Accrued compensation3,2212,986 Deferred revenue10,66811,490 Other current liab