Based on the numbers in the spreadsheet (see attachment):
And the Discounted Payback would be for how many years?© BrainMass Inc. brainmass.com June 4, 2020, 2:51 am ad1c9bdddf
No need for calculations. Theoretically - if NPV is 0, IRR would be equal to the IRR itself. As by definition, ...
The solution determines NPV and Payback and IRR.