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.
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
Create powerful Scenarios and sensitivity tables by data crunching
Boost your professional resume. Most sought after skill required by employers
Professional data presentation in forms of charts and dashboards
9:00am - 10:00am
Excel set up for a financial model
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
10:45am - 12:45pm
Creation of supportive schedules
Asset schedules - capex and depreciation
Working capital analysis
12:45pm - 1:00pm
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
3:15pm - 4:30pm
Application of valuation tools
Calculation of Free cash flows
Application of DCF model
Application of relative valuation model
Karan Sharma, CFA
Over 8 years of experience in M&A advisory, financial modelling, buy side equity research, advanced excel and financial statement analysis.
Rahul Sonthalia, CFA
Over 11 years of experience in the area of macro-economic research, equity research, investment banking, with specialization in financial analysis, equity valuation, and Financial Modeling.
Currently there are no public classes/sessions scheduled for this course yet. For any in-house or private training, please contact us.