Jump to content
Find Professionals    Deals    Get Quotations   Portfolios
Sign in to follow this  
deckbuild

How To Calculate Monthly Loan Repayment?

Recommended Posts

Looking for good contractors? Click here for your request

You will need a financial calculator to calculate Monthly Rest Package. Simple Interest (Flat Rate) is simpler. Don't be fool by the low Flat Rate interest, as the effective interest rate is the one that you should used to compare that to Monthly Rest package, many ppl get confused as they are not financially trained and some irresponsible people took advantage of that.

Do a search on Google for Monthly Mortgage Calculator, for monthly rest package the calculation is the same.

Duration (N) = Number of Monthly Repayment

Interest (i) = Monthly Rest Interest

Present Value = Loan Quantum

Future Value = 0

Find PMT

 

Share this post


Link to post
Share on other sites

P6/O lever maths syllabus quite 'hopeless' - cover those useful and uncover those useful like these effective int, PMT...

Car loan in Singapore is using 'flat interest rate', which is illegal in the U.S.A

Monthly instalment = A+B. The monthly amount is 'fixed' throughout the loan period

A= payment towards interest

B= payment towards principal

Instalment = (P.I.Y) + P/n

P= loan amount, $

I=interest rate (%)as quoted, not effective interest rate

Y= total number of year for loan

n= Yx12 = total number of instalment

Mortgage loan payment calculation is called 'Annuity due', or term loan.

PV = PMT +PMT((1-(1+r) to power of -(n-1))/r))

This one involves 'effective interest rate' = interest is compounded yearly.

PV = present value of loan amount, or 'outstanding amount'

PMT stands for 'payment' which is monthly instalment amount

r= effective interest rate

n= number of instalments

Want to know more? PM me with email. Will give some notes (hope you can digest) and a spread sheet s/w which can calculate up till 36 instalment by inputting 3 variables (P, Y, I). You can tell from each instalment, how much go to 'interest payment', 'principal payment' and 'outstanding amount'....

These are 'basic' for financial maths.

 

Share this post


Link to post
Share on other sites

30k loan with tenure of 2 years ...

PV = -30000

N = 2 (assume yearly) or 2 x 12 = 24 months

Interest = what did the bank interest rate charge u with ?

set p/y and c/y = 12 (because pay monthly installments)

Let's assume interest rate is 5%, then monthly PMT as what the forum said is the monthly payment

5% = 1316 monthly payment

3% = 1289

1% = 1263

Then of course, you can also calculate the total interest paid using Amortization, etc

I hope my financial calculator did not bluff me :-)

 

Share this post


Link to post
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
Sign in to follow this  

×