Course Overview
- Course Title: Modelowanie finansowe: Kompletny kurs finansów w Excelu
- Instructor: Yassine Rochd
- Target Audience:
- Individuals interested in careers in finance, such as Private Equity, Mergers & Acquisitions (M&A), financial control, or financial management.
- Professionals seeking to enhance their financial modeling skills.
- Those aiming to create business plans, financial reports, or company valuations.
- Prerequisites:
- Access to Microsoft Excel
Curriculum Highlights
- Key Topics Covered:
- Financial modeling principles used by investment bankers, private equity specialists, and transaction services consultants.
- Building transparent, complex, and well-organized financial models in Excel.
- Solid foundations of financial modeling.
- Creating a complete business plan in Excel.
- Key concepts in corporate accounting and finance essential for financial modeling.
- Constructing cash flow statements and calculating free cash flows (FCF).
- Modeling financial debt and simulating capital and interest repayments.
- Determining Enterprise Value using the comparative method and subtracting the value of equity.
- Establishing the normative size of EBITDA.
- Using Excel to calculate investment multiples and Internal Rate of Return (IRR) for a given transaction.
- Key Skills Learned:
- Financial modeling best practices and standards.
- Designing complex financial models with multiple investment scenarios.
- Creating debt schedules with different financing tranches and characteristics.
- Developing a professional business plan.
- Building a company valuation model based on comparable transactions using normative EBITDA.
- Calculating IRR and conducting sensitivity analysis based on investment exit parameters.
Course Format
- Duration: 3.5 hours on-demand video
- Format: Self-paced online course
- Resources:
- 6 downloadable resources
- Access on mobile and TV
- Certificate of completion