A Complete Financial Analyst Course

Focused View

Syed Muhammad Ali Shah

15:58:12

21 View

1 - Getting to grips with MS Excel

1 - Financial Modelling Introduction.mp4

14:17

1 - lesson1xlsx.zip

2 - Intro to Excel Ribbon and Menu.mp4

23:06

3 - Copy Paste Cut Paste Linking the Sheets.mp4

15:16

4 - Data Sort and Sub Totals.mp4

10:26

4 - introductionlessonxlsx.zip

5 - Locking Cell References in Formulas.mp4

08:50

6 - Fast Scrolling with F5.mp4

05:17

7 - Dynamic Naming.mp4

06:33

8 - Lock Cell References with sign.mp4

05:17

2 - Formating and Data Sorting in MS Excel

9 - What If Analysis and Conditional Formatting.mp4

21:59

9 - financialmodellingwhatifanalysisxlsx.zip

10 - Formatting Basics Using Macros.mp4

10:45

10 - lesson1xlsx.zip

11 - Data Filters in Tables.mp4

06:44

12 - IF and AND Function.mp4

15:49

13 - Pivot Tables Basics.mp4

11:56

14 - Format Table Function.mp4

07:45

15 - DSum and DAverage.mp4

09:45

16 - Removing Error.mp4

03:19

3 - Basics of Financial Management

17 - Compounding and Discounting.mp4

18:30

18 - Discounted Cash Flow DCF.mp4

28:51

19 - What is NPV.mp4

07:54

20 - Internal Rate of Return IRR.mp4

09:32

4 - Create Your First Financial Model for Profit and Loss Account

21 - Forecast Profit and Loss Introduction.mp4

09:33

21 - forecastprofitandlosspart1xlsx.zip

22 - Forecast Profit and Loss Revenue and COSmp4.mp4

32:35

22 - forecastprofitandlosspart2xlsx.zip

23 - Forecast Profit and Loss Fixed and Variable Costs.mp4

08:43

24 - Forecast Profit and Loss Finalizingmp4.mp4

25:53

25 - Completing the Profit and Loss.mp4

27:23

5 - Financial Model for Statement of Financial Position Balance Sheet

26 - Structure of Balance Sheet.mp4

07:02

27 - Balance Sheet Assumption.mp4

40:37

28 - Introduction to Cash Flow Statement.mp4

17:18

28 - introductiontocashflowstatementxlsx.zip

6 - Construct your Statement of Cash Flow Based on PnL and Balance Sheet

29 - Forecast Cash Flow Statement.mp4

18:52

30 - Completing the Statement of Financial Position.mp4

16:32

31 - Completing the Forecast Cash Flow Statement.mp4

15:26

7 - Extracting Data From Your System and Preparing Profit and Loss Statement

32 - Vlook up.mp4

14:19

33 - Analyzing the Data and Creating Unique Codes.mp4

11:09

34 - Using the V Lookup to Extract the Data.mp4

18:03

35 - Mapping the Account Codes to P&L Accounts.mp4

15:17

36 - Creating the Final Profit and Loss Output Sheet.mp4

12:00

8 - Capital Budgeting Investment Appraisal RISK and Betas

37 - Cash Flow Based Valuation.mp4

29:10

38 - Introduction to Capital Budgeting.mp4

17:17

39 - Introduction to Risk.mp4

25:13

40 - Beta Values and CAPM.mp4

16:36

41 - Geared and Ungeared Betas.mp4

25:41

9 - Financial Modelling and Investment Appriasal

42 - Introduction to DCF Financial Model.mp4

27:44

42 - capitalbudgetingmodel1xlsx.zip

43 - Fixed Assets and Depreciation Schedule.mp4

20:32

43 - capitalbudgetingmodel2xlsx.zip

44 - Depreciation and Tax Benefits.mp4

15:05

45 - Calculating the Operating Cash Flows.mp4

27:36

46 - Common Issues with Operational Assumption in DCF Model.mp4

17:43

47 - WACC and Beta.mp4

46:47

48 - Calulating Project Beta Cost of Equity and WACC.mp4

18:17

49 - Getting the Final Output of DCF Model.mp4

23:28

50 - Calculating the Internal Rate of Return IRR.mp4

13:34

51 - Sensitivity Analysis of the Project.mp4

24:00

10 - Business Valuation

52 - Fin Modelling Intro to Business Valuation.mp4

13:38

53 - Fin Modelling Understanding a Case Study and Intro.mp4

29:27

54 - Fin Modelling Business Valuation Final.mp4

33:51

Description

Prepare How to Prepare Financial Models in MS Excel - Beginners to Advanced

What You'll Learn?

Participants will learn the theory and application of Financial Modelling and how to use MS Excel in creating Financial Models from scratch.
Learn how to use MS Excel more efficiently
Organize, sort and arrange large data in MS Excel
Learn how to use excel advance functions such as vlook up and macros
Extract data and prepare company's Profit and Loss Statement
Automate Statement of Financial Position - The Balance Sheet
Automate Cash Flow Statement Based on the Profit and Loss and Balance Sheet
Learn the capital structure of a firm, gearing and betas
Learn how to calculate the Weighted Average Cost of Capital - WACC
Understand the concept of Discounted Cash Flow - DCF
Use DCF technique to calculate the NPV and IRR of a project in MS Excel
Prepare a complete investment appraisal financial model
Perform business valuation using different methods

Who is this for?

Accounting and Finance professionals as well as accounting and finance students.

What You Need to Know?

Basic knowledge of MS Excel and Basics of Accounting and Finance

More details

Description
OVERVIEW - Updated October 2021.
Financial Modeling is an essential skill for accounting and finance professional. It is very much in demand in the job market and is highly valued by employers.
Our Financial Modeling training takes you from basics to professional level. This sixteen hours training is based on practical exercises
The course focuses 40% on honing the participants MS Excel skills and 60% focus on application of MS Excel in Accounting and Finance
DETAILED CONTENT
1. Introduction to Excel
2. Useful tips and tools for your work in Excel
3. Keyboard shortcuts in Excel
4. Excel's key functions and functionalities made easy
5. Update! SUMIFS
6. Financial functions in Excel
7. Microsoft Excel's Pivot Tables
8. Building a complete P&L in Excel - Case Study
9. Introduction to Excel charts
10. Profit and Loss - Case Study
11. Statement of Financial Position - Case Study
12. Statement of Cash Flows - Case Study
13. Financial modeling fundamentals
14. Introduction to Company Valuation and Introduction to Mergers & Acquisitions
15. Learn how to build a Discounted Cash Flow model in Excel - NPVÂ and IRR
16. Investment Appraisal - Case Study
17. Business Valuation - Case Study
18. Capital Budgeting - The theory
19. Capital Budgeting - Case Study
20. Impact of interest rates and exchange rates on NPV
21. Sensitivity Analysis in Capital Budgeting
PREREQUISITES
1. Participants are expected to have basic knowledge of MS Excel. This could be measured as an MS Excel user for more than one year.
2. Basic knowledge of financial accounting.
3. Microsoft Office 2013 or later installed on your computer.
Who this course is for:
Accounting and Finance professionals as well as accounting and finance students.

User Reviews

Rating

average 0

Total votes0

Focused display

Financial Modeling

Syed Muhammad Ali Shah

Instructor's Courses

A qualified accounting and finance professional with over twenty years of extensive experience in diversified industry sectors such as auditing, large scale manufacturing and oil and gas.Like most accounting and finance professionals, I started my career as finance executive and then over the years rose to the position of CFO in a multinational company in oil and gas industry. I have also worked as a consultant with the World Bank and European Union on different projects in Middle East, Eastern Europe and CIS countries during 2011 to 2018 as a principal consultant for IFRS and Financial Management.I am qualified professional with three professional qualifications MBA, ACCA and CIMA UK. I have been teaching IFRS, Financial Reporting, Financial Management and Performance Management for over fifteen years and my focus areas are ACCA and CIMA qualifications.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.