P11-32. Forecast the Income Statement, Balance Sheet, and Statement of Cash Flow

Question

P11-32. Forecast the Income Statement, Balance Sheet, and Statement of Cash Flows Following are fiscal year financial statements of Cisco Systems Inc. LO CIS CISCO SYSTEMS INC. Consolidated Statements of Operations Years Ended (in millions) July 30, 2016 July 25, 2015 $37,254 11,993 49,247 $37,750 11,411 49,161 14,161 4,126 18,287 30,960 15,377 4,103 19,480 29,681 Revenue Product . . . . . . Service .. ..... Total revenue... Cost of sales Product.. Service ..... Total cost of sales. Gross margin ...... Operating expenses Research and development ....... Sales and marketing...... General and administrative............. Amortization of purchased intangible assets .. Restructuring and other charges ... Total operating expenses. Operating income.. Interest income... .... Interest expense.... Other income (loss), net .... Interest and other income (loss), net. .. Income before provision for income taxes... Provision for income taxes.... Net income.... 6,207 9,821 2,040 359 484 6,296 9,619 1,814 303 268 18,300 12,660 1,005 (676) (69) 260 12,920 2,181 $10,739 18,911 10,770 769 (566) 228 431 11,201 2,220 $ 8,981

Explanation / Answer

INCOME STATEMENT Revenue July 30,2016 July 25,2015 2017 Product 37254 37750 -496 -1.31391 -489.483 36764.52 Service 11993 11411 582 5.100342 611.684 12604.68 Total revenue 49247 49161 49369.2 Cost of Sales Product 14161 15377 -1216 -7.90791 -1119.84 13041.16 Service 4126 4103 23 0.560565 23.12893 4149.129 Total cost ofsales 18287 19480 17190.29 Grosss Margin 30960 29681 32178.91 Operating expenses Research and development 6296 6207 12.78454 16.44238 8117.474 Sales and Marketting 9619 9821 19.53215 86.06608 0 General and administrative 1814 2040 3.683473 4.149631 0 Amortzation of purchased intangible assets 303 359 0.615266 0.730254 95.23355 Restructuringand other charges 268 484 0.544196 0.98452 40.84901 Total operating Expenses 18300 18911 8253.556 Operating Income 12660 10770 23925.36 Interest Income 1005 769 1005 Interest Expenses -676 -566 -676 Other Income -69 228 -69 Total 260 431 260 Income before provision of taxes 12920 11201 24185.36 Provision for income taxes 2181 2220 Balance Sheet Assets July 30,2016 July 25,2015 2017 Current assets Cash and cash equivalents 7631 6877 754 10.96408 836.6692 8467.669 Investments 58125 53539 4586 8.565718 4978.824 63103.82 Accounts receivable 5847 5344 503 9.412425 550.3445 6397.344 Inventories 1217 1627 -410 -25.1998 -306.681 910.319 Finance receivables 4272 4491 -219 -4.87642 -208.321 4063.679 Other current assets 1627 1490 137 9.194631 149.5966 1776.597 Total 78719 73368 84719.43 Property and equipment 3506 3332 174 5.222089 183.0864 3689.086 Finance receivables 4158 3858 300 7.77605 323.3281 4481.328 Goodwill 26625 24469 0 0 26625 Purchased intangible assets 2501 2376 125 5.260943 131.5762 2632.576 Defferred tax assets 4299 4454 -155 -3.48002 -149.606 4149.394 Other assets 1844 1516 328 21.63588 398.9657 2242.966 Total 42933 40005 43820.35 121652 113373 128539.8 Liabilities Current Short term debt 4160 3897 263 6.748781 280.7493 4440.749 Accounts payable 1056 1104 -48 -4.34783 -45.913 1010.087 Income taxes payable 517 62 455 733.871 3794.113 4311.113 Accrued compensation 2951 3049 -98 -3.21417 -94.8501 2856.15 Defferred revenue 10155 9824 331 3.3693 342.1524 10497.15 Other current liabilities 6072 5476 596 10.88386 660.8678 6732.868 24911 23412 29848.12 Long term debt 24483 21457 3026 14.10262 3452.745 27935.75 Income taxes payable 925 1876 -951 -50.693 -468.91 456.0901 Deferred revenue 6317 5359 958 17.87647 1129.257 7446.257 Other long term liabilities 1431 1562 -131 -8.38668 -120.013 1310.987 33156 30254 37149.08 58067 53666 66997.2 Equity Common Stock 44516 Retained Earnings 19396 Accumulated and comprehensive income -326 63586 Non controlling assets -1 Total equity 63585 130582.2 Cash Flow Satement Retained earnings 19396 16045 3351 Income before taxes 24185 Provision for tax 2181 2220 -39 Dividend 4750 32247 Cash from operating activities Cash 7631 6877 -754 Allowance for doubtful debts 249 302 53 Accounts receivable 5847 5344 -503 Inventories 1217 1627 410 Financing receivables 4272 4491 219 Other 1627 1490 -137 Depriciation 1847 Short term debt 4160 3897 263 Accounts payable 1056 1104 -48 Income tax Payable 517 62 455 Accrued compensation 2951 3049 -98 Other current liabilities 6072 5476 596 Deffered tax assets 4299 4454 155 Deffered tax liabilities 10155 9824 331 2789 Cash from investing activities Invetments 58125 53539 -4586 Property 3506 3332 -174 Goodwill 26625 24469 -2156 Purchased intangible assets 2501 2376 -125 Other 1844 1516 -328 -7369 Cash from financing activities Common stock 44516 43592 -924 Debt maturities 4150 3226

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.