Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Surviving An IRS Tax Audit

Authors: Frederick W. Daily

3rd Edition

1413318649, 978-1413318647

More Books

Students also viewed these Accounting questions

Question

a. Describe the encounter. What made it intercultural?

Answered: 1 week ago