Financial Analysis Bootcamp (F.A.B.)

Financial Analysis Course will help you Master Accounting, Business Valuation, Excel, Financial Analysis, Forecasting, and PowerPoint skills.

  • Video Lessons = 154+ (11+ Hrs)
  • Lifetime Access
  • Lifetime Support
  • New Course Launched

What is a must-to-know skill for Financial Analyst?

Taking the Financial Analysis Course would be the best decision of your life and it will answer all the questions that you’ve in your mind. 

Financial Analysis Course will help you Master Accounting, Business Valuation, Excel, Financial Analysis, Forecasting, and PowerPoint skills.

With this, you’re guaranteed to become a Successful Financial Analyst.

With Financial Analysis course you’ll be able to evaluate your Business, make budgeting plan, work on Projects and determine the Performance and suitability of your entity.

The Course will guide you to have an entity which offers assured Monetary investment.

It is nothing but examining the financial information in order to make business decisions. The Financial Analysis Course will help you Advance your Career. Also, if you’re an Expert at Excel then this would be a major add on to your skill.

The main Objective is to help the learners analyze the Financial Statements in their Companies. It will help you analyze the Balance Sheet, Cash Flow and the Income Statement.

With Financial Analysis Course you can lead in Banks, Equity Research companies, Investment Firms, Insurance Companies, Investment Banks, Individual Companies and KPOs.

What will I learn?

The basic thing which you look in the course before you buy is what will i learn? How this course will benefit me in my profile. So below are the details what will you learn.

 #How to do Accurate Calculation for Rates of return and profitability analysis

#How to Perform robust vertical and horizontal income statement analysis by applying various performance ratios.

 #How to Approach the benchmarking income statement performance against an appropriate peer group.

✓ #How to Present financial information- Balance Sheet, Cash flow statement, Income Statement to managers and ratio analysis

 #Advanced Excel skills

 #How to Analyze financial information to estimate forecasts for the industry, business, & economic environment in order to make investment decisions

 #How to Prepare Presentations, charts, and graphs to help illustrate financial trends regarding inflation, interest rate, etc.

 #How to Preparing revenue and expense forecasts that helps to make financial decisions

 #How to Create and review the financial records of a company

✓ #How to Maintain knowledge and stay abreast of new regulations and policies in business law, taxation, financial reporting regulations that may affect investment policy

Financial Analysis Course Preview Video

COURSE CURRICULUM

Introduction to the Financial Analysis course

  • Instructor Introduction (1:38)
  • Preview Lecture 1: Introduction to the course (5:34)

Excel Functions to Analyze and visualize Large Data

  • What does the module cover (3:44)
  • Excel spreadsheet for this module- Download (0:34)
  • Data for Demonstration (2:55)
  • Extraction of data: to understand the SUMIF function (8:14)
  • Extraction of data: to calculate growth rate (3:58)
  • Extraction of data: to understand the VLOOKUP function (11:40)
  • Extraction of data: to understand the HLOOKUP function (9:31)
  • Extraction of data: to understand the INDEX and MATCH function (13:56)
  • Extraction of data: to understand the IF, COUNTIF and COUNTIFS function (9:09)
  • Presenting the data: to understand the LINE chart (12:33)
  • Presenting the data: to understand the PIE chart (11:45)
  • Presenting the data: to understand the COLUMN chart (13:03)
  • Presenting the data: for understanding the STACKED COLUMN chart (10:56)
  • Presenting the data: for understanding the CONDITIONAL FORMATTING function (6:58)
  • Practice Assignment #1 – Difficulty level: MEDIUM
  • Practice Assignment #1 – Solution

Module 1- Ends

Your Valuable Feedback

Learning the Basics of financial accounting statements:

  • What does the module cover (1:43)
  • What is accounting and why is it important? (4:18)
  • Key financial statements: Income statement (3:30)
  • Key financial statements: Balance sheet (3:14)
  • Demonstration for this module (0:49)
  • Transaction 1- Demonstration (0:40)
  • Transaction 2- Demonstration (1:03)
  • Transaction 3- Demonstration (1:35)
  • Transaction 4- Demonstration (2:21)
  • Transaction 5- Demonstration (1:55)
  • Transaction 6- Demonstration (1:59)
  • Transaction 7- Demonstration (2:07)
  • Transaction 8- Demonstration (1:52)
  • Transaction 9- Demonstration (1:34)
  • Transaction 10- Demonstration (1:54)
  • Practice Assignment #2 – Difficulty Level: EASY
  • Practice Assignment #2 – Solution

Module 2 – Ends

Your Valuable Feedback

Financial performance analysis of companies

  • What does the module cover (1:54)
  • Financial performance analysis- Introduction (2:24)
  • Download – Demonstration of excel spreadsheet for this module (0:34)
  • Module 3- Demonstration (5:06)
  • Measurement of the performance of companies? (3:20)
  • Key Metrics-Measurement of the performance of companies (9:27)
  • How to Calculate operating metrics for Company 1 (5:39)
  • How to Calculate financing metrics for Company 1 (3:43)
  • Calculate operating and financing metrics for Company 2 (5:05)
  • Calculate operating and financing metrics for Company 3 and Company 4 (0:43)
  • Calculate averages for all metrics across companies (6:50)
  • How to do the Visual representation of metrics across companies (1:44)
  • Learning to Rank the operating metrics (6:15)
  • Learning to Rank the financing metrics (5:34)
  • How to Choose the best company (3:12)
  • Important Recap of what we learned (2:14)
  • Practice Assignment #3: DIFFICULTY LEVEL – EASY
  • Practice Assignment #3- Solution

Module 3- End

Your Valuable Feedback

Forecasting an integrated financial model

  • Module 4- Introduction (2:10)
  • Module 4- Demonstration (1:13)
  • Demonstration of the exercise for the course- Download (0:34)
  • Steps How to forecast a financial model (2:57)
  • Step 1: To Capture historical IS & BS (8:00)
  • Step 2a: To Calculate historical IS ratios (12:20)
  • Step 2b: To Calculate historical BS ratios (6:39)
  • Step 3a: To Extrapolate future IS ratios (10:17)
  • Step 3b: To Extrapolate future BS ratios (5:01)
  • Important Recap of what we learned (1:27)
  • Step 4a: Understanding How to Forecast the future income statement (12:01)
  • Step 4b: Understanding How to Forecast the future balance sheet – assets side (7:17)
  • Step 4c: Understanding How to Forecast the Future balance sheet – liabilities side (12:56)
  • Measurement of the Components of the cash flow statement? (6:18)
  • Step 5a: How to Calculate the cash flow from operations (13:54)
  • Step 5b: How to Calculate the cash flow from investments (7:34)
  • Step 5c: How to Calculate the cash flow from financing (7:53)
  • Step 5d: How to Calculate the cash balance at the year-end (3:03)
  • Step 6: How to Integrate the balance sheet with cash flows statement (2:19)
  • Important Recap of what we learned (1:49)
  • Practice Assignment #4: DIFFICULTY LEVEL – HARD
  • Practice Assignment #4- Solution

Module 4 - End 

Your Valuable Feedback

To Conceptually understand the Discounted Cash Flow valuation technique

  • Module 5A- Introduction (1:49)
  • Understanding of valuation? (2:09)
  • Estimation-Discounted Cash Flow technique (2:58)
  • How to Calculate Free Cash Flows (4:56)
  • How to Calculate Free Cash flows for the future (1:44)
  • How to Calculate the discounted rate or WACC? (2:31)
  • How to Discount future cash flows to calculate present value (2:19)
  • How to Calculate Terminal Value (1:12)
  • How to Calculate enterprise value and equity value (0:47)

Module 5A- End

Your Valuable Feedback

Step by step Demonstration of the DCF valuation technique

  • Module 5B-: Introduction (2:45)
  • 5 Steps to do a DCF valuation (1:38)
  • Demonstration exercise for the module- Download (0:34)
  • Observe the data to check out the Demonstration for this module (4:55)
  • Step 1a: How to Calculate EBIT (5:47)
  • Step 1b: How to Calculate post-tax operating cash profits (5:52)
  • Step 1c: How to Calculate capex (5:50)
  • Step 1d: How to Calculate operating cash investments (3:10)
  • Step 1e: How to Calculate Free Cash Flows to Firm (FCFF) (2:52)
  • Step 2a: How to Calculate WACC (6:15)
  • What is discounting (3:06)
  • Step 2b: How to Discount future cash flows to present value terms (4:12)
  • Step 3: How to Calculate Terminal Value (4:33)
  • Step 4: How to Calculate Enterprise Value (0:58)
  • Step 5: How to Calculate equity value and share price (1:40)
  • How to do the Sensitivity analysis on share price (7:13)
  • Recap of what we learned (1:15)
  • Assignment #5: Difficulty Level- EASY
  • Practice Assignment #5 – Solution

Module 5B - END

Your Valuable Feedback

To Conceptually understand the multiples-based valuation technique

  • Module 6A- Introduction to (2:04)
  • Different techniques of equity valuation? (5:11)
  • Overview of Discounted cash flow techniques (1:48)
  • What is a multiple in a Multiples based valuation? (2:35)
  • To find out what does a multiple denote in Multiples based on valuation? (1:32)
  • What are the different types of multiples used in Multiples based valuation? (3:21)
  • Module 6A- Demonstration (2:22)
  • Which Financial statements supplement the Demonstration (2:44)
  • 3 Steps for doing multiples-based valuation (4:46)
  • Step 1: How to choose the right peers (6:34)
  • Step 2: How to Calculate the peer multiples (4:25)
  • Step 3: How to Calculate the target value (6:18)
  • How to find the best multiple to use? (7:51)
  • Important Recap of what we learned (3:40)

 Module 6A - End 

Your Valuable Feedback

Multiples-based valuation- Practical application

  • Module 6B- Introduction to (3:33)
  • Demonstration of the exercise for this module- Download (0:34)
  • Valuation- Of the sum of the parts using multiples (1/2) (11:53)
  • Valuation- Of the sum of the parts using multiples (2/2) (5:27)
  • Practice Assignment #6: DIFFICULTY LEVEL – EASY
  • Practice Assignment #6- Solution

Module 6B - End

Your Valuable Feedback

Advanced excel functions to analyze large data

  • What does the module cover 9 (2:52)
  • Excel template for the module- Download (0:34)
  • What is the LIST function (5:45)
  • What is the OFFSET function (8:30)
  • What is the SUMPRODUCT function (8:24)
  • What is the GOAL SEEK function (8:29)
  • What is the INDEX-MATCH function (18:54)
  • PIVOT function- Introduction (11:14)
  • INDIRECT function- Introduction (11:31)
  • Practice Assignment #7: Difficulty level – MEDIUM
  • Practice Assignment #7 – Solution

Module 7 - End

Your Valuable Feedback

Start Learning Today

No Frills

Lifetime Access

48+ Course Lessons
$48
  • 154+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now

Badges For YodalearningSecurity badges For YodalearningOnline Security Payment SuccesfullAdvanced Excel Payment Succesfull

Financial Analysis Boot Camp Course is our Partner Course.

 

30 days money back gauarantee

Course Completion Certificate By Yodalearning

Unlock your completion certificate

  • Complete any premium course at Yoda Learning Solutions
  • You are awarded a completion diploma
  • The diploma can be verified via URL and exported to LinkedIn to boost your career and impress potential employers.

For Enquiry About Courses? Contact Us:
[email protected]
 +1- 203-349-9909

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

How does it work?

The process is really smooth. After enrolling for the Course, you’ll get a link. With the given link you can register for the course. Enjoy lifetime access and support with the course. Watch the video courses 24×7 as per your interest.

how-it-works