NEW! FREE 30 Minutes MS Excel - Working with Dates Course  Watch now 

FINANCIAL MODELING

Learn the Top 15 techniques to create dynamic Business Models for Project Evaluation.

This Course includes:

Nip_Fab_testimonial_page_1.png
“I am very impressed with Yoda Learning courses – I particularly like the short videos that allow me to get to a topic quickly and the other gem is the shortcuts.”

Course Curriculum

0101 Course Introduction
0102 Financial Statement Analysis- Breaking Down
0103 Working with Financial statements – Part 1
0104 Activity – Basic Level
0105 Working with Financial statements – Part 2
0106 Activity – Advance Level
0107 Ratio Analysis Overview
0108 Valuation Overview
0109 Relative Valuation Overview

Download Course Curriculum

0201 Creating an Income Statement
0202 Continuing with assumptions
0203 Building the format of the Income Statement
0204 Building Formulas to Forecast Tax Expense and Minority Interest line Item
0205 Working with CAGR Calculation

Download Course Curriculum

0301 Overview of the Revenue Model
0302 Building a Revenue Model
0303 Calculating Average Revenue Per Store

Download Course Curriculum

0401 Constructing Balance Sheet Format_1
0402 Developing Balance Sheet and its Elements
0403 Working with CAGR and Trend Analysis Calculation
0404 Building Assumption for the Asset Side of the Balance Sheet
0405 Forecasting the Balance Sheet for the Liability Side
0406 Other Liability Items

Download Course Curriculum

0501 Introduction to the Cash Flow Statement
0502 Designing and Structuring the Cash Flow Statement
0503 Linking the Line Items in the cashflow

Download Course Curriculum

0601 Dealing with Working Capital, Capex, and Depreciation (WCCD)
0602 Getting the Format Ready – Approach 1
0603 Building Formula for Each Line Item
0604 Getting the Format Ready – Approach 2
0605 Forecasting Current Assets
0606 Creating a Waterfall Formula
0607 Forecasting Line items in the Working Capital Calculations
0608 Forecasting Working Captial Schedule
0609 Forecasting Capex and Depreciation Schedule

Download Course Curriculum

0701 Introduction to DCF Method
0702 Forecasting of the Dividend Schedule
0703 Valuation
0704 Compounding, Discounting, and Layers of Complexity of the DCF
0705 Calculating the Cost of Each Capital
0706 Building the Valuation Sheet
0707 Calculating the Cash Flows Related to DCF
0708 Building Sensitivity Analysis and Schedule of Valuation
0709 Session Conclusion

Download Course Curriculum

COURSE INSTRUCTOR

Rishabh Pugalia

Course Narrator

Worked with KPMG, and became a Chartered Accountant
Traded Interest Rate Futures, and then worked with J.P. Morgan (Fixed Income)

We’ve helped over 7,800 learners overcome their learning “plateau”...

Don’t take my word for it – check out this feedback from some of the professionals representing virtually every business domain, background and experience level…
“I am very impressed with Yoda Learning courses – I particularly like the short videos that allow me to get to a topic quickly and the other gem is the shortcuts.”
Peter Klugsberger - Yodalearning Student
Peter Klugsberger
Mckinsey & Company
“The courses are not only technically very knowledgeable, but also genuinely helpful for professionals who want to work smarter, not harder.”
Karnika Bhalla - Yoda Learning Student
Karnika Bhalla
Delloite
“The training curriculum and course was extremely well designed, thorough and catered to use cases relevant to our domain of work.”
Yoshika Chhabra
Yoshika Chhabra
E & Y

Lifetime Access

Financial Modeling Tutorials
$ 79
  • 44 HD Videos
  • 4.4 Hours of Video
  • Lifetime Support

30 days Money-back Guarantee

FAQ

DO YOU PROVIDE SUPPORT DURING THE COURSE?

We have a chat panel in every lecture window. You can take screenshots, upload file, and send queries to our support desk. QnA should be related to the case study files ONLY.

WHAT VERSION OF EXCEL DO YOU TEACH?

We use Excel 2013 and we have added all new features up to Office 365.

DO I GET A CERTIFICATE AT EACH LEVEL?

No, you do not get a Certificate at each level. We only provide the course completion certificate.

CAN I DOWNLOAD THE COURSE?

No. But, you can watch the videos unlimited number of times.

CAN I ACCESS THE COURSE FROM MORE THAN ONE COMPUTER?

Yes, you can access the course from only 2-3 devices (computer or mobiles) with your login credentials.

EXPLAIN THE REFUND POLICY.

You can ask for refund within 30-days of enrollment. No questions asked.

FOR ENQUIRY ABOUT FINANCIAL MODELING COURSE? CONTACT US:

[email protected]

US: +1 203-349-9909 / IN: +91-8080042523

Feel free to call us for any query related to the course. Our support team will resolve your issue.