← All financial models

Mitsubishi UFJ Financial (MUFG) Financial Model

📊 Download Model

Three-statement Excel model · 21 quarters and 5 fiscal years of history · 7 quarters and 5 fiscal years of projections

current ✓ C13 recon ✓ C14 trace ✓ C15 terminals

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.

History
21 quarters and 5 fiscal years
Projections
7 quarters and 5 fiscal years
KPI
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
Segments
6
Units
Billions of yen, except per share data
Verified
Updated
File
Excel workbook (.xlsx), 168 KB
Access
Free account required: 3 different models a month at no charge, then $9 a month.

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 preview for MUFG. Billions of yen, except per share data. Actual fiscal years followed by our estimates.
Income Statement
ActualEstimate
FY24FY25FY26FY27EFY28EFY29E
Net Interest Income¥2,457.9¥2,876.6¥3,006.3¥3,796.0¥4,319.4¥4,510.6
Trust Fees139.4144.4163.1179.6188.5196.1
Credit Costs for Trust Accounts0.00.00.0
Net Fees and Commissions1,681.31,945.82,226.82,445.72,592.42,722.0
Net Trading Profits368.2454.3329.5412.7412.7420.9
Net Other Operating Profits85.8(601.7)218.8206.0206.0210.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.020.15.90.00.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 Losses0.076.80.00.00.00.0
Reversal of Reserve for Contingent Losses0.04.52.00.00.00.0
Gains on Loans Written-off101.7112.296.896.697.4100.0
Net Gains (Losses) on Equity Securities371.3592.6486.0284.6111.070.2
Gains on Sales of Equity Securities452.1679.0604.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 Investees531.8597.0845.5992.31,032.01,062.9
Other Non-Recurring Gains (Losses)(121.0)(2.5)57.273.577.280.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 Taxes0.00.00.00.00.00.0
Less: Income Taxes - Deferred(66.5)(226.5)91.8(85.4)0.00.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.97811,642.14911,386.39511,202.89111,002.59610,804.550
Weighted Average Shares - Diluted (M)11,959.97811,642.14911,386.39511,202.89111,002.59610,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 Declared41.0064.0086.0096.00104.00112.00
Ratios & Assumptions
YoY Total Net Revenue Growth5.1%1.8%23.3%18.4%9.6%4.4%
Net Margin31.5%38.7%40.8%42.5%39.7%38.7%
Effective Tax Rate23.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.

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

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

All MUFG 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.