Join our investing community

Help for formula please

Discussion in 'General Investing Discussion' started by Lecoots, 11th Mar, 2008.

  1. Lecoots

    Lecoots New Member

    Joined:
    11th Mar, 2008
    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
     
  2. Simon Hampel

    Simon Hampel Co-founder Staff Member

    Joined:
    9th Jun, 2005
    Posts:
    4,619
    Location:
    Sydney, Australia
  3. Lecoots

    Lecoots New Member

    Joined:
    11th Mar, 2008
    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
     
  4. Lecoots

    Lecoots New Member

    Joined:
    11th Mar, 2008
    Posts:
    3
    Location:
    Melbourne, Victoria
    Help formula please

    Thanks Sim
    That spreadsheet works fine with me
    Lecoots