Google Answers Logo
View Question
 
Q: calculating "melded" rate ( No Answer,   3 Comments )
Question  
Subject: calculating "melded" rate
Category: Business and Money > Finance
Asked by: gelmiller-ga
List Price: $5.00
Posted: 13 Oct 2005 08:06 PDT
Expires: 12 Nov 2005 07:06 PST
Question ID: 579769
How do I calculate "melded" or "efective" rates on multiple loans? For
example, if I'm paying a 5% rate on a $100,000 mortgage and 9% on a
$50,000 mortgage and both are at terms of 360 months, how do I
determine what rate I'm paying on the entire $150,000? And then how
would I do so if the terms were different: say 240 & 360? Thanks
Answer  
There is no answer at this time.

Comments  
Subject: Re: calculating "melded" rate
From: finance_guru-ga on 13 Oct 2005 17:27 PDT
 
You have 2 loans:

Loan 1: PV = $100,000
        Interest/Month = 5/12
        Length of Loan = 360 Months
        Monthly Payments = $536.82
Loan 2: PV = $50,000
        Interest/Month = 9/12
        Length of Loan = 360 Months
        Monthly Payments = $402.31

Total Monthly Payments = $939.13
Total Amount Paid over the loan = $939.13 * 360 
                                = $338,086.80


Total Interest = 188,086.8
Interest on Loan 1 = 93,255
Interest on Loan 2 = 94,831.6

5 * 93,255/188086 + 9 * 94,831.6/188,086
= 7.01%

For Different Time periods, in a similar manner, you interest rate will be

Loan 1: PV = $100,000
        Interest/Month = 5/12
        Length of Loan = 240 Months
        Monthly Payments = $659.96

Loan 2: PV = $50,000
        Interest/Month = 9/12
        Length of Loan = 360 Months
        Monthly Payments = $402.31

SIMILARLY CALCULAGE IT FOR THE 2ND CASE ...
Subject: Re: calculating "melded" rate
From: gelmiller-ga on 13 Oct 2005 20:44 PDT
 
This answers my question exactly, thanks so much.
Subject: Re: calculating "melded" rate
From: finance_guru-ga on 14 Oct 2005 06:29 PDT
 
Actually the second one will be a bit more work !

Loan 1: PV = $100,000
        Interest/Month = 5/12
        Length of Loan = 240 Months
        Monthly Payments = $659.96

Loan 2: PV = $50,000
        Interest/Month = 9/12
        Length of Loan = 360 Months
        Monthly Payments = $402.31

Effective Interest over 240 Months for 9% loan
Total Interest = 78314.41

Effective Interest over 240 Months for 5% loan
Total Interest = 58,389

Effective Interest over 120 Months for 9% loan
Total Interest = 16,517

= 7.3% + 0.09 * (16517/153220)
= 7.3 + 0.1 = 7.4%

Thus you calculate the blended for the first 2 and then blend the
third one into it!!

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