Excel Fin Analysis Valuation And Financial Modeling Bundle

Tags: Financial Modeling , Financial Analysis

Learn Excel for Finance, Financial Analysis, DCF and Relative Valuation and Financial Modeling from scratch.

Last updated 2022-01-10 | 3.9

- Excel shortcuts
- Formulas
- Formatting and Number Formatting
- This Training is Dedicated to Learning about this most commonly used DCF Valuation Techniques.
- This Course Gives a Brief idea about the Revenue and Cost Drivers
- Forecasting the Future Financials and the Stock Price Recommendation.

What you'll learn

Excel shortcuts

Formulas

Formatting and Number Formatting

This Training is Dedicated to Learning about this most commonly used DCF Valuation Techniques.

This Course Gives a Brief idea about the Revenue and Cost Drivers

Forecasting the Future Financials and the Stock Price Recommendation.

You Shall Understand valuation Techniques Right From Scratch on a Financial Model.

* Requirements

* Basic computer knowledge
* Basic knowledge of Finance concepts
* Fundamental understanding of financial modeling is an added advantage
* Basic knowledge of financial accounting
* ratios will be great
* Basic knowledge on Microsoft excel and word will be nice
* The course starts from basic excel to basic accounting to advanced Financial model. Even if you dont have any finance background
* you will do well in this course

Description

This course is a comprehensive bundle of MS Excel, Valuation, Accounting, Financial Analysis and Financial Modeling. Any one interested in a career in Finance and Financial Analyst Industry. This course is a must. Many students and professionals assume that their chances of making an Analyst career in Finance Industry are bleak if they are not from the top tier colleges. However, we have seen industry trends where skilled students and professionals from lesser known universities and companies making into big financial firms and organizations. Universities are very limited in their curriculum as they are mostly restricted to focus on theoretical aspects than actual practical know-how. Financial Analyst Training involves analyzing companies’ financials in detailed manner. Analysis is conducted through a composite of financial records, news and interviews with company insiders. It is also known as securities research or Fundamental Analysis. It consist of the sell side research i.e. when research done by analyst are provided to their clients and also buy side research i.e. when analyst do research and use it to invest their firm’s money. The work within Financial Analysis mainly revolves around Financial Modeling Techniques, forecasting, valuations like DCF and Relative Valuations (estimate growth rate and valuations for companies in future). In this you will learn the following:

Excel Tips and Tricks for Finance
Valuations in details
Financial Modeling where in we will study in details the balance sheet, income statements, cash flow, projections etc along with the financial model in practical.

Who this course is for:

Working Professionals
Students pursuing Degree, Diploma, Engineering and commerce who want to make a career in finance/Fixed Income market.
Professionals who want to pursue a career in the Private Equity industry
Anyone who wants to learn financial modeling and report writing on real estate sector

Course content

6 sections • 224 lectures

Financial Modeling Overview 16 lectures

Financial Modeling Introduction Preview 07:39

Welcome to the world of Financial Modeling. This video will give you an overview of Financial modeling, industry and how it works

What is Financial Modeling Preview 12:14

Framework and Case Study of the Financial Model Preview 08:17

Prerequisites Preview 09:49

Prerequisites Continues Preview 09:14

Model Requirements Preview 09:37

Defining the Need Preview 07:31

Defining the Need Continues Preview 07:06

Defining the User Preview 06:14

Bottom Up Curses Top Down Preview 08:06

Defining the Macro Environment Preview 09:51

Impact of Brexit Preview 06:51

Defining the Sector Preview 09:05

About the Company Preview 10:00

Understanding Accounting Equations Preview 09:54

FM Prerequisites - Excel Shortcuts 55 lectures

Introduction to Excel reports Preview 12:05

Shortcut Key Function - F6 Preview 08:24

Shortcut Key Function - F10 Preview 06:16

Formatting Text and Numbers Preview 07:03

F2 and Shit Plus F2 Preview 08:16

CTRL Plus Apostrophe Preview 07:20

CTRL Plus Shift Plus Tilde Preview 07:48

Entering a Formula Preview 08:07

Entering a Function Preview 05:17

Operator Precedence Preview 10:59

Name and Formula in Excel Preview 11:45

Count functions in Excel Preview 06:43

Sum Functions in Excel Preview 07:04

Counts of Logical Values in Excel Preview 06:56

Sum Product Function in Excel Preview 07:04

Average Counting Blank and Non Blank Preview 10:45

Offset and Concat Function in Excel Preview 11:04

Relative Reference in Excel Preview 06:18

Absolute and Mixed Reference in Excel Preview 09:34

Logically if Function in Excel Preview 06:53

Logically AND & OR Function in Excel Preview 08:46

Nested if and Switch Function Preview 09:30

Example of Logical Function Preview 12:19

Basic of Date and Time Format Preview 12:09

Dated if and Weekday Function Preview 07:05

Network Day Function Preview 07:13

Work Day Function Preview 05:39

Example of Date and Time Function Preview 06:26

String Concentration Function Preview 12:36

Upper and Lower Function Preview 08:04

Lenth of the Function Preview 07:12

Trim and Clean Function Preview 11:39

Search and Concat Function Preview 11:09

Vertical Lookups (v LOOKUPS) Preview 06:58

Horizontal Lookups (H Lookups) Preview 07:22

Match Function Preview 11:16

Left V Lookups Preview 10:02

Tow Ways Lookup Preview 08:44

Tow Ways Lookup Continues Preview 11:12

Example of Lookups Preview 10:01

PMT Financial Function Preview 06:26

Loan with Different Terms Preview 06:26

Loan with Different Terms Continues Preview 07:21

PPMT and IPMT Preview 05:46

Example of PPMT and IPMT Preview 07:32

Average and Average If Function Preview 10:24

Random Number and rank Function Preview 06:01

Random Number and rank Function Continues Preview 07:35

Percentile and Quadrilles Preview 12:15

Round and Even Odd Function Preview 07:59

Trendline and Trend Analysis Preview 07:10

Trendline and Trend Analysis Continues Preview 08:05

Round up and Round Down Function Preview 05:36

INT and TRUNC Function Preview 07:25

FM Prerequisites - Excel Graphs & Charts 51 lectures

Introduction to Excel Charts and Smart Art Graphics Preview 07:46

Learning the HR Database Preview 11:58

Sales Productivity Database Preview 05:14

Learning how to insert pictures Preview 11:57

Study on Clip Arts Preview 07:41

Utilizing the Screenshot option Preview 04:08

Creating Shapes in Excel Preview 05:52

Creating Venn Diagram Preview 08:16

Training on Charts Preview 08:58

Groupings for percentages and ratios Preview 03:21

Applying groupings to database Preview 09:21

Formulas in Excel Chart Preview 10:11

Layout of the Chart Preview 06:20

Learning the show data table Preview 07:57

Different types of columns Preview 05:04

Understanding the Horizontal Bar Charts Preview 10:40

Pie charts for arts and graphics Preview 08:14

Label positioning in pie chart Preview 04:54

Line charts for trends over time Preview 08:05

Different options in Line charts Preview 05:24

Analyzing on the Doughnut chart Preview 11:44

Area chart for illustrating the magnitude Preview 09:19

Variation in bubble chart Preview 03:55

Rating and tenure in bubble chart Preview 06:24

Surface or surface area chart Preview 03:03

Example in surface chart Preview 08:53

Learning the Pyramids chart Preview 07:04

Example in Pyramid chart Preview 06:19

Mosaic or Mekko charts Preview 10:57

Graphical method in Radar chart Preview 08:58

Sunburst chart a multilevel pie chart Preview 10:08

Factors in Sunburst chart Preview 06:04

Aspect of Scatter plot Preview 11:53

Histogram a part of piechart Preview 01:25

Combo charts for arts and graphics Preview 06:57

Dashboard Chart Preview 04:03

Dashboard Chart Continue Preview 06:38

Thermometer Chart Preview 10:40

Map Chart Preview 12:00

Tips to Make Your Graph Perfect Preview 10:52

Deciding Which Type of Chart to Use Preview 07:28

Sparklines Preview 11:28

Sparklines Continue Preview 05:07

Pivot Charts Preview 07:41

Basic Block List Preview 09:52

Varying Width List Preview 04:47

Picture List Preview 11:53

Accent Process Preview 02:19

Converging Text Preview 07:45

Hierachy Preview 07:34

Pyramid Preview 06:27

FM Prerequisites - DCF Valuation 35 lectures

Introduction Discounted Cash Flow Preview 11:01

Course Outline Preview 08:16

Valuation Methodologies Preview 06:02

Relative Valuation Preview 11:56

Basic Concepts of DCF Preview 11:45

Understand DCF Method Preview 07:42

Using Concept of Terminal Value Preview 07:37

Common Trade of DCF Value Preview 10:59

Types of DCF Preview 09:32

Important Accounting Equations Preview 03:34

Advantages of DCF Preview 12:01

DCF Versus Comps Preview 07:04

Steps of DCF Preview 11:06

DCF Predicting the Cash Flows Preview 07:09

DCF Predicting the Cash Flows Continues Preview 10:45

Starting with the Case Study Preview 03:28

Predicting the Cash Flows Preview 08:02

Case Study Explained Preview 08:39

Predicting Terminal Values Preview 09:22

Methods to Calculate Terminal Values Preview 08:04

Case study Step 2 Explained Preview 05:45

Case study Step 2 Explained Continues Preview 06:09

Working on DCF Explain Preview 07:07

Net Debt Preview 04:00

Cost of Debt Preview 09:21

Cost of Equity Preview 10:54

Understand Beta Preview 10:09

Beta Continues Preview 07:58

Finalizing the case study Preview 12:10

Creating a Sensitivity Table Preview 07:18

Concluding the Analysis Preview 10:47

Common Interview Questions Preview 12:19

This video will give you some frequently asked questions in interviews and how to handle them

FM Prerequisites - Relative Valuation 29 lectures

Introduction to Relative Valuation Preview 02:32

Subject Outline Preview 06:39

Subject Outline Continues Preview 06:22

First Valuation Equation Preview 10:27

Understand Valuation Terminologies Preview 07:22

Second Valuation Equation Preview 10:19

Enterprise Value Versus Equity value Preview 08:55

Connecting the Two Equations Preview 09:14

Valuation Methodologies Preview 10:03

Absolute Valuation Preview 09:45

Relative Valuation Preview 11:45

Usage of Comps Preview 08:07

Usage of Comps Continues Preview 07:41

About the Company Preview 06:38

Steps of Comparable Comps Preview 07:16

Selecting the Peers Preview 10:40

Selecting the Peers Continues Preview 08:32

Selecting the Multiples Preview 09:30

Enterprise Value Multiples Preview 08:52

Equity Multiples Preview 09:09

Industry Specific Multiples Preview 09:44

Gathering the Data Part 1 Preview 11:40

Gathering the Data Part 2 Preview 11:50

Gathering the Data Part 3 Preview 09:21

Drawing the Comps Sheet Preview 11:01

Drawing the Comps Sheet Continue Preview 11:49

Drawing Conclusions Preview 05:54

Why not Comps Preview 05:03

Common Interview Questions Preview 08:27

Financial Modeling and Valuations on Excel 38 lectures

Financial Modeling Practical in Excel with a case study Preview 09:55

Populating the Historical Preview 10:37

Populating the Historical Continues Preview 09:39

Projecting Income Statement Preview 11:08

Key Data on Siemens Preview 13:44

Working Capital Schedule Preview 11:05

Working Capital Schedule Continues Preview 11:03

Property, Plant and Equipment Preview 05:40

Understand Intangible Assets Preview 09:54

Depreciation Schedule Preview 12:21

Long Term Debt Preview 07:45

Long Term Debt Continues Preview 06:06

Equity Schedule Preview 06:16

Working on Cash Flow Statement Preview 11:05

Short Term Debt Preview 06:30

Interest Income Preview 12:03

Basic Shares Calculation Preview 10:47

Basic Shares Calculation Continues Preview 04:55

Checking Errors Preview 08:57

Breaking Circularity Preview 10:15

Identify Line Items Preview 10:25

Ratio Analysis Preview 10:41

Ratio Analysis Continues Preview 07:25

Sensitivity Tables Preview 07:39

Scenario Analysis Preview 06:02

Scenario Analysis Continues Preview 07:07

Indexing Preview 07:28

DCF Introduction Preview 05:34

Best Practices Preview 06:24

Common Mistakes Preview 08:24

Common Interview questions Preview 09:47