Financial analytics provides scientific support to decision-making concerning a firm’s money related matters. This course addresses the topic of Financial analytics with a practical focus, focusing especially on demystifying analytics for finance managers, from both statistical and computing point of view.
DURATION – 3 DAYS
WHO SHOULD ATTEND
By completing this course, you should:
Be able to work comfortably with Microsoft Excel and many of its advanced features Become one of the top Excel users in your team Be much quicker at carrying out regular tasks Be able to build a P&L statement from a raw data extraction Be able to build a cash flow statement Know how to value a company Be able to build a valuation model from scratch Know how to create a model with multiple scenarios Know how to create professional and good-looking advanced charts.
Be able to work comfortably with Microsoft Excel and many of its advanced features Become one of the top Excel users in your team Be much quicker at carrying out regular tasks Be able to build a P&L statement from a raw data extraction Be able to build a cash flow statement Know how to value a company Be able to build a valuation model from scratch Know how to create a model with multiple scenarios Know how to create professional and good-looking advanced charts.
OBJECTIVES
LEARNING OUTCOMES:
We’ll cover tools and tips to make you more efficient in excel tactics. We’ll cover problem-solving basics We’ll cover the basics of data sourcing, management, cleaning and processing. You’ll learn how to analyze and interrogate large datasets with ease, as well as how to name and reference those datasets throughout your model. You’ll learn about ways to aggregate and synthesize your data, both through formulas and pivot tables. We’ll start building your actual model, based on the issue tree, analysis plan and actual data-centered analytics required as inputs. We’ll cover approaches to handling uncertainty with scenarios and sensitivities. Finally, we’ll cover how to pull it all together to create beautiful, robust and meaningful visual output that gives you robust and consistent outputs in the face of ever-changing business and leadership requirements.
CONTENT
Course Content
- 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