Data & spreadsheets · DCF Calculator
The Time Value of Money: The Idea Behind Every DCF Calculation
· Background
dcf valuation cash-flow
Discounting rests on one idea: money now is worth more than the same money later. This post explains why, introduces present and future value, and shows how the idea grows into a full DCF.
A promise of money next year is worth less than cash today — the intuition from interest, risk and preference for the present
A promise of 100 next year is not interchangeable with 100 available now because current money can be used, invested or held against risk. Present value translates dated claims to one valuation date. The discount rate expresses the required compensation in the model; the calculator applies it but does not determine what compensation is appropriate.
Future value first — how compounding turns a deposit into a larger sum, and the formula that describes it
Compounding moves forward: future value equals present value multiplied by one plus the rate for each period. At 8%, 100 becomes 108 after one year and 116.64 after two. The exponent counts periods, which is why changing timing changes value even when the promised amount and stated rate remain the same.
Present value as compounding in reverse — dividing by (1+r)^t and what the exponent represents
Present value reverses the operation by dividing a future cash flow by one plus the rate raised to its time. ToolAcre’s end-of-year rows use exponents one through N; mid-year timing subtracts one half from each exponent. Neither convention is a rounding choice, so compare models only after confirming when they assume cash arrives.
The discount rate as an opportunity cost — the return you forgo elsewhere, and why riskier promises deserve a higher rate
The discount rate is commonly interpreted as an opportunity cost adjusted for risk, but this implementation receives it as a user input. A higher required rate lowers present value because each denominator grows. The optional WACC helper assembles one rate from manual components without claiming those components are current or correct.
From one cash flow to many — summing present values across years, which is all a DCF really is
A DCF is the sum of several present-value calculations plus a discounted terminal amount. Each year keeps its own date and denominator before addition. The engine exposes FCF, exponent, discount factor and present value in every row, preventing a total from hiding whether year one accidentally started at exponent zero.
Worked example — three cash flows over three years discounted individually and totalled, with the same numbers shown as one formula
For hypothetical cash flows of 100, 120 and 140 at years one, two and three with an 8% rate, the present values are about 92.59, 102.88 and 111.14, totalling 306.61. This illustrates only the explicit forecast; a company DCF also requires a terminal method and an enterprise-to-equity bridge.
What this does not cover — choosing a discount rate for a real business or forecasting the cash flows themselves
This does not choose a rate or forecast for a real business. It also does not address whether FCFF is suitable for a bank, insurer or loss-making company; the product limitations say it is not. Present-value arithmetic can be exact while the selected cash flows fail to describe the asset being modelled.
Every DCF is this idea repeated — how ToolAcre applies present value to a generated forecast path
The outline implied that arbitrary cash-flow series could be entered directly. ToolAcre instead starts from positive FCF and generates annual figures from scalar, staged or per-year growth rates. Reproduce a compatible path and inspect the rows. The lesson is still repeated discounting, but the interface’s supported input model must not be overstated.