Finance Homework
Johath3
assignment2excel_1.xlsxINCOME STATEMENT
| NIKE, Inc. (NKE) | ||||
| INCOME STATEMENT | ||||
| Period Ending | May 31, 2015 | May 31, 2014 | May 31, 2013 | |
| Total Revenue | 30,601,000 | 27,799,000 | 25,313,000 | |
| Cost of Revenue | 16,534,000 | 15,353,000 | 14,279,000 | |
| Gross Profit | 14,067,000 | 12,446,000 | 11,034,000 | |
| Operating Expenses | ||||
| Research Development | - | - | - | |
| Selling General and Administrative | 9,892,000 | 8,766,000 | 7,796,000 | |
| Non Recurring | - | - | - | |
| Others | - | - | - | |
| Total Operating Expenses | - | - | - | |
| Operating Income or Loss | 4,175,000 | 3,680,000 | 3,238,000 | |
| Income from Continuing Operations | ||||
| Total Other Income/Expenses Net | 58,000 | -103,000 | 15,000 | |
| Earnings Before Interest And Taxes | 4,205,000 | 3,544,000 | 3,256,000 | |
| Interest Expense | - | - | - | |
| Income Before Tax | 4,205,000 | 3,544,000 | 3,256,000 | |
| Income Tax Expense | 932,000 | 851,000 | 805,000 | |
| Minority Interest | - | - | - | |
| Net Income From Continuing Ops | 3,273,000 | 2,693,000 | 2,451,000 | |
| Non-recurring Events | ||||
| Discontinued Operations | - | - | 21,000 | |
| Extraordinary Items | - | - | - | |
| Effect Of Accounting Changes | - | - | - | |
| Other Items | - | - | - | |
| Net Income | 3,273,000 | 2,693,000 | 2,472,000 | |
| Preferred Stock And Other Adjustments | - | - | - | |
| Net Income Applicable To Common Shares | 3,273,000 | 2,693,000 | 2,472,000 | |
| References | ||||
| Finance.yahoo.com,. (2015). NKE Income Statement | Nike, Inc. Common Stock Stock - Yahoo! Finance. | ||||
| Retrieved 10 October 2015, from | ||||
| http://finance.yahoo.com/q/is?s=NKE+Income+Statement&annual |
BALANCE SHEET
| NIKE, Inc. (NKE) | ||||
| BALANCE SHEET | ||||
| Period Ending | May 31, 2015 | May 31, 2014 | May 31, 2013 | |
| Assets | ||||
| Current Assets | ||||
| Cash And Cash Equivalents | 3,852,000 | 2,220,000 | 3,337,000 | |
| Short Term Investments | 2,072,000 | 2,922,000 | 2,628,000 | |
| Net Receivables | 3,747,000 | 3,789,000 | 3,425,000 | |
| Inventory | 4,337,000 | 3,947,000 | 3,484,000 | |
| Other Current Assets | 1,968,000 | 818,000 | 756,000 | |
| Total Current Assets | 15,976,000 | 13,696,000 | 13,630,000 | |
| Long Term Investments | - | - | - | |
| Property Plant and Equipment | 3,011,000 | 2,834,000 | 2,452,000 | |
| Goodwill | 131,000 | 131,000 | 131,000 | |
| Intangible Assets | 281,000 | 282,000 | 289,000 | |
| Accumulated Amortization | - | - | - | |
| Other Assets | - | - | - | |
| Deferred Long Term Asset Charges | 2,201,000 | 1,651,000 | 1,043,000 | |
| Total Assets | 21,600,000 | 18,594,000 | 17,545,000 | |
| Liabilities | ||||
| Current Liabilities | ||||
| Accounts Payable | 6,153,000 | 4,853,000 | 3,789,000 | |
| Short/Current Long Term Debt | 181,000 | 174,000 | 155,000 | |
| Other Current Liabilities | - | - | 18,000 | |
| Total Current Liabilities | 6,334,000 | 5,027,000 | 3,962,000 | |
| Long Term Debt | 1,079,000 | 1,199,000 | 1,210,000 | |
| Other Liabilities | - | - | - | |
| Deferred Long Term Liability Charges | 1,480,000 | 1,544,000 | 1,292,000 | |
| Minority Interest | - | - | - | |
| Negative Goodwill | - | - | - | |
| Total Liabilities | 8,893,000 | 7,770,000 | 6,464,000 | |
| Stockholders' Equity | ||||
| Misc Stocks Options Warrants | - | - | - | |
| Redeemable Preferred Stock | - | - | - | |
| Preferred Stock | - | - | - | |
| Common Stock | 3,000 | 3,000 | 3,000 | |
| Retained Earnings | 4,685,000 | 4,871,000 | 5,620,000 | |
| Treasury Stock | - | - | - | |
| Capital Surplus | 6,773,000 | 5,865,000 | 5,184,000 | |
| Other Stockholder Equity | 1,246,000 | 85,000 | 274,000 | |
| Total Stockholder Equity | 12,707,000 | 10,824,000 | 11,081,000 | |
| Net Tangible Assets | 12,295,000 | 10,411,000 | 10,661,000 | |
| References | ||||
| Finance.yahoo.com,. (2015). NKE Balance Sheet | Nike, Inc. Common Stock Stock - Yahoo! Finance. | ||||
| Retrieved 10 October 2015, from | ||||
| http://finance.yahoo.com/q/bs?s=NKE+Balance+Sheet&annual |
CASH FLOW
| NIKE, Inc. (NKE) | ||||
| CASH FLOW | ||||
| Period Ending | May 31, 2015 | May 31, 2014 | May 31, 2013 | |
| Net Income | 3,273,000 | 2,693,000 | 2,472,000 | |
| Operating Activities, Cash Flows Provided By or Used In | ||||
| Depreciation | 649,000 | 586,000 | 502,000 | |
| Adjustments To Net Income | 502,000 | 222,000 | 136,000 | |
| Changes In Accounts Receivables | -216,000 | -298,000 | 142,000 | |
| Changes In Liabilities | 1,237,000 | 525,000 | 27,000 | |
| Changes In Inventories | -621,000 | -505,000 | -219,000 | |
| Changes In Other Operating Activities | -144,000 | -210,000 | -28,000 | |
| Total Cash Flow From Operating Activities | 4,680,000 | 3,013,000 | 3,032,000 | |
| Investing Activities, Cash Flows Provided By or Used In | ||||
| Capital Expenditures | -963,000 | -880,000 | -598,000 | |
| Investments | 785,000 | -328,000 | -1,140,000 | |
| Other Cash flows from Investing Activities | 3,000 | 1,000 | 798,000 | |
| Total Cash Flows From Investing Activities | -175,000 | -1,207,000 | -940,000 | |
| Financing Activities, Cash Flows Provided By or Used In | ||||
| Dividends Paid | -899,000 | -799,000 | -703,000 | |
| Sale Purchase of Stock | -2,020,000 | -2,245,000 | -1,361,000 | |
| Net Borrowings | -26,000 | -77,000 | 937,000 | |
| Other Cash Flows from Financing Activities | - | - | - | |
| Total Cash Flows From Financing Activities | -2,790,000 | -2,914,000 | -1,045,000 | |
| Effect Of Exchange Rate Changes | -83,000 | -9,000 | 36,000 | |
| Change In Cash and Cash Equivalents | 1,632,000 | -1,117,000 | 1,083,000 | |
| References | ||||
| Finance.yahoo.com,. (2015). NKE Cash Flow | Nike, Inc. Common Stock Stock - Yahoo! Finance. | ||||
| Retrieved 10 October 2015, from | ||||
| http://finance.yahoo.com/q/cf?s=NKE+Cash+Flow&annual |
STOCK PRICES
| NIKE, Inc. (NKE) | |||||||
| STOCK PRICES | |||||||
| Prices | |||||||
| Date | Open | High | Low | Close | Volume | Adj Close* | Rate of Return |
| Oct 9, 2015 | 124.56 | 125.34 | 124.09 | 124.94 | 3,462,300 | 124.94 | |
| Oct 8, 2015 | 122.92 | 125.24 | 122.67 | 124.91 | 3,624,800 | 124.91 | -2.40% |
| Oct 7, 2015 | 123.61 | 124.45 | 121 | 122.1 | 5,107,700 | 122.1 | -224.96% |
| Oct 6, 2015 | 124.27 | 124.8 | 122.59 | 123.19 | 3,613,900 | 123.19 | 89.27% |
| Oct 5, 2015 | 125.84 | 126.49 | 124.09 | 124.27 | 4,823,200 | 124.27 | 87.67% |
| Oct 2, 2015 | 122.09 | 125.21 | 121.56 | 125.21 | 4,520,500 | 125.21 | 75.64% |
| Oct 1, 2015 | 123.16 | 123.94 | 121.28 | 123.83 | 4,460,000 | 123.83 | -110.21% |
| * Close price adjusted for dividends and splits. | |||||||
| References | |||||||
| Finance.yahoo.com,. (2015). NKE Historical Prices | Nike, Inc. Common Stock Stock - Yahoo! Finance. | |||||||
| Retrieved 10 October 2015, from | |||||||
| http://finance.yahoo.com/q/hp?s=NKE+Historical+Prices |
