← All financial models

Royal Bank of Canada (RY) Financial Model

📊 Download Model

Three-statement Excel model · 11 quarters and 2 fiscal years of history · 9 quarters and 5 fiscal years of projections

current ✓ C13 recon ✓ C14 trace ✓ C15 terminals

About the RY model

This three-statement Excel model covers Royal Bank of Canada (RY): its income statement, balance sheet and cash flow statement. It holds 11 quarters and 2 fiscal years of history and 9 quarters and 5 fiscal years of projections.

Projected revenue is built from KPI drivers: NII = average balance x yield for each asset and funding class; wealth fees = assets under administration or management x a basis-point fee rate; PCL = average loans x PCL rate; staff cost = FTE x compensation per head, across 6 segments.

Beyond the income statement, the workbook has these sections: Balance Sheet, Cash Flow Statement, KPI Drivers, Segment Performance and KPI Drivers - Projection Assumptions.

Model thesis: Balance-sheet growth at a steady margin plus AUA-driven wealth fees: FY26E diluted EPS C$16.18, ROE 17.2%, CET1 13.4%

On October 19, 2026, the model passed checks C13 (every subtotal reconciles to the reported figure at $0), C14 (every projected revenue cell traces to a KPI driver row) and C15 (each driver ends in a rate, a count or a historical anchor, never a typed-in projected dollar level). It was last updated September 28, 2026.

History
11 quarters and 2 fiscal years
Projections
9 quarters and 5 fiscal years
KPI
NII = average balance x yield for each asset and funding class; wealth fees = assets under administration or management x a basis-point fee rate; PCL = average loans x PCL rate; staff cost = FTE x compensation per head
Segments
6
Units
Millions of Canadian dollars, except per share and percentage amounts
Verified
Updated
File
Excel workbook (.xlsx), 192 KB
Access
Free account required: 3 different models a month at no charge, then $9 a month.

Income statement preview

Columns FY2024–FY2025 are actual results and FY2026E–FY2028E are our estimates. Figures were recalculated in Excel on September 28, 2026. Millions of Canadian dollars, except per share and percentage amounts.

Income statement preview for RY. Millions of Canadian dollars, except per share and percentage amounts. Actual fiscal years followed by our estimates.
Income Statement
ActualEstimate
FY2024FY2025FY2026EFY2027EFY2028E
Loans54,040.056,042.056,110.258,003.360,283.2
Securities17,668.020,055.022,383.825,026.227,249.7
Assets Purchased Under Reverse Repos and Securities Borrowed27,121.022,367.022,168.422,859.024,060.5
Deposits and Other6,122.05,361.04,112.44,494.44,542.0
Total Interest and Dividend IncomeC$104,951.0C$103,825.0C$104,774.8C$110,382.9C$116,135.4
Less: Deposits and Other(47,256.0)(44,817.0)(42,802.9)(43,905.9)(45,522.7)
Less: Other Liabilities(28,967.0)(25,371.0)(26,650.1)(28,572.4)(30,322.2)
Less: Subordinated Debentures(775.0)(637.0)(525.4)(529.6)(529.6)
Total Interest Expense(C$76,998.0)(C$70,825.0)(C$69,978.4)(C$73,007.9)(C$76,374.5)
Net Interest IncomeC$27,953.0C$33,000.0C$34,796.4C$37,375.0C$39,760.9
Insurance Service Result777.0867.0764.3787.3810.9
Insurance Investment Result294.0284.0290.8302.4314.5
Trading Revenue2,327.03,125.03,403.33,573.53,716.4
Investment Management and Custodial Fees9,325.010,647.012,181.613,551.714,581.5
Mutual Fund Revenue4,437.05,084.05,890.86,511.26,995.8
Securities Brokerage Commissions1,660.01,905.02,202.52,452.02,664.4
Service Charges2,294.02,425.02,355.02,378.62,402.3
Underwriting and Other Advisory Fees2,672.02,899.03,494.23,738.83,925.7
Foreign Exchange Revenue, Other Than Trading1,142.01,301.01,431.41,502.91,578.1
Card Service Revenue1,273.01,333.01,331.51,371.41,412.6
Credit Fees1,592.01,670.01,812.61,921.42,017.4
Net Gains on Investment Securities170.0120.0209.1219.6230.5
Income (Loss) from Joint Ventures and Associates(16.0)73.0102.0107.1112.5
Other1,444.01,872.02,147.32,233.22,322.5
Total Non-Interest IncomeC$29,391.0C$33,605.0C$37,616.5C$40,651.0C$43,085.3
Total RevenueC$57,344.0C$66,605.0C$72,412.9C$78,026.0C$82,846.2
Less: Provision for Credit Losses(C$3,232.0)(C$4,362.0)(C$4,064.8)(C$4,177.7)(C$4,174.7)
Less: Human Resources(21,083.0)(23,122.0)(24,976.7)(26,386.1)(27,789.1)
Less: Equipment(2,537.0)(2,790.0)(2,977.5)(3,195.1)(3,359.3)
Less: Occupancy(1,805.0)(1,679.0)(1,754.8)(1,868.6)(1,950.9)
Less: Communications(1,369.0)(1,497.0)(1,552.9)(1,712.6)(1,797.7)
Less: Professional Fees(2,525.0)(2,177.0)(2,121.1)(2,360.2)(2,472.9)
Less: Amortization of Other Intangibles(1,549.0)(1,759.0)(1,583.4)(1,716.4)(1,756.2)
Less: Other(3,382.0)(3,568.0)(3,664.2)(4,010.3)(4,191.8)
Total Non-Interest Expense(C$34,250.0)(C$36,592.0)(C$38,630.4)(C$41,249.3)(C$43,318.0)
Income Before Income TaxesC$19,862.0C$25,651.0C$29,717.7C$32,599.1C$35,353.4
Less: Income Taxes(C$3,622.0)(C$5,282.0)(C$6,597.6)(C$7,187.8)(C$7,777.8)
Net IncomeC$16,240.0C$20,369.0C$23,120.1C$25,411.3C$27,575.7
Less: Net Income Attributable to Non-Controlling Interests(C$10.0)(C$7.0)(C$5.0)C$0.0C$0.0
Net Income Attributable to ShareholdersC$16,230.0C$20,362.0C$23,115.1C$25,411.3C$27,575.7
Less: Preferred Dividends and Other Equity Distributions(322.0)(494.0)(562.1)(572.4)(572.4)
Net Income Available to Common ShareholdersC$15,908.0C$19,868.0C$22,553.0C$24,838.9C$27,003.3
Weighted Average Common Shares - Basic1,411.9031,409.0721,390.1931,365.9671,341.545
Weighted Average Common Shares - Diluted1,413.7551,411.5891,393.6341,369.5191,345.033
Basic Earnings Per ShareC$11.27C$14.10C$16.22C$18.18C$20.13
Diluted Earnings Per ShareC$11.25C$14.07C$16.18C$18.14C$20.08
Income Statement Ratios & Assumptions
YoY Total Revenue Growth16.1%8.7%7.8%6.2%
Net Margin28.3%30.6%31.9%32.6%33.3%
Efficiency Ratio59.7%54.9%53.3%52.9%52.3%
Effective Tax Rate18.2%20.6%22.2%22.0%22.0%

The full workbook adds 11 historical and 9 projected quarters, plus Balance Sheet · Cash Flow Statement · KPI Drivers · Segment Performance · KPI Drivers - Projection Assumptions — every subtotal a live formula, every projection traced to a driver.

Download the full RY model (xlsx)3 free models a month with an account, then $9 a month

Royal Bank of Canada research

Aardvark Labs Capital Research has published 4 reports on Royal Bank of Canada (RY). The latest is the Q3 FY26 Earnings Recap, published September 3, 2026, rated Hold.

Costs Behaved, the Regulator Freed the Capital Ceiling, and Wealth Management Took Back 57% of the Growth

All RY research →

Methodology

Every projected revenue cell traces to a KPI/driver row (C14). Terminal driver cells are rates, counts, or historical anchors — never typed-in projected dollar levels (C15). Every subtotal-vs-reported reconciliation row ties to $0 (C13). Each model is written per-ticker against its actual schema — no cloning, no level-input shortcuts.