Credit Analysis Pathway

Fundamentals 0/21 Playlists Completed

Financial Accounting Review

Accounting | 9 videos | 1 quiz
Why Analyze Financial Statements
1 of 10
03:29
Accounting Introduction - Financial Statements
2 of 10
02:13
Key Financial Statements and Dates
3 of 10
02:02
Balance Sheet Formula
4 of 10
01:11
Build a Simple Balance Sheet
5 of 10
05:25
Balance Sheet and Income Statement Transactions
6 of 10
05:40
Balance Sheet and Income Statement Transactions Workout
7 of 10
09:58
Financial Statement Integration
8 of 10
02:13
Cash Flow Statement Introduction and Why is Cash Important
9 of 10
02:23
Financial Accounting Review Tryout
10 of 10

Income Statement

Accounting | 22 videos | 1 quiz
Income Statement Introduction
1 of 23
00:56
Matching Principle Introduction
2 of 23
01:06
Matching Principle - Revenue Recognition
3 of 23
02:26
Matching Principle - Revenue Recognition Workout
4 of 23
01:53
Accounting for Revenue Workout
5 of 23
03:51
IS Presentation and Expenses
6 of 23
02:46
Matching Principle - Expenses Workout
7 of 23
02:26
Accounting for Expenses Workout
8 of 23
04:31
Operating Profit and EBIT
9 of 23
04:03
Cleaning EBIT and Finding Items in Financial Statements
10 of 23
03:57
Cleaning EBITDA Workout
11 of 23
02:07
Cleaning EBITDA Op Profit Not Provided Workout
12 of 23
02:44
Cleaning EBITDA With Footnotes Workout
13 of 23
04:28
Cleaning EBITDA Without Double Counting Workout
14 of 23
04:27
Cleaning EBITDA - Double Counting Depn
15 of 23
02:31
Cleaning EBITDA - Double Counting Depn Workout
16 of 23
03:33
Taxes - Marginal and Effective Tax Rates
17 of 23
01:58
Taxes - Marginal and Effective Tax Rates Workout
18 of 23
02:42
Taxes in the Financial Statements
19 of 23
01:07
Cleaning Net Income
20 of 23
04:05
Cleaning Net Income and Effective Tax Rate Workout
21 of 23
03:04
Case Study Income Statement
22 of 23
Income Statement Tryout
23 of 23

Earnings Per Share

Valuation | 12 videos | 1 quiz
Intro to EPS and its Importance
1 of 13
01:40
Basic vs. Diluted EPS
2 of 13
01:23
Basic EPS Calculation
3 of 13
03:41
Basic EPS with Preference Shares and NCI Workout
4 of 13
02:37
Basic EPS with Preference Shares and Share Issuance Workout
5 of 13
02:58
Diluted EPS Calculation
6 of 13
00:45
Value - Diluted Number of Shares
7 of 13
01:15
Diluted Shares and Options (Treasury Stock Method)
8 of 13
02:58
Diluted Shares and Options Workout
9 of 13
03:07
Diluted EPS, Options and Share Issuance Workout
10 of 13
04:10
Diluted EPS with Convertible Debt
11 of 13
01:30
Diluted EPS with Convertible Debt Workout
12 of 13
03:45
Earnings Per Share Tryout
13 of 13

Working Capital

Accounting | 21 videos | 1 quiz
Current Assets and Current Liabilities
1 of 22
01:01
Inventory Valuation
2 of 22
01:35
Inventory Valuation FIFO and LIFO
3 of 22
03:45
Inventory Valuation FIFO and LIFO Workout Q1
4 of 22
02:41
Inventory Valuation FIFO and LIFO Workout Q2
5 of 22
03:06
Inventory Valuation FIFO and LIFO Workout Q3
6 of 22
01:15
Inventory Valuation FIFO and LIFO Workout Q4
7 of 22
01:15
Inventory in the Financial Statements
8 of 22
01:30
Working Capital and Operating Working Capital
9 of 22
03:24
Working Capital Workout
10 of 22
01:12
Identifying Operating Items Workout
11 of 22
05:53
Operating Working Capital Workout
12 of 22
02:52
Operating Working Capital and Funding
13 of 22
03:43
Operating Working Capital and Cash Flow Impact
14 of 22
03:01
Operating Working Capital and Cash Flow Workout
15 of 22
04:52
Working Capital Days Ratios
16 of 22
02:57
Working Capital Days Ratios Workout
17 of 22
03:48
Working Capital Days Ratios Impact Funding
18 of 22
01:53
Working Capital Cycle
19 of 22
02:31
Working Capital Cycle Workout
20 of 22
02:17
Working Capital Includes Taxes
21 of 22
01:23
Working Capital Tryout
22 of 22

Non-Current Assets

Accounting | 13 videos | 1 quiz
Non-Current Assets Introduction
1 of 14
01:15
Forecasting PP&E
2 of 14
02:00
Forecasting PP&E Workout
3 of 14
03:16
Forecasting PP&E Depreciation Issue Workout
4 of 14
04:21
Depreciation
5 of 14
04:30
Gross vs. Net PP&E
6 of 14
02:27
Gross vs. Net PP&E Workout
7 of 14
03:34
Forecasting Intangibles
8 of 14
02:03
Forecasting Intangibles Workout
9 of 14
02:33
Gross vs. Net Intangibles Workout
10 of 14
03:24
Research and Development
11 of 14
01:52
Financial Investments
12 of 14
05:14
Non-Current Asset Metrics Workout
13 of 14
01:53
Non Current Assets Tryout
14 of 14

Capital Structure

Accounting | 18 videos | 1 quiz
Financing vs. Operating Items
1 of 19
01:25
Equity vs. Debt, and Leverage
2 of 19
04:41
Equity Items on the Balance Sheet
3 of 19
04:19
Which Share Count to use for Market Capitalization
4 of 19
02:15
Calculating Share Count Workout
5 of 19
02:16
Accounting for Share Transactions Workout
6 of 19
04:47
Free Float Shares
7 of 19
00:55
Forecasting Retained Earnings
8 of 19
02:22
Forecasting Retained Earnings Workout
9 of 19
02:54
Debt Products
10 of 19
03:27
Net Debt
11 of 19
02:06
Net Debt Workout
12 of 19
02:53
Interest, Debt Repayment and BS Presentation
13 of 19
04:40
PIK Interest and BS Presentation
14 of 19
03:01
PIK Interest Workout
15 of 19
01:36
Leverage Ratios
16 of 19
02:34
Leverage Ratios Workout
17 of 19
03:51
Case Study Capital Structure
18 of 19
Capital Structure Tryout
19 of 19

Accounting Ratios

Accounting | 16 videos | 1 quiz
Why Accounting Ratios Are Important
1 of 17
02:03
Profitability Ratios - Margins
2 of 17
01:17
Profitability Ratios - Earnings Per Share
3 of 17
01:40
Profitability Ratios - Case Study
4 of 17
04:18
Return Ratios - Return On Equity
5 of 17
01:37
Return Ratios - Return on Invested Capital
6 of 17
02:40
Return Ratios - Dividend Payout
7 of 17
01:35
Return Ratios - Case Study
8 of 17
02:46
Leverage Ratios
9 of 17
03:12
Leverage Ratios - Case Study
10 of 17
03:17
Liquidity Ratios - Operating Working Capital
11 of 17
02:38
Liquidity Ratios - OWC to Sales Ratio, Current Ratio, Cash Ratio
12 of 17
02:09
Liquidity Ratios - Working Capital Days
13 of 17
02:41
Liquidity Ratios - Case Study
14 of 17
04:21
Non-Current Asset Ratios
15 of 17
02:53
Non Current Asset Ratios - Case Study
16 of 17
02:18
Accounting Ratios Tryout
17 of 17

Cash Flow Statement

Accounting | 7 videos | 1 quiz
Identification and Categorization
1 of 8
04:23
Cash Flow Categories Workout
2 of 8
04:33
Reconciling Two Balance Sheets to Net Cash
3 of 8
03:51
Balance Sheet Items Impacted by Two Cash Flow Statement Items
4 of 8
02:13
Operating Working Capital in the Cash Flow Statement
5 of 8
01:00
Steps to Building a Cash Flow Statement
6 of 8
01:27
Building a Cash Flow Statement Workout
7 of 8
07:28
Cash Flow Statement Tryout
8 of 8

Equity Method Investments

Accounting | 4 videos
What are Equity Method Investments
1 of 4
01:29
Equity Method Accounting
2 of 4
02:49
BS and IS at Deal Date and Y1 Workout
3 of 4
03:37
Forecasting Equity Affiliate Workout
4 of 4
01:13

Introduction to Full Consolidation

Accounting | 21 videos | 1 quiz
M&A Accounting Overview
1 of 22
01:35
Balance Sheet Consolidation
2 of 22
03:06
Balance Sheet Consolidation Workout
3 of 22
02:53
Sources and Uses of Funds - Consolidation
4 of 22
01:03
Goodwill Calculation
5 of 22
02:22
Goodwill Workout
6 of 22
02:02
BS Consol, Sources Uses, GW Workout 1
7 of 22
03:53
Deal Goodwill and Asset Revaluation Workout
8 of 22
02:05
Deal Goodwill and Consolidated Goodwill Workout
9 of 22
03:45
IS Consolidation
10 of 22
01:13
IS Consolidation Workout
11 of 22
03:13
IS Consol With Mid Year Deal Date Workout
12 of 22
02:04
Spotting a Mid Year Deal in Multiples Workout
13 of 22
02:07
IS Consol With Stub Period Workout
14 of 22
04:23
NCI Value Over Time
15 of 22
02:22
NCI Value Over Time Workout
16 of 22
01:51
BS Consol and NCI - 2 Methods for Goodwill Calculation
17 of 22
03:14
BS Consol and NCI - FV of Net Assets Method Workout
18 of 22
05:23
BS Consol and NCI - Fair Value of NCI Method Workout
19 of 22
04:44
BS Consol and NCI - Methods Compared Workout
20 of 22
09:54
IS Consol and NCI Workout
21 of 22
04:39
Intro to Full Consolidation Tryout
22 of 22

Introduction to Modeling

Financial Modeling | 13 videos | 1 quiz
The Forecasting Process
1 of 14
01:35
Model Structure - Design Choices
2 of 14
04:00
IS, BS and CFS Integration
3 of 14
02:29
Forecast Model Simple 1
4 of 14
03:48
Forecast Model Simple 2 - IS and BS
5 of 14
02:52
Forecast Model Simple 2 - CFS Prep
6 of 14
03:04
Forecast Model Simple 2 - CFS Finish
7 of 14
03:18
Build the Forecast Balance Sheet - Back Up Calculations
8 of 14
02:57
Forecast Model Simple 3 - Intro and IS
9 of 14
03:36
Forecast Model Simple 3 - Balance Sheet
10 of 14
03:38
Forecast Model Simple 3 - BS Calcs
11 of 14
04:07
Forecast Model Simple 3 - CFS
12 of 14
04:29
Forecast Model Simple 3 - CFS Calcs and Finish
13 of 14
04:46
Introduction to Modeling Tryout
14 of 14

3 Statement Modeling with Iterations

Financial Modeling | 21 videos | 1 quiz
3 Statement Model Steps
1 of 22
03:25
Entering Historical Data
2 of 22
03:34
Model 1 Walkthrough
3 of 22
01:47
Model 1 Historical Data
4 of 22
03:59
Ratios and Forward Assumptions
5 of 22
02:24
Income Statement
6 of 22
03:03
Model 1 Income Statement
7 of 22
06:07
Balance Sheet
8 of 22
02:34
Model 1 Balance Sheet Calcs
9 of 22
05:28
Model 1 Balance Sheet
10 of 22
05:07
Cash Flow Statement
11 of 22
03:59
Model 1 Cash Flow Statement
12 of 22
06:08
Cash and Revolver
13 of 22
03:10
Model 1 Cash and Revolver
14 of 22
02:50
Interest Calculations
15 of 22
01:28
Model 1 Interest Calculations
16 of 22
03:16
Interest and Circular References
17 of 22
04:39
Model 1 Interest in Income Statement
18 of 22
05:27
Understanding Model Drivers
19 of 22
02:27
Model 1 Check Ratios and Statistics
20 of 22
03:21
Prepare for Handoff
21 of 22
02:44
Three Statement Modeling with Iteration Tryout
22 of 22

3 Statement Model Editing

Financial Modeling | 14 videos | 1 quiz
What To Do Before Editing
1 of 15
02:17
Inserting a New Item
2 of 15
03:10
Inserting a New Item - Example 1
3 of 15
05:36
Inserting a New Item - Example 2 (Plan the Edit)
4 of 15
02:33
Inserting a New Item - Example 2 (Do the Edit)
5 of 15
06:38
Removing an Old Item
6 of 15
01:51
Removing an Old Item - Example
7 of 15
04:37
After Editing
8 of 15
01:13
After Editing - Sense Check
9 of 15
02:36
After Editing - Structure Check
10 of 15
02:18
After Editing - Stress Check
11 of 15
01:49
After Editing - Example
12 of 15
03:52
Keyboard Shortcuts
13 of 15
02:41
Keyboard Shortcuts - Example
14 of 15
03:28
Three Statement Model Editing Tryout
15 of 15

Building a Model With Cash Sweep

Financial Modeling | 22 videos | 1 quiz
A 3 Statement Forecast Model
1 of 23
02:34
Model - Intro Walkthrough
2 of 23
01:24
Model - Entering Historical Data
3 of 23
05:55
Model - IS Revenue to EBITDA
4 of 23
02:47
Model - IS Finished
5 of 23
04:47
Model - Balance Sheet
6 of 23
03:02
Model - Balance Sheet Calcs
7 of 23
05:05
Model - Cash Flows From Operations and Investing
8 of 23
04:17
Model - Cash Flow Finished
9 of 23
02:53
Debt Calculations
10 of 23
01:15
Model - Cash to Service Debt
11 of 23
01:38
Cash Sweep - Revolver or Short Term Borrowings
12 of 23
02:56
Model - Cash Available for Accelerated Repayments
13 of 23
04:08
Cash Sweep - Mandated and Accelerated Payments
14 of 23
03:44
Model - Debt Tranche 1
15 of 23
04:44
Model - Debt Tranche 2
16 of 23
02:05
Model - Cash and Debt in Balance Sheet
17 of 23
03:32
Model - Debt Repayments Review
18 of 23
03:45
Iterative Interest Calculation
19 of 23
01:28
Model - Interest Calculation
20 of 23
02:31
Dealing With Circular References
21 of 23
05:32
Model - Income Statement Interest
22 of 23
03:49
Building a Model With Cash Sweep Tryout
23 of 23

Checking a Model for Integrity and Errors

Financial Modeling | 14 videos | 1 quiz
Error Checking Techniques and Shortcuts
1 of 15
04:17
Sense, Structure and Stress Check
2 of 15
03:21
Balance Sheet out of Balance
3 of 15
02:11
Model BS Unbalanced - Find the Figure
4 of 15
01:09
Model BS Unbalanced - Can't Find the Figure
5 of 15
02:06
Model Sense Check - Strange Trend 1
6 of 15
01:55
Model Sense Check - Strange Trend 2
7 of 15
01:53
Model Sense Check - Strange Trend 3
8 of 15
02:18
Model BS Unbalanced - Difference Repeats Each Year
9 of 15
02:19
Model BS Unbalanced - From Year 2 Onwards
10 of 15
01:47
Model Structure Check
11 of 15
01:34
Model - Circular Audit Tool 1
12 of 15
03:50
Model - Circular Audit Tool 2
13 of 15
02:48
Model - Multiple Errors
14 of 15
04:13
Checking a Model for Integrity and Errors Tryout
15 of 15

Credit Risk Overview

Credit Analysis | 8 videos | 1 quiz
How Banks Make Money
1 of 9
01:06
The Credit Perspective
2 of 9
01:47
How Bad Loans Affect Banks
3 of 9
01:52
Intro to the Credit Process
4 of 9
02:40
The 5 Cs of Credit
5 of 9
01:27
Quantifying Credit Risk
6 of 9
02:11
Default Risk
7 of 9
02:39
Loss Given Default Risk
8 of 9
03:50
Credit Risk Overview Tryout
9 of 9

Controlling Credit Risk

Credit Analysis | 11 videos | 1 quiz
Loan Documentation
1 of 12
02:15
Structuring the Loan
2 of 12
02:35
Type and Purpose of Loan
3 of 12
02:21
Paying for the Loan
4 of 12
04:44
Bank Return Workout 1
5 of 12
03:08
Bank Return Workout 2
6 of 12
04:56
Bank Return Workout 3
7 of 12
06:56
Protecting the Loan
8 of 12
02:14
Monitoring the Loan
9 of 12
02:22
Syndicating the Loan
10 of 12
04:55
Problem Loans
11 of 12
02:50
Controlling Credit Risk Tryout
12 of 12

Business Risk

Credit Analysis | 4 videos | 1 quiz
Understanding Business Risk
1 of 5
02:52
Company Risk
2 of 5
04:50
Management Risk
3 of 5
01:19
Estimating Business Risk
4 of 5
00:43
Business Risk Tryout
5 of 5

Financial Risk

Credit Analysis | 14 videos | 1 quiz
Balance Sheet Obligations
1 of 15
04:08
Debt Obligations Workout
2 of 15
02:51
Balance Sheet Assets
3 of 15
03:33
Income Statement and Profitability
4 of 15
02:13
EBIT EBITDA
5 of 15
02:25
Adjusting EBITDA Workout
6 of 15
09:04
Income Statement Metrics
7 of 15
02:47
Cash Flow 1 Overview
8 of 15
02:40
Cash flow 2 Operating Working Capital
9 of 15
03:48
Cash Flow 3 Cash Flow Metrics
10 of 15
03:40
Cash Flow Metrics
11 of 15
03:14
Liquidity and Flexibility
12 of 15
05:32
Liquidity 1
13 of 15
01:48
Liquidity 2
14 of 15
04:23
Financial Risk Tryout
15 of 15

Debt Capacity

Credit Analysis | 11 videos | 1 quiz
Debt Capacity Overview
1 of 12
02:50
Cash Flow Based Debt Capacity
2 of 12
03:26
Creating Cash Flow Scenarios
3 of 12
01:51
Amortizing the Loan
4 of 12
01:46
Creating Tranches
5 of 12
01:29
Modeling Credit Scenarios Part 1 Workout
6 of 12
05:53
Modeling Credit Scenarios Part 2 Workout
7 of 12
04:13
Modeling Credit Scenarios Part 3 Workout
8 of 12
01:51
Debt Capacity With Scenarios TLa
9 of 12
02:59
Debt Capacity With Scenarios TLa and TLb
10 of 12
05:26
Amortization Workout
11 of 12
04:28
Debt Capacity Tryout
12 of 12

Credit Analysis Case in Point

Credit Analysis | 18 videos
Introduction Part 1
1 of 18
02:23
Introduction Part 2
2 of 18
02:49
Business Risk
3 of 18
02:44
Financial Risk
4 of 18
00:47
Debt and Other Obligations
5 of 18
01:52
Debt and Other Obligations Review
6 of 18
00:52
Working Capital
7 of 18
02:26
EBITDA and Margins Analysis
8 of 18
00:56
EBITDA Adjustments
9 of 18
02:02
EBITDA Adjustments Review
10 of 18
00:40
Cash Flow Calculations
11 of 18
02:52
Cash Flow Review
12 of 18
01:00
Liquidity Analysis
13 of 18
03:19
Financial Risk Summary
14 of 18
01:17
Debt Capacity Introduction
15 of 18
01:49
Debt Capacity Calculations
16 of 18
05:26
Debt Capacity Review
17 of 18
01:39
Case Summary
18 of 18
02:51
Intermediate 0/3 Playlists Completed

13 Week Cash Flow Modeling Scenarios

Financial Modeling | 14 videos
Introduction
1 of 14
05:33
Accrual to Cash
2 of 14
03:03
What the Model Tells Us
3 of 14
03:36
Case in Point - True Religion Apparel
4 of 14
06:32
True Religion - Accrual to Cash
5 of 14
03:01
Cash Receipts
6 of 14
04:32
Cash Receipts Workout
7 of 14
02:59
Cash to Suppliers
8 of 14
06:09
Cash to Suppliers Workout
9 of 14
05:20
Cash Wages
10 of 14
03:36
Cash Wages Workout
11 of 14
03:08
Other Operational Disbursements
12 of 14
04:28
Financing Implications
13 of 14
07:14
Case Summary
14 of 14
03:12

Building a 13 Week Cash Flow Model

Financial Modeling | 17 videos
Case in Point SGC Intro
1 of 17
04:42
Building the Model
2 of 17
06:09
Step 0 Model Introduction
3 of 17
08:00
Step 1 Convert Monthly IS to Weekly
4 of 17
11:14
Step 1b Convert Monthly IS to Weekly - Expenses
5 of 17
12:28
Step 2 Calculating OWC Rollforwards - AR
6 of 17
08:33
Step 2b Calculating OWC Rollforwards - Inv AP
7 of 17
07:38
Step 2c Calculating OWC Rollforwards - Wages
8 of 17
05:59
Step 3 PPE
9 of 17
04:11
Step 4 Revolver Base
10 of 17
08:46
Step 5 13 Week CFS
11 of 17
06:24
Step 6 Cash Reconciliation
12 of 17
05:49
Step 7 Calculating the Revolver
13 of 17
17:43
Step 8 Debt and Interest
14 of 17
07:11
Step 9 Summary BS
15 of 17
03:38
Step 10 Reconciling EBITDA to CF
16 of 17
07:09
Case in Point Summary
17 of 17
02:00

Distressed Debt Restructuring

Credit Analysis | 11 videos
Introduction Summary
1 of 11
12:20
Case in Point Walk Through
2 of 11
02:29
Debt Capacity Exercise
3 of 11
05:09
Comparables Exercise
4 of 11
04:32
Liquidation Value Exercise
5 of 11
03:17
Debt Restructuring Exercise
6 of 11
06:41
Liquidation Analysis
7 of 11
03:03
Debrief Part 1
8 of 11
03:19
Debrief Part 2
9 of 11
04:39
Debrief Part 3
10 of 11
03:51
Debrief Part 4
11 of 11
08:12