Answered step by step
Verified Expert Solution
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
Get Instant Access with AI-Powered 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