hi
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.
good luck
FSt1
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.