All Topics / Heads Up! / Ive got a question about the book

Viewing 6 posts - 1 through 6 (of 6 total)
  • Profile photo of shaepowershaepower
    Member
    @shaepower
    Join Date: 2003
    Post Count: 7

    On page 68 i dont understand the calculations that took place to get “Weekly Repayment”

    Profile photo of Matt PMatt P
    Member
    @matt-p
    Join Date: 2003
    Post Count: 645

    If your having problems crunching the number you can go to this website, and put the numbers to get a resut.

    http://o2hl.com.au/calculatecost/calculators.cfm?calculator=loan_repayments

    Hope this helps.

    Matt

    “If you do what you have always done, you will get what you have always had.”

    “Isn’t it time for a change?”

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

    Hi,

    It’s a time value of money calculation whereby at the end of 25 years of principal and interest repayments, the amount of the loan outstanding is $0.

    Use these variables in the Excel PMT function and you should come to an answer of $62.82

    N= 1300 (25 years * 52 repayments per aunnum)
    PV= 35,200
    R/i = 0.15481% (8.05% / 52)
    First payment at beginning

    Cheers,

    Steve McKnight

    **********
    Remember that success comes from doing things differently.
    **********

    Steve McKnight | PropertyInvesting.com Pty Ltd | CEO
    https://www.propertyinvesting.com

    Success comes from doing things differently

    Profile photo of shaepowershaepower
    Member
    @shaepower
    Join Date: 2003
    Post Count: 7

    ah ok i understand. I forgot about the 52 weeks in the year bit. Anyway what is the Excel PMT function and how do i use it.[:)]

    Profile photo of melbearmelbear
    Member
    @melbear
    Join Date: 2003
    Post Count: 2,429

    shaepower, the PMT function works out your payments, both P&I for you.

    In excel, click on Insert, Function, and choose PMT. It then steps you through the variables reasonably easily.

    Cheers
    Mel

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

    Hi,

    Microsoft Excel… spreadsheet package.

    Use Mel’s advice about how to use it.

    It can be a bit tricky, but persevere and see where it gets you.

    Bye,

    Steve McKnight

    **********
    Remember that success comes from doing things differently.
    **********

    Steve McKnight | PropertyInvesting.com Pty Ltd | CEO
    https://www.propertyinvesting.com

    Success comes from doing things differently

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

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