Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started