Financial Modeling Bootcamp

Build a financial model and learn corporate finance and accounting principles. By the end of this course, you'll have a comprehensive Discounted Cash Flow (DCF) model to add to your portfolio. You'll have a fundamental knowledge of corporate finance and accounting concepts. Finally, your advanced Microsoft Excel skills will aid you in building financial models quickly and accurately.

Master Financial Modeling 

Build a comprehensive DCF (Discounted Cash Flow) model and master essential finance and accounting concepts. First, you'll dive into advanced Excel functions for finance like VLOOKUP and IF statements. You'll then review corporate finance and accounting concepts before building a valuation model on a public company.

The Financial Modeling Bootcamp covers common topics asked in investment banking and financial analyst interviews. After this course, you'll have a financial model to present as part of your portfolio during the interview process. This course prepares you with all the essential skills you need to succeed as a professional that specializes in building financial models.

• Master Advanced Excel - Learn essential Excel functions for finance including cash flow projection tools, and shortcuts for building financial models in Excel
• Learn Corporate Finance and Accounting - Learn the basics of enterprise value, corporate valuation, and reviewing financial statements
• Create a DCF (Discounted Cash Flow) Financial Model - Review financial information, derive a share value, and create a financial model to evaluate an investment

Free Retake & Course Materials

In addition to receiving comprehensive financial training and a financial model to show off after the course, you receive the following benefits:

• Free retake - take the course again for free within six months of your enrollment
• Free access to computers and software - no need to bring a computer or purchase software for the course
• Custom workbook - Keep your course workbook, complete with detailed instructions and practice exercises to reference and practice what you've learned after the course

This course has a prerequisite

• Students without corporate finance or accounting knowledge should request access to and review our free online preparatory materials after registering for the course.
• Excel proficiency equivalent to Intermediate Excel for Business is required, including VLOOKUP, Pivot Tables, and IF statements.

Course Overview

• 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 Syllabus

Day I: Advanced Excel for Financial Modeling

• Advanced techniques to Expedite Workflow
• Advanced Analytical Tools & Sensitivity Analysis
• Database Functions for Finance
• Functions for Financial Modeling

Day II: Intro to Corporate Finance, Accounting, & Modeling

• Intro to Corporate Finance
• Enterprise value
• Financial Accounting & Statement Analysis
• Integrated Financial Modeling
• Intro to DCF Modeling
• Sensitivity Analysis
• Intro to LBO Modeling

Day III: In-depth Financial Modeling & Valuation

• Company Analysis
• Financial projections
• Terminal Value
• Discounting Cash Flows
• Corporate Valuation
• Final Analysis & Reasonability Testing

Learn more about Financial Modeling Bootcamp at NYC Career Centers