Question: Manually input the financial data for JP Morgan into the spreadsheet. These numbers should be found in the company's most recent year-end annual reports (utilize
Manually input the financial data for JP Morgan into the spreadsheet. These numbers should be found in the company's most recent year-end annual reports (utilize the most recent available year-end numbers.)
| INCOME STATEMENT | 2015 | 2014 | 2013 | 2012 | 2011 |
| - | - | - | - | - | - |
| Net Sales | |||||
| Less: Cost of Goods Sold | |||||
| - | - | - | - | - | |
| Gross Profit | |||||
| Other Operating Revenue | |||||
| Less: Operating Expenses | |||||
| - | - | - | - | - | |
| Operating Income | |||||
| Less: Interest Expense | |||||
| (no capitalized interest) | |||||
| Other Income (Expenses) | |||||
| Unusual or Infreq. Item; | |||||
| Gain (Loss) | |||||
| Equity in Earnings of Assoc.; | |||||
| Profit (Loss) | |||||
| - | - | - | - | - | |
| Income before Taxes | |||||
| Less:Taxes Related to Operations | |||||
| - | - | - | - | - | |
| N.I. before Min. Ern. | |||||
| Minority Share of Earnings (Loss) | |||||
| - | - | - | - | - | |
| N.I. before Nonrecurring Items | |||||
| Oper. of Discontinued Segment; | |||||
| Income (Loss) | |||||
| Disposal of Discont. Segment; | |||||
| Gain (Loss) | |||||
| Extraordinary Item; | |||||
| Gain (Loss) | |||||
| Cum. Effect of Acct Change; | |||||
| Gain (Loss) | |||||
| - | - | - | - | - | |
| Net Income (Loss) | |||||
| = | = | = | = | = | = |
| BALANCE SHEET | 2015 | 2014 | 2013 | 2012 | 2011 |
| - | - | - | - | - | - |
| ASSETS | |||||
| Current Assets: | |||||
| Cash | |||||
| Marketable Securities | |||||
| Gross Receivables | |||||
| Less: Allowance for Bad Debts | |||||
| Net Trade Receivables | |||||
| Inventories | |||||
| Prepaid Expenses | |||||
| Other Current Assets | |||||
| - | - | - | - | - | |
| Total Current Assets | |||||
| Long-Term Assets: | |||||
| Net Tangible (Fixed) Assets (other than construction in progress) | |||||
| Construction in Progress | |||||
| Intangible Assets | |||||
| Investments | |||||
| Other Nonoperating Assets | |||||
| Other Operating Assets | |||||
| - | - | - | - | - | |
| Total Long-Term Assets | |||||
| Total Assets | |||||
| LIABILITIES AND EQUITY | |||||
| Current Liabilities: | |||||
| Accounts Payable | |||||
| Short Term Loans | |||||
| Current Maturity of L.t. Debt | |||||
| Other Current Liabilities | |||||
| - | - | - | - | - | |
| Total Current Liabilities | |||||
| Long-Term Liabilities: | |||||
| Long-term Debt | |||||
| Reserves | |||||
| Deferred Liabilities | |||||
| Minority Interest | |||||
| Redeemable Preferred | |||||
| Other Long-term Liabilities | |||||
| - | - | - | - | - | |
| Total Long-term Liabilities | |||||
| Total Liabilities | |||||
| Shareholders' Equity: | |||||
| Preferred Equity | |||||
| Common Equity-incl. Ret. Ern. | |||||
| - | - | - | - | - | |
| Total Equity | |||||
| Total Liabilities and Equity | |||||
| = | = | = | = | = | = |
| OTHER DATA | 2015 | 2014 | 2013 | 2012 | 2011 |
| - | - | - | - | - | - |
| Capitalized Interest | |||||
| Interest Portion of Rentals | |||||
| Liquidation Value of Pref. Stock | |||||
| Dividends on Redeemable Pref. | |||||
| Dividends on Nonredeemable Pref. | |||||
| Dividends per Common Share | |||||
| Total Cash Dividends | |||||
| Dil. Earn. per Sh. before Nonrec. Items | |||||
| Market Price per Common Share | |||||
| Tax Rate (0-1) | |||||
| Common Shares Outstanding | |||||
| Diluted Weighted Average Common Shares | |||||
| Cash Flow from Operations | |||||
| Options: | |||||
| Option expense | |||||
| Net income bef. nonrec. items not incl. opt. exp. |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
