Methodology
The Financial Dashboard pulls live company data and runs four classic valuation models on it. This page goes through each step, so nothing here is a black box.
When you enter a ticker and press Load Data, the dashboard fetches public data from Yahoo Finance: the company profile, the income statement, the balance sheet, the cash flow statement, and a set of summary figures (market cap, shares outstanding, EBITDA, dividends and so on). You can switch between annual and quarterly statements.
This data is free and convenient, but it is not audited by me. Figures can be delayed, restated, or missing for smaller companies, so always sanity-check against the official filings before relying on a number.
From the statements the dashboard computes a few standard health checks:
It also calculates revenue and net income growth, both year over year and as a compound annual growth rate (CAGR) across the available years.
Each model takes the live data plus the assumptions you set in the Valuation Inputs box, so you can stress test different scenarios. Every model follows the same structure: inputs first, then the steps, then the implied value per share.
Implied price = EPS * P/E multiple
Earnings per share comes from net income divided by shares outstanding. Pick the P/E multiple you think the business deserves, and the model shows the implied price and the upside or downside against today's price.
Enterprise value = EBITDA * EV/EBITDA multiple
Equity value = Enterprise value - Net debt
Per share = Equity value / shares outstanding
Net debt is total debt minus cash. This model is useful because it values the whole business first, then strips out debt to get to what the equity is worth.
This is the most involved model:
1. Start from free cash flow (FCF)
2. Grow it each year by your growth rate for N years
3. Discount each year back to today at your discount rate (WACC)
4. Add a terminal value using the Gordon growth formula:
Terminal value = FCF(final) * (1 + terminal growth) / (WACC - terminal growth)
5. Enterprise value = sum of discounted FCFs + discounted terminal value
6. Equity value = Enterprise value - Net debt
7. Per share = Equity value / shares outstanding
Because the free cash flow used here belongs to the whole firm, the model discounts it at WACC to get an enterprise value, then subtracts net debt to reach the value of the equity. (This net-debt step is easy to forget, and getting it wrong is a common reason a DCF looks off.)
Intrinsic value = next year's dividend / (discount rate - dividend growth)
Best suited to stable dividend payers. For companies that pay little or no dividend, this model will understate value, which is expected rather than a fault.
These models are deliberately simple and transparent. The output is an implied value under the assumptions you chose, not a price target and not a recommendation. Change the discount rate or growth by a percentage point and the DCF can move a lot, which is intentional: it shows how sensitive the value is to your assumptions.
This dashboard is an educational tool. It is not investment advice. Do your own research and speak to a licensed adviser before making any investment decision.