Financial Modelling in MS Excel
Automate your financial reports and financial models with MS Excel
4.38 (97 reviews)
447
students
16 hours
content
Aug 2024
last update
$54.99
regular price
What you will 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
Screenshots
Related Topics
3697532
udemy ID
12/11/2020
course created date
12/13/2020
course indexed date
Bot
course submited by