Excel for Financial Modeling & Valuation: The Complete Guide

Excel for Financial Modeling & Valuation: The Complete Guide

Hands on Excel Tutorials to Help You Master Financial Forecasting, Scenario Analysis, and Valuation Techniques.



Sub Category

  • Microsoft

{inAds}

Objectives

  • What is Financial Modeling? Why It Matters
  • Types of Financial Models
  • Overview of Valuation Methods (DCF, Multiples, LBO, etc.)
  • Excel Interface, Shortcuts, and Best Practices
  • Formatting and Layout for Financial Models
  • Key Excel Functions for Finance
  • Building the Income Statement
  • Constructing the Balance Sheet
  • Linking the Cash Flow Statement
  • Profitability Ratios
  • Introduction to Valuation
  • Discounted Cash Flow (DCF) Valuation
  • Relative Valuation: Comparable Company Analysis
  • Precedent Transactions Analysis and more


Pre Requisites

  1. No prior excel experience required


FAQ

  • Q. How long do I have access to the course materials?
    • A. You can view and review the lecture materials indefinitely, like an on-demand channel.
  • Q. Can I take my courses with me wherever I go?
    • A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!



{inAds}

Coupon Code(s)

Previous Post Next Post