From inside the F12 enter the brand new harmony on algorithm =B2. Remember that we have overlooked more than column Elizabeth because the the audience is planning go into the even more fee indeed there. Today from inside the F13, i assess the remaining equilibrium from the deducting the primary fee out-of the previous equilibrium:

Note that I’m review to see if the prior harmony is actually greater than no (so you can four quantitative towns and cities). If so, then we just do the kept balance and you may subtract the primary percentage into the few days and then have any extra fee count. Otherwise, i set the bill in order to no. This is very important so that anymore data of the commission, dominant, and you may appeal are typical zero also (remember that we may pay-off the loan very early). Continue reading We can today put a column getting calculating the rest equilibrium →