Who should attend

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

Training Content

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