On Google sheets (which is the same as excel so I’m told).
I’ve figure out the “=pmt” part, but how do I get it to display the new balance each time a payment is made?
So the loan is 10,000.00.
Payment is 110 biweekly.
I’ve tried programming the balance cell as follows: “=10,000.00-110”* or more precisely: “cell the loan amount is in-cell the payment amount is in”.
But that’s not working.
ETA: Loan is interest free.
Thanks