Build a deep understanding of finance and accounting while constructing a complete, real-company discounted cash flow (DCF) model in Excel. Over three intensive days, you will advance from intermediate Excel skills to professional-level financial modeling, covering financial accounting, corporate valuation theory, and hands-on model construction from start to finish.
Prerequisite:
Some prior exposure to finance or accounting is helpful but not required. Participants without a finance background can request a preparatory terminology guide upon registration. Excel proficiency equivalent to our Intermediate Excel for Business course is required, including familiarity with VLOOKUP, Pivot Tables, and IF statements.
Topics Covered at a Glance:
- Financial concepts, including market capitalization and enterprise value
- Financial accounting fundamentals: accrual versus cash accounting
- Discounted Cash Flow (DCF) modeling: assumptions, projecting cash flows, sensitivity analysis, and auditing
- Advanced Excel techniques, including Data Validation, CHOOSE, Data Tables, and Goal Seek
- Leveraged Buyout (LBO) modeling fundamentals
- Analysis of a real public company throughout the model-building process
- Setting up the financial model and building forward projections
- Corporate valuation and deriving an implied share price
- Reviewing and interpreting model output
Flexible Training Solutions for Your Team:
Group Vouchers and Scheduled Classes
Group vouchers are available so employees can attend sessions on weekdays, weeknights, or weekends at their own convenience. All courses are offered live online as well as in person at our Midtown Manhattan offices. Larger voucher purchases include a dedicated registration tracking portal to streamline enrollment management.
With a wide course selection on the calendar, employees can choose sessions that align with their skill level, schedule, and preferred format without needing extra coordination.
Practical Skills from Working Industry Professionals
Participants leave training ready to apply what they have learned the following day. Course files are theirs to keep as an ongoing desk reference.
Our hands-on, scenario-based curriculum is designed to reflect the real challenges your team faces at work. Training is available on-site at your office, at our Midtown Manhattan location, or through live virtual sessions, and every program can be adapted to your organization's specific goals.
