-
Package: Bank Financial Modeling
- Package: Intensive Accounting Boot Camp
- Package 1: Basic & Fundamental Concepts
- Package 2: Core Fundamental Concepts
- Package 3: Advanced Financial Modeling
- Package 4: Valuation Modeling Topics
- Package 5: Merger Modeling Topics
- Package 6: Leveraged Buyout Modeling
- Package: Technical Applications - Excel
- Package: Private Company Valuation
- Package: Super-Complex M&A LBO Modeling
- Package: Distressed Financial Modeling
- Package: Bank Financial Modeling
- Package: Insurance Financial Modeling
- Package: Real Estate Development Modeling
- Package: REIT Financial Modeling
- Package: Buy-Side Series
- Overview of Financial Markets + Exhibits
- Verification
- Certification
Package: Bank Financial Modeling
Banks, similar to insurance companies, play by a different set of accounting rules in which the normal approach of building financial models don't apply (such as revenue growth, COGS and SG&A, % of revenue, BS and days outstanding working capital). When it comes to balance sheet based companies, it's a whole other world out there, so strap in and get ready! But don't worry, we'll take it easy with a detailed commercial bank industry primer and overview to familiarize ourselves with the new terminology and then tee you up methodically to before diving into the complex stuff.
Courses
- Bank Industry Primer (4 post(s))
- Basic Bank Financial Modeling (0 post(s))
- Intermediate Bank Financial Modeling (0 post(s))
- Advanced Bank Financial Modeling (14 post(s))
Last 10 posts
Multi currency model
Do you have inputs on modeling multicurrency statements
Do you have inputs on modeling multicurrency statements
Cost of Funding
When estimating my cost of funding, for the purpose of determining my borrowing cost, (and ultimately my yield) because Yield is normally desired NIM+ FC what are the items that should be considered? is it the same as WACC calculation?
When estimating my cost of funding, for the purpose of determining my borrowing cost, (and ultimately my yield) because Yield is normally desired NIM+ FC what are the items that should be considered? is it the same as WACC calculation?
Liquidity and Cash reserve requirements
How do we account for liquidity/reserve requirement in the model. Should I reduce my funding available for lending by the reserve/liquidity requirement?
How do we account for liquidity/reserve requirement in the model. Should I reduce my funding available for lending by the reserve/liquidity requirement?
Provisioning IFRS 9
How will the model be affected by IFRS 9 standard on the calculation of Expected Credit Losses. ECL
How will the model be affected by IFRS 9 standard on the calculation of Expected Credit Losses. ECL
Completed work sheet
It would be useful to have a completed worksheet of the model. It is not always easy to follow the instructions. Is it possible you can send a completed model for the advanced model. Thanks. Fanar
It would be useful to have a completed worksheet of the model. It is not always easy to follow the instructions. Is it possible you can send a completed model for the advanced model. Thanks. Fanar
Overview and Terminology (banks primer) does not load - says "cannot load M3U8 404 not found"
x
x
Bank Modeling
My query pertains to the accounting for credit losses for banks. When there is a recovery by a bank, it should reduce the provision expense on the income statement and also reduce the loan reserve. Per the provision for credit losses video, recoveries increase the loan reserve balance on the balance... Read More
My query pertains to the accounting for credit losses for banks. When there is a recovery by a bank, it should reduce the provision expense on the income statement and also reduce the loan reserve. Per the provision for credit losses video, recoveries increase the loan reserve balance on the balance... Read More
what are the valuation method for non publicly traded banks ?