Key Features of the course 25 hours of instructor led training + additional 15 hours of videos Batch limited to a maximum of 10 students Lifetime access to e-learning courseware Excel Templates for practice Industry Sector specific documents Training from industry expert Get exposed to industry case studies and live examples Application oriented learning – Apply what you have learnt in theory in your MBA, CFA course Actual hands on test Support while model creation Career assistance by interacting with the Industry practitioners Learn Excel shortcuts, Tips and Tricks
Topics Covered
Everything is done on excel period Learn basic and advanced Excel skills Understanding different company filings and financial statements Creating a financial model template Constructing and projecting a financial model Revenues drivers Cost drivers Debt and interest expenses schedule Fixed Assets Schedule Key financial statements – Linkages of Income statement, Balance sheet and cash flow statement Ratio analysis Company Valuation Relative valuation – P/E, P/B, EV/EBITDA, EV/Sales models Absolute valuation – FCFF, FCFE models Scenario analysis Sensitivity analysis
Who should attend
MBA Students, Professionals looking to switch career to equity research, project valuation, equity valuation. CFA students who want to get practical exposure.
Pre-requisites
None. However, students would be given excel videos before the class to get basic idea about excel.
What you need to bring
Laptop, pen and copy.
Key Takeaways
Access to step by step model template Basic study material for financial modeling and tip sheet for excel shortcuts Selected videos covering Basic and Advanced Excel Financial Reporting Industry Analysis Doubt clearing session through Email – Assured response within 48 hours Phone/Online – Schedule a 30 min meeting to go through your financial model