Learn essential finance & accounting concepts while building a comprehensive discounted cash flow model in Excel. This financial modeling class blends finance, accounting, and Excel concepts into an intensive 3-day course. You'll learn the practical skills you need to succeed as a financial analyst from an experienced investment banker and hedge fund analyst.
- Advanced Excel Training for Finance: Master advanced techniques including Goal Seek, financial functions, shortcuts, and cash flow projection tools.
- Crash Course in Finance & Accounting: Review corporate finance and accounting concepts, including enterprise value, financial statements, investments, and corporate valuation.
- Real-World Financial Modeling Project: Create a valuation model on a public restaurant company using current financial data. Review company presentations, earnings releases, and financial reports to determine the model drivers and assumptions. Derive a share value using corporate valuation principles and evaluate the stock for a potential investment.
Prerequisites: This course assumes intermediate knowledge of Excel equivalent to our Intermediate Excel for Business course. Finance, accounting, or financial modeling knowledge is helpful but not required. Students without any background in corporate finance or financial accounting should review our free online prep materials before the course (request the free materials after registration).
Need to learn the prerequisite Excel skills? Check out our Excel courses, or learn financial modeling and Excel together in our Financial Analyst Training Program or Winter Break Financial Modeling Intensive.
Financial Modeling Bootcamp
Register for a class
What You'll Learn
- Advanced Excel for Finance: Financial functions, advanced formulas, Data Tables, & Excel tricks
- Corporate Finance: Market Cap, Enterprise Value, Stocks & Bonds, NPV, IRR
- Financial Accounting: Financial statements, financial ratios, and working capital
- Company Analysis: Analyze companies through financial statements, presentations, & recent news
- Discount Cash Flow Modeling: Project and discount future cash flows
- Corporate Valuation: Corporate valuation principles to value companies
- Financial Analyst Best Practices: Tips and tricks financial analysts need to know
- Investment Banking Interviews: Review concepts typically asked in investment banking interviews
Full Course SyllabusDownload PDF Outline
Day I: Advanced Excel for Finance
- PV and NPV functions to value investments
- XNPV functions to value investments based on investment dates
- IRR function to calculate the return on an investment
- XIRR function for returns based on investment dates
- PMT function to calculate the monthly payment on a mortgage
- YLD function to calculate the yield on a bond or other investment
Advanced Excel Techniques to Expedite Workflow
- Advanced Cell Anchoring: Create powerful formulas by locking either the column or the row
- Hot Keys: Transform the ribbon into a visual listing of pre-assigned shortcuts
- Windows: Techniques and keyboard shortcuts to allow editing of active windows
- Cell Auditing: Observe the relationship between formulas and cells
- Date Functions: Calculate dates with a variety of functions
- Create custom rules for Conditional Formatting with formulas
- Nested IF Statements
- Expand the functionality of the IF function by adding an AND / OR criteria
Advanced Analytical Tools
- Goal Seek: Find the desired result by adjusting an input value
- Data Tables: Data Tables show the range of effects of one or two different variables on a formula
Advanced Database Functions
- MATCH Function: Return the relative position (column or row number) of a lookup value
- VLOOKUP-MATCH: Create a more accurate VLookUp by enhancing the determination of the Column Index number
- INDEX-MATCH: Efficiently return a value or reference from a cell at the intersection of the row and column
- INDEX-Double MATCH: Use a second Match function to create a powerful, two-way lookup tool
Project I: Intro to Cash Flow Modeling
- Use advanced Excel techniques to project cash flows
- Set up model scenarios with dropdown menus and CHOOSE function
- Create a data table to show a range of outputs
- Use Goal Seek to back into a target value
Advanced Modeling Techniques
- Auditing the model
- Find & Replace
- Go To Special
Project II: Loan Amortization Model
- Use the Payment function to calculate the monthly payment on a mortgage
- Use various Excel tricks to quickly populate the loan table
- Advanced SUMIFS: Extract data from the loan table
Day II: Intro to Corporate Finance, Accounting, & Financial Modeling
- Present Value (PV) and Net Present Value (NPV)
- Internal Rate of Return
- How are PV and IRR used in financial modeling?
- How companies raise capital through debt and equity issuances
- Stocks, dividend yields, trading terminologoy, and valuation metrics
- Market Capitalization: Calculate the market cap for public companies
- Shares outstanding: How does share count change over time?
- Enterprise Value: Calculate the enterprise value for public companies
Financial Accounting & Statement Analysis
- Cash vs. accrual accounting
- Assets = Liabilities + Shareholder's Equity
- Annual and quarterly filings, and press releases
- Income Statement: Analyze line items on an income statement; calculate growth rates, and TTM
- Balance Sheet: Review assets, liabilities and shareholder's equity
- Cash Flow Statement: Analyze a public company cash flow statement
- Working Capital: Calculate and understand working capital
Review of Excel techniques for financial modeling
- Data Validation: Use data validation to define the model's scenarios
- Nested IFs: Show the active scenario with Nested IFs
- CHOOSE Function: Select the scenario to run through the model
- Naming Cells: Name cells for easy referencing
Projecting Cash Flows
- EOMONTH: Populate the future dates using EOMONTH
- IFERROR: Use IFERROR to avoid showing cell errors
- Calculate Net Income and project the future cash flows using the model's assumptions
- Use the model to calculate the enterprise value and share price
- Use Data Tables to sensitize the model's key inputs
- Advanced Conditional Formatting: Conditional Format with formulas to highlight cells that meet certain criteria
- Goal Seek: Calculate the revenue growth required to hit a certain share price
Auditing the Model
- Review the model for errors and formula consistency
- Paste Special: Convert the model from thousands to millions
- Go To Special: Change the color of hardcoded cells only
- Calculation options, circular references, error checking
Intro to LBO Modeling
- Review Leveraged Buyouts (LBOs) basics
- Create a simple LBO model
- Calculate the IRR and Equity Multiple
Day III: Comprehensive Financial Modeling & Corporate Valuation
- Discuss the business model and value drivers of a public restaurant company
- Capital Structure: Calculate the total enterprise value and build a capital structure table
- Historical Financials: Populate the historical financials
- Ratios: Calculate the financial ratios
- Create financial projections for revenues
- Create financial projections for expenses
- Create projections for the working capital items
- Estimate the company's terminal value using the Gordon Growth Model
Discounting Cash Flows
- Use CAPM to estimate the company's cost of equity
- Calculate the weighted average cost of capital (WACC)
- Calculate the present value of future cash flows
- Calculate the diluted shares outstanding using the treasury stock method
- Derive a value per share from total company valuation
- How does our value per share compare to the current price?
- How do our financial projections compare to management's and the analyst community
- Analyze the output and determine reasonability of the model and assumptions
- What areas or assumptions require additional research?
- What assumptions drive the valuation and how would changes impact our thesis
- Is the equity a good investment?
NYC's Top Finacial Modeling Course
Comprehensive & Affordable Training for Financial Analysts
"Took the two-day Financial Modeling Bootcamp. Extremely informative and useful. Smaller class size allows for one on one help and enables you to really understand the material you are working through. Additionally, you build out a model on an actual company during the course, allowing you to perform the same kind of analysis you would use in a real office setting, as opposed to looking at generic accounting problems. Office itself is very nice, and the professors are extremely well informed. 10/10 would recommend to anyone looking to develop, sharpen, or reestablish their financial modeling skills."
- Robert F. attended the Financial Modeling Bootcamp
"I can honestly say I learned more useful modeling and excel skills from the Financial Modeling Bootcamp then I have through one and a half years of business school. The course effectively conveys key finance, corporate finance, and financial accounting concepts while also offering students the opportunity to build real financial models with real-time data. The 7:1 student to teacher ratio along with the experience and modeling expertise of Mourad offers a unique opportunity for a personalized learning experience. Whether you are a student looking to pursue a career in finance or a current professional simply looking to brush up on your Excel skills, I would highly recommend this course."
- Noam L. attended the Financial Modeling Bootcamp
Who Should Attend This Course?
This course is perfect for incoming or current financial analysts seeking to learn or review finance, accounting, valuation, and Excel. This bootcamp will be particularly helpful for analysts working in investment banking, private equity, hedge funds, real estate, and venture capital, as well as professionals working in finance departments of non-financial companies. Additionally, the course covers many concepts covered in investment banking interviews.