you can create your own by using the folowing formulas..
=cumprinc() - creates a decending princible balance
=cumipmt() - creates a decending intrest balance
you will have to copy down for the length of the loan for each formula
calculates off the previous loan balance. other amounts can be calculated.
for example...
principal payment this month = previous loan balance - current loan balance.
intrest payment this month = payment - principal payment this month.

I did this for my morgage and found it to be reasonably accurate. off from
the morgage company's numbers but only by pennys.
look up the 2 formulas above in xl help for details on how they work. Thats
what i did.
i don't know but you can post in templates to see if there is a template of
this.
good luck
FSt1


"england26" wrote:

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