Financial Modeling Bootcamp (Live Online)

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 ExcelLearn Corporate Finance and Accounting - Learn the basics of enterprise value, corporate valuation, and reviewing financial statementsCreate a DCF (Discounted Cash Flow) Financial Model - Review financial information, derive a share value, and create a financial model to evaluate an investmentFree Retake & Course MaterialsIn 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 enrollmentFree access to computers and software - no need to bring a computer or purchase software for the courseCustom workbook - Keep your course workbook, complete with detailed instructions and practice exercises to reference and practice what you've learned after the courseThis course has a prerequisiteStudents 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 OverviewAdvanced Excel for Finance: Financial functions, advanced formulas, Data Tables, & Excel tricksCorporate Finance: Market Cap, Enterprise Value, Stocks & Bonds, NPV, IRRFinancial Accounting: Financial statements, financial ratios, and working capitalCompany Analysis: Analyze companies through financial statements, presentations, & recent newsDiscount Cash Flow Modeling: Project and discount future cash flowsCorporate Valuation: Corporate valuation principles to value companiesFinancial Analyst Best Practices: Tips and tricks financial analysts need to knowInvestment Banking Interviews: Review concepts typically asked in investment banking interviewsFull Course SyllabusDay I: Advanced Excel for Financial ModelingAdvanced techniques to Expedite WorkflowAdvanced Analytical Tools & Sensitivity AnalysisDatabase Functions for FinanceFunctions for Financial ModelingDay II: Intro to Corporate Finance, Accounting, & ModelingIntro to Corporate FinanceEnterprise valueFinancial Accounting & Statement AnalysisIntegrated Financial ModelingIntro to DCF ModelingSensitivity AnalysisIntro to LBO ModelingDay III: In-depth Financial Modeling & ValuationCompany AnalysisFinancial projectionsTerminal ValueDiscounting Cash FlowsCorporate ValuationFinal Analysis & Reasonability TestingLearn more about Financial Modeling Bootcamp at NYC Career Centers