Excel financial modeling training

Prerequisites

It is recommended that you have a good command of Excel

Objectives

◗ Learn a practical and accessible approach to becoming more effective at financial modeling.

◗ Ensure consistency in the model across the income statement, balance sheet, and cash flow statement.

◗ Calculate and optimize financial metrics.

◗ Explore complex choices through simulations under constraints to set objectives.

◗ Set up project funding.

Training program

◗ Adopt a structured approach to financial modeling

– Building a model: key steps (history, assumptions, financial statements)
– Applying best practices in modeling
– Summarizing and creating a visual presentation
– Identifying constraints and defining scenarios
– Appendix: Steps for Building the Model
✔ UNDERSTAND | Illustration: The “3 Pillars” of Financial Modeling
✔ EVALUATE | Quiz: In your opinion… What is the purpose of a financial model?
✔ APPLY | Practical Exercise: Reconstruct a Financial Modeling Framework Step by Step
✔ APPLY | Practical Exercise: Build a Dynamic Summary

◗ Forecasting cash flows and structuring financing

– Ensuring consistency between the income statement, balance sheet, and cash flow statement
– Direct and indirect methods for preparing projected cash flow statements
– Methods for dynamically forecasting balance sheet items related to the operating cycle (working capital)
– Structuring financing: equity, debt, debt characteristics, distribution strategy, project financing
– Appendix: indicator sheets
✔ APPLY | Practical exercise: complete the balance sheet and cash flow statement of a model based on the given assumptions
✔ EXPERIMENT | Workshop: analyze the financing of a project
✔ EVALUATE | Several quizzes: in your opinion… What factors cause discrepancies? What is the average payment term, and how many days of accounts receivable are shown on the balance sheet? What is the appropriate dividend level?

◗ Explore complex choices, optimize and simulate

– Answer questions using the template (using Target Value)
– Optimize under constraints and relax constraints based on an objective (using the Solver)
– Conduct a sensitivity analysis to improve your understanding of the model
✔ APPLY | Practical case: Build an automated sensitivity analysis
✔ EXPERIMENT | Workshop: Determine an optimal payout ratio based on shareholder cash flows
✔ EVALUATE | Application case: Answer questions about the model

Why choose this course?

What is the maximum growth rate for my business that will allow it to stabilize its debt?

You’ve always dreamed of having an integrated model that simulates your business, manages the impact of revenue and cost drivers, takes financing into account, and reflects contingencies and improvement initiatives. FinHarmony has made it a reality. Your proposals will be more robust and well-reasoned, your responses to requests for proposals will be more reliable, and your decision-making will be better informed.

Teaching and assessment methods

Before the training: Submit your expectations via your online portal 15 days before the training begins and complete a self-assessment of your skills.

Teaching Methods: A variety of teaching methods to cater to different learning styles, encourage active participation, and reinforce learning through experimentation and practice.

Educational materials: presentation materials, reference materials (summary sheets, tables, etc.), and other resources available in your account.

During the training: theoretical concepts are alternated with examples drawn from real-life cases. Participants are given the opportunity to engage in role-playing exercises. Numerous practical exercises allow participants to demonstrate their mastery of the skills as the training progresses.

Training monitoring and evaluation: attendance sheet and certificate of completion. Immediate and post-training evaluations conducted using the LearnEval platform.

Price

1 295 € EXCL. TAX

Testimonials

Excel financial modeling training

Jonathan C.
Company
Training

Generalist trainings

Excel financial modeling training