Financial Modeling Program for Analysts
Building spreadsheet models that actually work takes more than formulas. You need to understand how businesses make decisions with data. This program walks you through the core techniques analysts use every day—from forecasting revenue to valuing companies.
Most courses throw theory at you. We're different. You'll work through real scenarios based on actual business situations. The kind where numbers matter and stakeholders ask tough questions. By the end, you'll know how to structure models that stand up to scrutiny and communicate insights clearly.
What You'll Actually Learn
Foundation Mechanics
Start with the fundamentals that separate amateur spreadsheets from professional models. We cover structure, audit trails, and documentation practices that your future self will thank you for.
- Building scalable model architecture
- Error-checking techniques that catch mistakes
- Documentation standards for team environments
- Version control and change tracking
Financial Statement Analysis
Reading financial statements is one thing. Extracting insights from them is another. You'll learn to spot trends, identify red flags, and connect the dots between income statements, balance sheets, and cash flow.
- Three-statement modeling connections
- Working capital dynamics
- Ratio analysis that reveals business health
- Historical performance interpretation
Forecasting Methods
Predicting the future is tricky. But there are proven approaches that work better than guessing. We explore driver-based forecasting, sensitivity analysis, and scenario planning techniques used in professional settings.
- Revenue and expense projection methods
- Multiple scenario development
- Assumption documentation
- Testing forecast reliability
Valuation Techniques
How much is a company worth? The answer depends on who's asking and why. You'll work through DCF models, comparable company analysis, and precedent transactions—understanding when each approach makes sense.
- Discounted cash flow modeling
- Terminal value calculations
- Market-based valuation approaches
- Equity vs enterprise value considerations
Capital Structure Decisions
Debt and equity aren't just balance sheet items. They shape how companies operate and grow. We look at weighted average cost of capital, leverage ratios, and how financing decisions impact valuation.
- Cost of capital calculations
- Optimal capital structure analysis
- Debt capacity assessment
- Impact on shareholder returns
Investment Decision Frameworks
Should the company pursue this project? Expand into a new market? Acquire a competitor? You'll learn how to model these decisions with NPV, IRR, and payback analysis that supports clear recommendations.
- Project evaluation metrics
- Capital budgeting processes
- Risk-adjusted return assessment
- Strategic option valuation
Learn from Working Analysts
Our instructors aren't academics reading from textbooks. They're professionals who build models for a living—in investment banking, corporate finance, and consulting. They know what works in real environments because they do it every day.
Oskar Lindqvist
Corporate Finance Lead
Oskar spent eight years building financial models for M&A transactions at a mid-market advisory firm. He's seen what due diligence teams scrutinize and what makes executives confident in a deal. His sessions focus on practical techniques that hold up under pressure.
Vaughn Calloway
Valuation Specialist
Vaughn builds valuation models for private equity portfolio companies and distressed debt situations. His background includes restructuring advisory and forensic accounting. He brings perspective on modeling under uncertainty and communicating complex financial concepts to non-finance stakeholders.
Program Structure and Enrollment
This is a six-month program designed for people with some financial background who want to strengthen their modeling capabilities. You'll work through structured modules, complete practical assignments, and build a portfolio of models that demonstrate your skills.
Time Commitment
Expect to spend about 8-12 hours per week on coursework, assignments, and project work. The schedule is flexible—you can move faster or slower depending on your availability and prior experience.
Assessment Approach
We evaluate your progress through practical assignments rather than exams. You'll build models that mirror real business scenarios, receive detailed feedback from instructors, and iterate based on that guidance. The goal is skill development, not test scores.
What You'll Need
- Basic understanding of financial statements and accounting principles
- Intermediate spreadsheet skills (you should be comfortable with formulas and basic functions)
- Access to Excel or similar spreadsheet software with modeling capabilities
- Willingness to work through challenging problems and ask questions when stuck
Applications open throughout the year. We review submissions on a rolling basis and typically confirm enrollment within two weeks. The next cohort begins in a few months, giving you time to prepare and clear your schedule for focused learning.
Ready to Get Started?
If you're serious about improving your financial modeling capabilities and want to learn from practitioners who use these skills professionally, reach out. We can discuss your background, answer questions about the program, and help you decide if this is the right fit.
Contact Us About Enrollment