Use the PMT function to calculate loan payments
Syntax: PMT(rate, nper, pv, [fv], [type])
Step 1: Define the interest rate, number of periods, 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