A Complete Financial Analyst Course

Rating 4.3 out of 5 (42 ratings in Udemy)

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 …

Rating 4.3 out of 5 (42 ratings in Udemy)

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

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 - NPVand 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.

Duration 15 Hours 58 Minutes

Paid

Self paced

All Levels

English (US)

219

Rating 4.3 out of 5 (42 ratings in Udemy)

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.