When this exam was mailed to you, the 2020 Annual Report for Cisco Systems was also attached to the email. In addition two excerpts from that 10K was also provided: Cisco's Balance Sheet and Cisco's Statement of Equity Answer the following questions; if boxes are presented use them to provide your answers. 1 The Statement of Equity provides the Ending Balances for all active Equity accounts for 4 years. In the boxes below state the four years. 2. Compare the Statement of Equity to the Balance Sheet. Which "inactive' account presented on Which inactive Equity account on the Balance sheet is NOT presented in the Statement of Equity? a b Reading the Balance Sheet state briefly why this account is inactive: 3 Look at the first column in the Statement of Equity. It reports the number of Common Shares. Shares can be described as Authorized, issued, and Outstanding, or not depending on their status. Compare this column to the Common Stock Line Item on the balance sheet. Does this column in the Statement of Equity report ALL common shares or only those Common Shares that are Authorized, issued AND Outstanding? a b For the four year end balans reported, what is the highest number of Common Stock shares reported and the lowest number of such shares and state the year end for which this applies Year # of Shares Highest Lowest 3 Look at the first column in the Statement of Equity. It reports the number of Common Shares. Shares can be described as Authorized, issued, and Outstanding, or not depending on their status. Compare this column to the Common Stock Line Item on the balance sheet. Does this column in the Statement of Equity report All common shares or only those Common Shares that are Authorized, Issued AND Outstanding? a b For the four year end balances reported, what is the highest number of Common Stock shares reported and the lowest number of such shares and state the year end for which this applies Year # of Shares Highest Lowest 4 The account balances shown in the Statement of Equity combine the Par Value and APIC amounts for Common Stock. Which account balance should always be higher in the case of CISCO: Par Value or APIC a b Cisco accounts for Share Repurchases in a manner similar to Apple instead of showing a separate Treasury Share account. Across the three years of activity reported what is the largest annual share repurchase amount? 5 Retained Earnings can be either Positive or Negative as to arithmetic sign. When Cisco shows Negative Retained Earnings it ftes the label "Accumulated Deficit" in a manner similar to Tesla. State the largest single negative input to Retained Earnings in Samounts, the year it occurs and the activity it represents AMOUNT YEAR ACTIVITY a 6 Accumulated Other Comprehensive Income can either be Positive or Negative as to arithmetic sign. Is Cisco's 2021 AOCI balance Positive or Negative? b. In class we examined IBM's Other Comprehensive Income to learn that IBM has four separate Ocl activities within AOCI. Use the grid below to indentify which of the OC categories present in IBM are PRESENT OR NOT PRESENT in Cisco OCI/AOCI category Foreign Currency Available for Sale Derivatives Pensions Cumulative Translation Investments Cash Flow Adjustment Gains/Losses Hedging Present Present Present Present ENTER Present or Not Present IBM CISCO 7 In class we reviewed at last one public company's Financial Statements each class and observed which equity accounts were listed and whether Equity as a whole as positive or negative. la Using the statement of Equity, as a whole is Cisco's total EQUITY balance at each year end positive or negative (check the box) Always positive Always negative A mix b Compare the Statement of Equity to the Balance Sheet. Which of the 7 Equity accounts that we studied seem to be absent from CISCO? (There is only really one, because they do list preferred stock and they record repurchases as a reduction of Common Stock rather than in a separate Treasury Stock account. But one Equity account is surely "missing.") Place this missing account name in the box to the right CISCO SYSTEMS, INC Consolidated Balance Sheets (in millions, except par value) July 31, 2021 July 25, 2020 9,175$ 15,343 11,809 17,610 5,766 1.359 4,380 2,889 39,112 2.338 4,884 38,168 3,619 4,360 5,016 97.4975 5,472 1.282 5,051 2,349 43,573 2,453 5,714 33.806 1,576 3,990 3.741 94.853 ASSETS Current assets Cash and cash equivalents Investments Accounts receivable, net of allowance of $109 at Joly 31, 2021 und $143 at July 25, 2020 Inventories Financing receivables, net Other current assets Total current assets Property and equipment, net Financing receivables, net Goodwill Purchased intangible assets, net Deferred tax assets Other assets TOTAL ASSETS LIABILITIES AND EQUITY Current liabilities Short-term debt Accounts payable Income taxes payable Accrued compensation Deferred revenue Other current liabilities Total current liabilities Long-term debt Income taxes payable Deferred revenue Other long-term liabilities Total liabilities Commitments and contingencies (Note 1) Equity Cisco stockholders equity Preferred stock. 50.001 par value: 5 shares authorized, none issued and outstanding Common stock and additional paid-in capital, 50.001 par value: 20,000 shares authorized: 4,217 and 4,237 shares issued and outstanding at July 31, 2021 and July 25, 2020, respectively Accumulated deficit Accumulated other comprehensive loss Total equity TOTAL LIABILITIES AND EQUITY 2,5085 2,362 801 3,818 12,148 4.620 26,257 9.018 8,538 10,016 2,393 56.222 3,005 2,218 839 3.122 11,406 4741 23,331 11,578 8,837 9,040 2,147 56,933 42.346 (654) (417) 41,275 97,497 5 41,202 (2.763) (519) 37.920 94,853 See Notes to Consolidated Financial Statements Retained Earnings (Accumulated Deficit) 1,233 $ 11,621 Accumulated Other Comprehensive Income (Loss) Total Equity (849) S 43,204 11,621 225 225 640 (20,577) (418) (16,675) (5.979) 3.899 (168) (862) (5,979) 3,729 1.570 33,571 11.214 273 (792) 5 CISCO SYSTEMS, INC. Consolidated Statements of Equity (in millions, except per-share amounts) Common Stock Shares or and Com Additional Stock Paid-In Capital BALANCE AT JULY 28, 2018 4,614 $ 42,820 S Net income Other comprehensive income (loss) Issuance of common stock 71 640 Repurchase of common stock (3.902) Shares repurchased for tax withholdings on vesting of restricted stock units (17) (862) Cash dividends declared ($1 36 per common share) Effect of adoption of accounting standards Share-based compensation 1.570 BALANCE AT JULY 27, 2019 4.250 5 40,2665 Net income Other comprehensive income (loss) Issuance of common stock 61 655 Repurchase of common stock (59) (561) Shares repurchased for tax withholdings on vesting of restricted stock units (15) (727) Cash dividends declared (S1 A2 per common share) Share-based compensation 1,569 BALANCE AT JULY 25, 2020 4,237 5 41,2025 Net income Other comprehensive income (loss) Issuance of common stock 58 643 Repurchase of common stock (64) (625) Shares repurchased for tas withholdings on vesting of restricted stock units (14) (636) Cash dividends declared (51.46 per common share) Effect of adoption of accounting standard Share-based compensation 1.761 Other 1 BALANCE AT JULY 31, 2021 4.2175 42.346 S (5.903) 5 11,214 273 655 (2,058) (2,619) (6,016) (519) (2,763) 5 10,591 (727) (6,016) 1.569 37.920 10.591 102 643 (2,902) 102 (2.277) (6.166) (38) (636) (6,166) (38) 1.761 4,217 (0) (654) 5 (417) 5 41.275 See Notes to Consolidated Financial Statements July 31, 2021 July 25, 2020 July 27, 2019 36,014 5 13,804 49.818 35,9785 13323 49,301 39,005 12.899 31,904 13,300 4624 17,924 31.894 13.199 4.419 17618 31,683 14,863 4,375 19.238 32,666 CISCO SYSTEMS, INC. Consolidated Statements of Operations (in millions, except per share amounts) Years Ended REVENUE: Product 5 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 dow), net Interest and other income (loss), net INCOME BEFORE PROVISION FOR INCOME TAXES Provision for income taxes NET INCOME 6147 9.169 1.925 14 481 6.549 9.259 2,152 215 886 19,061 12833 GIS (434) 245 429 13,262 2.671 10.391 5 18,063 13,620 920 (585) 15 350 13.970 2,756 11,2145 6,577 9,571 1,827 150 322 18,447 14,219 1.308 (859) (97) 352 14,571 2.950 11.621 Net income per share Basic 2315 2.50 $ 2.655 2665 2.63 2.61 Diluted Share used in pershare calculation Basic Diluted 4.222 4,236 4,236 4,254 4,419 4,453 See Notes to Consolidated Financial Statements Table of Contents July 25, 2020 11,2145 July 27, 2019 11,621 336 459 (21) 315 19 478 CISCO SYSTEMS, INC. Consolidated Statements of Comprehensive Income (in inillions) Yanded July 31, 2021 Net income S 10.5915 Available for sale investments Change in net unrealized gains and losses, net of tax benefit (expense) of $46, 5(84), and $(101) for fiscal 2021, 2020, und 2019, respectively (95) Net (gains) losses reclassified into carings, net of tax expense (benefit) of 515, 521, and 56 for fiscal 2021, 2020, and 2019, respectively (38) (133) Cash flow hedging instruments Change in unrealized gains and losses, net of tax benefit (expense) of S(4), 50 and 50 for fiscal 2021, 2020, and 2019. respectively 16 Net (gains) losses reclassified into camnings, net of tax (benefit) expense of 53, 50, and SO for fiscal 2021, 2020 and 2019, respectively (11) 5 Net change in cumulative translation adjustment and actuarial gains and losses, net of tax benefit (expense) of S(2), 5(5), and 515 for fiscal 2021, 2020 and 2019. respectively Other comprehensive income 102 Comprehensive income 10,693 5 230 (50) 273 11.4875 (250) 225 11.846 See Notes to Consolidated Financial Statements