The Allowance for Loan Losses for Banks (FIG)

  Рет қаралды 39,196

Mergers & Inquisitions / Breaking Into Wall Street

Mergers & Inquisitions / Breaking Into Wall Street

Күн бұрын

In this tutorial, you’ll learn all about the Allowance for Loan Losses and the Provision for Credit Losses for commercial banks, which are important topics related to accounting and valuation for financial institutions (FIG). These topics are extremely likely to come up in interviews with these groups, and will come up on the job day in and day out.
breakingintowallstreet.com/
"Financial Modeling Training And Career Resources For Aspiring Investment Bankers"
Table of Contents:
3:03 Part 1: Allowance for Loan Losses vs. Regulatory Capital
4:24 Part 2: Loan Loss Accounting on the Financial Statements
8:18 Part 3: Example Scenarios to Illustrate the Mechanics
16:45 Part 4: How Regulatory Capital and the Allowance for Loan Losses Are Linked
19:50 Recap and Summary
The Business Model of Commercial Banks
Banks collect money from customers (deposits), and then lend I to people who need to borrow money (loans).
They expect to lose something on these loans because some people and companies default and become unable to pay back their loans.
But there are two categories: expected losses and * unexpected losses*.
The Allowance for Loan Losses corresponds to *expected losses*, while Regulatory Capital corresponds to *unexpected losses*.
Loan Loss Accounting on the Three Financial Statements
Balance Sheet: The Allowance is a contra-asset that’s netted against Gross Loans to calculate Net Loans.
Additions: The Provision for Credit Losses will increase this reserve, making the contra-asset more negative. This Provision represents the additional amount, above and beyond the existing Allowance, that the bank expects to lose.
Subtractions: Net Charge-Offs (actual defaults) will reduce this Allowance, making the contra-asset less negative.
Income Statement: The Provision for Credit Losses is an expense that reduces Pre-Tax Income and Net Income, but Net Charge-Offs do not appear on the IS... not directly, anyway.
Cash Flow Statement: The Provision for CLs is a non-cash add-back; you also record Loan Additions here. Just as with the Income Statement, Net Charge-Offs do NOT show up here.
Loan Loss Accounting, Illustrated in Different Scenarios
Scenario #1: The Bank expects to lose an ADDITIONAL $10 on its Loans
It simply records $10 for the Provision for Credit Losses. Gross Loans stays the same, but the Allowance becomes $10 more negative, and Net Loans declines by $10 as a result.
Scenario #2: Bank adds $100 in Loans, and expects to lose $5 on them
It records $5 for the Provision for Credit Losses. Gross Loans increases by $100, the Allowance becomes $5 more negative, and the Net Loans figure increases by $95.
Scenario #3: Now the bank actually loses $5 and records the charge-off
The Gross Loans figure declines by $5 and the Allowance for Loan Losses becomes $5 more positive. Those changes cancel each other out, and so the Net Loans figure stays the same. There’s no Income Statement impact.
Scenario #4: …but now, there’s a recovery of $2! Due to collateral, or the borrowers suddenly repaying some of the loan
Now, the Gross Loans figure increases by $2, but the Allowance also becomes $2 more negative - so the changes cancel each other out once again, and Net Loans stays the same. There’s no Income Statement impact.
Scenario #5: The Allowance is $10, but there’s a Gross Charge-Off of $20 - what happens? How can this possibly work?
In this case, the bank simply has to increase its Allowance for Loan Losses to cover this unexpected loss. So the bank might set aside, say, an additional $20, and therefore record a $20 Provision for Credit Losses, which results in a higher Allowance to cover this loss.
The Net Loans figure ends up declining because the Gross Loans figure will fall and the Allowance will eventually return to its original level.
How Regulatory Capital and the Allowance for Loan Losses Are Linked
So how exactly does Regulatory Capital (mostly Common Equity or Equity) “absorb” losses?
Because when an unexpected loss occurs, banks have to increase their Allowance for Loan Losses.
They do this by increasing the Provision for CLs, which reduces Net Income since it appears on the Income Statement.
That reduced Net Income, in turn, reduces Shareholders’ Equity.
So Regulatory Capital “absorbs losses” by ensuring that Equity stays above a certain level, even if Net Income falls… since a dramatic drop in Net Income would come, most likely, from unexpected losses.
The capital ratios fall when this happens, as they should.
RESOURCES:
youtube-breakingintowallstree...
youtube-breakingintowallstree...

Пікірлер: 64
@rembautimes8808
@rembautimes8808 4 жыл бұрын
This is a fantastic video. I have worked in a medium sized Financial Institution for the past 7 years and nobody explained this in such great detail and in a comprehensive manner. Totally recommend this course to anybody interested in Banking, Finance or into Fintech. I am about 80% sure I will sign up for this course
@financialmodeling
@financialmodeling 4 жыл бұрын
Thanks, glad to hear it!
@davidadu9145
@davidadu9145 5 жыл бұрын
Thanks a lot. This has been very helpful
@BrunoFalconi
@BrunoFalconi 3 жыл бұрын
This is fantastic material. Very well explained and thought out - straight forward examples make for excellent conceptual understanding. Thank you!
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks!
@julichom5712
@julichom5712 3 жыл бұрын
Man this is brilliant! Makes me want to sign up to your courses right away! Thanks a lot!
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks for watching!
@hardikpatel3999
@hardikpatel3999 7 жыл бұрын
Superb.. thnk you sir :)
@sunidhijain328
@sunidhijain328 4 жыл бұрын
Thoroughly discussed the concept.Very helpful video....Thank You....
@financialmodeling
@financialmodeling 4 жыл бұрын
Thanks for watching!
@HelloErth
@HelloErth 7 жыл бұрын
Cant thank you enough, so very helpful
@financialmodeling
@financialmodeling 7 жыл бұрын
Thanks for watching!
@mariasalas1440
@mariasalas1440 2 жыл бұрын
This video was very helpful- thanks
@financialmodeling
@financialmodeling 2 жыл бұрын
Thanks for watching!
@uffnik61
@uffnik61 Жыл бұрын
Thank you, it helped me understand me much more on banking
@financialmodeling
@financialmodeling Жыл бұрын
Thanks for watching!
@TeeA4
@TeeA4 7 жыл бұрын
Thank you. This is so helpful it 'hurts'. Thanks for doing that. You mentioned we could get the spreadsheet by clicking a link but I can't seem to get it.
@financialmodeling
@financialmodeling 7 жыл бұрын
Click "Show More". Scroll to the bottom. Click the links.
@aaronwimberleymbamsf5776
@aaronwimberleymbamsf5776 2 жыл бұрын
"Provisions" is where I thought the COVID crisis would affect the banking and financial institutions the most. It would be interesting to apply Monte Carlo or Var to this analysis. I think that the Basel requirements made sure that the financial institutions had enough of a buffer or reserve assets on hand. Very clean model- I have a pretty sophisticated one just like it.
@financialmodeling
@financialmodeling 2 жыл бұрын
Banks did initially increase their Provisions if you look at Q1 and Q2 of 2020. But then the government bailed out big companies, so the higher Provisions ended up not being necessary.
@kushansenanayake8220
@kushansenanayake8220 6 жыл бұрын
Superb explanation and thanks for the video. Can you actually do a video on how IFRS 9 changes will affect banking when it comes to impairment compared to IAS 39?
@financialmodeling
@financialmodeling 6 жыл бұрын
Thanks for the suggestion, but that one is probably a bit too obscure to cover here (we get virtually no interest in anything Bank Modeling-related, so I don't even know why we created any of this material).
@rathem7
@rathem7 3 жыл бұрын
Very helpful, thanks a lot! I have this perhaps beginner question: If I assume some loan will not pay 5% of the total outstanding, but the loan has a, let's say, 3 year maturity; is it equivalent to say that each year I expect to charge-off a 5%/3= 1.67% of the loan? And if, for example, the first year I just lost 1% of the loan, as it is less than 1.67%, I could be able to reduce provisions?? Thanks a lot.
@financialmodeling
@financialmodeling 3 жыл бұрын
Principal repayments of loans are not the same as charge-offs. Charge-offs are unexpected events that also affect the Provision for Credit Losses because banks tend to adjust provisions upward as a result. Mechanically, yes, repaying a loan and charging it off both reduce Gross Loans on the Balance Sheet, but their impact on Provisions is different, as is the potential for reversing the event (possible with a charge-off, but not with principal repayment).
@zreeradical5590
@zreeradical5590 6 жыл бұрын
Could you please include a link to down the example excel sheet you use in your video. U say the link is provided below but could not find it!
@financialmodeling
@financialmodeling 6 жыл бұрын
Click on "Show More." Scroll to the bottom under "Resources." Click the links.
@lemonidask
@lemonidask 6 жыл бұрын
thank you for the video and the excel file..it is really helpful as i am writting my thesis on loan loss reserves in banking industry..The think i want to ask you is why in the excel file you have limited the loan loss allowance in tier 2 to 50%???i mean i dont find anything in basel iii that limiths the amount of loan loss reserve in tier2..i will much appreciate it if you could support me with an answer!thank u!!
@financialmodeling
@financialmodeling 6 жыл бұрын
There are always limitations around the Allowance that can be counted toward regulatory capital so that banks can't "game the system" by setting their provisions too high. The 50% number here is arbitrary, but there are usually limitations based on the RWAs or other items... www.fdic.gov/regulations/resources/call/crinst/999rc-r.pdf "This adjusted gross risk-weighted-assets figure multiplied by 1.25 percent is the bank's Tier 2 capital limit on the allowance for loan and lease losses"
@lemonidask
@lemonidask 6 жыл бұрын
i know about the limitation of 1.25%..thank you very much for your reply!!!keep up the good work!!
@moumitaghosh3919
@moumitaghosh3919 4 жыл бұрын
Can you please tell how are you calculating the net income?
@financialmodeling
@financialmodeling 4 жыл бұрын
I'm not really sure what you mean. Net Income for a bank = Net Interest Income + Other Revenue Sources Such as Fees - Provision for Credit Losses - Non-Interest Expenses - Taxes, exactly what's shown on screen and in the file here.
@randomuselesshandle
@randomuselesshandle 7 жыл бұрын
When a recovery happens, in my opinion the increase on the asset side be attributable to cash balance instead of gross loans. What do you think?
@financialmodeling
@financialmodeling 7 жыл бұрын
??? Are you asking about what happens if the Allowance for Loan Losses decreases? There would be a Cash impact, but that's not the best way to think about it. The company's Provision for Credit Losses would change and that, in turn, would affect Pre-Tax Income, Net Income, Cash, Equity, the Allowance for Loan Losses, etc.
@randomuselesshandle
@randomuselesshandle 7 жыл бұрын
No. I‘m talking about scenario 4 at 12:15. You booked $2 increase in loans and another $2 in loss allowance (contra). However I believe the $2 should've been booked in cash instead of loans in that case.
@financialmodeling
@financialmodeling 7 жыл бұрын
Recoveries shouldn't affect the Net Loans number. The only way that happens is if there are offsetting changes to the Allowance and to the Gross Loans number. Also, if there's a Recovery, that doesn't mean the bank gets cash from borrowers; it could just mean the borrowers have started repaying the loan again, in which case Gross Loans needs to increase to reflect that.
@randomuselesshandle
@randomuselesshandle 7 жыл бұрын
I see. You used upgrades and recoveries interchangeably here. I'm not sure if written-off loans would be entirely booked back on BS in that case though. Thanks for your response.
@SalMat786
@SalMat786 Жыл бұрын
Do you know how I can download the excel spreadsheet that was used in this excellent tutorial?
@financialmodeling
@financialmodeling Жыл бұрын
Click "Show More" and scroll to the links under "Resources" at the bottom.
@fintech1378
@fintech1378 3 жыл бұрын
Can you give link to the full course?
@financialmodeling
@financialmodeling 3 жыл бұрын
breakingintowallstreet.com/biws/bank-modeling/
@ya0004ng
@ya0004ng 7 жыл бұрын
is the allowance recovery equivalent to allowance write back?
@financialmodeling
@financialmodeling 7 жыл бұрын
Yes sometimes it is called that.
@benfrieden1921
@benfrieden1921 4 жыл бұрын
I'm a bit confused - Can you please help me understand why there is no impact on cash? Or where cash comes into play? I would logically think that at some point the bank would be on the hook for some of the loan losses and would face liquidity concerns as a result. This seems to not be the case though? In fact, seems like provision for credit losses actually boosts the cash balance due to being an add-back on the CFS. I'd think at some point the bank would face insolvency issues and real cash losses if all their outstanding loans went to 0 (as an extreme illustration of this example)?
@financialmodeling
@financialmodeling 4 жыл бұрын
The more relevant question for banks is not cash, but regulatory capital and specifically having enough Common Equity Tier 1 (CET 1) on hand to cover potential unexpected losses in the future. The main issue with recording a Provision for Credit Losses is that doing so reduces the bank's Net Income, and therefore reduces its CET 1 as well. This is a big problem because if CET 1 falls low enough, the bank will have to cut dividends, halt stock repurchases, and possibly raise additional capital, diluting existing shareholders. By themselves, loan defaults do not reduce a bank's cash balance because the loans are not in cash on the Balance Sheet... they're a separate line item. A falling cash balance is more of an issue for the Liquidity Coverage Ratio (LCR) and related metrics.
@benfrieden1921
@benfrieden1921 4 жыл бұрын
@@financialmodeling Got it, thanks for getting back to me on this and see what you are saying regarding regulatory capital and common equity tier 1 being reduced over time as the bank has to keep taking net income losses as they set aside provisions for loss - But as a follow up, there is ultimately some relation to cash balance correct? Here is my accounting logic below, but maybe I'm confused: Bank loans out $100, this is presumably an outflow of cash for (100) and an increase of 100 in loan receivables. Then they take make an addition to provision for loan losses of 50 and net charge off of (50), which reduces their net income, equity, and also reduces the net loan amount outstanding by (50) so the net loan balance is now 50. Lastly, when the bank gets paid back $50, their cash increases by $50 and net loan amount is written down to $0. Presumably, since they had cash outflow of $100 when they issued loan and cash inflow of $50 when they received the loan (or net loan amount), there is a net cash loss of ($50). Is my logic correct there? Thanks again for getting back to me on this - You guys are great!
@financialmodeling
@financialmodeling 4 жыл бұрын
@@benfrieden1921 No. An initial loan issuance for a bank just means that Gross Loans increases on the Assets side, and some L&E line item increases to balance the change on the other side. Banks issue Loans first, and then back them up with funding sources on the L&E side. It's not like letting a friend borrow cash from you. It really is all about Equity and CET 1 for a bank. If the bank receives back $50 of the loan, it may sit in cash temporarily, but the bank will then put the proceeds into another loan or some other interest-earning asset.
@lenfordmorris1407
@lenfordmorris1407 6 жыл бұрын
get stuff! but where can I get this excel doc? you said you were going to link it, but I dont see it!
@financialmodeling
@financialmodeling 6 жыл бұрын
Click "Show More". Scroll to the bottom. Click the links under "Resources."
@lenfordmorris1407
@lenfordmorris1407 6 жыл бұрын
thanks!!
@tareq1318
@tareq1318 6 жыл бұрын
Can you please explain interest suspense account of a bank to me? And why it comes under other liabilities?
@financialmodeling
@financialmodeling 6 жыл бұрын
Not familiar with it, but it looks like Investopedia, Wikipedia, etc. have decent explanations.
@tareq1318
@tareq1318 6 жыл бұрын
Mergers & Inquisitions / Breaking Into Wall Street alright thanks man. I dint really get much understanding from wiki and investopedia so thought you might know. Thanks anyway.
@unrealspetznaz
@unrealspetznaz 5 жыл бұрын
but, when someone "suddenly appears" and repays some of its debt, USD2 in the example at about min 13, how come that increases gross loans? if a debtor pays its debts, then they no longer owe you anything, and so you dont own a loan anymore. I am missing something!
@financialmodeling
@financialmodeling 5 жыл бұрын
Eventually, the Gross Loan balance will be reduced. This is just what happens immediately after the repayment of the Debt when the bank is required to record the change on its statements. If the debt is repaid, it must be viewed now as a valid Gross Loan just like all the other loans the bank has issued.
@unrealspetznaz
@unrealspetznaz 5 жыл бұрын
@@financialmodeling Thank you very much for the answer. Greatly appreciated :-)
@tavo25110
@tavo25110 4 жыл бұрын
@Mergers & Inquisitions / Breaking Into Wall Street Should we consider any tax effect from recoveries? How are recoveries reflected in the CF statement? It is clear from your video that recoveries are not included in the P/L but how do we translate the fact that we recovered a loan into the CF with is corresponding tax effect? Thanks in advance
@user-vz7nf5fb6d
@user-vz7nf5fb6d Жыл бұрын
Is it a regulatory requirement to create provisions for EACH loan that the bank has provided?
@financialmodeling
@financialmodeling Жыл бұрын
It is not necessarily a "regulatory requirement," as a bank just has to have enough equity capital on-hand to meet the requirements (and the same for the net stable funding and liquidity requirements), but it is a standard part of a bank's business to estimate the potential losses for each loan over its lifecycle, allocate them in the Allowance for Loan Losses, and change it over time as the loss expectations change.
@user-vz7nf5fb6d
@user-vz7nf5fb6d Жыл бұрын
@@financialmodeling thank you very much!
@karthik007
@karthik007 2 жыл бұрын
I still didn't get why recoveries would increase provision for credit losses ??
@financialmodeling
@financialmodeling 2 жыл бұрын
I'm not sure what you're referring to. Recoveries change the Net Charge-Off number and the Allowance for Loan Losses, but not the Provision for Credit Losses (at least, not directly). Indirectly, if Recoveries are higher than expected, a bank may reduce its Provision for CLs if it expects lower losses in the future.
@Vishal_Sharma1818
@Vishal_Sharma1818 3 жыл бұрын
Can you share this excel to my email
@financialmodeling
@financialmodeling 3 жыл бұрын
Click "Show More" and scroll to the links at the bottom.
@Vishal_Sharma1818
@Vishal_Sharma1818 3 жыл бұрын
@@financialmodeling your videos are very informative thanks for such nice work I never seen such a video with illustrative examples in excel Kudos to such hard and nice work
Free Cash Flow Conversion Analysis
15:05
Mergers & Inquisitions / Breaking Into Wall Street
Рет қаралды 24 М.
Auditing bank loans and borrowings
29:25
AmandaLovesToAudit
Рет қаралды 27 М.
Useful gadget for styling hair 🤩💖 #gadgets #hairstyle
00:20
FLIP FLOP Hacks
Рет қаралды 10 МЛН
ВОДА В СОЛО
00:20
⚡️КАН АНДРЕЙ⚡️
Рет қаралды 35 МЛН
Эффект Карбонаро и нестандартная коробка
01:00
История одного вокалиста
Рет қаралды 10 МЛН
Subscription Revenue Model (Netflix)
17:38
Mergers & Inquisitions / Breaking Into Wall Street
Рет қаралды 55 М.
Purchase Accounting for Noncontrolling Interests AKA Minority Interests
23:00
Mergers & Inquisitions / Breaking Into Wall Street
Рет қаралды 22 М.
Prof. Tobias Berg on Bank Leverage and Capital Regulation
10:56
Frankfurt School of Finance & Management
Рет қаралды 2,9 М.
Current Expected Credit Losses Methodology
15:19
FDICchannel
Рет қаралды 10 М.
Merger Model: Cash, Debt, and Stock Mix
19:59
Mergers & Inquisitions / Breaking Into Wall Street
Рет қаралды 70 М.
Key Financial Metrics and Ratios: ROA, ROE, and ROIC
24:13
Mergers & Inquisitions / Breaking Into Wall Street
Рет қаралды 187 М.
Valuation Multiples, Growth Rates, and Margins
22:41
Mergers & Inquisitions / Breaking Into Wall Street
Рет қаралды 50 М.
Non-Recurring Charges on the Income Statement
21:16
Mergers & Inquisitions / Breaking Into Wall Street
Рет қаралды 17 М.
Useful gadget for styling hair 🤩💖 #gadgets #hairstyle
00:20
FLIP FLOP Hacks
Рет қаралды 10 МЛН