Learn more about our Financial Modeling Classes
Financial modeling is the creation of a projection, usually in Excel, of a company's future performance. Financial models are used to value businesses for purposes of raising capital or evaluating investments or to evaluate a financial transaction, such as a leveraged buyout or acquisition.
Why Learn Financial Modeling at NYIM?
- Build Intuition & Analytical Skills: Throughout the course, we will use real-world examples and financial data, so you're prepared for a position as a financial analyst. We use these examples to help build intuition for how Excel modeling, financial accounting, and valuation work together, instead of just providing unfounded formulas. You will also read company financials, presentations, and management commentary to determine the revenue projections and profitability ratios.
- Excel Tricks: A keys to success for any financial analyst is efficiency. The class provides extensive Excel tips and tricks that you will need to cut down errors and hours of work.
- 100% Practical: We've cultivated a course that focuses 100% on the practical skills and knowledge required for analyst and associate positions at investment banking, hedge funds, private equity, and asset management.
See for yourself why NYIM is rated the best Financial Modeling training in NYC by our customers:
Who should attend our Financial Modeling courses?
Our financial modeling and Excel courses are perfect for those interviewing for or starting a job in finance, including investment banking, hedge funds, private equity, real estate, and venture capital. The core finance, accounting, and Excel skills are applicable in almost any financial field.
If you are interviewing for a position in finance, this course will prepare you for typical interview questions, and help you decide which type of firm is the right fit.
Are there any prerequisites for the Financial Modeling course?
Since the course is intensive in modeling in Excel, intermediate-to-advanced Excel skills are required. We offer a Financial Analyst Training Program which includes three days of Excel training for those who need an Excel refresher.
Basic knowledge of financial concepts is helpful but not required. We offer a free finance and accounting review guide for all registrants in our financial modeling courses.
Financial Modeling Course Detailed Overview
- Finance Principles: Review essential finance concepts, such as Net Present Value (NPV), Internal Rate of Return (IRR), and how to calculate them in Excel.
- Market Capitalization: Learn how to calculate market cap for real companies, and which share count to use (basic versus diluted, and treasury stock method).
- Enterprise Value: What is Enterprise Value and why do we use it? What should and shouldn't be included and why?
- Financial Accounting: Learn accounting principles including accrual versus cash accounting. Analyze the core financial statements, including the income statement, balance sheet and statement of cash flow. Review financial ratios and working capital and discuss how these items impact modeling and valuation.
- Discount Cash Flow Modeling: Learn the "skeleton" of DCF modeling, how to project cash flow and a terminal value, and derive a share price from the model.
- Excel Techniques: Learn various Excel techniques, including Data Validation, CHOOSE, Data Tables, Goal Seek and more.
- Leveraged Buyouts: Review LBOs essentials, the players, and typical transaction structures. Create a simple LBO model to illustrate how these deals work and how private equity firms analyze them.
- Real Company Analysis: At home, review a presentation and financial statements for a public restaurant company. Understand the company's business model, growth drivers, profitability metrics, and other factors that impact valuation.
- Set up the Financial Model: Input historical financials, capital structure and other company information to start setting up your financial model.
- Model Projections: Analyze the company's revenue and expenses through financial statements and management commentary. Adjust for one-time items. Understand what is causing revenue increases/decreases and margin expansion/contraction. Create detailed revenue projections.
- Corporate Valuation: Calculate the WACC for the discount rate. Use the WACC and terminal growth rate to determine the Terminal Value (Gordon Growth Model). Discount the unlevered free cash flows to reach a total company value.
- Derive a value per share: Using the projections and discounted cash flows, derive an equity value per share. Review the model for reasonableness and sensitize the fundamental assumptions.
- Analyze the Model Output: Should we invest in the stock? What more information do we need? Where is our model deficient? Where do we feel confident? How do these projections compare to management's and the analyst community?