How do I set up an Installment Note in Excel?
 

I would like to set up a way to keep record of payments on an installment
note with simple interest. The balance times the rate divided by the number
of days to figure the interest then apply the rest of the payment to the
balance.