360° Financial Modeling & Valuation Course

4 Hours

Deal Price$24.99

Suggested Price$75.00

You save 66%

46 Lessons (4h)

Your First Program
Preview

Downloadable Practice Sheet
Practice Problem
OVERVIEW OF FINANCIAL MODELING
Course Introduction4:01
Financial Statement Analysis- Breaking Down3:46
Working with Financial statements - Part 16:02
Activity - Basic Level5:39
Working with Financial statements - Part 21:49
Activity - Advance Level5:05
Ratio Analysis Overview10:35
Valuation Overview6:02
Relative Valuation Overview5:59
INCOME STATEMENT
Creating an Income Statement5:16
Continuing with assumptions3:57
Building the format of the Income Statement4:25
Building Formulas to Forecast Tax Expense and Minority Interest line Item2:37
Working with CAGR Calculation4:17
REVENUE MODEL
Overview of the Revenue Model6:25
Building a Revenue Model5:55
Calculating Average Revenue Per Store5:47
BALANCE SHEET
Constructing Balance Sheet Format_15:03
Developing Balance Sheet and its Elements7:10
Working with CAGR and Trend Analysis Calculation5:43
Building Assumption for the Asset Side of the Balance Sheet9:41
Forecasting the Balance Sheet for the Liability Side6:40
Other Liability Items10:29
CASH FLOW STATEMENT
Introduction to the Cash Flow Statement10:08
Designing and Structuring the Cash Flow Statement6:31
Linking the Line Items in the cashflow6:52
Add End 03
WORKING CAPITAL AND CAPEX & DEPREICIATION
Dealing with Working Capital, Capex, and Depreciation (WCCD)6:57
Getting the Format Ready - Approach 13:53
Building Formula for Each Line Item4:37
Getting the Format Ready - Approach 25:55
Forecasting Current Assets10:59
Creating a Waterfall Formula2:48
Forecasting Line items in the Working Capital Calculations6:13
Forecasting Working Captical Schedule6:00
Forecasting Capex and Depreciation Schedule11:44
DCF VALUATION
Introduction to DCF Method5:11
Forecasting of the Dividend Schedule3:49
Valuation6:08
Compounding, Discounting and Layers of Complexity of the DCF4:16
Calculating the Cost of Each Capital10:02
Building the Valuation Sheet10:41
Calculating the Cash Flows Related to DCF5:49
Building Sensitivity Analysis and Schedule of Valuation8:15
Session Conclusion11:45

DescriptionInstructorImportant DetailsRelated Products

A 4-Hour Instruction Course to Learn Industry Best Practices & Common Pitfalls in Financial Modeling

Yoda Learning
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.

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

Specs

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
Have questions on how digital purchases work? Learn more here

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.

Your Cart

Your cart is empty. Continue Shopping!

Processing order...