Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Royal Bank Of Canada logo

Royal Bank Of Canada

Sector: Financial Services   

Industry: Banks - Global

Optionable: Yes  Market Cap: 147,468 M  90-day average vol: 1,044,204

Previous close: 105.84  Open: 105.48  Bid: 105.3  Ask: 110.09
52 week range    
TD / 
BMO / 
BNS / 
CM / 
BAC / 
NA-CA / 
TD-CA / 
Last updated: Wednesday 22nd May 2024

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord



StockDividendMarket Cap (B)PEPrice ($)


0.0173405 B1348.51


0.036474 B12.4117.03



0.042788 B11.873.75



0.039157 B11.4130.14




0.0335149 B13.283.77



RY Income Statement

Amortization of intangibles666 M712 M970 M1,015 M1,077 M1,197 M1,273 M1,287 M1,369 M1,487 M
Basic EPS from continuing operations6.036.756.87.598.398.787.8411.0811.2510.68
Basic EPS total6.036.756.87.598.398.787.8411.0811.2510.68
Basic weighted shares outstanding1,443 M1,443 M1,486 M1,467 M1,444 M1,435 M1,424 M1,424 M1,404 M1,391 M
CreditCard689 M1,982 M889 M933 M1,054 M1,072 M969 M1,078 M2,715 M2,729 M
CreditLossesProvision-1,164 M1,097 M-1,546 M-1,150 M-1,307 M-1,864 M-4,351 M753 M484 M2,468 M
Depreciation unreconciled666 M712 M970 M1,015 M1,077 M1,197 M1,273 M1,287 M1,369 M1,487 M
DepreciationAndAmortization666 M712 M970 M1,015 M1,077 M1,197 M1,273 M1,287 M1,369 M1,487 M
Diluted EPS total6.06.736.787.568.368.757.8211.0611.2510.67
Diluted normalized net income/share6.06.736.787.568.368.757.8211.0611.2510.67
Diluted weighted shares outstanding1,452 M1,450 M1,494 M1,474 M1,450 M1,441 M1,429 M1,427 M1,404 M1,393 M
Dividends paid per share2.843.083.243.483.774.074.294.324.965.34
EarningLossOfEquityInvestments149 M110 M
Equipment1,147 M1,277 M1,438 M1,434 M1,593 M1,777 M1,907 M1,986 M2,099 M2,381 M
FeesAndCommissions10,618 M8,788 M12,830 M13,694 M14,548 M14,929 M15,384 M17,387 M13,782 M14,635 M
GainOnSaleOfBusiness309 M-8 M26 M-110 M-219 M
GeneralAndAdministrativeExpense14,604 M2,963 M15,801 M16,383 M16,452 M14,600 M15,252 M16,539 M1,783 M4,022 M
ImpairmentOfCapitalAssets8 M142 M-130 M-166 M
Income before tax11,710 M7,210 M13,299 M14,672 M15,760 M15,914 M14,389 M20,631 M19,889 M18,466 M
Income taxes2,706 M2,597 M2,841 M3,203 M3,329 M3,043 M2,952 M4,581 M4,302 M3,600 M
IncomefromAssociatesandOtherParticipatingInterests162 M149 M176 M335 M21 M76 M77 M130 M
InsuranceAndClaims3,573 M2,963 M3,424 M3,053 M2,676 M4,085 M3,683 M1,783 M4,022 M
InsuranceAndPremiums3,510 M5,675 M
Interest expense7,903 M7,958 M7,921 M9,764 M15,069 M21,584 M14,048 M8,143 M18,054 M61,862 M
InterestExpenseForDeposit5,873 M5,723 M5,467 M6,564 M9,842 M12,988 M8,783 M5,448 M10,751 M36,679 M
InterestExpenseForLongTermDebt240 M288 M666 M
InterestExpenseForLongTermDebtAndCapitalSecurities246 M240 M227 M270 M322 M365 M280 M179 M288 M666 M
InterestIncome22,019 M22,652 M24,452 M26,904 M33,021 M41,333 M34,883 M28,145 M40,771 M86,991 M
InterestIncomeAfterProvisionForLoanLoss12,952 M13,597 M14,985 M15,990 M16,645 M17,885 M16,484 M20,755 M22,233 M22,661 M
InterestIncomeFromDeposits76 M77 M167 M307 M566 M683 M307 M305 M1,697 M6,852 M
InterestIncomeFromFederalFundsSoldAndSecuritiesPurchaseUnderAgreementsToResell971 M1,251 M1,816 M3,021 M5,536 M8,960 M4,668 M1,309 M5,447 M22,164 M
InterestIncomeFromInvestmentSecurities4,519 M7,062 M14,512 M
InterestIncomeFromLoans16,979 M16,882 M17,876 M18,677 M21,249 M24,863 M23,420 M21,654 M26,565 M43,463 M
InterestIncomeFromLoansAndLease16,979 M16,882 M17,876 M18,677 M21,249 M24,863 M23,420 M21,654 M26,565 M43,463 M
InterestIncomeFromSecurities3,993 M4,519 M4,593 M4,899 M5,670 M6,827 M6,488 M4,877 M7,062 M14,512 M
InvestmentBankingProfit1,809 M1,885 M1,876 M2,093 M2,053 M1,815 M2,319 M2,692 M2,058 M2,005 M
MinorityInterests94 M101 M53 M41 M31 M11 M5 M12 M-13 M-7 M
Net income from total operations8,910 M4,613 M10,405 M11,428 M12,400 M12,860 M11,432 M16,038 M15,574 M14,859 M
NetIncomeCommonStockholders8,697 M4,613 M10,111 M11,128 M12,115 M12,591 M11,164 M15,781 M15,574 M14,859 M
NetIncomeContinuousOperations9,004 M4,613 M10,458 M11,469 M12,431 M12,871 M11,437 M16,050 M15,587 M14,866 M
NetInterestIncome14,116 M14,694 M16,531 M17,140 M17,952 M19,749 M20,835 M20,002 M22,717 M25,129 M
NetOccupancyExpense1,330 M1,410 M1,568 M1,588 M1,558 M1,635 M1,660 M1,584 M1,554 M1,634 M
NonInterestExpense17,661 M21,601 M20,526 M21,794 M22,833 M23,997 M24,880 M26,090 M28,392 M35,195 M
NonInterestIncome16,257 M15,214 M18,664 M20,141 M21,927 M21,783 M22,586 M25,644 M26,048 M31,000 M
Normalized income8,615 M5,299 M9,775 M10,784 M11,584 M11,530 M10,454 M14,972 M14,728 M13,792 M
OccupancyAndEquipment2,477 M2,687 M3,006 M3,022 M3,151 M3,412 M3,567 M3,570 M3,653 M4,015 M
OtherCustomerServices1,080 M1,184 M1,239 M1,433 M1,394 M1,269 M1,321 M
OtherGandA14,604 M2,963 M15,801 M16,383 M16,452 M14,600 M15,252 M16,539 M1,783 M4,022 M
OtherInterestExpense1,784 M1,995 M2,227 M2,930 M4,905 M8,231 M4,985 M2,516 M7,015 M24,517 M
OtherNonInterestExpense2,724 M2,724 M3,095 M3,213 M3,450 M3,483 M3,458 M3,343 M3,548 M4,477 M
OtherNonInterestIncome685 M2,881 M773 M889 M1,328 M1,308 M864 M1,462 M4,801 M5,027 M
OtherunderPreferredStockDividend213 M191 M294 M300 M285 M269 M268 M257 M247 M
PreferredStockDividends213 M191 M294 M300 M285 M269 M268 M257 M247 M
ProfessionalExpenseAndContractServicesExpense763 M932 M1,078 M1,214 M1,379 M1,305 M1,330 M1,351 M1,511 M2,223 M
Revenue per share666 M712 M970 M1,015 M1,077 M1,197 M1,273 M1,287 M1,369 M1,487 M
SalariesAndWages11,031 M11,583 M12,377 M13,330 M13,776 M14,600 M15,252 M16,539 M16,528 M18,971 M
SecuritiesActivities1,379 M1,436 M1,429 M1,416 M1,372 M1,305 M1,439 M1,538 M
Selling Gen & administrative expense14,604 M14,546 M15,801 M16,383 M16,452 M14,600 M15,252 M16,539 M18,311 M22,993 M
ServiceChargeOnDepositorAccounts2,574 M1,592 M2,995 M3,203 M3,194 M3,176 M3,163 M3,388 M1,976 M2,099 M
Special income/charges8 M-2,724 M-167 M-122 M-192 M-3,548 M-4,477 M
Total common shares outstanding1,442 M1,443 M1,485 M1,458 M1,441 M1,430 M1,424 M1,425 M1,425 M
Total net income8,910 M4,613 M10,405 M11,428 M12,400 M12,860 M11,432 M16,038 M15,574 M14,859 M
Total ordinary shares1,414 M1,414 M1,414 M1,414 M1,414 M1,414 M1,414 M1,414 M1,414 M1,414 M
Total revenues48,765 M56,129 M
TotalPremiumsEarned1,384 M1,473 M1,444 M1,513 M1,603 M1,625 M1,678 M1,709 M3,510 M5,675 M
TotalRevenue48,765 M56,129 M
TradingGainLoss-742 M-552 M-701 M-806 M-1,150 M-995 M-1,239 M-1,183 M-926 M-2,392 M
TrustFeesbyCommissions5,976 M5,214 M7,517 M8,142 M8,928 M9,376 M9,813 M11,383 M9,091 M9,807 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu


I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.


Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University