Use the PV function to calculate present value
Syntax: PV(rate, nper, pmt, [fv], [type])
Step 1: Define the interest rate, number of periods, payment, and optionally future value and payment type.
Step 2: Enter the formula in a cell and press Enter.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com