What formula is used to calculate the amortization schedule in cell G7, assuming an equally amortizing loan product over the tenor?
The formula used in cell G7 is "=1/(B$3*12)", assuming an equally amortizing loan product over the tenor.