Financial Modeling Program in Excel
Modeling is projecting scenarios, understanding complex relationships and converting data into informed decisions.
DURATION
16 hours of intensive technical training
FORMAT
Blended - Combination of synchronous online sessions with face-to-face working sessions, on October 17 and 18 in Madrid. on October 17 and 18 in Madrid.
EXCLUSIVITY
Number of places is limited to 20 participants.
PRICE 600€
Consult available bonuses
This course provides technical and structured training in financial modeling, designed to be applied from day one in real environments.
Throughout the course, participants will advance in the construction of a guided case study, combining theoretical foundations with direct application. Each phase is accompanied by periodic deliverables, individualized review and follow-up by an expert team.
According to a study conducted by PwC, financial analysts who use structured modeling in Excel manage to reduce, on average, between 30% and 40% of the time spent on recurring tasks -such as projections, budgets and scenario analysis-, which translates into 15 hours less work per week. 15 horas semanales menos de trabajo.
Recommended background:
- Functional proficiency in Excel.
- Solid knowledge of accounting and finance.
- Familiarity with financial analysis concepts.
- Ability to work with structured logic and attention to detail, given the technical focus of the program.
¿Este curso es para mí?:
- Graduados en Administración, Finanzas e Ingeniería que quieran desarrollar habilidades clave para acceder a roles en consultoría, banca de inversión o desarrollo corporativo.
- Consultores financieros o técnicos, con o sin experiencia previa en modelización, que deseen dominar la construcción estructurada de modelos financieros desde cero y mejorar su capacidad para trabajar con modelos de terceros.
- Professionals in investment banking, energy, infrastructure or real estate who want to incorporate a rigorous financial vision to their technical expertise and expand their growth possibilities and professional projection.
- Entrepreneurs and startup professionals who need to manage large volumes of data in spreadsheets and face the challenge of structuring and analyzing their financial information to build reliable forecasts and optimize their work time.
What you will learn in this course:
- You will build financial models from scratch, following a structured and replicable logic
- You will interpret and adapt existing financial models with solvency.
- You will analyze real investments, scenarios and financial decisions through the practical use of models
- You will analyze real investments, scenarios and financial decisions through the practical use of models
¿Dónde te impulsará este curso?:
- M&A (Mergers and Acquisitions)
- Project Finance
- Business Development
- Real Estate and Asset Management
- Financial Analysis and Management Control
- Project Management
CALENDAR
| Mo | Tu | We | Th | Fr | Sa | Su |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 18:00 a 20:30 |
8 | 9 18:00 a 20:00 |
10 | 11 | 12 |
| 13 | 14 18:00 a 20:00 |
15 | 16 | 17 17:00 a 20:00 |
18 09:00 a 14:00 |
19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 18:00 a 20:30 |
29 | 30 | 31 |
Virtual sessions: October 7, 9, 14 and 28 through our “Campus Bespoke” (ZOOM) platform
Presential sessions: October 17 and 18 at the Hotel The Westin (Sala Consejo B) – Madrid
ESTRUCTURA DEL PROGRAMA
A lo largo de 16 horas, el contenido se organiza en 7 módulos progresivos, diseñados para construir, revisar y aplicar un modelo financiero completo desde cero:
MODULE 1
Introduction to modeling and fundamental concepts of Excel
MODULE 2
Parte operativa del modelo. Estados financieros y cuadre del modelo
MODULE 3
Financial dimension of the model. Introduction to modeling
MODULE 4
Debt dimensioning
MODULE 5
Fiscal dimension of the model: modeling and elimination of circular references
MODULE 6
Equity Cash Flow: restricciones y determinación. Valoración de activos por descuento de flujos de caja
MODULE 7
Review and joint completion of the exercises and resolution of doubts
All contents will be developed simultaneously through the individual execution of a case study that, sequentially, will allow each participant to build a complete financial model from scratch.
Do you want to take the next step in your professional development?
- Places are limited to 20 participants: reduced format to ensure a personalized and practical experience.
- Download the Academic Guide to know in detail the course objectives, methodology and Academic Director of the Program.
- Reserve your place by paying 50% of the registration fee. You can cancel without penalty until September 8.
- After September 8, full payment of tuition will be required to confirm enrollment.
- Possibility of discounts through Fundae or agreements with collaborating companies.
Rigorous training. Real application. A solid step towards your next professional challenge