# Calculation - P&I Loan

#### gav

From: Gavin Finn

Can someone help with the following:
I am looking for a calculator that will tell me how much I will owe at a particular point in time taking into a/c the interest rate, repayment amount plus any additional repayment amounts that are added. Eg If I had a loan of 100k and my aim was to have it down to 85k in 6 months time, what would I have to contribute each month/fortnight to get to this figure

I have searched the web but with no luck

Thanks
gav

Last edited by a moderator:

#### Rolf Latham

From: Rolf Latham

Hi Gavin

Theres a few amortization calcs like the one Duncan mentioned, use search engines like Altavista and youll get truckloads.

Ta

Rolf

Last edited by a moderator:

#### Owen

From: Owen .

Also try the PMT function in Excel (if you have it). You can enter your interest rate, period, starting figure, ending figure and it will work out your payment for you.

=PMT(D6/12,E6,B6,C6)

D6 = 6.5% (Interest rate /12 for months)
E6 = 6 (number of payment)
B6 = \$100,000 (Present Value)
C6 = \$85,000 (Future Value)

Owen

"Gambling promises the poor what property performs for the rich – something for nothing"

Last edited by a moderator:

#### new class

From: Anony Mouse

Gavin
I use my trusty Casio fc-100 (Financial Consultant) available for around \$70 at Officeworks. Does calculation like that in a breeze.
Most calculator will solve,if you have any four of the following five inputs.

present value
future value
periodic interest rate
payment
no. compounding periods

"A government that robs Peter to pay Paul can always count on the support of Paul."
Of course, Paul's support is obvious, but it is equally obvious that to rob from Peter to pay Paul will make Peter
very, very angry.
My question is this: "How can you run a good government with a sore Peter?"

Last edited by a moderator:

#### Donna L

From: Donna L

Hugh's calculators are my favourite:
http://www.interest.com/hugh/calc/

Try generic loan amortisation - you can
change any of the parameters.

Also has calculators that look at what
happens if you add an extra \$100 a
month etc.

Donna L

Last edited by a moderator:

#### jayhunter2000

From: Jay Hunter

Hi Gavin,

The best i have found is:

http://www.homeloansnow.com.au

or use the Westpac one only if you want to get confused and really frustrated!

Jay

Last edited by a moderator:

Replies
12
Views
3K
Replies
3
Views
1K
Replies
12
Views
2K
Replies
47
Views
6K
Replies
13
Views
2K