Modelowanie finansowe: Kompletny kurs finansów w Excelu

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