how to calculate npv in excel

Imagine you’re standing at a crossroads, holding two investment opportunities in your hands. One promises $10,000 in five years, while the…