DCF calculator (discounted cash flow valuation) 소개
A discounted cash flow (DCF) valuation prices a business as the present value of the free cash flow it will produce. Here this year's free cash flow grows at a constant rate through the projection years, each year is discounted at the discount rate (usually the WACC), and a terminal value covers every later year with the Gordon growth formula, TV = FCF_N × (1 + g_T) ÷ (r − g_T), discounted back from year N. Subtracting net debt gives equity value, and dividing by shares gives value per share.
With the defaults, 5,000,000 of free cash flow growing 8% a year for 5 years, a 10% discount rate and 2.5% terminal growth, the enterprise value is 86,012,011.42, of which the terminal value supplies 62,343,037.45, or 72%. After 10,000,000 of net debt, the equity is worth 76,012,011.42, or 7.60 a share across 10,000,000 shares.
Because the terminal value usually dominates, small changes in the discount rate or terminal growth move the result a long way. Terminal growth must stay below the discount rate.
자주 묻는 질문
How do you calculate a DCF valuation?
Project free cash flow, discount each year at the discount rate, add the discounted terminal value, then subtract net debt. With the defaults, the five projected cash flows are worth 23,668,973.97 today and the terminal value 62,343,037.45, so the enterprise value is 86,012,011.42; less 10,000,000 of net debt, equity is 76,012,011.42.
How is terminal value calculated?
With the Gordon growth formula: next year's cash flow divided by the discount rate minus the long-run growth rate. The default year-5 cash flow is 5,000,000 × 1.08^5 = 7,346,640.38, so TV = 7,346,640.38 × 1.025 ÷ (0.10 − 0.025) = 100,404,085.25 at the end of year 5, or 62,343,037.45 in today's money.
What terminal growth rate should I use?
A rate no higher than the risk-free rate used in the valuation, as Aswath Damodaran of NYU Stern advises, because no business can outgrow the whole economy forever. The choice matters: with the other defaults fixed, terminal growth of 2% gives an enterprise value of 81,830,466.23, 2.5% gives 86,012,011.42 and 3% gives 90,790,920.21.
What discount rate should I use in a DCF?
For free cash flow to the firm, the weighted average cost of capital (WACC), which blends the required return on equity and the after-tax cost of debt. The result is sensitive to it: with the other defaults fixed, a 9% rate values the business at 99,615,400.68, 10% at 86,012,011.42 and 11% at 75,619,499.32.
What is the difference between enterprise value and equity value?
Enterprise value is what the whole business is worth to all its capital providers; equity value is what is left for shareholders after net debt (debt minus cash). The default enterprise value of 86,012,011.42 minus 10,000,000 of net debt leaves 76,012,011.42 of equity. With net cash, enter net debt as a negative number and equity exceeds enterprise value.
“DCF calculator (discounted cash flow valuation)”의 정확도는 어느 정도인가요?
정확도는 입력값과 계산 방법의 가정에 따라 달라집니다. 십진 연산은 유효숫자 50자리를 사용하지만, 추정값·수치해석 방법·원본 데이터의 정밀도는 더 낮을 수 있습니다. 표시값을 반올림해도 이러한 한계는 사라지지 않습니다. 독립적인 출처의 풀이와 대조한 계산 예시: 4. 예를 들어 “Default company”은 Python decimal (prec 50) summing FCF₀(1.08)^t/1.1^t for t = 1…5 plus the Gordon terminal value discounted 5 years와 대조해 확인합니다.
이 계산 방법의 출처는 무엇인가요?
Damodaran — Valuation: discounted cash flow models (NYU Stern); CFA Institute — Free cash flow valuation (CFA Program curriculum, Equity valuation).