Use the RATE function to calculate interest rate
Syntax: RATE(nper, pmt, pv, [fv], [type], [guess])
Step 1: Define the number of periods, payment, present value, and optionally future value, payment type, and an initial guess.
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