Financial Modeling teaches you to work with historical information on companies and analyze the company / industry performance.

This analysis is then used as an input to build financial models. These models then project the future financial performance of the companies analyzed and hence give us an estimate of the valuation of the companies.

What you will Learn?

HANDS-ON TRAINING TO BUILD REAL-WORLD MODELS WITH EXAMPLES FROM TODAY'S TOP FIRMS

• Use common function keys
• Construct a basic IF statement
• Differentiate between different ways of summing and counting
• Select alternatives to using the IF function
• Use error trapping
• Control the appearance of numbers and text
• Apply various methods for determining dates
• Select and apply appropriate lookup and reference functions
• Create a Pivot Table to analyze data sets
• Use functions for discounting on uneven periods
• Understand other useful Excel features
• Apply financial modeling best practices
• Project an income statement and balance sheet
• Force-balance the balance sheet
• Construct a Statement of Cash Flows
• Calculate free cash flow
• Incorporate projection scenarios in a model
• Add an automatic cash sweep feature to a model
• Construct a discounted cash flow model to determine the intrinsic value of equity
• Perform meaningful sensitivity analysis
• Construct a valuation sheet to apply the APV valuation approach
• Value a stream of future interest tax shields
• Measure residual earnings (earnings above or below required earnings).
• Determine the value of earnings using accrual accounting
• Determine the value of equity or the firm using multiples

Who Should Attend this?

• Entry level finance professionals
• investment professionals
• financial analysts
• corporate bankers
• and lateral hires