Financial models are a key element in most major business decisions.
As a financial professional, our career is impeccably linked to financial modeling skills. It’s considered as one of the most critical value add that one can bring on the table.
Financial modeling is the task of building an abstract representation (a model) of real world scenarios. Built on Microsoft Excel, it is an exercise taken by decision makers to forecast the future performance, profitability and cash flows of their company, project or investment.
Learning objectives
Apply
Put Theory into practice
Interpret financial statements
Understand the mechanics of three core financial statements - Income statement, Balance sheet and Cash flow
Master CFA curriculum concepts
Enables you to apply concepts learnt in Level I, promoting a smoother transition to Level II
Forecast
Create powerful Scenarios and sensitivity tables by data crunching
Employer demand
Boost your professional resume. Most sought after skill required by employers
Dynamic presentation
Professional data presentation in forms of charts and dashboards
Agenda
9:00am - 10:00am
Excel overview
Excel set up for a financial model
Formula refresher
Logical and date formulas
Powerful Excel tools
Excel best practices
10:00am - 10:30am
Case study and model set up
Understanding case study
Model set up
10:30am - 10:45am
Coffee break
10:45am - 12:45pm
Creation of supportive schedules
Revenue modeling
Expense projection
Asset schedules - capex and depreciation
Working capital analysis
12:45pm - 1:00pm
Lunch break
1:00pm - 3:00pm
Linking the three financial statements
Linking income statement to schedules
Balance sheet linking with income statement and cash flow statement
Relationship between cash flow statement and balance sheet
Balancing the balance sheet
03:00pm - 03:15pm
Coffee break
3:15pm - 4:30pm
Application of valuation tools
Calculation of Free cash flows
Application of DCF model
Application of relative valuation model
Trainers
Karan Sharma, CFA
Trainer
Over 8 years of experience in M&A advisory, financial modelling, buy side equity research, advanced excel and financial statement analysis.
Upcoming dates
Currently there are no public classes/sessions scheduled for this course yet. For any in-house or private training, please contact us.
