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

100.40
 
USD
  
1.25
  
(1.26%)
Optionable: Yes  Market Cap: 140,187 M  90-day average vol: 1,187,333

Previous close: 99.15  Open: 99.11  Bid: 100.17  Ask: 100.75
52 week range    
77.90   
   102.07
Peers   
TD / 
BMO / 
BNS / 
CM / 
BAC / 
NA-CA / 
BNS-CA / 
BMO-CA / 
TD-CA / 
Last updated: Thursday 28th March 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

Financials

RY Cash Flow

Annual
Oct-14Oct-15Oct-16Oct-17Oct-18Oct-19Oct-20Oct-21Oct-22Oct-23
(Increase) Decrease in other current assets-69,134 M-29,665 M
(Increase) Decrease in other current liabilities530 M546 M1,040 M512 M218 M1,401 M814 M62,052 M-10,452 M
(Increase) Decrease in other working capital45,602 M67,044 M24,817 M41,450 M53,188 M33,819 M125,300 M104,783 M110,807 M82,332 M
(Increase) Decrease in payables-3,336 M-986 M
(Increase) Decrease in receivables4,945 M393 M
Acquisitions-2,964 M-65 M-106 M-22 M-2,360 M1,712 M
Amortization of intangibles674 M719 M973 M1,017 M1,083 M1,307 M1,315 M1,316 M1,387 M1,595 M
Cash at beginning of period15,550 M17,421 M12,452 M14,929 M28,407 M30,209 M26,310 M118,888 M113,846 M72,397 M
Cash at end of period17,421 M12,452 M14,929 M28,407 M30,209 M26,310 M118,888 M113,846 M72,397 M61,989 M
Cash flow15,174 M24,149 M26,856 M37,725 M17,474 M14,265 M138,819 M61,044 M21,942 M26,079 M
CashFlowFromContinuingInvestingActivities-8,217 M-25,143 M-21,426 M-15,458 M-8,018 M-11,126 M-39,557 M-57,348 M-57,054 M-28,265 M
ChangeInIncomeTaxPayable-3,336 M-986 M
ChangeInLoans-41,244 M-55,150 M-10,513 M-17,640 M-51,373 M-35,259 M-4,048 M-61,905 M-102,653 M-34,688 M
ChangeInPayablesAndAccruedExpense-3,336 M-986 M
ChangeInTaxPayable-3,336 M-986 M
ChangeInWorkingCapital4,358 M11,894 M14,304 M23,810 M1,815 M-1,440 M121,252 M42,878 M2,681 M6,934 M
ChangesInAccountReceivables4,612 M-2,444 M
CommonStockDividendPaid-6,960 M-5,549 M
CommonStockPayments-5,541 M-6,250 M-5,623 M-7,601 M-7,248 M-6,594 M-5,667 M-4,743 M-11,127 M-4,075 M
Current deferred income taxes-207 M302 M-479 M203 M459 M-519 M-586 M581 M569 M-995 M
Deferred income taxes-207 M302 M-479 M203 M459 M-519 M-586 M581 M569 M-995 M
Depreciation499 M527 M573 M600 M569 M627 M1,333 M1,276 M1,265 M1,275 M
Depreciation unreconciled1,173 M1,246 M1,546 M1,617 M1,652 M1,934 M2,648 M2,592 M2,652 M2,870 M
DepreciationAndAmortization1,173 M1,246 M1,546 M1,617 M1,652 M1,934 M2,648 M2,592 M2,652 M2,870 M
EarningsLossesFromEquityInvestments-224 M-146 M-184 M-331 M-1000000.0-74 M-73 M-127 M-108 M221 M
Effect of exchange rate changes198 M455 M181 M-138 M66 M419 M1,062 M-2,810 M-4,152 M1,611 M
FinancingCashFlow-5,284 M-4,430 M-3,134 M-8,651 M-7,720 M-7,457 M-7,746 M-5,928 M-2,185 M-9,833 M
Free cash flow13,947 M22,812 M25,599 M36,361 M15,494 M12,004 M136,190 M58,858 M19,442 M23,349 M
GainLossOnInvestmentSecurities-228 M-220 M-176 M-246 M-149 M-213 M-218 M-151 M-43 M-193 M
GainLossOnSaleOfBusiness95 M-77 M-268 M2 M-40 M-158 M8 M-26 M-100 M-92 M
GainLossOnSaleOfPPE14 M-32 M19 M-1000000.0
IncomeTaxPaidSupplementalData2,315 M2,046 M1,581 M4,708 M5,818 M2,977 M2,880 M4,198 M7,326 M
InterestPaidSupplementalData7,186 M7,096 M7,097 M8,803 M13,513 M19,984 M13,058 M7,555 M13,677 M
Issuance of capital stock5,607 M6,277 M5,452 M4,743 M5,810 M5,627 M4,848 M4,853 M5,525 M4,239 M
Issuance of debt-6 M-105 M-4 M-30 M-263 M13 M-14 M9,609 M-5,102 M
IssuanceOfCapitalStock5,607 M6,277 M5,452 M4,743 M5,810 M5,627 M4,848 M4,853 M5,525 M4,239 M
IssuanceOfDebt394 M-805 M2,102 M-149 M137 M-825 M-385 M9,788 M-4,427 M
Net cash from financing activities-5,284 M-4,430 M-3,134 M-8,651 M-7,720 M-7,457 M-7,746 M-5,928 M-2,185 M-9,833 M
Net cash from investing activities-8,217 M-25,143 M-21,426 M-15,458 M-8,018 M-11,126 M-39,557 M-57,348 M-57,054 M-28,265 M
Net cash from operating activities15,174 M24,149 M26,856 M37,725 M17,474 M14,265 M138,819 M61,044 M21,942 M26,079 M
Net change in cash & cash equivalents1,871 M-4,969 M2,477 M13,478 M1,802 M-3,899 M92,578 M-5,042 M-41,449 M-12,019 M
Net income from continuing operations9,004 M10,026 M10,458 M11,469 M12,431 M12,871 M11,437 M16,050 M15,807 M14,866 M
NetBusinessPurchaseAndSale173 M255 M-2,330 M-51 M67 M-22 M78 M-2,360 M1,712 M
NetCommonStockIssuance66 M27 M-171 M-2,858 M-1,438 M-967 M-819 M110 M-5,602 M164 M
NetInvestmentPropertiesPurchaseAndSale-7,803 M-9,605 M-14,730 M-9,283 M-2,178 M-7,058 M-36,230 M-14,622 M-23,821 M-45,990 M
NetInvestmentPurchaseAndSale-7,803 M-9,605 M-14,730 M-9,283 M-2,178 M-7,058 M-36,230 M-14,622 M-23,821 M-45,990 M
NetIssuancePaymentsOfDebt394 M-805 M2,102 M-149 M137 M-825 M-385 M9,788 M-4,427 M
NetLongTermDebtIssuance400 M-700 M2,106 M-119 M400 M-838 M-371 M179 M675 M
NetPPEPurchaseAndSale-1,227 M-1,337 M-1,257 M-1,364 M-1,980 M-2,261 M-2,629 M-2,186 M-2,500 M-2,730 M
NetPreferredStockIssuance-525 M1,025 M1,211 M-300 M-105 M-600 M237 M770 M594 M
Operating (gains) losses-318 M-416 M-519 M-524 M-190 M-445 M-283 M-304 M-251 M-64 M
Other financing charges net-1,008 M-113 M-1,279 M-35 M-537 M-2 M-6 M-3 M-5 M-21 M
Other non-cash items484 M2,468 M
Payment of cash dividends4,211 M4,564 M4,997 M5,309 M5,640 M6,025 M6,333 M6,420 M6,960 M5,549 M
PreferredStockIssuance1,000 M1,350 M1,475 M350 M1,745 M2,245 M749 M
PreferredStockPayments-1,525 M-325 M-264 M-300 M-105 M-950 M-1,508 M-1,475 M-155 M
ProceedsPaymentInInterestBearingDepositsInBank640 M-14,456 M-3,109 M-4,811 M-3,809 M-1,874 M-676 M-40,618 M-28,373 M18,743 M
ProvisionForLoanLeaseAndOtherLosses1,164 M1,097 M1,546 M1,150 M1,307 M1,864 M4,351 M-753 M484 M2,468 M
Purchase of property plant & equipment-2,629 M
Purchase of short term investments2,000 M1,000 M3,606 M1,500 M2,750 M2,750 M1,000 M1,500 M
PurchaseOfInvestment-55,833 M-53,246 M-58,482 M-61,559 M-59,286 M-72,435 M-149,516 M-123,547 M-122,964 M-202,456 M
PurchaseOfPPE-1,227 M-1,337 M-1,257 M-1,364 M-1,980 M-2,261 M-2,629 M-2,186 M-2,500 M-2,730 M
Repayment of debt-1,600 M-1,700 M-1,500 M-119 M-1,100 M-3,588 M-3,121 M-821 M-825 M
RepaymentOfDebt-1,600 M-1,700 M-1,500 M-119 M-1,100 M-3,588 M-3,121 M8,788 M-825 M
Repurchase of capital stock-5,541 M-6,250 M-5,623 M-7,601 M-7,248 M-6,594 M-5,667 M-4,743 M-11,127 M-4,075 M
Revenue per share674 M719 M973 M1,017 M1,083 M1,307 M1,315 M1,316 M1,387 M1,595 M
SaleOfBusiness173 M255 M634 M14 M173 M78 M
SaleOfInvestment48,030 M43,641 M43,752 M52,276 M57,108 M65,377 M113,286 M108,925 M99,143 M156,466 M
ShortTermDebtIssuance-5,102 M
ShortTermDebtPayments9,609 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.

We respect your privacy and will never share your email.
MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

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.

Dave

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