Question: 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
Get step-by-step solutions from verified subject matter experts
