HR ANALYTICS AND METRICS
Overview
This course covers the area of financial analytics, which is a major determinant of a firm’s growth as it provides scientific support in the decision-making of a firm’s finances. The course aims at demystifying financial analytics for finance managers, from both the statistical and computing points of view.
- Tools and tips to make the trainees more efficient in the mastery of Microsoft excel
- Teaching the basics of problem-solving
- Teaching the basics of data sourcing, management, cleaning and processing.
- Been able to easily analyze and interrogate large datasets.
- Been able to appropriately label and reference the specified datasets throughout the model.
- Learning methods of aggregating and synthesizing selected data using formulas and pivot tables.
- Developing an actual unique model based on the issue tree, analysis plan and actual datacentered-analytics
- Actual scenarios to facilitate learning of various approaches to handling uncertainties and
sensitivities. - Linkage of all areas covered which will result in the creation of well-packed, robust, organized,
and coherent visual outputs that are adaptable to all business and leadership conditions.
- To gain mastery of basic and advanced features of Microsoft Excel thereby becoming experts in
the field. - To become more efficient in executing regularly assigned duties.
- Be able to build a P&L statement from a raw data extraction.
- Be able to build a cash flow statement.
- Know how to evaluate the value of a company.
- Be able to construct a valuation model from the beginning.
- Know how to create a model using multiple scenarios
- Know how to create professional and attractive advanced charts.
- Introduction: Financial Modelling, Financial Planning and DCF Valuation
- Creating the Financial Model Template from scratch
- Model Inputs and Financial Plans
- Model Scenarios
- Model Revenue Schedule
- Model Cost of Sales Schedule
- Model Working Capital Schedule
- Model Depreciation Schedule
- Model Debt Schedule
- Model Equity Schedule
- Model Tax Schedule
- Model Income Statement
- Model Balance Sheet
- Model Cashflow Statement
- Model DCF Valuation
- Model Financial Ratios
