Financial Modeling on Excel Complete finance course on Excel

Financial Modeling practical case and training on Excel - Business Plan, Valuation, and Financial Modeling on Excel

Created by: Yassine Rochd
Private Equity Associate

What Will I Learn?

• Gain proficiency in the modeling rules followed by investment bankers, private equity professionals, and transaction services consultants
• Build a clear, comprehensive, and well-organized financial model in Excel
• Acquire a solid foundation in financial modeling fundamentals
• Create a complete business plan in Excel
• Review the essential and fundamental accounting and corporate finance concepts for financial modeling
• Construct a cash flow statement and calculate free cash flows (FCF)
• Model financial debt and simulate principal and interest repayments.
• Determine the company's Enterprise Value using the comparable method and deduct the Equity Value
• Establish a normative EBITDA
• Using Excel, calculate the investment multiple and the internal rate of return (IRR) for a transaction

Requirements

• Access to Microsoft Excel

Target audience

• Finance students who are interested in highly competitive areas of corporate finance such as Private Equity, Venture Capital, M&A, Leveraged Finance, ECM, Transaction Services, Restructuring, Valuation, and, of course, financial modeling
• Candidates for an interview in finance who want to practice and prepare for Excel-based financial modeling cases
• Corporate finance interns seeking to enhance their skills in finance, financial modeling and Excel
• Junior analysts in corporate finance
• Senior finance analysts who aim to enhance their proficiency in financial modeling using Excel