I would like a template or someone to tell me how to set up the formulas that
would figure out the remaining loan balance after each payment. It's owner
financed with interest calculated monthly, but I try to make weekly payments.
I haven't done so every week though. What I want excel to do is apply the
payments towards the balance weekly while still figuring the interest
monthly. I have no idea how to set up the formulas for this. Can anyone help
or is this not enough information? thanks