Excel Refresher
• Reducing the use of mouse
• Cell freezing and referencing
• Sorting and filtering the data along with advance filters
• Adding, deleting, hiding, unhiding rows and columns
• Changing the width of row/ column
• Simple excel formulas such as sum, product, paste special, concatenate, etc
• Conditional formatting
• V lookup/H lookup
• Match function
• Index function
• Transpose function
• Computation of CAGR
• Pivot Tables
• Usage of IF, Sumif, countif, sumifs, counta, etc
• Sumproduct function
• Trace precedents and dependents
• Calculation of IR
• Combination of multiple functions such as Vlookup+Match, Index+Match, etc
• Offset function
• Data Table
• Goal seek
• Sensitivity analysis
• Scenario Manager
• Developer tab
• Indirect function for summarizing data from different sheets
• Creation of dashboards to present the data in a professional manner
• Different types of charts and where to use them
• Formatting the charts
• Name manager
• Then vs Now interactive chart
Financial Modelling
• What is a good financial model
• Tips to avoid modelling errors
• Model building
• Building assumptions and rationale behind them
• Building dynamic business models from data provided
• Building financial statements
• Fixed assets and depreciation
• Working capital
• Capital structure
• NPV and IRR and which one is better
• Presentation and summarization of model from investor perspective
• XIRR and MIRR functions
• Computation of WACC using CAPM approach
• Computation of FCFF and FCFE
• Using data table and scenario manager, etc to take decisions
• Manufacturing model
• Real estate model
• Infrastructure modelling
• Hospitality Modelling
Valuation
• Different techniques of valuation
• Discount rate
• Enterprise value
• Free cash flow to firm (FCFF)
• Free cash flow to equity (FCFE)
• Beta
• Relative valuation
• Why different companies in same sector trade at different multiples
• How relevance of multiples change as per industry
Comparable company multiple method
• How to select peers
• Computing the multiples
• How to use comparable multiples for computing WACC
• Computing the valuation using the above method
Comparable Transaction multiple method
• Analysing the recent deals in the market and how to use them for creating meaningful transaction comp analysis
• Difference between comparable companies multiple method and comparable transaction multiple method
• Computing the valuation using the above method
Discounted Cash Flow method
• Computing debt free cash flows from the projections
• Terminal value
• Computation of WACC and factoring the risk related to the company
• Different ways to compute terminal value and where to use which way
• Computation of valuation using discounted cash flow method
Case Study: Valuation for
• Financial Industry
• Other Industries