Learn Financial Modeling
Turn a company story into a spreadsheet that holds together.
Free to start. Built from a single prompt. No credit card.
Financial modeling is building a spreadsheet that forecasts a business's performance and estimates its value, usually in Excel or Google Sheets. The standard core is the three-statement model, linking an income statement, balance sheet and cash flow statement so a change in one assumption flows through all three. On top of that sit tools like discounted cash flow valuation, scenario analysis and sensitivity tables. Learnr builds a personalized course that teaches each layer step by step, with clear structure and checks. It covers modeling as a skill, and a model is never a prediction or investment advice.
How to learn Financial Modeling, step by step
- Get fast at the spreadsheet tools you need. Learn absolute and relative references, SUMIFS, INDEX and MATCH or XLOOKUP, and keyboard shortcuts for navigation. Modeling involves thousands of formulas, so speed and accuracy in the spreadsheet itself matters from day one.
- Refresh how the three statements connect. Trace how net income flows to retained earnings and the cash flow statement, and how depreciation, working capital and capital spending tie the balance sheet to cash. If this feels shaky, review accounting first.
- Adopt clean modeling conventions. Keep inputs on their own tab, color hardcoded inputs differently from formulas (blue for inputs and black for formulas is a common convention), and never bury a typed number inside a formula. Clean structure is what makes a model auditable.
- Build a three-statement model of a real company. Use a public company annual report, forecast revenue from drivers like units and price, then project costs, the balance sheet and cash. Add a check row that flags when assets do not equal liabilities plus equity.
- Add a DCF valuation. Calculate unlevered free cash flow, learn how a discount rate such as WACC is built, and compare the perpetuity growth and exit multiple approaches to terminal value. Notice how much of the value sits in the terminal value.
- Stress-test with scenarios and sensitivities. Build data tables that show value across ranges of growth and discount rates, and add base, upside and downside cases. Short Learnr review sessions help the formulas and accounting links stay fresh between builds.
What you'll learn
- Structure a model with separate inputs, calculations and outputs
- Build a linked three-statement model that balances
- Forecast revenue and costs from clear, defensible drivers
- Run a discounted cash flow valuation, including terminal value
- Test assumptions with scenarios and sensitivity tables
What's inside your Financial Modeling course
A sample path Learnr builds for Financial Modeling. Your real course adapts to your goal and level.
- 1. Spreadsheet skills and modeling conventions
- 2. Accounting refresher: how the statements link
- 3. Building the forecast: revenue and cost drivers
- 4. The three-statement model and balance checks
- 5. DCF valuation, discount rates and terminal value
- 6. Scenarios, sensitivities and presenting results
How long does it take to learn Financial Modeling?
With solid spreadsheet skills and some accounting, building a basic three-statement model and DCF typically takes 6 to 12 weeks at 4 to 6 hours a week. Interview-ready or professional speed takes months of repeated builds on different companies.
What you need before you start
Working knowledge of Excel or Google Sheets and introductory accounting, especially how the income statement, balance sheet and cash flow statement relate. Basic understanding of the time value of money also helps.
Common mistakes to avoid
- Hardcoding numbers inside formulas, which hides assumptions and makes the model impossible to update or audit later.
- Treating a precise output as accurate. A valuation is only as good as its assumptions, so always show how results change when inputs move.
- Building one giant tab with no structure or checks, so a single broken link silently throws off every number downstream.
How Learnr builds your course
Type your topic
Tell Learnr you want to learn Financial Modeling, or get as specific as you like.
Get a personalized course
Learnr instantly builds a full Financial Modeling course tailored to your goal and skill level.
Learn and level up
Move through bite-sized lessons and interactive practice, earning XP and keeping your streak.
Financial Modeling questions, answered
Do I need to know accounting before learning financial modeling?
Yes, at least the basics. Models are built on how the three financial statements link, so Learnr can start you with an accounting refresher if you need one.
Can I learn financial modeling in Google Sheets?
Yes. Most modeling concepts and functions work the same way in Google Sheets as in Excel, though Excel remains the common standard in finance roles.
Explore more courses
More money courses
- Learn Bookkeeping
- Learn Real Estate Investing
- Learn Retirement Planning
- Learn Index Funds
- Learn Dividend Investing
- Learn Value Investing
- Learn Credit Scores
- Learn Paying Off Debt
Ready to learn Financial Modeling?
Start your free, personalized Financial Modeling course in seconds. .