Alternatively, you can use the What-If analysis tool, a built-in calculator in Excel, to solve for the discount rate that equals zero. Read the original article on Investopedia.

If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE() function.