Free · Open · Built on SEC EDGAR
Wall-Street-grade DCF models.
For everyone. For free.
DCF4ALL builds a 4-sheet Discounted Cash Flow valuation workbook for any US-listed company in under a minute. Historicals pulled from SEC filings, assumptions you can edit, formulas you can audit.
Built on edgartools. Data sourced from SEC EDGAR.
Build a DCF model
Pick a ticker. We pull historicals from SEC EDGAR and download a 4-sheet Excel workbook with live formulas.
Typical build time: 20–60 seconds depending on the company.
What you get
A 4-sheet workbook you can actually use
Every projected cell is a live Excel formula. Edit a yellow assumption and the whole model recalculates instantly.
Historical Data
Read-only5 years of revenue, EBITDA, free cash flow, and balance-sheet items pulled directly from SEC filings.
Assumptions
EditableWACC components, growth rates, and margins. Yellow cells are yours to change. Everything else recalculates.
Projections
Auto-updates10 years of projected financials built entirely from Excel formulas referencing your assumptions.
Valuation
Auto-updatesTerminal value, equity bridge, and intrinsic value per share, plus a 5x5 WACC vs. terminal-growth sensitivity table.
Why this exists
Mission
DCF4ALL aims to make finance more accessible to the general public, so that every investor can access tools similar to those used on Wall Street.
Hedge funds and investment firms pay tens of thousands of dollars every year for software that automates valuation work. This project gives a Simple DCF model away for free in the hope of slightly evening the playing field.
As more people begin to invest in the stock market, financial literacy becomes increasingly important for making informed decisions and building wealth over time. DCF4ALL is a small contribution towards that goal.
FAQ
Plain-English answers
The same Q&A that ships inside every workbook, aimed at first-time users with no prior finance background.
1. How can I learn valuation?
There are many excellent free resources online for learning valuation. My top recommendation is Professor Aswath Damodaran of NYU Stern, who is widely regarded as the 'Dean of Valuation' and has made his entire MBA-level course material freely available on YouTube. His lectures are rigorous, practical, and accessible to beginners. A great starting point is his Valuation series:
2. What is a Simple DCF?
A DCF (Discounted Cash Flow) is a way to estimate what a company is really worth today by projecting the cash it will generate in the future and discounting those future cash flows back into today's dollars. It is one of the most widely used valuation methods in finance.
3. Why do investors use DCFs?
DCFs help investors decide whether a stock looks undervalued or overvalued based on the company's underlying business fundamentals rather than just market sentiment, news headlines, or short-term price movements.
4. How are future cash flows forecast?
We start with the company's revenue, apply an expected growth rate, subtract operating costs, taxes, and reinvestment needs (CapEx and working capital). What is left is Free Cash Flow, the cash the business actually generates for its owners each year.
5. What does the discount rate mean?
A dollar received next year is worth less than a dollar today because of risk and the time value of money. The discount rate (WACC) reflects the return investors require for taking on the risk of this particular business. A higher discount rate means future cash is worth less today.
6. What is terminal value?
Companies do not simply stop after 10 years. Terminal Value captures all the cash flows beyond the explicit forecast period, assuming the business keeps growing at a steady long-term rate forever. It often makes up the majority of the total valuation, so the terminal growth rate matters a lot.
7. How do I use this workbook step by step?
Step 1: Review the Historical Data tab to see the company's past performance. Step 2: Open the Assumptions tab. Step 3: Change any yellow cell to reflect your own view of the future. Step 4: Watch the Projections tab recalculate automatically. Step 5: Read the final intrinsic value per share on the Valuation tab.
8. Why do assumptions matter so much?
The output of a DCF is only as good as the inputs. A 1% change in growth or discount rate can swing the final valuation by 20% or more. Always run a few scenarios (optimistic, base case, pessimistic) to see how sensitive the answer is.
9. What common mistakes should I avoid?
Avoid assuming permanently high growth rates. All businesses eventually mature. Do not use a discount rate that fails to reflect the company's actual risk. Do not forget to subtract net debt and divide by the right share count. And do not anchor to the current stock price. The whole point is to form your own independent view.
Support the project
Help keep DCF4ALL free
DCF4ALL is a solo-built, free project. If it saved you money or taught you something, I'd love your support.
Buy me a coffee
The simplest way to support development and hosting costs.
buymeacoffee.com/toj27 →
Play Wallstreetle
Learn about stocks through daily games built on real market data.
wallstreetle.com →Star edgartools
The open-source Python library that powers all the SEC data extraction. Thank you, Dwight Gunning.
github.com/dgunning/edgartools →