All Topics / Finance / Newbie question on loans

Viewing 4 posts - 1 through 4 (of 4 total)
  • Profile photo of JimmyBJimmyB
    Join Date: 2003
    Post Count: 2

    Hi all,

    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.


    Profile photo of melbearmelbear
    Join Date: 2003
    Post 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


    Profile photo of JimmyBJimmyB
    Join Date: 2003
    Post Count: 2

    Hi Mel.

    I checked it out and it all looks pretty good.
    Thanks for the tip!


    Profile photo of Steve McKnightSteve McKnight
    Join Date: 2001
    Post Count: 1,763

    Hi Jimmy,

    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.


    Steve McKnight

    Remember that success comes from doing things differently.

    Steve McKnight | Pty Ltd | CEO

    Success comes from doing things differently

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. If you don't have an account, you can register here.