Give the annual income statement of 2018 and 2019 in excel sheet of the following company
Royal bank of Canada
Bank of Nova Scotia
Please find the Income Statement for the following companies (2018 & 2019):
1.Royal Bank of Canada:
Particulars | 2018 | 2019 |
Interest Income | 33.02B | 41.33B |
Interest and Fees on Loans | 21.25B | 24.86B |
Interest Income on Fed. Funds | 5.54B | 8.96B |
Interest Income on Fed. Repos | - | - |
Interest on Bank Deposits | 566M | 683M |
Other Interest or Dividend Income | 5.67B | 6.83B |
Total Interest Expense | 15.07B | 21.58B |
Interest Expense on Bank Deposits | 9.84B | 12.99B |
Other Interest Expense | 5.23B | 8.6B |
Interest Expense on Debt | 322M | 365M |
Interest Capitalized | - | - |
Other Borrowed Funds | 4.91B | 8.23B |
Particulars | 2018 | 2019 |
Net Interest Income | 17.95B | 19.75B |
Loan Loss Provision | 1.31B | 1.86B |
Net Interest Income after Provision | 16.65B | 17.89B |
Non-Interest Income | 23.51B | 25.19B |
Securities Gain | 147M | 125M |
Trading Account Income | 1.15B | 995M |
Trust Income, Commissions & Fees | 16.6B | 16.74B |
Commission & Fee Income | 7.67B | 7.37B |
Other Operating Income | 5.61B | 7.33B |
Non-Interest Expense | 25.51B | 28.22B |
Labor & Related Expense | 13.78B | 14.6B |
Equipment Expense | 3.15B | 3.41B |
Other Operating Expense | 8.01B | 9.59B |
Operating Income | 14.64B | 14.85B |
Non-Operating Income (Expense) | 1.1B | 986M |
Non-Operating Interest Income | - | - |
Miscellaneous Non Operating Expense | 1.1B | 986M |
Equity in Affiliates (Pretax) | - | - |
Unusual Expense | - | - |
Pretax Income | 15.74B | 15.84B |
Income Taxes | 3.33B | 3.04B |
Income Tax - Current - Domestic | 3.13B | 3.2B |
Income Tax - Current - Foreign | - | - |
Income Tax - Deferred - Domestic | 201M | (156M) |
Income Tax - Deferred - Foreign | - | - |
Income Tax Credits | - | - |
Equity in Affiliates | 21M | 76M |
Other After Tax Income (Expense) | - | - |
Consolidated Net Income | 12.43B | 12.87B |
Minority Interest Expense | 31M | 11M |
Net Income | 12.4B | 12.86B |
Extraordinaries & Discontinued Operations | - | - |
Extra Items & Gain/Loss Sale Of Assets | - | - |
Cumulative Effect - Accounting Chg | - | - |
Discontinued Operations | - | - |
Net Income After Extraordinaries | - | - |
Preferred Dividends | 285M | 269M |
Net Income Available to Common | 12.12B | 12.59B |
EPS (Basic) | 8.39 | 8.78 |
Basic Shares Outstanding | 1.44B | 1.43B |
EPS (Diluted) | 8.36 | 8.75 |
Diluted Shares Outstanding | 1.45B | 1.44B |
2.Bank of Nova Scotia:
Particulars | 2018 | 2019 |
Total Revenue | $35,486,000 | $30,954,000 |
Cost of Revenue | $10,554,000 | $8,029,000 |
Gross Profit | $0 | $0 |
Operating Expenses | ||
Research and Development | $0 | $0 |
Sales, General and Admin. | $11,933,000 | $10,820,000 |
Non-Recurring Items | $0 | $0 |
Other Operating Items | $3,104,000 | $2,634,000 |
Operating Income | $0 | $0 |
Add'l income/expense items | $0 | $0 |
Earnings Before Interest and Tax | $9,895,000 | $9,471,000 |
Interest Expense | $1,321,000 | $1,014,000 |
Earnings Before Tax | $8,575,000 | $8,457,000 |
Income Tax | $1,881,000 | $1,814,000 |
Minority Interest | $0 | $0 |
Equity Earnings/Loss Unconsolidated Subsidiary | -$310,000 | -$134,000 |
Net Income-Cont. Operations | $6,383,000 | $6,509,000 |
Net Income | $6,383,000 | $6,509,000 |
Net Income Applicable to Common Shareholders | $6,245,000 | $6,367,000 |
Give the annual income statement of 2018 and 2019 in excel sheet of the following company...
The balance sheet at December 31, 2018, 2019, and 2020, and income statement for the years ended December 31, 2018, 2019, and 2020, for Apache Inc. include the following data: (Click icon to view the balance sheet.) (Click icon to view the income statement.) Requirements Use the years of data to answer the following: 1. Calculate the current ratio for 2018, 2019, and 2020. 2. Calculate the debt ratio for 2018, 2019, and 2020. 3. Evaluate each ratio and determine...
Income statements for Rundle Company for 2018 and 2019 follow: RUNDLE COMPANY Income Statements 2019 2018 Sales $ 200,900 $ 180,900 Cost of goods sold 143,900 121,900 Selling expenses 20,100 18,100 Administrative expenses 12,800 14,800 Interest expense 3,900 5,900 Total expenses $ 180,700 $ 160,700 Income before taxes 20,200 20,200 Income taxes expense 6,600 3,500 Net income $ 13,600 $ 16,700 Required Perform a horizontal analysis, showing the percentage change in each income statement component between 2018 and 2019. Perform...
1. Complete a common size statement for the Income Statement and Balance Sheet. 2. Please give the dollar amount of change and percentage change in each of the following accounts from 2018 and 2019. Thank you for help!!! C17 Assignment for 35 points. There are two problems PUT YOUR ANSWERS ON A SEPARATE SHEET OF PAPER 1. Common Size Statements and 2. Horizonal Analysis 1. Complete a common size statement for the Income Statement and Balance Sheet Income Statement For...
Goal: Create an Excel worksheet to prepare an income statement, a balance sheet and a statement of changes in equity for a start-up business. Scenario: You have started a valet parking business called First Class Valet. You have tracked your cash, supplies, revenues, expenses, and other items in a spreadsheet. The totals for each account at the end of your first month are as follows (ignore GST): 1. Sales Revenues, $400 2. Supplies on hand (asset account), $175 3. Cash,...
The following income statements were drawn from the annual reports of Toner Sales Company: 2018* $ 426,600 (281,556) 145, 044 2019* $ 521,600 (292,096) 229,504 Net sales Cost of goods sold Gross margin Less: Operating expense Selling and administrative expenses Net Income (68,256) 76,788 (83,456) $ 146,048 $ *All dollar amounts are reported in thousands. The president's message in the company's annual report stated that the company had implemented a strategy to increase market share by spending more on advertising....
Income statements for Jordan Company for 2018 and 2019 follow: 2018 JORDAN COMPANY Income Statements 2019 Sales $200,100 Cost of goods sold 142,700 Selling expenses 21,900 Administrative expenses 12,300 Interest expense 3,800 Total expenses $180,700 Income before taxes 19,400 Income taxes expense 6,400 Net income $ 13,000 $180, 100 120,700 19,900 14,300 5,800 $160, 700 19,400 3,000 $ 16,400 Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between 2018 and 2019 b. Perform...
Income statements for Finch Company for 2018 and 2019 follow: FINCH COMPANY Income Statements 2019 2018 Sales $ 202,000 $ 182,000 Cost of goods sold 143,400 121,400 Selling expenses 20,200 18,200 Administrative expenses 12,200 14,200 Interest expense 3,100 5,100 Total expenses $ 178,900 $ 158,900 Income before taxes 23,100 23,100 Income taxes expense 5,400 3,400 Net income $ 17,700 $ 19,700 Required Perform a horizontal analysis, showing the percentage change in each income statement component between 2018 and 2019. Perform...
The following is the comparative balance sheet as of December 31, 2019 and 2018 and the income statement for the year ended December 31, 2019 for Lynbrook Inc.: Lynbrook Inc. Comparative Balance Sheet December 31, 2019 and 2018 Assets: 2019 2018 Cash $ 39 $ 81 Accounts receivable 640 588 Inventory 650 610 Total current assets 1,329 1,279 Property, Plant & Equipment 1,505 1484 Less: Accumulated depreciation (770) (651) Net Property, Plant & Equipment 735 833 Total Assets $...
Miami Company Miami Company included the following information in its annual reports 2019 2018 2017 $178,400 $162500 $161,500 Cost of goods sold 115,000 102,500 100.000 Operating expenses 50.000 50.000 45,000 Net income 13400 10,000 10,500 Refer to the information for Miami Company. In a percentage change income statement over the period of 2017 to 2019. what is the change in sales? 14,733 0.1056 90
Use the following information to create an income statement and balance sheet for 2018 and 2019; assume the tax rate is 34%. Then, using those statements, calculate for 2019: Cash flow from assets, Cash flow to creditors, Cash flow to stockholders 2016 2017 Sales 50,920 56,916 Depreciation expense 7,308 7,640 Cost of goods sold 17,508 20,712 Other expense 4,164 3,624 Interest expenses 3,416 4,076 Cash 26,696 28,452 Accounts receivables 33,348 41,484 short term notes payables 5,152 5,048 long term debt 89,408...