Financial Modeling 101
3.4 (44 ratings)
1,160 students enrolled
Wishlisted Wishlist

# Financial Modeling 101

Learn the Top 5 Formulas Essential for Financial Modeling
3.4 (44 ratings)
1,160 students enrolled
Created by iBanking Training
Last updated 12/2016
English
Price: Free
Includes:
• 37 mins on-demand video
• 5 Supplemental Resources
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• Develop an understanding of basic accounting theories and apply essential Excel formulas
• Perform ratio analysis
• Develop knowledge of the top 5 most useful formulas in financial modeling
• Be able to 'quick fix' broken formulas
• Evaluate companies and perform comparable company analysis
• Build dynamic formulas using VLOOKUP
• Troubleshoot for errors and correct them quickly and easily!
• Value cashflow outlay
• Perform sensitivity analysis in different scenarios
• Calculate the net present value of cash flow outlay using NPV
• Perform sensitivity analysis with a Data Table
View Curriculum
Requirements
• While no prior knowledge of finance is required some familiarity with Microsoft Excel would be beneficial
Description

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

Who is the target audience?
• This course is people that want to understand the essential formulas in financial modeling
Compare to Other Financial Modeling Courses
Curriculum For This Course
5 Lectures
37:00
+
Essential Excel Formulas for Financial Modeling
5 Lectures 37:00

In this lecture you will learn:

• Essential Excel formulas and basic accounting theories.
• How to do ratio analysis.
• The top 5 most useful formulas in financial modelling.
• How to easily "quick fix" broken formulas

How to Build "Uniform Formulas"
08:20

In this lecture you will 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 fix them quickly and easily.
• Why using VLOOKUP is so effective in building dynamic formulas
How to Build "Dynamic Formulas"
09:24

In this lecture you will 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.
• Why NPV is such a powerful and convenient formula to use to calculate cash flow outlays.

How to Value Cashflow Outlay
07:21

In this lecture you will learn:

• How to perform sensitivity analysis with a Data Table.
• Why Data Table is so important in sensitivity analysis.
How to Perform Sensitivity Analysis
07:20

Finance Job Growth Highest in 10 Years!

Thank you for watching Financial Modeling 101. Hopefully, you found the tutorials helpful. You might now be thinking about what next? If you really want to learn financial modelling sign up for our full course, Financial Modeling and Valuation: Complete Beginner to Pro. The course usually costs \$50 but is available for the specially discounted price of \$20 by clicking on this link: https://www.udemy.com/financial-modeling-and-valuation-complete-beginner-to-pro/?couponCode=FINMOD20

If You Are Considering a Career in Finance There is No Time Like the Present!

An article in Business Insider says that finance firms added 19,000 net workers in January of 2016, the highest gains since March of 2006.

In other words, if you are interested in a career in finance or in advancing your current finance career, there hasn’t been a better time in the past 10 years!

But you still have to be qualified and today, more than ever before, that means you need know financial modeling.

According to the New York Times, because “millions of dollars can be won or lost on one calculation, firms are finding it essential that their new hires can tell the difference between a pivot table and a header row” – which means workers need to know the basics of financial modeling.”

The article goes on to say: “such knowledge is crucial to carrying out the daily tasks of many disciplines on Wall Street — whether it is the merger deal-making, bond trading or sell-side analysis.”

Luckily for you, it’s never been easier or more convenient to learn financial modeling thanks to iBank’s Financial Modeling Training.

Our knowledgeable instructors and comprehensive course materials, including streaming video lectures, are going to show you how to build highly accurate financial models.

Here are the topics we cover in training:

• Overview of Accounting & Financial Statement Analysis

• Excel Functions

• Ratios

• Why We Value Companies

• Valuation Methods, including: DCF, Trading Multiples & Precedent Transactions

• Debt & Interest Schedule

• Revolver Modeling

• Sensitivity Analysis

• 5 Year Projections

• Profit & Loss Account

• CAPEX

• Cashflow Statement

• Balance Sheet

• And more.....

Remember, you can proceed with the training at your own pace. Simply log in when it is convenient for you and replay important lecture segments if necessary to ensure full understanding.

Don’t miss this golden opportunity to either launch or advance a finance career. Sign up now for the special price of \$20: https://www.udemy.com/financial-modeling-and-valuation-complete-beginner-to-pro/?couponCode=FINMOD20

Bonus Lecture: Developing an Investment Banking Career
04:35