Portfolio Case Study · Financial Modeling & Credit Strategy

Commercial Credit
Portfolio Strategy Brief
Hawaii Market Scenario Modeling Tool

A portfolio-level scenario modeling tool built from first principles and calibrated to Hawaii's commercial real estate lending environment using 2025 data from the FDIC, Federal Reserve, and Mortgage Bankers Association.

Independent Project Financial Modeling Credit Risk Analysis Hawaii CRE Market NPV & Stress Testing Executive Communication
Project at a Glance
Audience
CCO / Board
Chief Credit Officer & Board Risk Committee level
Data
2025
FDIC Q1 2025 · Fed/NBER · MBA Q2 2025
Tool Type
Live
Real-time scenario modeling, 4 interactive sliders
Scope
Portfolio
Portfolio-level strategy. Not an underwriting tool.

The Problem

The core tension in commercial lending portfolio strategy — how aggressively to approve loans given a specific default rate and return environment — is rarely modeled in a way that executives can interact with in real time. Most credit reporting is backward-looking: delinquency rates, charge-off history, portfolio balances. The forward-looking question — at what approval rate does our risk-adjusted return peak, and how sensitive is that to a change in default assumptions? — typically gets answered in a static quarterly spreadsheet, if at all.

In Hawaii specifically, that analysis looks different than the mainland. Land scarcity creates a structural floor under collateral values. A stable, diversified economy (tourism, military, government) produces lower default volatility than mainland markets exposed to single-industry concentration. A relationship-driven, lower-volume deal environment means each individual loan carries outsized portfolio impact relative to a high-volume consumer book. National default rate benchmarks and loss severity assumptions do not translate directly.

This tool was built to model that specific problem — the optimal approval rate decision for a Hawaii community bank commercial portfolio — using current 2025 data and Hawaii-specific calibration.

Model Methodology

The model is built on six sequential formulas. Each is stated explicitly below with its data rationale.

Formula 1 — Annual Loan Volume
Annual Loan Volume = Monthly Applications × Approval Rate × Avg Loan Size × 12
Scales monthly deal flow to an annualized portfolio volume figure. Monthly applications default to 45, reflecting relationship-driven Hawaii community bank deal pace rather than high-volume consumer origination.
Formula 2 — Annual Interest Income
Annual Interest Income = Annual Loan Volume × Net Interest Margin
NIM default: 4.10%. Source: FDIC Q1 2025 community bank NIM = 3.46% (4th consecutive quarterly increase; ICBA May 2025). Commercial CRE carries approximately 60–70 basis points above the portfolio NIM average. Hawaii commercial rate environment per Commercial Loan Direct Hawaii 2025.
Formula 3 — Annual Expected Loss
Annual Expected Loss = Annual Loan Volume × Default Rate × Loss Severity
Default Rate default: 1.2%. Source: MBA Q2 2025 bank/thrift CRE delinquency = 1.29%; Hawaii set below national avg given land scarcity, Hawaii Island unemployment 2.50% (Colliers Dec 2025), and historically low foreclosure rates (ATTOM Q1 2024). Loss Severity default: 38%. Source: Federal Reserve/NBER W31970 — banks recover ~70% of CRE loan balances on default (avg ~30% loss); Hawaii CRE premium applied due to stronger collateral but slower commercial liquidation timelines vs. residential.
Formula 4 — Annual Net Return
Annual Net Return = Annual Interest Income − Annual Expected Loss
Pre-expense net return on the commercial loan portfolio. Does not include operating costs, provisioning, or overhead. Use as directional return metric, not accounting net income.
Formula 5 — 5-Year Net Present Value
NPV = Σ [ Annual Net Return ÷ (1 + Discount Rate)^Year ] for Y = 1 to 5
Discounts future net returns to present value using a 9% discount rate, reflecting cost of capital and opportunity cost for a community bank. Standard DCF approach. Assumes stable annual return across the horizon — does not model origination vintage curves or portfolio seasoning.
Formula 6 — Break-Even Default Rate
Break-Even Default Rate = NIM ÷ Loss Severity
The maximum default rate before the portfolio stops being profitable in aggregate. At NIM 4.10% and Loss Severity 38%: Break-Even = 4.10% ÷ 38% ≈ 10.8%. Important caveat: This is a pre-expense approximation and represents an upper bound. The true break-even — after operating costs and loan loss provisioning — is materially lower. Use as a directional ceiling, not a precise operating threshold.

Hawaii Market Assumptions — 2025 Data

All default assumptions are calibrated to Hawaii commercial real estate conditions using the most current available data as of 2025. Adjustable via the Advanced Assumptions panel in the tool.

Input Default Value Rationale & Source
Net Interest Margin 4.10% FDIC Q1 2025: community bank NIM = 3.46%, rising for the 4th consecutive quarter (ICBA, May 2025). Commercial CRE premium ~65bp above portfolio average. Hawaii commercial loan rates range 4.93–12.95% depending on structure (Commercial Loan Direct Hawaii 2025). · FDIC Q1 2025 · ICBA May 2025
Loss Severity 38% Federal Reserve/NBER Working Paper W31970: banks recover ~70% of CRE loan principal on default (avg loss ~30%). Hawaii CRE collateral premium — land scarcity and stable property values — justifies below-national assumption, but commercial liquidation timelines are longer than residential, supporting a 38% estimate. FDIC/SSRN study of 14,000+ distressed CRE loans (Johnston & Shibut 2015) confirms LGD varies significantly by market conditions and loan seasoning. · NBER W31970 · FDIC/SSRN CRE LGD Study
Default Rate 1.2% MBA Q2 2025 Loan Performance Survey: bank/thrift CRE delinquency = 1.29% (90+ days delinquent or non-accrual). Hawaii set below national average given: (1) Hawaii Island unemployment 2.50% Dec 2025 (Colliers), one of lowest recent levels; (2) Hawaii foreclosure rate among the lowest nationally (ATTOM Q1 2024); (3) Hawaii CRE described as "capital-available but capital-protected" with conservative underwriting and strong sponsorship requirements (Commercial Loan Direct 2025). · MBA Q2 2025 · Colliers Hawaii 2025
Average Loan Size $3.5M FHB's CRE portfolio totaled $4.41B as of Q1 2025 (FHB 10-Q, March 2025). Bank of Hawaii Q1 2025 investor materials show average CRE exposure by segment: multi-family $3.1M, office $1.8M, retail $2.5M, construction $4.1M, industrial $13.6M. FHB holds Hawaii's largest CRE loan portfolio and regularly originates deals ranging from $500K to $50M+. Model slider range expanded accordingly. · FHB Q1 2025 10-Q · BOH Q1 2025 Investor Materials
Monthly Applications 45 Commercial lending in Hawaii is relationship-driven, not volume-driven. Local and regional banks dominate; relationships, deposits, and borrower reputation drive deal flow. Lower volume, higher deal quality is the characteristic pattern. Institutional mainland lenders participate selectively for large stabilized Oahu assets only. (Commercial Loan Direct Hawaii 2025; Brevitas Hawaii CRE 2025) · Brevitas Hawaii CRE 2025
Discount Rate 9% Standard community bank cost of capital assumption for NPV analysis. Reflects opportunity cost of capital deployment in a post-rate-tightening environment. Adjustable in model Advanced Assumptions panel.

The Tool

Move the sliders and watch every metric update in real time — 5-year NPV, expected loss rate, portfolio health score, break-even default rate, stress-case NPV (+25% default), sensitivity analysis, and a Credit Committee Brief export. Calibrated for Hawaii commercial real estate market conditions using 2025 data. Loan size range $500K–$50M reflects FHB's actual CRE deal spectrum per Q1 2025 SEC filings.

Live Interactive Tool
Commercial Credit Portfolio Strategy Brief
Hawaii commercial lending · 2025 data · Real-time scenario modeling · Credit Committee export
Try it live →

Feature Breakdown

Scenario Inputs
Live Scenario Controls
Four sliders — approval rate, monthly deal volume, average loan size ($500K–$15M), and default rate (0.3%–8%). All calibrated to Hawaii commercial CRE scale. Every output metric updates in real time on slider movement.
Risk Analysis
Break-Even & Stress Testing
Calculates the maximum default rate before portfolio-level profitability turns negative (NIM ÷ Loss Severity), with an explicit caveat that this is a pre-expense upper bound. Stress-case NPV at +25% default rate deterioration shown alongside base case.
Visualization
Tradeoff Curve
Risk-adjusted return plotted across the full approval rate range (40%–85%), with under-lending, optimal, and risk zones marked. Current position updates dynamically. Quality degradation penalty applied at high approval rates reflecting marginal borrower risk.
Portfolio Health
Portfolio Health Score
Composite indicator combining NIM coverage ratio (50% weight), default rate distance from break-even (35% weight), and approval rate discipline (15% weight). Provides a single at-a-glance portfolio quality signal for executive review.
Sensitivity
Primary Lever Analysis
Quantifies the relative NPV impact of a 10% change in approval rate vs. default rate vs. loan volume — identifying which variable has the highest marginal strategic impact under current assumptions.
Export
Credit Committee Brief
One-click export of a formatted memo including recommendation, complete model formulas with live calculated values, risk assessment, 2025-sourced assumptions, and suggested next step. Includes data source citations.

Model Limitations

This tool models portfolio-level approval strategy. It is intentionally scoped to that question and does not perform individual deal underwriting. The following dimensions are outside its scope by design and would require separate analysis:

Individual borrower creditworthinessNo assessment of a specific borrower's DSCR, debt capacity, repayment history, or financial statements. That is the underwriter's function.
Collateral quality and LTVLoss severity is applied as a uniform portfolio assumption. Specific property appraisal, condition, LTV ratio, and market liquidity per deal are not captured.
Guarantor strengthPersonal and corporate guarantees, which materially affect loss given default on commercial loans, are not modeled.
Covenant structuresLoan performance covenants, triggers, and cure provisions — which significantly shape real-world credit outcomes — are outside scope.
Concentration risk by borrower or sectorThe model assumes uniform distribution. In practice, two $10M relationships represent far more concentration risk than twenty $1M relationships.
Regulatory capital constraintsCRE concentration limits, Tier 1 capital ratios, and OCC examination thresholds are not modeled. A bank near regulatory limits faces constraints this tool does not reflect.
Vintage and seasoning effectsUniform default assumptions applied across the portfolio. Actual loan performance varies significantly by origination vintage and loan age.
Operating costs and provisioningBreak-even default rate is a pre-expense upper bound. True break-even — after overhead and ALLL provisioning — is materially lower.

What This Demonstrates

Commercial credit risk framework NPV & discounted cash flow modeling Hawaii CRE market knowledge 2025 primary source research Stress testing methodology Portfolio-level strategic thinking Loss given default (LGD) concepts Break-even analysis Model limitation awareness DSCR & credit framework fluency Board-ready communication Sensitivity analysis

Project Summary

Situation
Portfolio-level commercial credit strategy decisions are typically supported by static, backward-looking reports — leaving executives without a forward-looking instrument to stress-test approval rate assumptions or visualize break-even default thresholds before committing to a direction.
Task
Build a board-ready scenario tool calibrated for Hawaii commercial real estate — without formal credit training or institutional data — that correctly reflects the risk profile of a Hawaii community bank commercial portfolio using current 2025 data from the FDIC, Federal Reserve, and MBA.
Action
Researched Hawaii commercial lending conditions, sourced 2025 data from FDIC Q1 2025, NBER Working Paper W31970, MBA Q2 2025, Colliers Hawaii 2025, and Honolulu Board of Realtors. Built the six-formula model from first principles, calibrated Hawaii-specific assumptions for NIM, loss severity, and default rate, and built the interactive tool in HTML/CSS/JavaScript.
Result
A working credit portfolio strategy tool that demonstrates portfolio-level analytical thinking, Hawaii market knowledge, model limitation awareness, and the ability to translate credit risk concepts into executive-level communication — built from primary source research and explicitly documenting its own assumptions and scope boundaries.

Analytical Takeaway

The approval rate decision in commercial lending is not simply a credit quality question — it is a portfolio optimization problem. The optimal approval rate is the point at which risk-adjusted return peaks: high enough to capture profitable marginal deals, low enough that the quality degradation of incremental approvals does not erode total return.

What makes Hawaii different from the mainland is the relationship between collateral strength and loss severity. Land scarcity creates a structural floor under CRE values that does not exist in most mainland markets. This compresses loss severity and raises the break-even default rate — meaning a Hawaii community bank can tolerate a higher default rate before portfolio profitability is impaired, all else equal. That is a material difference in how approval rate strategy should be calibrated.

This tool makes that calibration visible and interactive — not as a replacement for underwriting judgment, but as a framework for the strategic conversation that happens before individual deals reach the credit committee.