Join our investing community

Margin Loan on Navra units

Margin Loan on Navra units

  1. Giddo

    Giddo Active Member

    Joined:
    9th Jun, 2006
    Posts:
    42
    Location:
    SE Qld
    Giddo submitted a new resource:

    Margin Loan on Navra units - Margin Loan on Navra units

    Read more about this resource...
     
    Last edited by a moderator: 15th Sep, 2016
  2. Chris.R_WA

    Chris.R_WA Well-Known Member

    Joined:
    7th Aug, 2006
    Posts:
    113
    Location:
    Perth, WA
    Hi Giddo,

    This is just a pretty basic spreadsheet so you can quickly see the outcome of different scenarios. Have a play around with the rate of return from the fund, and also the interest rate of the margin loan, to see if it is still viable in more bearish situations. Basically, the level of gearing will magnify any gains or losses.

    Best wishes, Chris
     

    Attached Files:

  3. Giddo

    Giddo Active Member

    Joined:
    9th Jun, 2006
    Posts:
    42
    Location:
    SE Qld
    Very good Chris. Thanks a million, just what I wanted.
    Giddo
     
  4. Tom&Don

    Tom&Don Active Member

    Joined:
    16th Aug, 2005
    Posts:
    44
    Location:
    Melbourne
    Or you could try this one..
     

    Attached Files:

  5. Chris.R_WA

    Chris.R_WA Well-Known Member

    Joined:
    7th Aug, 2006
    Posts:
    113
    Location:
    Perth, WA
    Thats much prettier than mine, maybe I should have coloured some cells!:D
     
  6. FuriousG77

    FuriousG77 New Member

    Joined:
    28th Jan, 2008
    Posts:
    4
    Location:
    Melbourne, NSW
    Ok stupid question but I'll ask. From the spreadsheet (and other reading) I've always been under the impression that the LVR was calculated using the total portfolio value (ie if I have 100 ANZ shares, and purchase another 100 ANZ shares with my loan, I'm at 50%, as the loan is 50% of the folio).

    I now seen online that if I have $50,000 of existing shares and my LVR is 70% then I can only purchase an extra $34,000 shares to add to my folio, which would be the MAX, leaving no safety margin, so if I want 50% I can only buy $25,000 of shares with the margin loan.

    Is there a difference from starting from scratch vs using an existing portfolio, or am I just missing something simple in this?

    Thanks for that help.
     
  7. bundy1964

    bundy1964 Well-Known Member

    Joined:
    22nd Dec, 2006
    Posts:
    351
    Location:
    Adelaide, SA
    I think you missed adding in the value of the shares you are buying.

    Say you had 50K of existing shares and the margin amount was 70% you could take 35k in cash and max out your LVR or by buying shares at 70%, you could buy 50k worth and have a LVR of 50% and a buffer between 25% and 30% depending on which loan you use.
     
  8. FuriousG77

    FuriousG77 New Member

    Joined:
    28th Jan, 2008
    Posts:
    4
    Location:
    Melbourne, NSW
    Ahhh, cool, so it's one of those things that would turn up, after I've done it. Thanks.