- What a financial model is — and what it is not
- The skills you'll walk away with by the end of the course
- How the course is structured and how to get the most from it
What financial modeling actually is
Let's start with the scary-sounding term. A financial model is simply a spreadsheet that turns a set of assumptions about a business into numbers about its future. You feed in things you believe — "sales will grow 8% a year," "our profit margin is about 25%" — and the spreadsheet does the math to tell you what profit, cash, and value would result.
That's it. No magic, no secret formula. A model is a structured calculator for a business. The reason analysts spend so much time on them is that a good model lets you ask "what if?" and get an instant answer. Change the growth rate, and every downstream number updates by itself. That is the single idea this whole course is built around.
It helps to be clear about what a model is not. It is not a crystal ball — it cannot predict the future with certainty. It is not a pile of random numbers either. And it is not about memorizing fancy formulas. A model is a tool for thinking clearly about a business, where every number traces back to an assumption you can explain and defend.
A tiny example, so it feels real
Imagine a small coffee shop. This year it earned 1,000 (in thousands of dollars) of revenue. You assume revenue grows 10% next year, and that profit is always 20% of revenue. Watch how two assumptions produce a forecast:
| Item | This year | Next year |
|---|---|---|
| Revenue | 1,000 | 1,100 |
| Growth assumption | — | 10% |
| Margin assumption | 20% | 20% |
| Profit | 200 | 220 |
The blue figures are inputs you chose. The black figures are formulas the spreadsheet worked out. Here is the actual Excel formula that produced next year's revenue, assuming this year's revenue sits in cell B2 and the 10% growth sits in C3:
=B2*(1+C3)
If you later decide growth should be 15% instead of 10%, you change one cell and the profit updates on its own. That live, connected behaviour is what separates a model from a static table of numbers.
Beginners often type the answer (like 1100) straight into the cell. Don't! Write the formula instead. A hard-typed number won't update when your assumption changes, and that is how silent errors creep in.
Real analysts colour their cells: blue for inputs you type, black for formulas. You can already do this — it makes any model instantly easier to read and audit.
How this course is structured
The course is split into five phases. You're in Phase 1: Foundations, where we build Excel fluency and financial-statement literacy. After that you'll build a complete model, then learn to analyze and value a company, and finally present your work like a professional. Each lesson follows the same rhythm: a short concept, a worked demonstration, a "your turn" practice file, and a quick checkpoint.
You do not need any finance background to start. Every term is defined in plain English the first time it appears. The best way to learn is to build alongside the lessons — open Excel, copy the examples, and break things on purpose to see what happens. The free practice files and section quizzes are there to lock the ideas in.
How to get the most from each lesson
- Read the concept first — don't rush to the spreadsheet.
- Rebuild the worked example yourself rather than just copying it.
- Do the practice file, then compare with the completed "after" version.
- Take the section quiz and aim for 80% or better before moving on.
Before this course
You stare at a company's numbers and aren't sure where to begin. Spreadsheets feel intimidating, and "valuation" sounds like a black box.
After this course
You can build an integrated three-statement model from scratch, value a company with DCF and comparables, and explain every number you produced.
Key terms
Key takeaways
- A financial model turns assumptions into a forecast — it's a structured calculator, not a crystal ball.
- Use formulas, not hard-typed answers, so outputs update when assumptions change.
- The course moves through five phases; learn by building alongside each lesson.