Ending In:
Certification Included
access
Lifetime
content
4.0 Hours
Description
Don’t just learn how to develop financial statements and theories behind the valuation. Learn the techniques that wow industry leaders and become hot in the job market with this 360° Financial Modeling & Valuation course. With 4 hours of video content, you'll get a great overview of financial modeling and how to build client-ready deliverables from scratch. You'll learn formatting protocols, statements, forecast drivers, and more.
- Access 46 lectures & 4 hours of content 24/7
- Build a 3-statement financial model with valuation in 3 phases
- Build client-ready deliverables from scratch
- Become better with Excel shortcuts, industry best practices, time-saving tips & more
- Create a report-like presentation
- Complement your statements with CAGR, Horizontal & Vertical Analysis
- Learn the fundamental drivers of each line-item in their respective schedules
- Perform Discounted Cash Flow Valuation where you learn to calculate FCFF & WACC
Yoda Learning
4.3/5 Instructor Rating
★ ★ ★ ★
★
Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certificate of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: intermediate
Requirements
- Any device with basic specifications
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Course Outline
- Your First Program
- Downloadable Practice Sheet
- Practice Problem
- OVERVIEW OF FINANCIAL MODELING
- Course Introduction - 4:01
- Financial Statement Analysis- Breaking Down - 3:46
- Working with Financial statements - Part 1 - 6:02
- Activity - Basic Level - 5:39
- Working with Financial statements - Part 2 - 1:49
- Activity - Advance Level - 5:05
- Ratio Analysis Overview - 10:35
- Valuation Overview - 6:02
- Relative Valuation Overview - 5:59
- INCOME STATEMENT
- Creating an Income Statement - 5:16
- Continuing with assumptions - 3:57
- Building the format of the Income Statement - 4:25
- Building Formulas to Forecast Tax Expense and Minority Interest line Item - 2:37
- Working with CAGR Calculation - 4:17
- REVENUE MODEL
- Overview of the Revenue Model - 6:25
- Building a Revenue Model - 5:55
- Calculating Average Revenue Per Store - 5:47
- BALANCE SHEET
- Constructing Balance Sheet Format_1 - 5:03
- Developing Balance Sheet and its Elements - 7:10
- Working with CAGR and Trend Analysis Calculation - 5:43
- Building Assumption for the Asset Side of the Balance Sheet - 9:41
- Forecasting the Balance Sheet for the Liability Side - 6:40
- Other Liability Items - 10:29
- CASH FLOW STATEMENT
- Introduction to the Cash Flow Statement - 10:08
- Designing and Structuring the Cash Flow Statement - 6:31
- Linking the Line Items in the cashflow - 6:52
- Add End 03
- WORKING CAPITAL AND CAPEX & DEPREICIATION
- Dealing with Working Capital, Capex, and Depreciation (WCCD) - 6:57
- Getting the Format Ready - Approach 1 - 3:53
- Building Formula for Each Line Item - 4:37
- Getting the Format Ready - Approach 2 - 5:55
- Forecasting Current Assets - 10:59
- Creating a Waterfall Formula - 2:48
- Forecasting Line items in the Working Capital Calculations - 6:13
- Forecasting Working Captical Schedule - 6:00
- Forecasting Capex and Depreciation Schedule - 11:44
- DCF VALUATION
- Introduction to DCF Method - 5:11
- Forecasting of the Dividend Schedule - 3:49
- Valuation - 6:08
- Compounding, Discounting and Layers of Complexity of the DCF - 4:16
- Calculating the Cost of Each Capital - 10:02
- Building the Valuation Sheet - 10:41
- Calculating the Cash Flows Related to DCF - 5:49
- Building Sensitivity Analysis and Schedule of Valuation - 8:15
- Session Conclusion - 11:45
access
Lifetime
content
4.0 Hours