Three-statement Excel model · 21 quarters and 5 fiscal years of history · 7 quarters and 5 fiscal years of projections
About the MUFG model
This three-statement Excel model covers Mitsubishi UFJ Financial Group, Inc. (MUFG): its income statement, balance sheet and cash flow statement. It holds 21 quarters and 5 fiscal years of history and 7 quarters and 5 fiscal years of projections.
Projected revenue is built from KPI drivers: NII = average interest-earning assets x NII yield; expenses = expense ratio x total net revenue; credit costs = credit-cost ratio x average loans; equity-securities gains = disposal rate x domestic equity book, across 6 segments.
Beyond the income statement, the workbook has these sections: Balance Sheet, Cash Flow Statement, Disclosed Bank Metrics (as filed), Segment Performance and KPI Drivers.
Model thesis: NII yield on a ¥237tn deposit book in Japan's first rate cycle: FY27E net income ¥2,994bn, 11% above MUFG's ¥2,700bn target; DPS ¥96
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 FY24–FY26 are actual results and FY27E–FY29E are our estimates. Figures were recalculated in Excel on September 28, 2026. Billions of yen, except per share data.
| Income Statement | ||||||
|---|---|---|---|---|---|---|
| Actual | Estimate | |||||
| FY24 | FY25 | FY26 | FY27E | FY28E | FY29E | |
| Net Interest Income | ¥2,457.9 | ¥2,876.6 | ¥3,006.3 | ¥3,796.0 | ¥4,319.4 | ¥4,510.6 |
| Trust Fees | 139.4 | 144.4 | 163.1 | 179.6 | 188.5 | 196.1 |
| Credit Costs for Trust Accounts | 0.0 | 0.0 | 0.0 | |||
| Net Fees and Commissions | 1,681.3 | 1,945.8 | 2,226.8 | 2,445.7 | 2,592.4 | 2,722.0 |
| Net Trading Profits | 368.2 | 454.3 | 329.5 | 412.7 | 412.7 | 420.9 |
| Net Other Operating Profits | 85.8 | (601.7) | 218.8 | 206.0 | 206.0 | 210.1 |
| Net Gains (Losses) on Debt Securities | (450.8) | (991.5) | (177.3) | |||
| Total Net Revenue (Gross Profits) | ¥4,732.5 | ¥4,819.3 | ¥5,944.5 | ¥7,040.0 | ¥7,719.0 | ¥8,059.8 |
| Less: G&A Expenses excl. Amortization of Goodwill | (2,866.5) | (3,191.6) | (3,525.4) | (3,846.2) | (4,263.1) | (4,433.8) |
| Less: Amortization of Goodwill | (22.2) | (36.6) | (41.8) | (42.7) | (41.4) | (39.4) |
| Total Non-Interest Expense | (¥2,888.7) | (¥3,228.1) | (¥3,567.2) | (¥3,888.9) | (¥4,304.5) | (¥4,473.2) |
| Provision for General Allowance for Credit Losses | (6.7) | 0.0 | 20.1 | 5.9 | 0.0 | 0.0 |
| Net Operating Profits | ¥1,837.1 | ¥1,591.2 | ¥2,397.3 | ¥3,157.0 | ¥3,414.5 | ¥3,586.6 |
| Less: Credit Costs | (592.9) | (302.3) | (474.7) | (415.8) | (424.3) | (485.8) |
| Losses on Loan Write-offs | (193.1) | (289.7) | (252.6) | |||
| Provision for Specific Allowance for Credit Losses | (387.4) | 0.0 | (202.4) | |||
| Other Credit Costs | (12.4) | (12.6) | (19.8) | |||
| Reversal of Allowance for Credit Losses | 0.0 | 76.8 | 0.0 | 0.0 | 0.0 | 0.0 |
| Reversal of Reserve for Contingent Losses | 0.0 | 4.5 | 2.0 | 0.0 | 0.0 | 0.0 |
| Gains on Loans Written-off | 101.7 | 112.2 | 96.8 | 96.6 | 97.4 | 100.0 |
| Net Gains (Losses) on Equity Securities | 371.3 | 592.6 | 486.0 | 284.6 | 111.0 | 70.2 |
| Gains on Sales of Equity Securities | 452.1 | 679.0 | 604.7 | |||
| Losses on Sales of Equity Securities | (70.7) | (35.5) | (100.3) | |||
| Losses on Write-down of Equity Securities | (10.2) | (51.0) | (18.4) | |||
| Equity in Earnings of Equity Method Investees | 531.8 | 597.0 | 845.5 | 992.3 | 1,032.0 | 1,062.9 |
| Other Non-Recurring Gains (Losses) | (121.0) | (2.5) | 57.2 | 73.5 | 77.2 | 80.6 |
| Total Net Non-Recurring Gains (Losses) | ¥290.9 | ¥1,078.3 | ¥1,012.9 | ¥1,031.2 | ¥893.2 | ¥827.9 |
| Ordinary Profits | ¥2,128.0 | ¥2,669.5 | ¥3,410.2 | ¥4,188.2 | ¥4,307.7 | ¥4,414.5 |
| Net Extraordinary Gains (Losses) | (77.9) | (118.8) | (88.0) | (63.3) | (92.6) | (96.7) |
| Profits before Income Taxes | ¥2,050.1 | ¥2,550.6 | ¥3,322.2 | ¥4,124.9 | ¥4,215.1 | ¥4,317.8 |
| Less: Income Taxes - Current | (411.9) | (382.7) | (853.4) | (907.8) | (1,011.6) | (1,057.9) |
| Refund of Income Taxes | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Less: Income Taxes - Deferred | (66.5) | (226.5) | 91.8 | (85.4) | 0.0 | 0.0 |
| Total Taxes | (¥478.3) | (¥609.2) | (¥761.6) | (¥993.3) | (¥1,011.6) | (¥1,057.9) |
| Profits | ¥1,571.8 | ¥1,941.5 | ¥2,560.5 | ¥3,131.6 | ¥3,203.5 | ¥3,260.0 |
| Less: Profits Attributable to Non-Controlling Interests | (81.0) | (78.5) | (133.3) | (137.7) | (141.0) | (143.4) |
| Net Income | ¥1,490.8 | ¥1,862.9 | ¥2,427.2 | ¥2,993.9 | ¥3,062.5 | ¥3,116.5 |
| Weighted Average Shares - Basic (M) | 11,959.978 | 11,642.149 | 11,386.395 | 11,202.891 | 11,002.596 | 10,804.550 |
| Weighted Average Shares - Diluted (M) | 11,959.978 | 11,642.149 | 11,386.395 | 11,202.891 | 11,002.596 | 10,804.550 |
| Basic EPS | ¥124.65 | ¥160.02 | ¥213.17 | ¥267.24 | ¥278.35 | ¥288.45 |
| Basic EPS | ¥124.65 | ¥160.02 | ¥213.17 | |||
| Diluted EPS | ¥124.33 | ¥159.48 | ¥212.34 | |||
| Dividends per Share Declared | 41.00 | 64.00 | 86.00 | 96.00 | 104.00 | 112.00 |
| Ratios & Assumptions | ||||||
| YoY Total Net Revenue Growth | 5.1% | 1.8% | 23.3% | 18.4% | 9.6% | 4.4% |
| Net Margin | 31.5% | 38.7% | 40.8% | 42.5% | 39.7% | 38.7% |
| Effective Tax Rate | 23.3% | 23.9% | 22.9% | 24.1% | 24.0% | 24.5% |
The full workbook adds 21 historical and 7 projected quarters, plus Balance Sheet · Cash Flow Statement · Disclosed Bank Metrics (as filed) · Segment Performance · KPI Drivers — every subtotal a live formula, every projection traced to a driver.
Mitsubishi UFJ Financial research
Aardvark Labs Capital Research has published 4 reports on Mitsubishi UFJ Financial (MUFG). The latest is the Q1 FY27 Earnings Recap, published August 18, 2026, rated Hold.
MUFG Fixed Its Capital Ratio a Quarter Early and Beat by 28%, Then Lagged Every Peer for Raising Nothing
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.