I need to create an amortization table on Excel. Does any...

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: comp.apps.spreadsheets FAQ

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by kike
Submitted on 7/12/2003
Related FAQ: comp.apps.spreadsheets FAQ
Rating:	Rate this question:
I need to create an amortization table on Excel. Does any one know how to do it? The table should have one column for the principal and one for the interest. I also need to be able to change monthly payments on specific months to see how that will affect the number of payments. Please take in consideration that the extra payments will be irregular on amount and on months. It will not be the same amount all the time. Thanks for your help.

Answer by TKD
Submitted on 8/20/2003
Rating:	Rate this answer:
Search for PPMT worksheet function in Excel's help file to set up your table.

Answer by shaggy
Submitted on 9/3/2003
Rating:	Rate this answer:
go to template click on template select loan amortization schedule

Answer by dances with dogs
Submitted on 6/7/2004
Rating:	Rate this answer:
If you don't have the template and you have a Mac, go to http://www.microsoft.com/mac/resources/templates.aspx?pid=templates (or go to http://www.microsoft.com/mac/ and search for "templates.") to get the template you need.

Answer by Nathan
Submitted on 1/21/2006
Rating: Not yet rated	Rate this answer:
Look at this website: www.richmore.com/mortgage/excel/

Answer by Derrick
Submitted on 7/17/2007
Rating: Not yet rated	Rate this answer:
go to bankrate.com

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: