Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

RY Stock Annual Balance Sheet. Download in Excel

Royal Bank Of Canada logo

Royal Bank Of Canada

Sector: Financial Services   

Industry: Banks - Global

120.72
 
USD
  
1.00
  
(0.84%)
Previous close: 119.72  Open: 119.57  Bid: 107.9  Ask: 122.91
52 week range    
93.97   
   128.05
Mkt Cap: 175,036 M  Avg Vol (90 Days): 932,350
Peers   
TD / 
BMO / 
BNS / 
CM / 
BAC / 
NA-CA / 
BNS-CA / 
BMO-CA / 
TD-CA / 
Last updated: Sunday 22nd December 2024

Stock Rankings

53
Technical
52
Quality
How are these ranks calculated?
Search for a stock

Financials

RY Balance Sheet

Annual
Oct-15Oct-16Oct-17Oct-18Oct-19Oct-20Oct-21Oct-22Oct-23Oct-24
Accounts payable5,659 M5,740 M6,006 M8,681 M8,335 M9,463 M10,506 M12,266 M9,664 M9,745 M
Accounts receivable4,600 M5,357 M5,685 M6,688 M7,435 M6,962 M7,251 M7,549 M7,207 M7,732 M
Accrued expenses14,744 M16,227 M16,934 M19,307 M19,520 M20,759 M24,871 M67,922 M69,953 M58,855 M
Accumulated depreciation & depletion-4,121 M-4,450 M-4,778 M-5,206 M-5,672 M-6,718 M-7,677 M-5,205 M-6,085 M-7,077 M
AdvanceFromFederalHomeLoanBanks13 M
AllowanceForLoansAndLeaseLosses-2,029 M-2,235 M-2,159 M-2,912 M-3,100 M-5,639 M-4,089 M3,753 M5,004 M6,037 M
AvailableForSaleSecurities830 M981 M1,216 M94,608 M102,470 M115,550 M127,167 M77,127 M
BankAcceptanceExecutedAndOutstanding17,872 M21,745 M35 M
Building & improvements1,294 M1,379 M1,363 M1,399 M1,395 M6,587 M6,813 M7,009 M7,144 M7,757 M
Cash and equivalents35,248 M43,086 M62,151 M67,041 M65,071 M160,272 M195,103 M180,408 M133,075 M122,743 M
CashAndDueFromBanks22,690 M27,851 M32,662 M36,471 M38,345 M39,013 M79,638 M72,397 M61,989 M56,723 M
CashEquivalents106 M306 M1,082 M361 M416 M2,371 M1,619 M1,772 M
CommercialLoan130,072 M158,247 M164,099 M185,144 M201,304 M214,397 M230,069 M273,967 M287,826 M360,439 M
CommercialPaper70,692 M56,575 M83,862 M
Common par19,709 M24,572 M24,116 M23,926 M23,294 M23,576 M24,451 M24,302 M26,481 M29,983 M
Common stock equity62,146 M71,017 M73,829 M79,861 M83,523 M86,664 M98,667 M108,064 M117,661 M127,089 M
CommonStock14,611 M17,859 M17,703 M17,617 M17,587 M17,628 M17,728 M16,984 M19,167 M20,952 M
Construction in progress168 M132 M153 M264 M432 M203 M170 M120 M108 M129 M
ConsumerLoan110,205 M110,594 M110,329 M112,115 M112,561 M109,637 M111,263 M549,751 M569,951 M626,978 M
Cost in excess9,289 M11,156 M10,977 M11,137 M11,236 M11,302 M10,854 M12,277 M12,594 M19,286 M
CurrentAccruedExpenses6,358 M6,448 M7,192 M7,073 M7,416 M7,476 M9,340 M5,019 M10,936 M13,226 M
CustomerAcceptances13,453 M12,843 M16,459 M15,641 M18,062 M18,507 M19,798 M17,827 M21,695 M35 M
DeferredAssets2,072 M2,827 M1,732 M1,475 M1,989 M2,579 M2,011 M1,472 M2,446 M4,328 M
DeferredTaxAssets2,072 M2,827 M1,732 M1,475 M1,989 M2,579 M2,011 M1,472 M2,446 M4,328 M
DefinedPensionBenefit245 M29 M59 M626 M147 M143 M2,640 M3,331 M2,826 M3,630 M
Deposits697,227 M757,589 M789,635 M836,197 M640,040 M759,835 M810,453 M1,208,814 M1,231,687 M1,409,531 M
DerivativeAssets105,626 M118,944 M95,023 M94,039 M101,560 M113,488 M95,541 M154,439 M142,450 M150,612 M
DerivativeProductLiabilities107,860 M116,550 M92,127 M90,238 M98,543 M109,927 M91,439 M153,491 M142,629 M163,763 M
DividendsPayable1,194 M1,309 M1,394 M1,482 M1,567 M1,611 M1,622 M1,856 M1,975 M2,123 M
EmployeeBenefits1,969 M3,345 M2,336 M1,902 M2,699 M2,424 M2,038 M1,668 M1,611 M1,924 M
FederalFundsPurchasedAndSecuritiesSoldUnderAgreementToRepurchase130,946 M153,810 M173,092 M239,061 M226,586 M274,231 M262,201 M309,458 M368,889 M340,607 M
FederalFundsSoldAndSecuritiesPurchaseUnderAgreementsToResell306,961 M313,015 M307,903 M317,845 M340,191 M350,803 M
FinancialInstrumentsSoldUnderAgreementsToRepurchase83,288 M103,441 M143,084 M206,814 M226,586 M274,231 M309,458 M368,889 M340,607 M
Float term debt7,362 M9,762 M9,265 M9,131 M151,869 M181,908 M201,103 M10,025 M11,386 M35,777 M
GoodwillAndOtherIntangibleAssets12,103 M15,804 M15,484 M15,824 M15,910 M16,054 M15,325 M18,360 M18,501 M27,084 M
Gross fixed assets (Plant Property & Equipment)6,849 M7,286 M7,448 M8,038 M8,863 M14,652 M15,101 M12,419 M12,834 M13,929 M
GrossLoan474,252 M523,839 M544,776 M579,730 M621,956 M666,631 M721,664 M824,327 M858,392 M987,934 M
IncomeTaxPayable1,533 M2,730 M2,342 M2,071 M2,202 M2,209 M3,403 M
Intangibles2,814 M4,648 M4,507 M4,687 M4,674 M4,752 M4,471 M6,083 M5,907 M7,798 M
InterestBearingDepositsAssets108,011 M71,086 M66,020 M
InterestBearingDepositsLiabilities697,227 M757,589 M789,635 M836,197 M640,040 M759,835 M810,453 M989,652 M
InterestPayable5,019 M10,936 M13,226 M
Invested capital69,508 M80,779 M83,094 M88,992 M235,392 M268,572 M299,770 M118,089 M129,047 M162,866 M
InvestmentsInAffiliatesSubsidiariesAssociatesAndJointVentures711 M501 M835 M
Land & improvements123 M171 M157 M153 M153 M152 M145 M141 M140 M244 M
Leases2,464 M2,566 M2,586 M2,726 M3,001 M3,383 M3,494 M2,845 M3,007 M3,169 M
LongTermCapitalLeaseObligation49 M5,357 M5,077 M5,110 M4,764 M4,673 M
LongTermDebtAndCapitalLeaseObligation7,362 M9,762 M9,265 M9,131 M151,918 M187,265 M206,180 M15,135 M16,150 M40,450 M
LongTermProvisions512 M485 M460 M507 M581 M618 M601 M627 M644 M793 M
Machinery furniture & equipment2,800 M3,038 M3,189 M3,496 M3,882 M3,906 M3,986 M2,304 M2,435 M2,630 M
Minority interest1,798 M595 M599 M94 M102 M103 M95 M111 M99 M103 M
MoneyMarketInvestments174,723 M186,302 M220,977 M294,602 M306,961 M313,015 M307,903 M317,845 M340,191 M350,803 M
MortgageLoan233,975 M254,998 M270,348 M282,471 M308,091 M342,597 M380,332 M418,796 M
Net fixed assets (net PP&E)2,728 M2,836 M2,670 M2,832 M3,191 M7,934 M7,424 M7,214 M6,749 M6,852 M
Net loans472,223 M521,604 M542,617 M576,818 M618,856 M660,992 M717,575 M820,574 M853,388 M981,897 M
NetUnrealizedGainLossForeignCurrency5,688 M
NetUnrealizedGainLossInvestments-2,357 M
Non-current deferred income taxes201 M989 M97 M84 M82 M52 M74 M439 M426 M542 M
NonCurrentDeferredLiabilities2,229 M2,960 M2,176 M2,343 M2,645 M2,997 M3,592 M4,099 M4,256 M4,691 M
NonCurrentDeferredRevenue2,028 M1,971 M2,079 M2,259 M2,563 M2,945 M3,518 M3,660 M3,830 M4,149 M
NonInterestBearingDeposits219,162 M
Notes payable28,711 M23,434 M15,006 M
Other equity adjustments4,626 M4,926 M4,354 M4,823 M4,248 M3,414 M5,725 M6,852 M8,498 M
Other receivable4,951 M4,722 M4,901 M10,222 M12,296 M11,668 M15,282 M7,054 M5,979 M9,834 M
OtherAssets25,969 M24,887 M20,159 M20,434 M22,113 M26,652 M23,651 M9,174 M13,491 M18,374 M
OtherCurrentBorrowings4,508 M8,887 M9,609 M4,507 M
OtherDeposits1,208,814 M1,231,687 M1,409,531 M
OtherEquityAdjustments4,626 M4,926 M4,354 M4,823 M4,249 M3,414 M5,725 M6,852 M8,498 M
OtherEquityInterest4,626 M4,926 M4,354 M4,823 M4,248 M3,414 M2,533 M
OtherLiabilities47,415 M47,918 M52,400 M56,093 M63,798 M70,431 M69,477 M20,349 M25,161 M23,741 M
OtherLoanAssets609 M615 M517 M
OtherPayable46,645 M44,419 M31,363 M
Payables8,386 M9,779 M9,742 M12,234 M12,104 M13,283 M15,531 M62,903 M59,017 M45,629 M
Preferred securities of subsidiary trust5,098 M6,713 M6,413 M6,309 M5,707 M5,948 M6,723 M7,318 M7,314 M9,031 M
PreferredStock5,098 M6,713 M6,413 M6,309 M5,707 M5,948 M6,723 M7,318 M7,314 M9,031 M
Prepaid expenses14,684 M8,849 M11,108 M
ReinsuranceRecoverable1,084 M1,127 M
RestrictedCashAndCashEquivalents4,399 M4,308 M5,867 M4,940 M5,688 M9,816 M11,441 M25,634 M20,104 M20,475 M
RestrictedCashAndInvestments4,399 M4,308 M5,867 M4,940 M5,688 M9,816 M11,441 M25,634 M20,104 M20,475 M
Retained earnings37,811 M41,519 M45,359 M51,112 M55,981 M59,806 M71,795 M78,037 M84,328 M88,608 M
SecuritiesAndInvestments215,508 M236,093 M218,379 M222,866 M249,004 M275,814 M284,724 M148,205 M190,151 M183,300 M
SecurityAgreeToBeResell317,845 M340,191 M350,803 M
Short term debt103,911 M88,896 M98,868 M9,609 M4,507 M
Total assets1,074,208 M1,180,258 M1,212,853 M1,334,734 M1,428,935 M1,624,548 M1,706,323 M1,917,219 M2,004,992 M2,171,582 M
Total equity62,146 M71,017 M73,829 M79,861 M83,523 M86,664 M98,667 M108,064 M117,661 M127,089 M
Total liabilities1,010,264 M1,108,646 M1,138,425 M1,254,779 M1,345,310 M1,537,781 M1,607,561 M1,809,044 M1,887,232 M2,044,390 M
TotalEquityGrossMinority63,944 M71,612 M74,428 M79,955 M83,625 M86,767 M98,762 M108,175 M117,760 M127,192 M
TotalEquityGrossMinorityInterest63,944 M71,612 M74,428 M79,955 M83,625 M86,767 M98,762 M108,175 M117,760 M127,192 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest1,074,208 M1,180,258 M1,212,853 M1,334,734 M1,428,935 M1,624,548 M1,706,323 M1,917,219 M2,004,992 M2,171,582 M
TotalTaxPayable1,533 M2,730 M2,342 M2,071 M2,202 M2,209 M3,403 M2,136 M2,959 M2,398 M
TradingLiabilities35,069 M29,285 M37,841 M
TradingSecurities158,703 M151,292 M127,657 M128,258 M146,534 M115,880 M120,016 M148,205 M190,151 M183,300 M
Treasury stock-2 M-58 M-132 M-112 M-334 M
UnrealizedGainLoss3,331 M
debtc103,911 M88,896 M98,868 M9,609 M4,507 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

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