Backboards: 
Posts: 163

Check me on this? Loan has annual rate of 5.74%. If current balance is in cell B1, then payoff date can be calculated with:

=B1+(0.0574*B1/12)-[monthly payment]
and then copy that formula down, right


Responses:
Post a message   top
Replies are disabled on threads older than 7 days.