Thanks for the suggestions. I have double-checked: I tried using the type zero by adding the ",0 ,1)" to the end of my NPER formula, but it didn't change anything.
I checked my month 1 row: I used the same formulas as you did for Interest, Principal, and New Balance. The only difference is that...