InsightDCF: Open-model DCF analysis
Institutional-grade discounted
cash flow, for everyone.
Enter any public ticker. The model auto-detects industry terminal assumptions from Damodaran's NYU datasets, scores moat durability, and builds a 10-year DCF — all visible, all editable, all explainable.
— By Seymur Mammadov
Browse the full lists: most undervalued · most overvalued
Damodaran-anchored terminal assumptions
Industry terminal margins, WACC, D/E, and betas pulled live from NYU Stern datasets — the same source used by professional valuation practitioners.
Moat-scoring convergence detector
ROIC-WACC spread, gross margin trends, and reinvestment efficiency combined into a scoring system that determines when a given company's financial metrics start converging towards the industry average.
Fully editable projections
Every assumption is surfaced and editable. Change year-by-year growth rates, margins, or capital structure — the model re-runs instantly.
Monte Carlo + sensitivity analysis
5,000-draw simulation with correlated growth/margin shocks. Three sensitivity heatmaps across WACC, terminal growth, ERP, margin, and tax.
AI-generated plain-English explanation
Claude Haiku reads the model's own computed outputs and explains why the numbers came out the way they did — no hallucinated facts.
Equation flowcharts
Every major calculation chain visualised as an interactive flowchart: beta → WACC, EBIT → FCFF, Gordon growth, equity bridge, and more.
About Me
From my first DECA competition as a high school sophomore, I knew I was interested in finance. What started as a senior year project made to combine my interests in computer science and valuation quickly became something much more personal: building a DCF engine I could actually trust.
Every edge case I encountered showed me how much more there was to refine. Assumptions had to be tested, outputs had to be challenged, and every improvement revealed another layer of complexity behind what seemed to me at first as a mathematically simple model. After hundreds of hours of development, iteration, and testing, this platform became the result of that process.
Seeing the gap between market prices and underlying business value grow in recent years pushed me to share my work beyond a personal project. My goal is to create a tool that gives students an interactive way to learn financial modeling, provides investors with an accessible valuation framework that is as automated as they want it to be, and gives professionals the flexibility to build their own assumptions into a rigorous system.
For educational and informational purposes only. Output is a model estimate, not investment advice. Past financial performance does not guarantee future results. Always do your own research before making investment decisions.
Recent updates
View all →2026-07-03
Analyst consensus revenue growth replaces trailing average as the default anchor
The model's starting-point revenue growth rate used to be a trailing three-year average, which is backward-looking by construction and lags any real change in a company's trajectory. Apple's trailing growth came out near 1.9% a year, even though the market and sell-side analysts both expect something closer to 12%. Holding a ten-year forecast to the trailing figure made a normal, growing business look permanently stagnant and priced it far below where almost any other reasonable observer would. The engine now anchors on analyst consensus by default — the compounded annual growth rate implied by forward revenue estimates from the data provider's earnings trend data — and only falls back to the trailing average when no analyst estimates exist. Because a forecast error compounds across ten years, a raw consensus figure at the extreme end (some semiconductor and high-growth names implied over 100% a year) would blow up the model just as badly as understating growth did, so both the analyst and trailing figures are bounded to a plausible range before they're used. Every result now shows which anchor was used and what the other one would have implied, and a toggle lets you re-run the same company on trailing history instead, since for some companies — mature, cyclical, or thinly covered by analysts — trailing data is still the more defensible anchor.
2026-07-03
Recency-weighted EBIT margin anchor replaces flat multi-year mean
The write-off filter that strips impairment-contaminated years from the EBIT margin anchor was averaging whatever years survived the filter with equal weight, regardless of how old they were. That works fine for a stable business, but it badly lags a company moving through a cycle. Micron's clean-year average came out near 11%, dragged down by trough years years back, while the business was running close to 25% margins at the point the valuation was actually run. The anchor now weights clean years by recency, with roughly a two-year half-life, so a company's most recent margin performance dominates the anchor while older years still contribute and dampen single-year noise. The write-off detection is unchanged — contaminated years are still identified and dropped the same way — only the averaging of what's left has shifted from flat to recency-weighted. Since this anchor sets the starting point for the entire ten-year margin trajectory, getting the recent regime right matters most for cyclical and fast-changing businesses, which is exactly where the flat average was furthest off.
2026-07-03
Beta sanity clamp and short-term-investments cash guard
Two data-quality gaps in the inputs feeding cost of capital and invested capital. First, the data provider's reported beta occasionally comes back as an obvious outlier — Kraft Heinz showed a beta of 0.077, which is not a plausible risk estimate for a public equity and, left unclamped, drove the cost of equity down to levels close to the risk-free rate itself. Beta now clamps to a plausible band before it's used, with a fallback to a market beta of 1.0 when the field is missing entirely, and a note whenever the clamp fires. Second, cash was previously read from a single balance-sheet field that excludes short-term investments — money-market funds and short-duration securities that are functionally cash for a company's capital structure. Apple alone was short nearly $19 billion of what a market participant would count as cash on hand, which understates cash-rich companies' equity value and overstates their invested capital. Cash now includes short-term investments where the data provider supplies them, netting against debt the same way an equity research analyst would.
2026-06-30
Lease and pension obligations folded into invested capital
Reported financial debt only counts money the company borrowed outright. But a long-term lease is debt in everything but name: the company has locked itself into a stream of fixed payments to use an asset, exactly as it would servicing a loan to buy that asset. Since 2019 accounting rules put those leases on the balance sheet, yet the data provider's debt figure still leaves them out. The same is true of an underfunded pension, which is a senior claim the company owes its retirees. For a retailer, airline, or restaurant chain that leases its stores, planes, or kitchens, this is not a rounding error — it can be a large share of the real capital the business runs on. Leaving these out understated invested capital and therefore overstated return on capital, because the model divided profit by too small a capital base. The engine now adds capitalized leases and any net pension deficit (after tax, since the shortfall is deductible as it's funded) into the debt base, so they flow consistently into invested capital, the debt-to-equity ratio, and the cost of capital. The subtle part is keeping the return calculation honest. A lease payment bundles two things: rent for using the asset, and an implicit interest charge for financing it over time. Once the lease sits in the capital base, that interest portion no longer belongs in operating costs — it's a financing cost, like interest on any loan. So the model adds the imputed interest back to operating profit before computing return on capital. Without that step, capital would rise while profit stayed artificially depressed, and the fix would overshoot, turning an overstated return into an understated one. Adding it back lets the numerator and denominator move together, so return on capital settles at its true economic level rather than swinging to either extreme. The interest-coverage check that sets the cost of debt deliberately stays on the reported figures, so the credit rating isn't flattered by the add-back. Each valuation now carries a note showing whether the adjustment fired and how much debt it pulled in, or stating plainly when the provider supplied no lease or pension data. The one piece that remains outside the model is contingent liabilities — litigation and guarantees that live only in financial-statement footnotes and can't be read from structured data; those are left to the manual debt override.