FMVA Financial Modeling & Valuation
Advanced Excel, DCF, LBO, and M&A modeling for analysts and finance professionals, built on real deal case studies and the enterprise deliverables recruiters care about.
Modeling as a craft
A financial model is not a spreadsheet of numbers; it is a structured argument about a company's future, and building one well is a craft with its own standards. This program teaches those standards from the ground up: how to structure a model so it is auditable, how to format it so others can follow it, and how to build the three financial statements and link them into one integrated engine that flows from assumptions to outputs cleanly.
Excel mastery is the foundation, advanced formulas, disciplined structure, and the model-auditing techniques that catch the errors that quietly ruin analyses. From there the program builds toward the models that define the analyst role, so that by the end you are not learning Excel tricks but building the models a real desk produces.
What separates this program from a generic Excel course is that it treats the model as a deliverable with professional standards, not a personal scratchpad. You learn the conventions that let someone else pick up your model and trust it, which is precisely the difference between a student's spreadsheet and an analyst's model, and it is the first thing a reviewer notices.
Valuation and transaction models
The valuation core covers discounted cash flow from first principles: projecting free cash flow, choosing a defensible discount rate through the cost of capital, and handling terminal value and sensitivity honestly. Alongside it you learn comparable-company and precedent-transaction analysis, so you can triangulate a value rather than trust a single method.
The transaction modules are where the program becomes distinctive. You build a full leveraged-buyout model with debt schedules and a returns analysis, and a merger-and-acquisition model with accretion-dilution analysis, synergies, and deal structuring. These are the models that separate someone who has taken a finance course from someone who can do the job.
The valuation work is taught so that you understand the assumptions behind every number, not just the mechanics of entering them. Knowing why the discount rate matters, how terminal value can dominate a DCF, and where comparables mislead is what lets you defend a valuation under questioning, which is where interviews and investment committees separate the capable from the merely trained.
Deliverables that get you hired
Skill is necessary but not sufficient; you also have to demonstrate it. This program is built around the deliverables recruiters and investment committees actually look at: real deal datasets, investment-committee-ready decks, model tests, and a recruiter-ready portfolio of models you can defend under questioning.
The career kit, interview guides, model tests, and portfolio building, is treated as part of the curriculum rather than an afterthought, because the point of the program is not just to build models but to turn that ability into a role. You finish with work you can put in front of an employer.
The transaction models are the program's signature because they are what real deals run on. Building an LBO's debt schedule and returns, or an M&A model's accretion and dilution, forces you to connect financing, operations, and value in one integrated view, and that integrated thinking is the analyst skill that transfers across every finance role you might take.
See the method, not just the topic
A representative worked example from the program, so you can see the level of concreteness the curriculum works at.
Year 1 2 3 4 5
Free cash flow 100 110 121 133 146
Discount factor 0.909 0.826 0.751 0.683 0.621 (WACC = 10%)
PV of FCF 90.9 90.9 90.9 90.9 90.7
Terminal value (Gordon growth, g = 2.5%):
TV = FCF5 x (1+g) / (WACC - g) = 146 x 1.025 / 0.075 = 1,995
PV of TV = 1,995 x 0.621 = 1,239
Enterprise value = sum of PV(FCF) + PV(TV)
= 454.3 + 1,239 = 1,693The full syllabus
Four modules of five chapters each, sequenced so the material builds cumulatively. Each chapter carries a note on what it teaches.
Module 1Excel and modeling foundations
- 01Excel mastery: advanced formulas and functionsAdvanced Excel formulas and functions that modeling actually relies on. These are the formulas that separate slow modelers from fast ones.
- 02Model structure, formatting, and best practiceStructuring and formatting a model so others can audit and trust it. Structure is what lets a reviewer trust your model at a glance.
- 03Building the three financial statementsBuilding the income statement, balance sheet, and cash flow statement. The three statements become one connected system, not three tabs.
- 04Linking statements into an integrated modelLinking the three statements into one integrated, self-balancing model. A well-linked model flows from assumptions to outputs without breaks.
- 05Model auditing and error checkingAuditing a model and finding the errors that quietly break analyses. Auditing habits catch the errors that quietly sink real analyses.
Module 2Valuation core
- 06Discounted cash flow valuationDiscounted cash flow valuation from first principles. DCF becomes something you reason about, not just execute.
- 07Free cash flow and the forecast horizonProjecting free cash flow and choosing a sensible forecast horizon. The forecast horizon is a judgment call you learn to defend.
- 08Cost of capital and the discount rateEstimating the cost of capital that discounts those cash flows. The discount rate is where many valuations quietly go wrong.
- 09Terminal value and sensitivityHandling terminal value and testing sensitivity honestly. Terminal value often dominates a DCF, so you learn to handle it honestly.
- 10Comparable company and precedent analysisValuing by comparable companies and precedent transactions. Comparables let you sanity-check a DCF rather than trust it blindly.
Module 3Transaction modeling
- 11Leveraged buyout modelingBuilding a leveraged-buyout model end to end. The LBO is where financing, returns, and value meet in one model.
- 12Debt schedules and returns analysisModeling debt schedules and computing returns for an LBO. Debt schedules make the returns analysis real rather than assumed.
- 13Merger and acquisition modelingBuilding a merger-and-acquisition model. M&A modeling adds the logic of combining two businesses.
- 14Accretion and dilution analysisAccretion and dilution analysis for a deal. Accretion and dilution is the first question a deal team asks.
- 15Synergies and deal structuringModeling synergies and structuring a transaction. Structuring turns a model into an argument for doing the deal.
Module 4Deliverables and career kit
- 16Real deal datasets and case studiesWorking with real deal datasets and case studies. Real datasets make the practice indistinguishable from the job.
- 17Investment-committee-ready decksProducing an investment-committee-ready deck from a model. A committee-ready deck is how a model becomes a decision.
- 18Model tests and interview guidesPassing model tests and using interview guides. Model tests mirror the technical screens interviews actually use.
- 19Recruiter-ready model portfolioAssembling a recruiter-ready portfolio of models. The portfolio is the evidence that wins the role.
- 20Presenting and defending a modelPresenting and defending a model under questioning. Defending a model under questioning is the skill that closes offers.
How to get the most from it
Financial modeling is learned by building, not by watching, so this program is structured around doing. The most effective way through it is to build every model yourself rather than following along passively, to rebuild the harder ones from a blank sheet until the structure is second nature, and to treat the model-auditing techniques as a habit applied to your own work, not just a topic. The models you build become your portfolio, so the effort compounds.
It also pays to work the career kit alongside the modeling rather than saving it for the end. Practicing the model tests under time pressure, refining your decks, and rehearsing how you would defend a valuation all sharpen the skills interviews probe. Modeling ability is necessary but not sufficient; being able to present and defend a model is what closes the gap to an offer.
Where modeling takes you
Financial modeling is the common denominator of corporate finance, investment banking, private equity, and FP&A, which is why it is one of the highest-leverage skills to build early. An analyst who can build a clean, defensible model is useful on day one, and the ability transfers across roles and sectors, making it a durable foundation for a finance career rather than a narrow specialization.
In the journey, the modeling this program builds also underpins the investment and alternatives certifications, where valuation and transaction modeling recur constantly. Whether you go on to the CFA, to CAIA, or straight into a role, the modeling capability you build here is a base the rest of your career draws on.
Assessment: model tests and the portfolio
The program is assessed the way the job is: through the models you build and the tests you pass. Model tests under time pressure mirror the technical screens that finance interviews use, so working them seriously is direct preparation for the hiring process, not a separate academic exercise. The point is to make the assessment and the career preparation the same activity.
The portfolio is the lasting output. Three full transaction models, real deal case studies, and investment-committee-ready decks accumulate into a body of work you can put in front of an employer, and it is often this concrete evidence, more than any certificate, that wins the role. Treating every model as portfolio work from the start is the way to get the most from the program.
What you will be able to do
- Build integrated, auditable financial models from a blank sheet
- Value a company by DCF, comparables, and precedent transactions
- Model an LBO and an M&A deal with full debt and returns analysis
- Produce investment-committee-ready decks recruiters respect
- Carry a portfolio of models that demonstrates real skill
Who should take it
- Finance students and aspiring analysts
- FP&A, corporate finance, and investment banking juniors
- Private equity and valuation professionals
- Consultants needing transaction-modeling skills
Modeling across the finance landscape
Financial modeling is unusual in how widely it transfers, and understanding that helps you see the program's value. The same integrated-model discipline underpins corporate finance, investment banking, private equity, and FP&A, so the skill you build does not lock you into one path but opens several, which is rare for a technical specialization.
Within the journey, the modeling here also feeds the investment and alternatives certifications, where valuation and transaction modeling recur constantly. Whether you continue to the CFA or CAIA or move straight into a role, the modeling capability is a foundation the rest of your finance career draws on, which is why it sits early in the sequence.
What makes this program different
Financial-modeling courses are common, but many teach isolated techniques rather than the integrated craft of building a model a professional would trust. This program's distinction is that it treats modeling as a discipline with standards: structure, formatting, auditing, and defensibility are taught as seriously as the formulas, because those are what separate an analyst's model from a student's spreadsheet. The result is that graduates build models others can pick up and rely on, which is the actual bar in a finance role.
The second differentiator is the transaction focus. Building full LBO and M&A models on real deal data, rather than stopping at a simple DCF, is what prepares you for the work that defines analyst roles in banking, private equity, and corporate development. Pairing that with a career kit and a defensible portfolio means the program aims squarely at getting you hired and effective, not just certified.
Common questions and how to prepare
People often ask whether they need to be an Excel expert before starting; they do not. The program builds Excel mastery as part of the curriculum, though comfort with the basics helps you move faster. A more useful question is how much to practice, and the honest answer is a lot: modeling is a motor skill as much as a knowledge, so rebuilding models from blank sheets until the structure is automatic is what produces real fluency.
The common pitfall is treating the models as exercises to complete rather than portfolio pieces to perfect. The models you build are the evidence you will show employers, so investing in making them clean, auditable, and defensible pays off directly. Working the model tests under time pressure and rehearsing how you would defend each valuation prepares you for the technical screens and interviews where these skills are actually judged.
What you build and keep
Build three full transaction models on real deal datasets, a DCF, an LBO, and an M&A model, and package them into an investment-committee-ready deck and a recruiter-ready portfolio you can defend in interviews.
Format: Self-paced with lifetime access; 250+ lessons, 10 case studies, 3 full transaction models.
Run this program for your team
Every program can be delivered as a private, tailored cohort for your organization, aligned to your systems, policies, and career frameworks.
Scope a corporate cohortFrequently asked questions
What is the FMVA Financial Modeling & Valuation program?
Advanced Excel, DCF, LBO, and M&A modeling for analysts and finance professionals, built on real deal case studies and the enterprise deliverables recruiters care about.
Who is this program for?
It suits finance students and aspiring analysts, along with others described on this page.
How is it delivered?
Self-paced with lifetime access; 250+ lessons, 10 case studies, 3 full transaction models.
Is there a project or capstone?
Build three full transaction models on real deal datasets, a DCF, an LBO, and an M&A model, and package them into an investment-committee-ready deck and a recruiter-ready portfolio you can defend in interviews.
How does this fit the wider journey?
In the journey, modeling comes right after the foundation because it is the practical skill every finance and investment role assumes. It also underpins the CFA and CAIA programs, where valuation and modeling recur throughout.
Can my organization run this as a private cohort?
Yes. Every program can be delivered as a tailored corporate cohort. Contact us to scope it.