Job Description
Role Description
This is a contract Financial Modeling Training Tutor role located in Greater London. As a Financial Modeling Training Tutor, you will be responsible for delivering training sessions, developing course materials, and providing guidance and support to students in financial modeling concepts and techniques.
Qualifications
- Expertise in financial modelling techniques, tools, and software
- Demonstrated experience in delivering training or educational sessions
- Strong understanding of financial concepts and analysis
- Excellent communication and interpersonal skills
- Relevant certification or degree in Finance, Accounting, or a related field
Classroom training delivered in London.
Mon - Friday 10 am to 4 pm (Dates to be confirmed)
--------------------------------
Introduction to Financial Modeling
• Overview of financial modeling and its applications
• Key principles of financial modeling
• Excel tips and tricks for financial modeling Financial Statements
• Overview of financial statements (income statement, balance sheet, cash flow statement)
• Understanding the relationship between financial statements
• Building a simple financial model from scratch Forecasting Techniques
• Time series analysis and forecasting
• Regression analysis and forecasting
• Monte Carlo simulation for uncertainty analysis Valuation Methods
• Overview of different valuation methods (DCF, comparable analysis, precedent transactions)
• Building a DCF model from scratch
• Sensitivity analysis for valuation models Project Finance Modeling
• Overview of project finance and its key components
• Building a project finance model from scratch
• Understanding the impact of debt and equity on project finance Leveraged Buyout Modeling
• Overview of leveraged buyouts and its key components
• Building a leveraged buyout model from scratch
• Understanding the impact of debt and equity on LBOs Mergers and Acquisitions Modeling
• Overview of mergers and acquisitions and its key components
• Building an M&A model from scratch
• Understanding the impact of synergies and financing on M&A deals Financial Analysis and Ratio Analysis
• Overview of financial analysis and its key components
• Ratio analysis for financial modeling
• Understanding the impact of different ratios on financial modeling Corporate Budgeting and Forecasting
• Overview of corporate budgeting and forecasting
• Building a corporate budgeting model from scratch
• Understanding the impact of different scenarios on corporate budgets Capital Structure Modeling
• Overview of capital structure and its key components
• Building a capital structure model from scratch
• Understanding the impact of different debt and equity components on capital structure Risk Management and Hedging Strategies
• Overview of risk management and hedging strategies
• Building a risk management model from scratch
• Understanding the impact of different hedging strategies on financial modeling Portfolio Management Modeling
• Overview of portfolio management and its key components
• Building a portfolio management model from scratch
• Understanding the impact of different asset classes on portfolio management Real Estate Modeling
• Overview of real estate modeling and its key components
• Building a real estate model from scratch
• Understanding the impact of different scenarios on real estate modeling Equity Research and Stock Valuation
• Overview of equity research and stock valuation
• Building an equity research model from scratch
• Understanding the impact of different stock valuation techniques on financial modeling Advanced Excel Techniques for Financial Modeling
• Advanced Excel data analysis techniques
• Pivot tables, advanced filters, and sorting
• Advanced Excel functions for financial modeling
Visualization Techniques for Financial Modeling
• Overview of visualization techniques for financial modeling
• Building a financial model dashboard from scratch
• Understanding the impact of different visualization techniques on financial modeling Sensitivity Analysis and Scenario Planning
• Overview of sensitivity analysis and scenario planning
• Building a sensitivity analysis model from scratch
• Understanding the impact of different scenarios on financial modeling Capital Budgeting and Investment Analysis
• Overview of capital budgeting and investment analysis
• Building a capital budgeting model from scratch
• Understanding the impact of different investment scenarios on financial modeling Financial Modeling Best Practices
• Overview of financial modeling best practices
• Best practices for Excel formulas and functions
• Best practices for model structure and documentation Financial Modeling Case Studies
• Application of financial modeling in real-life scenarios
• Review of case studies and examples of financial models used in various industries
• Group discussion and analysis of case studies to reinforce learning and application of financial modeling techniques.