This is really good, thank you so much!

Thanks a lot for this. What if my schedule balances do not agree to the bank's amortization schedule, i.e. loan balances at the end of each period do not agree (could be due to timing differences because interest rate changes are done during the month - not at the beginning or end)... How do I account for the differences or else how do I ensure that my balances agree to the bank's. By the way, in order to avoid dragging down the formula for the interest rate column everytime the rate changes, I create a formula saying the interest rate in the period I'm looking at is equal to interest rate in the previous period (in your schedule for example, I would have made cell C13 = C12, then drag down the formula to C252. So every time your rate changes, the cells below the changed month will automatically change as well. Ta.

If Extra payment ?If only interest receive?