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


    Search the Q&A Archives


Currently I use a mortgage calculator to figure out my...

<< Back to general questions

Question by Fred
Submitted on 10/2/2003
Related FAQ: N/A
Rating: Rate this question: Vote
Currently I use a mortgage calculator to figure out my mortgage payments.

Does any body know the formula from which one could derive a mortgage payment based on the duration, interest, and loan amount on a standard 30/15 yr mortgage with a fixed interest rate? I want to learn to do this w/out the use of a mortgage calculator.


Answer by Billy Waggens
Submitted on 2/13/2005
Rating: Not yet rated Rate this answer: Vote
Use the PMT function within Microsoft Excel.

 

Answer by donna
Submitted on 5/4/2005
Rating: Not yet rated Rate this answer: Vote
create a new account

 

Answer by meesau
Submitted on 7/10/2005
Rating: Not yet rated Rate this answer: Vote
its easy to figure out. first you Take the interest rate for example lets say 1.9% divide that by 1200.You really need a scientific calculator with a memory to do this.first save the result of this in your memory. Then add a 1 to it. When you get the sum of that square it by the terms of the mortgage example say a 30 year mortgage is 360 months, then minus a 1 from the result of that. Then save the result of that into memory also. Then take the first result you saved divide that by the second result you saved, when you get the answer to that then add the first result you saved in your memory to that. The answer of that then you multiply the amount of money you are borrowing for example $200000.00 dollars the product of that is your monthly payment. I may not have explained it perfectly but it works try it a few times Fred it took me a month to actually just find the formula for that but I also like to know how things are done also. Well hope u understand this good luck

 

Answer by Chris
Submitted on 5/27/2007
Rating: Not yet rated Rate this answer: Vote
How to calculate a mortgage payment without a calculator?

 

Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.


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:

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.

 

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 general questions


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

© 2008 FAQS.ORG. All rights reserved.