Dr. Schmidt is a finance specialist in capital budgeting and valuation techniques, ensuring the accurate modeling of discounted cash flow metrics.
The **Discounted Payback Period Calculator** determines the time required for the discounted future cash flows from an investment to equal the initial investment cost. This metric assesses risk by prioritizing cash flow recovery speed in present value terms. This versatile four-function solver allows you to determine the **Initial Investment (I)**, the required **Annual Cash Flow (C)**, the **Discount Rate (R)**, or the **Payback Period (T)**. Simply input any three of the four required variables and the tool will solve for the missing one (assuming cash flows are an **annuity**).
Discounted Payback Period Solver
Discounted Payback Period Formulas
This calculator models the discounted payback period by treating the cash flows as a Present Value of an Annuity (PVA), where the Initial Investment (I) must equal the Present Value of the stream of Annual Cash Flows (C).
Core Relationship: Investment $\approx$ Annual Cash Flow $\times$ Discount Factor
$$ I = C \left[ \frac{1 - (1+R)^{-T}}{R} \right] $$
\text{Where R is the Discount Rate (decimal) and T is the Payback Period (years)}
\text{Solve for Initial Investment (I): } $$ I = C \cdot \text{PVA Factor} $$
\text{Solve for Cash Flow (C): } $$ C = \frac{I}{\text{PVA Factor}} $$
\text{Solve for Payback Period (T): } $$ T = -\frac{\ln(1 - I \cdot R / C)}{\ln(1 + R)} $$
Formula Source: Corporate Finance Institute: Payback Period
Variables
- I (Initial Investment): The net initial outlay or cost required to start the project. (In currency).
- C (Annual Cash Flow): The net cash generated by the project each period (assumed to be constant, or an **annuity**). (In currency).
- R (Discount Rate, %): The rate of return required by the investor (often the WACC or cost of capital). (In percentage).
- T (Payback Period, Years): The time required for the sum of the discounted cash flows to recover the initial investment. (In years).
Related Capital Budgeting Calculators
Analyze the full suite of investment decision metrics:
What is the Discounted Payback Period?
The Discounted Payback Period is a capital budgeting technique used to determine how long it takes for a project’s cumulative cash inflows, when discounted to their present value, to equal the initial investment cost. This metric is a refinement of the simpler Payback Period because it accounts for the time value of money—the crucial idea that future cash is less valuable than cash received today.
This period is used by managers primarily as a risk screening tool. Projects with shorter payback periods are generally preferred because they return the initial capital faster, reducing the time the investment is exposed to risk (like changes in market demand or technology). If the calculated Discounted Payback Period exceeds the company’s mandated threshold (e.g., 5 years), the project is typically rejected, regardless of its ultimate profitability (NPV or IRR).
How to Calculate Discounted Payback (Example)
A project requires an Initial Investment (I) of $\$100,000$, generates Annual Cash Flow (C) of $\$30,000$ (annuity), and the Discount Rate (R) is $12\%$. We solve for the Payback Period (T).
-
Step 1: Calculate the Payback Factor
The goal is to find the Present Value of Annuity (PVA) factor that equals the ratio of Investment to Cash Flow: $\frac{I}{C} = \frac{\$100,000}{\$30,000} \approx 3.3333$.
-
Step 2: Solve for Time (T) using the PVA formula inverse
Using the complex formula (or a financial calculator) with $R=0.12$, we find $T$ such that $PVA_{Factor}(T) = 3.3333$.
-
Step 3: Determine the Payback Period (T)
The resulting Payback Period (T) is approximately $\mathbf{4.55 \text{ years}}$. This is significantly longer than the simple payback period ($\$100k / \$30k \approx 3.33 \text{ years}$), highlighting the cost of delaying cash flows.
Frequently Asked Questions (FAQ)
Simple Payback ignores the time value of money. Discounted Payback is a more conservative and accurate metric because it first discounts each future cash flow back to its present value before summing them up to find the recovery time.
Shorter is always preferred. A shorter period indicates faster recovery of the initial capital, which reduces risk exposure and makes the funds available sooner for other profitable uses.
The Discount Rate (R) is typically set to the company’s **Weighted Average Cost of Capital (WACC)**. This rate represents the minimum return the company must earn on its overall asset base to satisfy its investors.
If $C=0$, the investment generates no income, and the required payback time (T) is infinite. The calculator will flag this as an error because the investment will never be recouped.