Finance Training For Financial Analysts
Last updated 7/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.69 GB | Duration: 9h 48m
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 dаta: understanding the SUMIF function
Lecture 6 Extraction of dаta: calculating growth rates
Lecture 7 Extraction of dаta: understanding the VLOOKUP function
Lecture 8 Extraction of dаta: understanding the HLOOKUP function
Lecture 9 Extraction of dаta: understanding the INDEX and MATCH function
Lecture 10 Extraction of dаta: understanding the IF, COUNTIF and COUNTIFS function
Lecture 11 Presentation of dаta: understanding the LINE chart
Lecture 12 Presentation of dаta: understanding the PIE chart
Lecture 13 Presentation of dаta: understanding the COLUMN chart
Lecture 14 Presentation of dаta: understanding the STACKED COLUMN chart
Lecture 15 Presentation of dаta: 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
Homepage
https://www.udemy.com/course/the-financial-analyst-skills-training-fast-course-2017/
https://rapidgator.net/file/289769edf0467d9dcef024c70fea4b22/wdnkm.Finance.Training.For.Financial.Analysts.part3.rar.html
https://rapidgator.net/file/53623b106335222297661085ce29a6d2/wdnkm.Finance.Training.For.Financial.Analysts.part1.rar.html
https://rapidgator.net/file/d2befebebf8747b2d02a8b00a748304e/wdnkm.Finance.Training.For.Financial.Analysts.part2.rar.html
https://uploadgig.com/file/download/3B9A8a2b61150aCb/wdnkm.Finance.Training.For.Financial.Analysts.part1.rar
https://uploadgig.com/file/download/6e966C36eeaCE96b/wdnkm.Finance.Training.For.Financial.Analysts.part3.rar
https://uploadgig.com/file/download/804a249bb8066c7d/wdnkm.Finance.Training.For.Financial.Analysts.part2.rar
https://nitroflare.com/view/1747C2AAAB115DE/wdnkm.Finance.Training.For.Financial.Analysts.part1.rar
https://nitroflare.com/view/BF061C22D82720A/wdnkm.Finance.Training.For.Financial.Analysts.part3.rar
https://nitroflare.com/view/DE9A47EED2E021A/wdnkm.Finance.Training.For.Financial.Analysts.part2.rar
Please Help Me Click Connect Icon Below Here and Share News to Social Network | Thanks you !
Comments (0)
Users of Guests are not allowed to comment this publication.