Advanced Financial Modeling – Live Online Training

This specially designed 8 days Financial Modeling Live Online Training on Financial Modeling is designed for working professionals and hence its not basic introductory course however its a fast pace course covering all the topics of Financial Modeling with Practical examples and case studies.

Students will be asked to work on real time project and they have to implement all the best practices and leanings of the class in that dummy project which will be allocated to them to work on. Real time practical helps them to get confidence on actually doing and building a real financial model instead of just getting theoretical knowledge of the concepts.

They will be using Excel as a tool to prepare an actual working financial model along with instructor where instructor will not only make them understand the topics but also get them involved in actual implementation of those concepts by building a model by themselves.

Note: If you are not aware about the basics of Financial Modeling then don’t worry. We do provide a complementary online complete financial modeling course which will cover all the basic to intermediate level of understanding of the Financial Modeling concepts. Students are recommended to complete the online course before attending our classroom training for better understanding of the topics.

Complementary Online Course on “Financial Modeling – Build a complete DCF valuation model” worth USD 249.

EVENT CONTENT

Module 1

  • Financial Modeling Principles
  • Excel as a tool for Financial Modeling
  • Building Financial Models from scratch
  • Modeling Growth Drivers, Depreciation, Cost Drivers, Asset and Debt Schedules

Module 2

  • Valuation Principles
  • Projecting Cash Flow Statement
  • Circular References and Handling them
  • Financial Ratio Analysis
  • Valuation using DCF and Comps
  • Scenario Analysis and Building Valuation Dashboards
  • Q and A

Module 3

  • Advanced Functions, Tools and Charting
  • Advanced Tools in Excel for Auditing Financial Models
  • Mastering Financial Functions
  • Advanced Charting Techniques in Excel

Module 4

  • Using Macros and VBA for Financial Modeling
  • Understanding Macros and VBA for Financial Modeling
  • Implementing Monte Carlo Simulation
  • Advanced Charting Techniques in Excel
  • Commodities, Foreign Exchange and Corporate Bonds
  • Q and A

Training Duration: 8 Days, 4 Hours per day

Training Timing: 12:00 PM to 4:00 PM GMT (Click here to view timing in your geography)

Download Complete Course Agenda – Click here

Sample Certificate of PreparationInfo:
Certificate of Participation: Click here
Certificate of Excellence: Click here

Steps to Validate Certificate from PreparationInfo: Click here

What do customers think of PreparationInfo Training program? The Overall experience of customers with PreparationInfo?

View More Testimonials on YouTube – Click here

1
Why value a company?
2
Company Valuation – Theoretical Framework
3
The investor’s perspective
4
Calculating Unlevered free cash flows
5
Using an appropriate discount factor
6
Estimating cost of debt
7
Estimating cost of equity
8
Forecasting future cash flows
9
Caclulating Terminal value
10
Discounting future cash flows
11
Calculating Enterprise and Equity value of the firm
12
Learning by Doing – Learn How to Value a Company – Introduction to Case Study 2
13
A Quick Summary of The Various Stages of a Complete DCF Valuation
14
Let’s Go Through The Structure of the DCF Model That We Will Create in Excel
15
A Glimpse At the Company We Are Valuing – Cheeseco
16
Modeling the Top Line of the Financial Model
17
This Is How You Can Build Flexible Financial Models in Excel
18
Modeling Other Items: Other Revenues and Cogs
19
Modeling Other Items: Operating Expenses and D&A
20
Modeling Other Items: Interest Expenses, Extraordinary Items and Taxes
21
How to Forecast Balance Sheet Items – The Practical and Easy to Understand Way
22
A Key Concept for Finance Practitioners – the “Days” Methodology
23
Learn How to Calculate “Days”
24
How to Use “Days” in Order to Project the Future Development of Some BS Items
25
Forecasting Property Plant & Equipment, Other assets and Other liabilities
26
Excel Best Practices! Create a Good-looking and Clean Output Sheet in Your Model
27
Applying What We Learned in Practice – Populating the P&L Sheet
28
This is How you Can Create a Clean Output Balance Sheet in Your Financial Model
29
Completing the Output BS Sheet For the Historical Period
30
Learn How to Calculate Unlevered Free Cash Flows
31
Important! Reconcile UFCF to Net Cash Flow
32
A Very Useful Lesson! Learn How To Calculate Cash Flows
33
Arriving to Actual Net Cash Flow Figures and Performing a Check with Cash
34
The Fast and Effective Way to Modify Multiple Cell References in Excel
35
Introducing Weighted Average Cost of Capital and Perpetuity Growth Rate
36
Learn How to Find The Present Value of Future Cash Flows in Financial Models
37
Calculating Continuing Value and Enterprise Value of the Business
38
Final Steps! Calculate Equity Value of the Business Under Consideration
39
Excel Tools in Practice – Sensitivity Analysis for WACC and Perpetuity Growth
40
Excel tools in Practice – An Application of Goal Seek
41
Recap of the Financial Model with Charts and Hypothesis Testing

Be the first to add a review.

Please, login to leave a review
Add to Wishlist
Enrolled: 160 students
Duration: 8 Weeks
Lectures: 41
Video: 32 Hours

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed