Jump to content








  • Topics

  • Latest posts...

    1. 10

      Thailand Live Friday 11 October 2024

    2. 173

      Why do retirees marry in Thailand ?

    3. 73

      Foreign Tour Operators Flood Phuket, Taking Jobs from Locals

    4. 2

      Afghan Man charged with Election day terror plot

    5. 1

      Double-Ten Retailer Promotions: 10-10 is a Chinese Holiday. So, why is this big DEAL here?

    6. 0

      93-Year-Old Woman Crawls into Sakae Krang River & is Missing While Daughter Sleeps

    7. 25

      Pattaya Police Raid Poker Gambling Ring, Arrest 9 Foreign Players

    8. 25

      Pattaya Police Raid Poker Gambling Ring, Arrest 9 Foreign Players

    9. 2

      Former Aussie cop’s epic run across Thailand for tsunami victims

    10. 7

      Thailand triumphs in UN Human Rights council bid

    11. 1

      Donald Trump’s New Tax Promise: Eliminating Income Taxes for Americans Abroad

    12. 2

      Former Aussie cop’s epic run across Thailand for tsunami victims

    13. 25

      Pattaya Police Raid Poker Gambling Ring, Arrest 9 Foreign Players

Calculating monthly interest on home loan


Recommended Posts

Hi,

I am interested in finding how the bank calculate the interest and principal I am paying each month.

I have statements every month which shows current interest rate, loan amount, principal, interest, outstanding.

I used to ask a friend a few years ago and the formula wasn't too complex and the result was exactly same as the statement. But I can't find it anywhere.

I tried to play in excel with ipmt function but that doesn't seem to be it.

Thank you

K

Link to comment
Share on other sites


Bankrate dot com website has great calculators and you can expand the amortization schedule and see all the details month by month. Good for checking things out. For example, I entered 100,000, 30 years, 5 % interest as an example. Excel formulas should work but one has to plow through the help to be sure you put the correct period in, i.e. 30 years really needs to go in as 360 for Months, etc.

Date Payment Principal Interest Total Interest Balance June 2015 $836.03 $217.28 $618.75 $618.75 $164,782.72 July 2015 $836.03 $218.10 $617.94 $1,236.69 $164,564.62
Link to comment
Share on other sites

@hhgz

That is probably a good formula but isn't exactly what I'm looking for. Here is more details:

This month my statement shows (I modified the real values so formula wouldn't find these values)

Credit line: 1,000,000 THB

Current interest rate: 6%

Payment amount: 11,000 THB

Principal: 4,863 THB

Interest: 6,137 THB

Outstanding balance: 800,000 THB

Say I always pay 11,000 THB per month, how can I predict principal and interest breakdown for next month (assuming rate 6% is fixe)?

Thank you.

Link to comment
Share on other sites

As mentioned earlier there are many calculators on the internet to provide your answer...many, many different types of calculators relating to mortgages, personal loans, credit card payments, extra payments, etc. Like gt10002000 mentioned Bankrate.com has a bunch of calculators covering almost any type of money repayment scenario.

Link to comment
Share on other sites

@hhgz

That is probably a good formula but isn't exactly what I'm looking for. Here is more details:

This month my statement shows (I modified the real values so formula wouldn't find these values)

Credit line: 1,000,000 THB

Current interest rate: 6%

Payment amount: 11,000 THB

Principal: 4,863 THB

Interest: 6,137 THB

Outstanding balance: 800,000 THB

Say I always pay 11,000 THB per month, how can I predict principal and interest breakdown for next month (assuming rate 6% is fixe)?

Thank you.

I always found this useful:-

https://www.drcalculator.com/mortgage/

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...