The Excel net present value formula: NPV = -$232,000 + $38,800 (1+0,10) -1 + $38,800 (1+0,10) -2 + $38,800 (1+0,10) -3 + … + ...
TL;DR: Get Word, Excel, PowerPoint, and more on your Mac with a lifetime Microsoft Office license, now $89.97 (reg. $219).
Excel FILTER function mastery requires understanding TRUE/FALSE logic. Use the * multiplier for AND logic to easily handle multiple complex conditions.