Amortization Schedule

[berg891832]

Can anyone help. Which function or formula would be best to use to create an amortization schedule table of values if I had a house at 150,000 at 9% for 30 years.

Thanks in advance.

Bill

 

[PaddyD]

check out pmt(). Post back if it's not clear...

paddy

 

[berg891832]

Okay, I have the PMT function down but can I have a complete table of all the payments complete with payment amount, interest paid?

 

[maxflia10]

Try this site,

http://geocities.yahoo.com/search?p=amortization

From Paul