[hokumom]

I need to find a loan amoritazition schedule where the payment is entered and it calculates the number of payments. all the schedules I can find calculate the payment amount and you enter the number of payments...

[kjjb0204]

http://www.bretwhissel.net/cgi-bin/amortize

Leave the number of payments field blank. Your payment amount you enter must be enough to cover the interest.

[hokumom]

thank you, this is great and it does the job, but I am looking for this table in an excel spreadsheet format. Do you know of one?

[jimr381]

Welcome to the forum.

Have you looked into the Goal Seek tool within Excel? It allows you to tell it the payment you want to pay and you can apply it to a PMT() to figure out the number of periods you would need to pay for.

[kjjb0204]

Google is your friend.

http://office.microsoft.com/en-us/te...tion&av=TPL000

[hokumom]

Hi. I've allready checked out all those templates and they all have the payment amount as the unknown. I want the payment amount to be the known.
I can't find one anywhere.

[hokumom]

yours (kjjb0204) was the closest, I'm just looking for it in an excel format.

[Aj_old]

Try this:

[jimr381]

**points up to his previous post** I missed your reply to my post. What I specified should work out for you. If you need assistance with it then feel free to let me know.

[hokumom]

Hi jimr381
I did play around with the goal seek. I liked it but it would take getting some familararity with it for it to be user friendly for me. Also, I don't get the table of payments with it.
thank you