Have a question for the event organizer?
Send your message below!
LA: Financial Modeling Corporate Training
Build a complete DCF model in Excel while mastering core finance and accounting concepts using real company data. This intensive 3-day course accelerates your financial modeling skills from beginner to advanced, perfect for professionals seeking valuation and analysis expertise.
| Provider | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Location | At your location, Los Angeles | |||||||||||||||
| Pricing |
$1,800 for up to 20 people
We’re happy to discuss your training needs free of charge. Reach out for a free consultation and let us know which skill your team is interested in, your preferred custom training options, and the approximate number of participants you’ll have so we can create a package for you. Send us an email or give us a call today! |
|||||||||||||||
| Duration |
Up to 7 hours For a shortened session, please request desired length in special requests at checkout.
|
|||||||||||||||
| Group Size |
Up to 20 people Group size can be changed after booking if needed.
|
|||||||||||||||
| Materials | None required | |||||||||||||||
| Other |
General Notes
Supported Platforms for Virtual Events: Zoom is our recommended platform, but we can accommodate Google Meets, Microsoft Teams, and WebEx if you provide the meeting link to CourseHorse in advance of the event. PoliciesPrice Match GuaranteeIf you find a similar event with a competitor at a lower price, we’ll gladly match it. This applies to events of comparable description and duration. Simply provide the details when booking, or within 72 hours of your booking, and we’ll ensure you get the best value. Contact an event concierge to get started. Rescheduling & Cancellation PolicyReschedule or cancel your event by emailing us at [email protected].
Rescheduled events must occur within 1 year of the original event. |
|||||||||||||||
Description
Build an Excel discounted cash flow (DCF) model for a real public company in this three-day course. Study finance and accounting fundamentals alongside modeling techniques.
Prerequisite:
No finance background is required; beginners receive a preparatory terminology guide upon registration. Intermediate Excel skills, including VLOOKUP, Pivot Tables and IF statements, are required.
What You'll Learn at a Glance:
- Key financial concepts: market capitalization, enterprise value, and the relationship between equity and debt value
- Financial accounting essentials, with a focus on the accrual accounting model
- DCF modeling from first principles: building assumptions, projecting free cash flows, running scenario and sensitivity analyses, and auditing your model for errors
- Advanced Excel techniques, including Data Validation, CHOOSE, Data Tables, and Goal Seek
- The fundamentals of Leveraged Buyout (LBO) modeling
- In-depth analysis of a real company using actual publicly available financial statements
- Constructing a complete financial model with multi-year projection scenarios
- Deriving a valuation range and implied share price from model outputs
- Interpreting and communicating the results of your financial model
Custom solutions for every team:
Purchase Vouchers or Group Classes
Invest in your workforce by purchasing group vouchers, giving employees the flexibility to attend any course at their convenience on weeknights, weekdays, or weekends. Larger voucher blocks include a custom registration tracking portal to simplify enrollment management.
With various courses on our calendar, there is no need to find a single time that works for everyone. Employees can redeem vouchers for whichever class best matches their skill level, schedule, and location preferences.
Learn Relevant Skills from Industry Experts
Participants leave our sessions as capable, confident users ready to put their new skills to work the very next day. They also keep course files permanently as an ongoing reference guide.
Our hands-on curriculum and focused instruction serve every learning style. We simulate the real-world challenges employees actually face on the job, making training immediately relevant.
We have extensive experience designing programs for onsite office sessions, partner-venue sessions, and fully remote virtual delivery. Every program can be customized to suit your organization's training needs.