Three-statement Excel model · 11 quarters and 2 fiscal years of history · 9 quarters and 5 fiscal years of projections
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.
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 | |||||
|---|---|---|---|---|---|
| Actual | Estimate | ||||
| FY2024 | FY2025 | FY2026E | FY2027E | FY2028E | |
| Loans | 54,040.0 | 56,042.0 | 56,110.2 | 58,003.3 | 60,283.2 |
| Securities | 17,668.0 | 20,055.0 | 22,383.8 | 25,026.2 | 27,249.7 |
| Assets Purchased Under Reverse Repos and Securities Borrowed | 27,121.0 | 22,367.0 | 22,168.4 | 22,859.0 | 24,060.5 |
| Deposits and Other | 6,122.0 | 5,361.0 | 4,112.4 | 4,494.4 | 4,542.0 |
| Total Interest and Dividend Income | C$104,951.0 | C$103,825.0 | C$104,774.8 | C$110,382.9 | C$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 Income | C$27,953.0 | C$33,000.0 | C$34,796.4 | C$37,375.0 | C$39,760.9 |
| Insurance Service Result | 777.0 | 867.0 | 764.3 | 787.3 | 810.9 |
| Insurance Investment Result | 294.0 | 284.0 | 290.8 | 302.4 | 314.5 |
| Trading Revenue | 2,327.0 | 3,125.0 | 3,403.3 | 3,573.5 | 3,716.4 |
| Investment Management and Custodial Fees | 9,325.0 | 10,647.0 | 12,181.6 | 13,551.7 | 14,581.5 |
| Mutual Fund Revenue | 4,437.0 | 5,084.0 | 5,890.8 | 6,511.2 | 6,995.8 |
| Securities Brokerage Commissions | 1,660.0 | 1,905.0 | 2,202.5 | 2,452.0 | 2,664.4 |
| Service Charges | 2,294.0 | 2,425.0 | 2,355.0 | 2,378.6 | 2,402.3 |
| Underwriting and Other Advisory Fees | 2,672.0 | 2,899.0 | 3,494.2 | 3,738.8 | 3,925.7 |
| Foreign Exchange Revenue, Other Than Trading | 1,142.0 | 1,301.0 | 1,431.4 | 1,502.9 | 1,578.1 |
| Card Service Revenue | 1,273.0 | 1,333.0 | 1,331.5 | 1,371.4 | 1,412.6 |
| Credit Fees | 1,592.0 | 1,670.0 | 1,812.6 | 1,921.4 | 2,017.4 |
| Net Gains on Investment Securities | 170.0 | 120.0 | 209.1 | 219.6 | 230.5 |
| Income (Loss) from Joint Ventures and Associates | (16.0) | 73.0 | 102.0 | 107.1 | 112.5 |
| Other | 1,444.0 | 1,872.0 | 2,147.3 | 2,233.2 | 2,322.5 |
| Total Non-Interest Income | C$29,391.0 | C$33,605.0 | C$37,616.5 | C$40,651.0 | C$43,085.3 |
| Total Revenue | C$57,344.0 | C$66,605.0 | C$72,412.9 | C$78,026.0 | C$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 Taxes | C$19,862.0 | C$25,651.0 | C$29,717.7 | C$32,599.1 | C$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 Income | C$16,240.0 | C$20,369.0 | C$23,120.1 | C$25,411.3 | C$27,575.7 |
| Less: Net Income Attributable to Non-Controlling Interests | (C$10.0) | (C$7.0) | (C$5.0) | C$0.0 | C$0.0 |
| Net Income Attributable to Shareholders | C$16,230.0 | C$20,362.0 | C$23,115.1 | C$25,411.3 | C$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 Shareholders | C$15,908.0 | C$19,868.0 | C$22,553.0 | C$24,838.9 | C$27,003.3 |
| Weighted Average Common Shares - Basic | 1,411.903 | 1,409.072 | 1,390.193 | 1,365.967 | 1,341.545 |
| Weighted Average Common Shares - Diluted | 1,413.755 | 1,411.589 | 1,393.634 | 1,369.519 | 1,345.033 |
| Basic Earnings Per Share | C$11.27 | C$14.10 | C$16.22 | C$18.18 | C$20.13 |
| Diluted Earnings Per Share | C$11.25 | C$14.07 | C$16.18 | C$18.14 | C$20.08 |
| Income Statement Ratios & Assumptions | |||||
| YoY Total Revenue Growth | 16.1% | 8.7% | 7.8% | 6.2% | |
| Net Margin | 28.3% | 30.6% | 31.9% | 32.6% | 33.3% |
| Efficiency Ratio | 59.7% | 54.9% | 53.3% | 52.9% | 52.3% |
| Effective Tax Rate | 18.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.
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
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.