Sign up  |  Log in

How do you calculate total interest on a mortgage?

Not the monthly interest but the total on the whole Mortgage.

You’re ready to take on the CFA Program, so stop guessing where you should begin. You give us your study dates, we’ll give you the study plan. Our adaptive activity feed breaks down your 300 hours into bite-sized weekly tasks that fit into your life.

The easiest way would be to create an Amortization Schedule assuming no prepayments, and sum all the monthly interest payments.  I don’t know of any formulas off hand that would do that for you. 

Why do you need to know?

The suggestion above is the absolute hardest way to do it.

Calculate the monthly payment of the mortgage, multiply by the number of payments, and subtract the amount borrowed. Everything left is interest.

aaronhotchner wrote:

The suggestion above is the absolute hardest way to do it.

Calculate the monthly payment of the mortgage, multiply by the number of payments, and subtract the amount borrowed. Everything left is interest.

True that.  Totally didn’t think of that, but its true.  So for a  standard 360 month mortgage multiply the P&I by 360 and subtract the original UPB.

you can do it with you TI Calc.

Put in the numbers and calculate the monthly payment. 

E.g. say 200 K PV, 6% per year, 360 months 

PV=-200000, I/Y=0.5, N=360 CPT PMT

PMT=1199.10

Now hit 2nd Amort

P1=1

P2=360

BAL=0.00

PRN=200,000

INT=231676.38 <– Total Interest paid over the 360 months.


CP

Reviving an old thread but besides the calculator method, does anyone has the full formula of calculating mortgage?

big excuse for not creating another topic but one question:

  “An investor is looking at 150.000 home. If 20 % must be put down and the balance is financed at 9% over next 30 years, what is the monthly mortgage payment?”

why do I need to do this 150.000 (1-02) = -120.000 as 20% means like 150.000 - 20% = 30.000 and this sum of money goes to PV not 120.000 as it’s 80% 

what did I missed? 

MFaffer wrote:
big excuse for not creating another topic but one question:

  “An investor is looking at 150.000 home. If 20 % must be put down and the balance is financed at 9% over next 30 years, what is the monthly mortgage payment?”

why do I need to do this 150.000 (1-02) = -120.000 as 20% means like 150.000 - 20% = 30.000 and this sum of money goes to PV not 120.000 as it’s 80% 

what did I missed?

You missed that the 30,000 is going to the seller of the home; it has nothing to do with the loan.

The loan amount is 120,000; that’s the PV on the loan.

Simplify the complicated side; don't complify the simplicated side.

Financial Exam Help 123: The place to get help for the CFA® exams
http://financialexamhelp123.com/