Build a comprehensive financial model while mastering corporate finance and accounting principles. Upon completion, you will have created a detailed Discounted Cash Flow (DCF) model to showcase in your professional portfolio, gained fundamental knowledge of corporate finance and accounting concepts, and developed advanced Microsoft Excel skills for rapid and accurate financial model construction.
Mastering Financial Modeling and Valuation:
This comprehensive program guides you through building a complete DCF model while learning essential finance and accounting concepts. You will start by exploring advanced Excel functions critical for finance professionals, including VLOOKUP and IF statements. Next, you will review corporate finance and accounting fundamentals before constructing a sophisticated valuation model based on a real public company.
The Financial Modeling Bootcamp covers topics frequently discussed in investment banking and financial analyst interviews. After completing this course, you will have a polished financial model to include in your portfolio during the interview process. This program equips you with all the essential skills needed to succeed as a professional specializing in financial model development and corporate valuation analysis.
- Master advanced Excel techniques; learn essential financial functions, including cash flow projection tools, formulas, and shortcuts for building financial models efficiently in Excel
- Learn corporate finance and accounting fundamentals; understand enterprise value calculations, corporate valuation methods, and how to analyze financial statements comprehensively
- Create a complete DCF financial model; analyze financial information, derive share valuation, and build a sophisticated model for evaluating investment opportunities
Comprehensive Benefits and Course Materials:
In addition to receiving extensive financial training and building a financial model for your professional portfolio, you receive the following advantages:
- Free course retake: retake the entire course at no charge within six months of your initial enrollment
- Free access to computers and software; no need to bring your own computer or purchase software for the training
- Custom course workbook: keep your detailed workbook complete with comprehensive instructions and practice exercises for ongoing reference and skill development after the course
Course Prerequisites:
- Students without a corporate finance or accounting background should request access to and review our free online preparatory materials after registration to ensure a foundational understanding.
- Excel proficiency is required at the intermediate level equivalent to Intermediate Excel for Business, including proficiency with VLOOKUP, Pivot Tables, and IF statements.
Detailed Course Overview:
- Advanced Excel for Finance: financial functions, advanced formulas, Data Tables, and Excel optimization techniques
- Corporate Finance: market capitalization, enterprise value, stocks and bonds, net present value (NPV), and internal rate of return (IRR)
- Financial Accounting; financial statements analysis, financial ratios calculation, and working capital management
- Company Analysis: comprehensive company evaluation through financial statements, presentations, and recent news
- Discounted Cash Flow Modeling: projecting future cash flows and discounting them to present value
- Corporate Valuation: applying valuation principles to determine company worth
- Financial Analyst Best Practices: professional tips and strategies that financial analysts apply in their daily work
- Investment Banking Interviews: review and understand concepts typically asked in investment banking interviews
Complete Course Syllabus:
Day 1: Advanced Excel for Financial Modeling
- Advanced techniques to accelerate workflow and increase efficiency
- Advanced analytical tools and sensitivity analysis methods
- Database functions specifically for finance professionals
- Key functions for financial modeling and forecasting
Day 2: Introduction to Corporate Finance, Accounting, and Modeling
- Introduction to corporate finance principles and concepts
- Enterprise value calculation and analysis
- Financial accounting fundamentals and statement analysis
- Integrated financial modeling practices
- Introduction to DCF modeling methodology
- Sensitivity analysis for scenario testing
- Introduction to LBO (leveraged buyout) modeling
Day 3: In-Depth Financial Modeling and Valuation
- Company analysis and financial assessment
- Financial projections and forecasting
- Terminal value calculation and assumptions
- Discounting cash flows to present value
- Corporate valuation principles and applications
- Final analysis and reasonability testing of results
Learn more about the Financial Modeling Bootcamp at NYC Career Centers
