Google Answers Logo
View Question
 
Q: Mortgage Interest Calculation ( No Answer,   1 Comment )
Question  
Subject: Mortgage Interest Calculation
Category: Business and Money > Finance
Asked by: grammatoncleric-ga
List Price: $2.00
Posted: 06 Feb 2004 10:33 PST
Expires: 06 Feb 2004 18:18 PST
Question ID: 304162
What is the interest rate on a 30-year fixed mortgage for a loan of
$120,000?  Monthly payment is $700.  I'm not sure what the compounding
is....please calculate for what is most common in the home loan world.
 Show me how you arrive at the answer.

The Grammaton Cleric

P.s. An answer within an hour of posting derives a tip.

Request for Question Clarification by revbrenda1st-ga on 06 Feb 2004 10:48 PST
Hi, grammatoncleric,

You mention a monthly payment of $700. Does that payment include
interest and fees such as insurance, or is it just the monthly
principal payment?

Thanks,
revbrenda

Request for Question Clarification by revbrenda1st-ga on 06 Feb 2004 11:18 PST
Hi again,

Also, can you tell me if $700 is the actual payment or a rounded off
figure? I have a rate for a monthly payment of $699.91.

Thanks,
revbrenda

Clarification of Question by grammatoncleric-ga on 06 Feb 2004 13:00 PST
Hi Revbrenda,

So, this question is entirely theoretical.  I have actual numbers
which are not so round as 120K and $700.  Rather, I'm looking for some
equations.  Use $700.00 exactly and provide me a way of doing this
myself.

GC

Request for Question Clarification by revbrenda1st-ga on 06 Feb 2004 13:55 PST
Sorry, grammatoncleric,

I understand now what you need. Mathematics is not my strong suit --
indeed, as the saying goes, "I'd rather eat bark" than do math.
However, I was raised to believe that there is more than one way to
skin a cat. I found an on-line tool which allows me to enter the total
mortgage over a 30 year period and from the calculator, find the
monthly payment and rate of interest for this loan. After my last
clarification request I was able to fine tune the percentage with a
monthly rate of $699.98. I can't seem to get an exact $700 payment.
I'm sure one of our other researchers can figure it out and come up
with a workable equation for you.

I wish you well,
revbrenda
Answer  
There is no answer at this time.

Comments  
Subject: Re: Mortgage Interest Calculation
From: ipfan-ga on 06 Feb 2004 15:54 PST
 
The interest rate on the hypothetical loan you mention is 5.75% per
annum.  I figured this out using my HP 12C calculator.  Deriving
interest rates involves a complex equation and iterative techniques,
i.e., you have to run the equation again and again with different
"guesses" until you get close enough to call it good.  There's an
Excel formula and a good discussion of the challenging math behind
this at
http://db.uwaterloo.ca/~alopez-o/math-faq/node76.html

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy