Financial Modeling 101

Posted By: naag
Financial Modeling 101

Financial Modeling 101
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 37M | Lec: 5 | 184 MB
Genre: eLearning | Language: English

Learn the Top 5 Formulas Essential for Financial Modeling

Welcome to Financial Modeling 101

In these tutorials you will learn the top 5 formulas used in financial modeling:

Lecture 1: How to Build Uniform Formulas

In this video, you are going to learn:

Essential Excel formulas and basic accounting theories that you will need to know to perform accurate financial modeling in the future!

How to do ratio analysis – there is much more to it than just comparing

The top five most useful formulas in financial modeling – plus, what is the most frequently used formula and why!

How to easily “quick fix” broken formulas … and much more!

This video is a terrific introduction into financial modeling and will give you a much better understanding of the process and whether it is something you want to pursue to advance your career.

Lecture 2: Building Dynamic Formulas

In this tutorial, you are going to learn:

How to evaluate companies and how to perform comparable company analysis

How to build dynamic formulas using VLOOKUP

How to troubleshoot for errors and correct them quickly and easily!

2 reasons why using VLOOKUP is so effective in building dynamic formulas

And much more

Lecture 3: Value Cashflow Outlay

In this lecture, you are going to learn:

How to value cashflow outlay

How to use more advanced financial modeling techniques and perform sensitivity analysis in different scenarios

How to calculate the net present value of cash flow outlay using NPV

2 big reasons why NPV is such a powerful and convenient formula to use to calculate cash flow outlays

And much more

Lecture 4: Sensitivity Analysis

In this lecture you will learn:

How to perform sensitivity analysis with a Data Table

2 reasons why Data Table is so important in sensitivity analysis

And much more

Financial Modeling 101