JimmyBMember@jimmybJoin Date: 2003Post Count: 2
Having recently developed a strong interest in property investment, I have gone out and bought a stack of books on the topic and am slowly going through them all. Steve’s was the first one and that was enough to keep me hooked.
However, having a strong background in mathematics, I was dismayed to discover that not one of my books contained any information as to how home loans actually work (in all their gory detail), how repayments are calculated, how interest rate rises are applied to existing loans etc.
While I can aapproximate the mechanisms of loans, I am more interested in getting the info ‘from the horse’s mouth’, so to speak.
I have searched the web and found nothing. My local bank tells me that they can’t provide the information because they use their systems to do all the calculations.
Can anybody please recommend a source of information in this regard? Any advice would be appreciated.
JimmymelbearMember@melbearJoin Date: 2003Post Count: 2,429
Jimmy, noting your background in maths, I am guessing that you are good with Microsoft Excel?
In there, you will find several calculators in the functions that you can use – or in XP, I think there is a template that will do loan repayments over 30 years, plus you can add in additional repayments at various times.
The calculators are:
PMT = Principal and Interest Payment
IPMT = Interest Payment Only
PPMT = Principal Payment Only
MelJimmyBMember@jimmybJoin Date: 2003Post Count: 2
I checked it out and it all looks pretty good.
Thanks for the tip!
JimmySteve McKnightKeymaster@stevemcknightJoin Date: 2001Post Count: 1,749
P&I loans are calculated based on the annuity formula where PAYMENT is a variable of PRESENT VALUE (principal or loan balance), INTEREST (per compunding period) and TIME.
Excel does this with the PMT function.
Hope this helps.
Remember that success comes from doing things differently.
Steve McKnight | PropertyInvesting.com Pty Ltd | CEO
Success comes from doing things differently
You must be logged in to reply to this topic.