Excel Based Financial Modeling

Excel Based Financial Modeling training is offered by Knowise Learning Academy. We, at Knowise, truly believe that skill enhancement is a lifelong process and regular upgrade helps individuals and organizations excel in their field.  

We are a financial training organization that helps individuals enhance their skills and exceed in the financial services domain.

Our USP lies in simplifying the most complex concept and making the participant understand the “ why” and not just the “how”. Finance trainings require the technical aspects to be conveyed not just from a conceptual point of view, but also from a practical point of view. 

Our finance training modules for corporates use case studies, role plays and real time calculations to ensure the participants grasp the concept quickly and relate to it in their work. All our trainers come with vast industry experience and  are well versed in handling their subjects from a practical point of view.  

Course Content:

• Build a financial model from scratch as done at financial institutions
• Understanding  valuation and Dividend Discount Model
• Free Cash Flow to Firm (FCFF) & Free Cash Flow to Equity (FCFE)
• Calculate the Discount Rate using cost of capital
• Preparation of DCF Model
• Equity Value Multiples: P/E, P/CF, P/BV, P/S, PEG, Dividend Yield
• Perform Trading Multiples analysis – EV/EBITDA, EV/EBIT, EV/Sales
• Perform Transaction Multiples analysis – EV/EBITDA, EV/EBIT, EV/Sales