Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Manually input the financial data for your company into your spreadsheetThese numbers should be found in the company's most recent year-end annual reports (utilize the

Manually input the financial data for your company into your spreadsheetThese numbers should be found in the company's most recent year-end annual reports (utilize the most recent available year-end numbers. Use Excel formulas as much as possible in your spreadsheet design. Complete a separate spreadsheet for each company. Write that you completed the input for the spreadsheet for both companies and that the spreadsheet works.

Company 1- TD Bank

Company 2- JP Morgan Chase

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 0 0
Short Term Loans 0 0 0
Current Maturity of L.t. Debt 0 0
Other Current Liabilities 0 0
- - - - -
Total Current Liabilities 0 0 0 0 0
Long-Term Liabilities:
Long-term Debt 0 0 0 0 0
Reserves 0 0 0 0 0
Deferred Liabilities 0 0 0 0 0
Minority Interest 0 0 0 0 0
Redeemable Preferred 0 0 0 0 0
Other Long-term Liabilities 0 0 0 0 0
- - - - -
Total Long-term Liabilities 0 0 0 0 0
Total Liabilities 0 0 0 0 0
Shareholders' Equity:
Preferred Equity 0 0 0 0 0
Common Equity-incl. Ret. Ern. 0 0 0 0 0
- - - - -
Total Equity 0 0 0 0 0
Total Liabilities and Equity 0 0 0 0 0
= = = = = =
OTHER DATA 2015 2014 2013 2012 2011
- - - - - -
Capitalized Interest 0.0 0.0 0.0 0.0 0.0
Interest Portion of Rentals 0.0 0.0 0.0 0.0 0.0
Liquidation Value of Pref. Stock 0.0 0.0 0.0 0.0 0.0
Dividends on Redeemable Pref. 0.0 0.0 0.0 0.0 0.0
Dividends on Nonredeemable Pref. 0.0 0.0 0.0 0.0 0.0
Dividends per Common Share 0.000 0.000 0.000 0.000 0.000
Total Cash Dividends 0.0 0.0 0.0 0.0 0.0
Dil. Earn. per Sh. before Nonrec. Items 0.000 0.000 0.000 0.000 0.000
Market Price per Common Share 0.000 0.000 0.000 0.000 0.000
Tax Rate (0-1) 0.000 0.000 0.000 0.000 0.000
Common Shares Outstanding 0.0 0.0 0.0 0.0 0.0
Diluted Weighted Average Common Shares 0.0 0.0 0.0 0.0 0.0
Cash Flow from Operations 0.0 0.0 0.0 0.0 0.0
Options:
Option expense 0.0 0.0 0.0 0.0 0.0
Net income bef. nonrec. items not incl. opt. exp. 0.0 0.0 0.0 0.0 0.0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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