Description
The 16 hour STP course Using Financial Modelling for Analysis and Valuation is designed to provide students with the skills and knowledge required to build financial models for analyzing and valuing companies. The course will cover various techniques and best practices for building financial models, including forecasting future financial performance, building a discounted cash flow (DCF) model, performing sensitivity analyses, and conducting scenario analyses.
Students will also learn how to use financial models for various purposes, such as M&A analysis, capital budgeting, and risk analysis. Also, will be able to forecast future financial performance based on historical data and industry trends.
What Will I Learn
You will be able to:
- build financial models for analyzing and valuing companies using Excel or other financial modelling software
- perform sensitivity analyses to assess the impact of changes in key assumptions on the value of the company
- apply financial modelling techniques to different types of analysis, such as M&A analysis, capital budgeting, and risk analysis
- critically evaluate financial models built by others and identify areas for improvement
- develop a deep understanding of financial statements and the key drivers of financial performance in different industries
- understand the limitations and assumptions of financial models and how to address them in the analysis
Curriculum
- Formatting the data, summarizing, and creating a presentable format
- Manipulating Text and Numerical Data
- Using Pivot Tables to Summarize Data
- Converting data into tabular format
- High profit sales using conditional formatting
- Excel Best Practises
- Inputs/Assumptions Worksheet
- Preparing the 3 Financial Statements
- Preparing Depreciation & Amortization Schedule
- reparing Debt Schedule
- Understand the Business Model and Operating Model
- Modelling the Historical Statement
- Modelling Assumptions for Future Action
- Modelling Revenue Build-up – projecting the future revenues
- Modelling Cost Build-up – projecting the future cost
- Modelling the Asset Schedule
- Modelling the Depreciation Schedule – Book and Income Tax Depreciation
- Working Capital and Term Loan Modelling – Debt Infusion
- Equity Modelling – Equity Infusion
- WACC and Cost of Equity Analysis
- Performing Valuation using DCF
- Performing Sensitivity/ Scenario Analysis
- Comparing the Valuation Summary using Different Parameters
How It works
|
Live Online Sessions Each session is interactive and informative, featuring case studies, quizzes and projects |
|
Interact, Learn and Grow bsevarsity.com enables you to master the concepts, interact with expert faculty and other learners, and be a part of the community whilst growing. |
 |
Get Certified Get Certified from bsevarsity.com. Share your success with the world |
Training 5 or more people?
We provide custom courses and group sessions as well. To know more about our Customized Programs.
Try BSE Business Click here