Terry Dolan
Vice Chair & Chief Financial Officer at U.S. Bancorp
Thanks, Andy. Turning to Slide 7. Our balanced mix of consumer, corporate and commercial deposits continues to be a key source of strength for the bank. As Andy highlighted, while average total deposits declined 2.6% or $13.1 billion on a linked-quarter basis, we ended the period with $522 billion of deposits, representing a 3.2% increase in ending balances on linked-quarter.
This quarter, end-of-period percent of non-interest-bearing deposits declined to approximately 20% from 25% in the first quarter due to both industry dynamics and a change we made to Union Bank retail accounts at conversion. Specifically, about half of the decline was related to an increase in deposit volumes and mix shift, while the other half primarily -- was primarily driven by a customer-friendly product conversion decision by us.
To create a more positive customer experience, we upgraded Union Bank customers to our interest-bearing Bank Smartly Checking product, which offers a better checking solution as well as other benefits. This change will provide customer retention benefits without a material impact on our net interest margin. Given current interest rate volatility and the significant competition for deposits across the industry, we now expect our cumulative deposit beta to be in the mid-40% range by the end of this rate cycle, slightly higher than our previous expectation, but consistent with the deposit pricing dynamics in the industry.
On Slide 8, average loan -- average total loans this quarter were $389 billion, which was flat on a linked-quarter basis and up 19.9% year-over-year. Commercial real estate loans represent approximately 14% of our total average loan portfolio with commercial real estate office exposure representing only 2% of total loans and 1% of total commitments. Our office exposure is well-balanced amongst suburban, specialty and central business districts and had a weighted average loan-to-value ratio of approximately 55% at initial underwriting. Given current macro factors as well as other portfolio considerations, we increased the reserve ratio for commercial real estate office loans to 8.5%.
Turning to Slide 9. We reported diluted earnings per share of $0.84 for the quarter or $1.12 per share after adjusting for notable items in the amount of $575 million or $0.28 per diluted common share. Notable items this quarter included $310 million of merger and integration-related charges associated with the acquisition of Union Bank as well as $265 million related to balance sheet optimization and capital management actions, largely driven by a provision charge of $243 million related to the securitization of approximately $4.4 billion of indirect auto loans as well as an additional $4.2 billion sale of Union Bank mortgage loans. These moves enables us to more effectively position the balance sheet for profitable growth and optimized returns.
Slide 10 provides a more detailed earnings summary for the quarter.
Turning to Slide 11. Net interest income on a fully taxable equivalent basis totaled approximately $4.4 billion, which represented a 4.7% decrease on a linked-quarter basis and a 28.4% increase from a year ago due to the impact of rising rates and the acquisition of Union Bank. Our net interest margin declined from 3.10% in the first quarter to 2.90% in the second quarter, which is somewhat lower than expected. The linked-quarter decline was primarily due to the impact of maintaining higher cash levels given the debt ceiling concerns and deposit pricing pressures, partially offset by higher rates on earning assets.
Slide 12 highlights trends in non-interest income. Non-interest income increased 8.7% or $219 million on a linked-quarter basis, driven by higher payments services revenue, trust and investment management fees and commercial product revenues. Within payment services, revenue increased $112 million on a linked-quarter basis, reflecting credit card growth -- credit card revenue growth of $62 million or 17.2%, driven by higher margins and sales volume and an increase in merchant processing revenue of $49 million or 12.7% driven by pricing.
Also noteworthy, were increases in trust and investment management fees of $31 million or 5.3%, driven by core business growth and commercial product revenue of $24 million or 7.2%, driven by strong debt capital markets activity in the quarter. Compared with the year ago, non-interest income for the company increased $178 million or 7.0%, largely driven by higher quarter fee income.
Turning to Slide 13. Reported non-interest expense for the company totaled $4.6 billion in the second quarter, which included a $310 million of merger and integration-related charges. Non-interest expense as adjusted decreased $52 million or 1.2% on a linked-quarter basis.
Slide 14 shows credit quality trends, which continue to be strong from a historical perspective, but are normalizing as expected. The ratio of non-performing assets to loans and other real estate was 0.29% at June 30 compared to 0.30% at March 31 and 0.23% a year ago. Our second quarter net charge off ratio of 0.35% as adjusted increased 5 basis points from our first quarter level of 0.30% as adjusted and was higher when compared to the second quarter 2022 level of 0.20%. Our allowance for credit losses as of June 30 totaled $7.7 billion or 2.03% of period-end loans.
Turning to Slide 15. We accelerated our capital actions and ended the quarter with a CET1 capital ratio of 9.1%. The 60 basis points linked-quarter increase in the CET1 ratio reflected 20 basis points of earnings accretion net of distributions and an additional 40 basis points attributable to risk-weighted asset and other balance sheet optimization initiatives with low-to-neutral earnings impact.
During the quarter, we received the results of the Federal Reserve's 2023 stress test and we expect to be subject to the minimum stress capital buffer requirement of 2.5%, which is unchanged from last year despite this year's more stressful economic scenario and an additional $1.4 billion of merger-related charges with limited recognition of cost synergies related to Union Bank.
I will provide third quarter and updated full year 2023 forward-looking guidance on Slide 16. Starting with third quarter 2023 guidance. We expect net interest income of between $4.2 billion and $4.4 billion in the third quarter. Total revenue as adjusted is estimated to be in the range of $6.9 billion to $7.1 billion, including approximately $75 million of purchase accounting accretion. Total non-interest expense as adjusted is expected to be approximately $4.3 billion, inclusive of approximately $120 million of core deposit intangible amortization related to the Union Bank acquisition. Our income tax rate as adjusted is expected to be approximately 23% to 24% on a taxable equivalent basis. We expect merger and integration charges of between $150 million to $200 million in the third quarter.
I will now provide updated guidance for the full year. For 2023, net interest income is expected to be in the range of $17.5 billion to $18.0 billion. Total revenue as adjusted is now expected to be in the range of $28.0 billion to $29.0 billion, inclusive of approximately a $330 million of full year purchase accounting accretion. Total non-interest expense as adjusted for the year is expected to be approximately $17 billion, inclusive of approximately $500 million of core deposit intangible amortization related to Union Bank. Our estimated full year income tax rate on a taxable equivalent basis as adjusted is expected to be approximately 23% to 24%. We continue to expect to have $900 million to $1 billion of merger and integration charges in 2023 and total merger and integration costs of approximately $1.4 billion consistent with earlier guidance.
I will now hand it back to Andy for closing remarks.