Learn essential finance & accounting concepts while building a comprehensive discounted cash flow (DCF) model in Excel. In this 3-day intensive financial modeling class, you'll go from beginner to advanced in Excel skillset; learn Finance, Accounting, and Corporate Valuation; and build a comprehensive Financial Model on a real company.
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 Glance
- Financial Concepts, Market Capitalization, & Enterprise Value
- Financial Accounting, including accrual versus cash accounting
- Discount Cash Flow (DCF) Modeling: Assumptions, Projecting Cash Flows, Sensitivities, Auditing
- Excel Techniques, including Data Validation, CHOOSE, Data Tables, Goal Seek and more
- Leveraged Buyouts (LBO) Modeling
- Real Company Analysis
- Setup the Financial Model and model projections
- Corporate Valuation and deriving a value per share
- Analyze the Model Output
Custom solutions for every team:
Purchase Vouchers or Group Classes
You can purchase group vouchers so your employees can attend any of our courses at their convenience on weeknights, weekdays, or weekends. Our classes are live online or in person at our Manhattan offices. When you invest in a large block of vouchers, you'll also receive a custom registration tracking portal to manage them.
With various courses on our calendar, you don't have to worry about coordinating with each employee to find a class that works for them. Your employees can use their vouchers to enroll in classes that fit their proficiency, schedule, and location needs.
Learn Relevant Skills from Industry Experts
Your employees will leave our training as proficient users who can implement what they've learned the next day. Your employees will also have our course files to keep forever so they can continue using their training as a guide for their day-to-day tasks.
Our hands-on curriculum and focused instruction cater to every learning style. We simulate the challenges your employees will actually face on the job.
We have extensive experience developing curricula for various training sessions, either onsite at your office, in our Midtown Manhattan offices, or through remote virtual training. Our programs can be completely customized to suit your training needs.
