Finance Training For Financial Analysts

The comprehensive course in Excel, Accounting, Financial Analysis, Forecasting, Business Valuation and PowerPoint.

What you'll learn
Undertake data analysis and manipulation in Excel
Make flexible and dynamic financial models
Create data visualization charts in Excel
Prepare the accounting statements of any company
Create income statement, balance sheet and cash flows statement from scratch
Perform ratio analysis on company financials
Compare the performance of different companies using a framework
Create a forward looking integrated financial model
Extrapolate and forecast forward looking financial ratios
Apply the Discounted Cash Flows valuation technique on a real company
Apply the Multiples valuation technique on a real company
Use PowerPoint for creating business presentations
Requirements
Absolutely none. We will teach everything from scratch.
Description
Hey, welcome to our best-selling Finance Training for Financial Analysts course.We are glad to see you visit this course. If only we could shake hands!What is this course about?In this course, we will teach you the comprehensive skills needed to be a Financial Analyst.We will illustrate the following broad content topics in great detail in this course:1) Excel2) Accounting3) Financial statement analysis4) Forecasting financial statements5) Business valuation6) PowerPointIt is a very comprehensive course that will teach you the complete skills of a Financial Analyst.How is this course useful for YOUR purpose?Hey, did you watch the promo video? If not, please do. If you are looking to be a Financial Analyst, then this course will prepare you for the job.Look, the Financial Analyst jobs are high paying ones. So your employer will want you to be on ready to work on a real project on Day 1!Our course does exactly that - we make you job ready for your professional work.The course provides all the practical training of a Financial Analyst.You can crack your upcoming interviews easily with the learning from this course.You have lifetime access to the course once you enroll. So even if you don't plan to start now, you can still enroll and come back anytime later.What makes this course different than others?This course content is unique!You will learn exactly what you are required to do in your daily work.You get access to practical real life illustrations of all key skills to be a Financial Analyst.It is a completely hands-on course.You need to carry out the illustrations in the course along with the instructor.We provide you the same set up as the instructor. All illustration spreadsheets can be downloaded at your end.You will feel as if somebody is guiding you step by step in all illustrations.It is a very practical on the job training for you.You are going to love our instructor's teaching style. He makes it very engaging and fun learning experience.You will have practice assignments to test your learning from the courseThe Practice Assignments are marked with varying difficulty levels - High, Medium and Low.You will have unlimited access to our support.Our support team responds to any course queries within 24 hours of your request. 
There are manually edited hand typed captions added on all lectures of this course. Feel free to refer to them in case you feel the need.And of course, the price is competitive. What are other students saying about this course?Check our our reviews below.Read what student Rameez Akhtar wrote - "THE COURSE COVERS ALMOST EVERYTHING THAT WILL GIVE A YOUNG ASPIRING FINANCIAL ANALYST ALL THE TOOLS TO LAND A SUITABLE JOB IN THIS COMPETITIVE WORLD."Go to the reviews section below to read more such stories.What if YOU do not like the course?Well, we will be very sad to hear that you did not like the course.But you are well protected.You have a 30 day money back guarantee in case you are not happy with the course.No questions asked.But we sincerely hope, you will definitely like the course!What  next?If there are any doubts, don't hesitate to reach out to us.Start learning now.See you inside the course.

Overview

Section 1: Introduction to the FAST course

Lecture 1 Welcome to the course

Section 2: Module 1: Basic excel functions to analyze large data

Lecture 2 Introduction to Module 1

Lecture 3 Download the excel spreadsheet illustration for this module

Lecture 4 Lets look at the data for the illustration exercises

Lecture 5 Extraction of data: understanding the SUMIF function

Lecture 6 Extraction of data: calculating growth rates

Lecture 7 Extraction of data: understanding the VLOOKUP function

Lecture 8 Extraction of data: understanding the HLOOKUP function

Lecture 9 Extraction of data: understanding the INDEX and MATCH function

Lecture 10 Extraction of data: understanding the IF, COUNTIF and COUNTIFS function

Lecture 11 Presentation of data: understanding the LINE chart

Lecture 12 Presentation of data: understanding the PIE chart

Lecture 13 Presentation of data: understanding the COLUMN chart

Lecture 14 Presentation of data: understanding the STACKED COLUMN chart

Lecture 15 Presentation of data: understanding the CONDITIONAL FORMATTING function

Lecture 16 Practice Assignment 1: DIFFICULTY LEVEL - MEDIUM

Lecture 17 SOLUTION TO PRACTICE ASSIGNMENT 1

Lecture 18 Lecture 17: End of Module 1

Section 3: Module 2: Basics of financial accounting statements

Lecture 19 Introduction to Module 2

Lecture 20 What is accounting and why we need it?

Lecture 21 Key financial statements: Income statement

Lecture 22 Key financial statements: Balance sheet

Lecture 23 Illustration for this module

Lecture 24 Illustration of transaction 1

Lecture 25 Illustration of transaction 2

Lecture 26 Illustration of transaction 3

Lecture 27 Illustration of transaction 4

Lecture 28 Illustration of transaction 5

Lecture 29 Illustration of transaction 6

Lecture 30 Illustration of transaction 7

Lecture 31 Illustration of transaction 8

Lecture 32 Illustration of transaction 9

Lecture 33 Illustration of transaction 10

Lecture 34 Practice Assignment #2: DIFFICULTY LEVEL - MEDIUM

Lecture 35 SOLUTION TO PRACTICE ASSIGNMENT #2

Lecture 36 End of Module 2

Section 4: Module 3: Financial performance analysis of companies

Lecture 37 Introduction to Module 3

Lecture 38 Introduction to financial performance analysis

Lecture 39 Download the excel spreadsheet illustration for this module

Lecture 40 Illustration for this module

Lecture 41 How to measure the performance of companies?

Lecture 42 What are the key metrics for measuring performance of companies?

Lecture 43 Calculation of operating metrics for Company 1

Lecture 44 Calculation of financing metrics for Company 1

Lecture 45 Calculation of operating and financing metrics for Company 2

Lecture 46 Calculation of operating and financing metrics for Company 3 and Company 4

Lecture 47 Calculation of averages for all metrics across companies

Lecture 48 Visual representation of metrics across companies

Lecture 49 Ranking of operating metrics

Lecture 50 Ranking of financing metrics

Lecture 51 Choosing the best company

Lecture 52 Quick recap: What did we learn?

Lecture 53 Practice Assignment #3: DIFFICULTY LEVEL - EASY

Lecture 54 SOLUTION TO PRACTICE ASSIGNMENT #3

Lecture 55 End of Module 3

Section 5: Module 4: Forecasting an integrated financial model

Lecture 56 Introduction to Module 4

Lecture 57 Illustration for this module

Lecture 58 Download the illustration exercise for the course

Lecture 59 The six steps to forecasting a financial model

Lecture 60 Step 1: Capturing historical IS & BS

Lecture 61 Step 2a: Calculating historical IS ratios

Lecture 62 Step 2b: Calculating historical BS ratios

Lecture 63 Step 3a: Extrapolating future IS ratios

Lecture 64 Step 3b: Extrapolating future BS ratios

Lecture 65 Quick recap of what we have do so far

Lecture 66 Step 4a: Forecasting future income statement

Lecture 67 Step 4b: Forecasting future balance sheet - assets side

Lecture 68 Step 4c: Forecasting the future balance sheet - liabilities side

Lecture 69 What are the components of cash flow statement?

Lecture 70 Step 5a: Calculating the cash flow from operations

Lecture 71 Step 5b: Calculating the cash flow from investments

Lecture 72 Step 5c: Calculating the cash flow from financing

Lecture 73 Step 5d: Calculating the cash balance at end of year

Lecture 74 Step 6: Integrating the balance sheet with cash flows statement

Lecture 75 Recap: What did we learn in this module?

Lecture 76 Practice Assignment #4: DIFFICULTY LEVEL - HARD

Lecture 77 SOLUTION TO PRACTICE ASSIGNMENT #4

Lecture 78 End of Module 4

Section 6: Module 5: Conceptual understanding of Discounted Cash Flow valuation technique

Lecture 79 Introduction to Module 5

Lecture 80 What is valuation?

Lecture 81 What does the Discounted Cash Flow technique estimate?

Lecture 82 Calculation of Free Cash Flows

Lecture 83 Free Cash flows are calculated for the future

Lecture 84 Calculation of the discount rate or WACC?

Lecture 85 Discounting future cash flows to calculate present value

Lecture 86 Calculation of Terminal Value

Lecture 87 Calculation of enterprise value and equity value

Lecture 88 End of Module 5

Section 7: Module 6: Step by step illustration of DCF valuation technique

Lecture 89 Introduction to Module 6

Lecture 90 5 steps to doing a DCF valuation

Lecture 91 Download the illustration exercise for the module

Lecture 92 Lets look at the data for the illustration in this module

Lecture 93 Step 1a: Calculating EBIT

Lecture 94 Step 1b: Calculating post tax operating cash profits

Lecture 95 Step 1c: Calculating capex

Lecture 96 Step 1d: Calculating operating cash investments

Lecture 97 Step 1e: Calculating Free Cash Flows to Firm (FCFF)

Lecture 98 Step 2a: Calculating WACC

Lecture 99 Understanding the concept of discounting

Lecture 100 Step 2b: Discounting future cash flows to present value terms

Lecture 101 Step 3: Calculating Terminal Value

Lecture 102 Step 4: Calculating Enterprise Value

Lecture 103 Step 5: Calculating equity value and share price

Lecture 104 Sensitivity analysis on share price

Lecture 105 Recap of what we learnt in this module

Lecture 106 Practice Assignment #5: DIFFICULTY LEVEL - EASY

Lecture 107 SOLUTION TO PRACTICE ASSIGNMENT #5

Lecture 108 End of Module 6

Section 8: Module 7: Conceptual understanding of the multiples based valuation technique

Lecture 109 Introduction to Module 7

Lecture 110 What are the different techniques of equity valuation?

Lecture 111 A very brief overview of Discounted cash flow technique

Lecture 112 Multiples based valuation: What is a multiple?

Lecture 113 Multiples based valuation: what does a multiple denote?

Lecture 114 Multiples based valuation: What are the different types of multiples used?

Lecture 115 Illustration for this module

Lecture 116 Financial statements supplements to the illustration

Lecture 117 Steps to do a multiples based valuation

Lecture 118 step 1: choosing the right peers

Lecture 119 Step 2: Calculating the peer multiples

Lecture 120 Step 3: Calculating the target value

Lecture 121 So what is the best multiple to use?

Lecture 122 Recap: What did we learn in this module?

Lecture 123 End of Module 7

Lecture 124 Please provide us your valuable feedback on the course thus far

Section 9: Module 8: Practical application of the multiples based valuation

Lecture 125 Introduction to Module 8

Lecture 126 Download the illustration exercise for this module

Lecture 127 How to do a sum of the parts valuation using multiples (1/2)

Lecture 128 How to do a sum of the parts valuation using multiples (2/2)

Lecture 129 Practice Assignment #6: DIFFICULTY LEVEL - EASY

Lecture 130 SOLUTION TO PRACTICE ASSIGNMENT #6

Lecture 131 End of Module 8

Section 10: Module 9: Advanced excel functions to analyze large data

Lecture 132 Introduction to Module 9

Lecture 133 Download the excel template for this module

Lecture 134 Understanding the LIST function

Lecture 135 Understanding the OFFSET function

Lecture 136 Understanding the SUMPRODUCT function

Lecture 137 Understanding the GOAL SEEK function

Lecture 138 Understanding the INDEX-MATCH function

Lecture 139 Understanding the PIVOT function

Lecture 140 Understanding the INDIRECT function

Lecture 141 Practice Assignment #7: DIFFICULTY LEVEL - MEDIUM

Lecture 142 SOLUTION TO PRACTICE ASSIGNMENT #7

Lecture 143 Please provide us your valuable feedback on the course thus far

Lecture 144 End of Module 9

Section 11: End of the course - What did we learn?

Lecture 145 Quick Recap

Section 12: COURSE CHALLENGE #1 - DIFFICULTY LEVEL : EASY

Lecture 146 Please provide us your valuable feedback

Current Financial Analysts,Aspiring Financial Analysts,Start-up founders,Consultants,Non finance professionals