Help for formula please

Discussion in 'Share Investing Strategies, Theories & Education' started by Lecoots, 11th Mar, 2008.

Join Australia's most dynamic and respected property investment community
  1. Lecoots

    Lecoots New Member

    Joined:
    1st Jul, 2015
    Posts:
    3
    Location:
    Melbourne, Victoria
    With the market turmoil I wanted to be able to work out the Share Price when a margin call would be triggered. I know the size of the loan, obviously the current share price and number of shares held and the stock LVR (say 75%).
    I rationalised the formula would be:
    $Trigger=Loan Value/(Shares held*.75) in this instance
    I rang the lender and he said not correct but when asked what it is they said they work another way on percentages and they don't have a tool for the angle I am asking.
    I got to your site today and I guess others will be working from my perspective and it will be a frequently asked question.
    Thanks in advance
    Lecoots
     
    Lecoots, 11th Mar, 2008
    #1
  2. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,412
    Location:
    Sydney
    Simon Hampel, 11th Mar, 2008
    #2
  3. Lecoots

    Lecoots New Member

    Joined:
    1st Jul, 2015
    Posts:
    3
    Location:
    Melbourne, Victoria
    Thanks Sim, trying to reconcile your spreadsheet with a monthly statement I have. Will let you know how it goes
     
    Lecoots, 11th Mar, 2008
    #3
  4. Lecoots

    Lecoots New Member

    Joined:
    1st Jul, 2015
    Posts:
    3
    Location:
    Melbourne, Victoria
    Help formula please

    Thanks Sim
    That spreadsheet works fine with me
    Lecoots
     
    Lecoots, 12th Mar, 2008
    #4