Skip to main content
Test Uni Product
Program overview
lorem ipsum dolor sit amet consectetur adipiscing elit fugiat irure sint imperdiet soluta quibusdam distinctio distinctio ducimus fugiat id et blanditiis voluptate eum voluptate dolore eu rerum iusto cillum officia dolor at officia eos deleniti dolor assumenda adipiscing quas dolorem sint exercitation adipiscing omnis est placeat ipsum ullamco fugiat id
What's Included
Course 1: Accounting Crash Course
This course is designed to efficiently teach accounting to students and professionals embarking on c ...
Course TOC
Accounting Crash Course
This course is designed to efficiently teach accounting to students and professionals embarking on careers in finance. The course is written in a clear, easy-to-follow style that makes accounting accessible, and is filled with exercises that test and reinforce covered concepts. We begin with an anal ...
This course is designed to efficiently teach accounting to students and professionals embarking on careers in finance. The course is written in a clear, easy-to-follow style that makes accounting accessible, and is filled with exercises that test and reinforce covered concepts. We begin with an analysis of accounting rules and the structure and composition of key financial filings like 10Ks and 10Qs. We introduce the income statement, balance sheet, cash flow statement, and thoroughly analyze their important inter-relationships, line-by-line, all the while using real life examples to reinforce important concepts. The course concludes with a discussion of ratio analysis.
1.
Course Downloads
Files
2.
Overview: Why is Accounting Important?
Video,
9:54
3.
Basic Accounting Principles
Video,
14:05
4.
Financial Reportings & Important Filings
Video,
6:32
5.
Reading the 10K
Video,
7:47
6.
Accounting Introduction Review
Quiz
7.
Revenue
Video,
6:15
8.
Revenue Recognition
Video,
8:38
9.
Revenue Manipulation
Video,
3:13
10.
COGS & Gross Profit
Video,
10:09
11.
Selling, General & Administrative, Research & Development Expenses
Video,
5:10
12.
Depreciation
Video,
12:13
13.
Amortization
Video,
9:26
14.
Other Operating Expenses
Video,
9:14
15.
Interest Expense and Interest Income
Video,
2:28
16.
Other Non-Operating Items
Video,
6:12
17.
Tax Expense
Video,
3:37
18.
Net Income, EPS & Dividends
Video,
10:07
19.
EBIT, EBITDA & Income Statement Summary
Video,
7:35
20.
The Lemonade Stand, Part 1
Video,
8:10
21.
The Lemonade Stand, Part 2
Video,
3:43
22.
Income Statement Review
Quiz
23.
Stock Based Compensation Expense
Video,
5:20
24.
An Introduction to Assets
Video,
7:46
25.
An Introduction to Liabilities
Video,
7:37
26.
Double Entry Accounting
Video,
10:49
27.
How the Income Statement Connects to the Balance Sheet
Video,
9:42
28.
The Lemonade Stand Revisited
Video,
9:30
29.
How Assets & Liabilities are Presented
Video,
4:07
30.
Intro to the Balance Sheet Review
Quiz
31.
Cash, Receivables & Prepaid Expenses
Video,
8:22
32.
Inventory
Video,
21:33
33.
Property, Plant & Equipment, Part 1
Video,
12:29
34.
Property, Plant & Equipment, Part 2
Video,
8:14
35.
Intangible Assets & Goodwill
Video,
12:34
36.
Assets Review
Quiz
37.
Payable, Accrued Expenses, Deferred Revenue & Debt
Video,
13:47
38.
Lease Accounting Overview
Video,
3:10
39.
Finance Leases, Part 1
Video,
6:47
40.
Finance Leases, Part 2
Video,
5:51
41.
Operating Leases
Video,
7:13
42.
Lease Accounting Example
Video,
3:46
43.
Equity
Video,
19:11
44.
The Lemonade Stand, Part 3
Video,
30:43
45.
Balance Sheet Review
Quiz
46.
The Cash Flow Statement
Video,
11:59
47.
Cash From Operations
Video,
13:08
48.
Cash From Financing & Cash From Investing
Video,
7:19
49.
[Test Gaga] Lesson 2
Video,
0:05
50.
The Lemonade Stand, Part 4
Video,
7:21
51.
Cash Flow Statement Review
Quiz
52.
Working Capital 101
Reading
53.
Financial Statement Analysis
Video,
24:06
54.
Test Video 3
Video,
0:05
55.
Financial Statement Analysis Review
Quiz
56.
The SUCCES Framework Introduction
Video,
2:31
57.
Accounting Crash Course Welcome
Video,
1:30
Course 2: Excel Crash Course
For finance professionals, proficiency in Excel is a fundamental part of the job description. Whethe ...
Course TOC
Excel Crash Course
For finance professionals, proficiency in Excel is a fundamental part of the job description. Whether you currently work in Excel at a beginner or intermediate level, this course will take you to the next level and turn you into an advanced "power" user. We'll start with the basics before we quickly ...
For finance professionals, proficiency in Excel is a fundamental part of the job description. Whether you currently work in Excel at a beginner or intermediate level, this course will take you to the next level and turn you into an advanced "power" user. We'll start with the basics before we quickly introduce you to lesser known time-saving keyboard shortcuts and powerful Excel functions and features that you can immediately put to use on the job. The only way to learn Excel is by doing, so you'll be completing Excel exercises alongside the instructor at every step of the way.
1.
Getting Started
Video,
9:12
2.
Course Downloads
Files
3.
Excel for Mac Quick Setup
Video,
8:08
4.
Using the Keyboard to Navigate the Excel Ribbon
Video,
5:13
5.
Ribbon Layout
Video,
4:51
6.
Excel Settings
Video,
7:57
7.
Excel Basics Review
Quiz
8.
Basic Excel Shortcuts, Navigation & Editing
Video,
7:22
9.
Basic Formatting
Video,
4:54
10.
Referencing Cells from Other Worksheets
Video,
4:34
11.
Navigation to Referencing Cells from Other Workbooks
Video,
1:27
12.
Navigation Within Excel Review
Quiz
13.
Splitting & Freezing Panes
Video,
4:12
14.
Entering & Editing Data
Video,
7:57
15.
Columns & Rows
Video,
6:31
16.
Paste Special
Video,
9:52
17.
Ctrl Shortcuts
Video,
1:28
18.
Naming Cells
Video,
3:11
19.
Anchoring Cells
Video,
3:32
20.
Naming Worksheets
Video,
1:10
21.
Grouping & Hiding Columns & Rows
Video,
3:12
22.
Grouping Workbooks
Video,
2:44
23.
Formula Auditing
Video,
6:50
24.
Cell Alignment & Center Across Selection
Video,
2:56
25.
Go To Special
Video,
4:12
26.
Conditional Formatting
Video,
10:16
27.
Creating Dynamic Headers, Custom Formatting & the TEXT Function
Video,
7:41
28.
More on Custom Formatting
Video,
15:46
29.
#Ref, #Div/0! & Other Excel Errors
Video,
2:54
30.
Find and Replace
Video,
2:33
31.
Page layout
Video,
6:31
32.
Entering/Editing Data Review
Quiz
33.
Introduction to Functions: SUM & Average
Video,
3:03
34.
Simple & Nested IF Statements
Video,
9:58
35.
IFS statement (2016+ only)
Video,
7:14
36.
IFERROR & Concatenation
Video,
7:58
37.
Date Functions: EOMONTH & EDATE
Video,
5:26
38.
ISNUMBER, ISTEXT & Combining with IF to Create Overrides
Video,
7:10
39.
More Date Functions: YEARFRAC, DAY, MONTH, YEAR & DATE
Video,
6:26
40.
AND & OR Functions
Video,
6:17
41.
Logical Functions Review
Quiz
42.
HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX Functions
Video,
10:45
43.
Common Errors with HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX
Video,
2:47
44.
The MATCH Function
Video,
3:29
45.
Combining H/VLOOKUP, OFFSET, INDEX, CHOOSE with MATCH
Video,
13:51
46.
Combining INDIRECT with &
Video,
8:12
47.
Creating Drop Down Menus with Data Validation
Video,
2:59
48.
Combining INDIRECT with MATCH
Video,
6:54
49.
The Address Function
Video,
7:36
50.
Using COLUMN and ROW Functions as Counters in Complex Formulas
Video,
7:06
51.
Data Tables
Video,
13:52
52.
When Data Tables Fail: Self Referencing IF Statement
Video,
8:01
53.
XLOOKUP: Why it Rocks
Video,
8:46
54.
Nested (Two-Way) XLOOKUP vs INDEX MATCH
Video,
5:26
55.
Using XLOOKUP to Generate Multiple Values
Video,
2:21
56.
Scenario Analysis Using XLOOKUP
Video,
4:46
57.
Where XLOOKUP Loses To INDEX MATCH
Video,
11:39
58.
Lookup Functions & Data Tables Review
Quiz
59.
The SUMPRODUCT Function
Video,
4:28
60.
Advanced SUMPRODUCT: Adding Criteria & Booleans in Excel
Video,
13:06
61.
SUMIF/S & AVERAGEIF/S
Video,
8:22
62.
CEILING, FLOOR & ABS Functions
Video,
1:36
63.
ROUND, ROUNDUP, ROUNDDOWN & COMBIN Function
Video,
3:52
64.
The MIN & MAX Functions
Video,
2:50
65.
COUNT/A & COUNTIF/S Functions
Video,
5:01
66.
Present Value & Future Value Functions
Video,
6:44
67.
NPV & XNPV Functions
Video,
7:29
68.
IRR & XIRR Functions
Video,
3:18
69.
Mathematical Functions Review
Quiz
70.
Text Functions (LEN, LEFT, RIGHT, MID, REPLACE, etc.)
Video,
7:59
71.
Using Text Functions to Solve Data Extraction Challenges
Video,
7:48
72.
Flash Fill (Excel 2013 Only)
Video,
2:47
73.
Text to Columns
Video,
6:23
74.
Remove Duplicates
Video,
1:57
75.
VALUE and DATEVALUE
Video,
4:07
76.
Sort & Subtotal
Video,
4:16
77.
Autofilter
Video,
4:09
78.
Pivot Tables, Part 1
Video,
9:11
79.
Pivot Tables, Part 2
Video,
8:00
80.
The fiscal half date problem
Video,
9:22
81.
The Olympic event problem
Video,
16:13
82.
Conclusion
Video,
0:23
83.
Create your first LAMBDA function
Video,
7:35
84.
LAMBDA: Create a CAGR function
Video,
4:52
85.
LAMBDA: Create a DSO function
Video,
3:32
86.
LAMBDA: The =IMPLIEDG() function
Video,
4:18
87.
LAMBDA: The =EOQUARTER() function
Video,
8:12
88.
LAMBDA: The =TSM() function
Video,
8:16
89.
LAMBDA: The =SHEETNAME() function
Video,
2:51
90.
Using LAMBDA functions across multiple workbooks
Video,
2:48
91.
VBA & Macros in Excel
Video,
7:07
Course 3: DCF Modeling
Building on the knowledge gained from the financial statement modeling course, you will be introduce ...
Course TOC
DCF Modeling
Building on the knowledge gained from the financial statement modeling course, you will be introduced to valuation analysis in general, and the DCF model in particular. We will continue to use Apple as the case study, and teach you how to value the company step-by-step. Along the way, you will learn ...
Building on the knowledge gained from the financial statement modeling course, you will be introduced to valuation analysis in general, and the DCF model in particular. We will continue to use Apple as the case study, and teach you how to value the company step-by-step. Along the way, you will learn how to estimate the weighted average cost of capital (WACC) in the real world, how to implement commonly used approaches to calculating terminal value, and all the nuances of DCF modeling. Finally, we will use data tables to analyze a broad range of scenarios given different assumptions.
1.
DCF Modeling Course Welcome
Video,
0:51
2.
Course Downloads
Files
3.
Introduction
Video,
4:38
4.
Enterprise Value vs. Equity Value
Video,
6:56
5.
Book Value vs. Market Value
Video,
2:51
6.
Cash Flow vs. Relative Valuation
Video,
1:46
7.
DCF Overview
Video,
9:17
8.
The 2 Stage DCF Approach
Video,
6:25
9.
DCF vs. Comps in the Real World, Part 1
Video,
9:10
10.
DCF vs. Comps in the Real World, Part 2
Video,
3:18
11.
Unlevered vs. Levered DCF Approach
Video,
12:09
12.
Unlevered vs. Levered Concept Check
Video,
2:46
13.
DCF Implementation
Video,
5:42
14.
DCF Modeling Integrated vs Standalone
Video,
2:29
15.
DCF Model Sections Preview
Video,
1:28
16.
Date and General Model inputs
Video,
4:33
17.
Inputting Historical UFCFs
Video,
2:44
18.
Estimating Unlevered Taxes
Video,
6:06
19.
From Historical NOPAT to UFCF
Video,
4:03
20.
Forecasting Unlevered Free Cash Flows
Video,
2:31
21.
UFCF Forecasting Mechanics
Video,
6:33
22.
Forecasting Working Capital
Video,
2:34
23.
Discounting Unlevered Free Cash Flows
Video,
5:15
24.
Stub Year Fraction
Video,
3:02
25.
Terminal Value - Perpetuity Method
Video,
5:49
26.
TV as percent of total and implied multiple
Video,
2:13
27.
Exit Multiple Concepts
Video,
4:24
28.
Terminal Value - Exit Multiple Approach
Video,
3:17
29.
Calculating the Implied Growth Rate
Video,
7:48
30.
Before We Continue Model Review So Far
Video,
3:40
31.
Understanding Net Debt
Video,
13:47
32.
Modeling Net Debt
Video,
7:38
33.
From enterprise value to Equity value
Video,
5:36
34.
Shares Outstanding Overview
Video,
11:08
35.
Restricted Stock or RSUs in the Share Count
Video,
5:23
36.
Modeling Basic Shares Outstanding and RSUs
Video,
5:39
37.
Calculating Valuation Multiples
Video,
2:43
38.
Model Output DCF Sensitivity Tables
Video,
10:57
39.
Model Presentation and Football Field
Video,
5:59
40.
Modeling the Midyear Convention
Video,
6:28
41.
Adding a Midyear Convention Toggle
Video,
3:35
42.
Midyear Adjustment Impact on TV
Video,
1:18
43.
Stock Options in the Share Count
Video,
14:38
44.
Stock Splits and Dual Classes
Video,
3:16
45.
Convertible Securities Share Impact
Video,
2:50
46.
If-Converted Method
Video,
5:29
47.
Convertible Debt - Tesla Example
Video,
4:01
48.
Convertible Preferred Terminology
Video,
1:19
49.
Modeling Stock Options
Video,
7:03
50.
Modeling Convertible Debt
Video,
6:58
51.
Modeling Convertible Preferred Stock
Video,
3:10
52.
WACC Concepts, Part 1
Video,
12:14
53.
WACC Concepts, Part 2
Video,
5:53
54.
WACC Concepts, Part 3
Video,
5:13
55.
WACC Concepts, Part 4
Video,
6:49
56.
Modeling WACC Cost of Equity and Debt
Video,
10:04
57.
Modeling WACC Capital Weights
Video,
4:37
58.
Connecting the DCF to 3 Statement Model
Video,
10:48
59.
Calculating LTM Data
Video,
4:41
60.
Industry Beta Concepts
Video,
9:12
61.
Industry Beta Exercise
Video,
3:32
62.
Negative Net Debt
Video,
7:37
63.
Normalizing Terminal Year Free Cash Flows
Video,
5:44
64.
Value Drivers
Video,
16:55
65.
Finding Cost of Debt on Bloomberg
Video,
3:34
66.
Finding Beta on Bloomberg
Video,
1:21
Wall Street Prep is the trusted training provider for the world's top investment banks, private equity firms, Fortune 1000 companies and business schools. Our online training and instructor-led boot camps are direct adaptations of our corporate training, making Wall Street Prep the ideal choice for those looking to break into finance.