Course Overview
- Course Title: Modelagem Financeira, Finanças e Gestão financeira no Excel
- Instructor: Yassine Rochd
- Target Audience:
- Professionals interested in financial careers such as Private Equity, M&A, financial control, or financial management
- Individuals seeking to enhance their financial modeling skills
- Prerequisites:
- Access to Microsoft Excel
Curriculum Highlights
- Key Topics Covered:
- Financial modeling techniques used by investment bankers, private equity professionals, and consultants
- Building comprehensive financial models in Excel
- Fundamentals of financial modeling
- Developing detailed business plans in Excel
- Essential accounting concepts and principles for financial modeling
- Creating cash flow statements and calculating Free Cash Flow (FCF)
- Structuring financial debt and simulating principal and interest payments
- Corporate valuation using market comparison methods
- Establishing and analyzing normalized EBITDA
- Using Excel to calculate investment multiples and Internal Rate of Return (IRR)
- Key Skills Learned:
- Proficiency in financial modeling techniques
- Building clear and well-structured financial models in Excel
- Creating detailed business plans
- Understanding essential accounting principles
- Calculating cash flow statements and Free Cash Flow (FCF)
- Structuring financial debt and simulating payments
- Performing corporate valuation
- Analyzing normalized EBITDA
- Calculating investment multiples and IRR in Excel
Course Format
- Duration: 3.5 hours of on-demand video
- Format: Self-paced online course
- Resources:
- 15 downloadable resources
- Access on mobile and TV
- Closed captions
- Audio description in existing audio
- Certificate of completion