Course Content
Mastering Discounted Cash Flow Analysis with Excel
Mastering Discounted Cash Flow Analysis with Excel
Understanding the Discount Rate in Valuation
When we discount future cash flows, we need a rate that reflects both the risk and opportunity cost of investing in a company. This rate is called the discount rate or discount factor.
It answers a fundamental question: How much less is a future dollar worth to us today?
The discount rate plays a critical role in DCF because:
It shrinks future values to reflect time and uncertainty;
It's the lens through which we evaluate investments: the higher the risk, the higher the rate.
For instance, a tech startup with volatile revenue streams might have a discount rate of 15β20%, while a stable utility company might be closer to 6β8%.
When valuing a company as a whole (using unlevered free cash flow), the discount rate is usually calculated based on two pillars:
Cost of Equity: the return expected by shareholders. It reflects market risk and can be estimated using models like CAPM (Capital Asset Pricing Model);
Cost of Debt: the effective rate a company pays on its borrowed funds, adjusted for the tax shield (because interest is tax-deductible).
Together, they are combined into the Weighted Average Cost of Capital (WACC), which we'll explore further in later chapters.
Think of the discount rate as a "risk tax". The more uncertain or delayed the cash flows, the more tax you pay through discounting. It forces your valuation model to be realistic, not optimistic.
The discount rate is not arbitraryβit reflects the expectations of the market and the specific risks of the business. Mastering how it's calculated and applied is essential for building accurate valuation models.
Thanks for your feedback!