Financial Modeling Bootcamp (Live Online)

Master the skills you need to succeed as a financial analyst. This bootcamp will cover advanced Excel for finance, corporate finance and accounting principles, and financial analysis and valuation.Master the advanced Excel, financial modeling, corporate finance, and accounting skills you need to succeed as a financial analyst. Build a financial model to value a public company, and learn industry best practices from experienced investment bankers and hedge fund analysts.Advanced Excel for Financial Modeling: Master advanced techniques including sensitivity analysis, financial functions, modeling 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 for 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.Prerequisite:Prior financial experience is helpful, but not required. Those without a finance or accounting background will receive a short guide prior to the course (request upon registration) to acclimate themselves to terminology.Excel proficiency equivalent to Intermediate Excel for Business is required, including VLOOKUP, Pivot Tables, and IF statements.What You’ll Learn at a GlanceAdvanced Excel for Finance: Financial functions, advanced formulas, Data Tables, & Excel tricksCorporate Finance: Market Capitalization, 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 interviewsCourse 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 NYIM Training