How to Calculate the Payback Period With Excel
The discount rate is typically the project’s cost of capital or the company’s weighted average cost of capital (WACC), reflecting the risk and opportunity cost of the invested capital. While useful, the Discounted Payback Period should not be the sole criterion for investment decisions, as it does not account for cash flows beyond the break-even…