Use the NPER function to calculate the number of periods
Syntax: NPER(rate, pmt, pv, [fv], [type])
Step 1: Define the interest rate, payment, present value, 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