Finance Excel assignment 2
NeedHelp23
cisco_systems_inc..xlsxIncome statement 2015
| Cisco Systems, Inc. | |
| Income statement for period ended 25-July- 2015 | |
| $('000') | |
| Total Revenue | 49,161,000 |
| Cost of Revenue | 19,480,000 |
| Gross Profit | 29,681,000 |
| operating expenses | |
| Research Development | 6,207,000 |
| Selling General and Administrative | 11,861,000 |
| Non Recurring | 484,000 |
| Others | 359,000 |
| Total Operating Expenses | 18,911,000 |
| Operating Income or Loss | 10,770,000 |
| Income from Continuing Operations | |
| Total Other Income/Expenses Net | 997,000 |
| Earnings Before Interest And Taxes | 11,767,000 |
| Interest Expense | 566,000 |
| Income Before Tax | 11,201,000 |
| Income Tax Expense | 2,220,000 |
| Net Income From Continuing Ops | 8,981,000 |
| Net Income Applicable To Common Shares | 8,981,000 |
| Reference | |
| Yahoo Finance. (2015).Cisco Systems, Inc Income statement. Retrieved from https://finance.yahoo.com/q/is?s=CSCO+Income+Statement&annual |
Balance sheet 2015
| Cisco Systems, Inc. | |
| Balance sheet for ending 25-july-2015. $('000') | |
| Assets | |
| Current Assets | |
| Cash And Cash Equivalents | 6,877,000 |
| Short Term Investments | 53,539,000 |
| Net Receivables | 12,750,000 |
| Inventory | 1,627,000 |
| Other Current Assets | 1,490,000 |
| Total Current Assets | 76,283,000 |
| Long Term Investments | 3,858,000 |
| Property Plant and Equipment | 3,332,000 |
| Goodwill | 24,469,000 |
| Intangible Assets | 2,376,000 |
| Other Assets | 3,163,000 |
| Total Assets | 113,481,000 |
| Liabilities | |
| Current Liabilities | |
| Accounts Payable | 4,215,000 |
| Short/Current Long Term Debt | 3,897,000 |
| Other Current Liabilities | 15,511,000 |
| Total Current Liabilities | 23,623,000 |
| Long Term Debt | 21,457,000 |
| Other Liabilities | 3,335,000 |
| Deferred Long Term Liability Charges | 5,359,000 |
| Minority Interest | 9,000 |
| Total Liabilities | 53,783,000 |
| Stockholders' Equity | |
| Common Stock | 43,592,000 |
| Retained Earnings | 16,045,000 |
| Other Stockholder Equity | 61,000 |
| Total Stockholder Equity | 59,698,000 |
| Net Tangible Assets | 32,853,000 |
| References | |
| Yahoo Finance. (2015).Cisco Systems, Inc Balance sheet. Retrieved from https://finance.yahoo.com/q/bs?s=CSCO+Balance+Sheet&annual |
cashflow statement 2015
| Cisco Systems, Inc. | |
| Periodic 25-july- 2015 $('000') | |
| Net Income | 8,981,000 |
| Operating Activities, Cash Flows Provided By or Used In | |
| Depreciation | 2,442,000 |
| Adjustments To Net Income | 1,165,000 |
| (Changes In Accounts Receivables) | (1,047,000) |
| Changes In Liabilities | 1,497,000 |
| Changes In Inventories | (116,000) |
| Changes In Other Operating Activities | (370,000) |
| Total Cash Flow From Operating Activities | 12,552,000 |
| Investing Activities, Cash Flows Provided By or Used In | |
| Capital Expenditures | (1,227,000) |
| Investments | (8,379,000) |
| Other Cash flows from Investing Activities | (482,000) |
| Total Cash Flows From Investing Activities | (10,088,000) |
| Financing Activities, Cash Flows Provided By or Used In | |
| Dividends Paid | (4,086,000) |
| Sale Purchase of Stock | (2,810,000) |
| Net Borrowings | 4,469,000 |
| Other Cash Flows from Financing Activities | (14,000) |
| Total Cash Flows From Financing Activities | (2,313,000) |
| Effect Of Exchange Rate Changes | - |
| Change In Cash and Cash Equivalents | 151,000 |
| References | |
| Yahoo Finance. (2015).Cisco Systems, Inc Cash flow. Retrieved from https://finance.yahoo.com/q/cf?s=CSCO+Cash+Flow&annual |
Stock prices
| Cisco Systems, Inc. | |
| Historical stock prices( 7 Days) | |
| Date | Adj Close price |
| 17-Dec-15 | 26.72 |
| 16-Dec-15 | 27.24 |
| 15-Dec-15 | 26.85 |
| 14-Dec-15 | 26.49 |
| 11-Dec-15 | 26.16 |
| 10-Dec-15 | 26.77 |
| 9-Dec-15 | 26.73 |
| Rate of Return=[(Stock price of the last day- stock price of the first day)/Stock price of the first day]*100 | |
| Last Day | 26.72 |
| First day | 26.73 |
| Change | -0.01 |
| Rate of Return | -0.0374111485 |
| References | |
| Yahoo Finance. (2015).Cisco Systems, Inc historical prices. Retrieved from https://finance.yahoo.com/q/hp?s=CSCO+Historical+Prices |
