Join our investing community

Living on Equity forecasts

Discussion in 'Investing Strategies' started by jscott, 16th Apr, 2006.

  1. jscott

    jscott Well-Known Member

    Joined:
    10th Jan, 2006
    Posts:
    143
    Location:
    Perth
    Just wondering if it would be possible to include examples with 20 or 40 year forecasts into the next instalment of the LOE articles. My own modelling in Excel show things are great early on but get ugly in later years. I'm sure Steve can explain this, but it would make sense to include future projections, especially if you model it with a few years of no (or -ve) growth in the early years...
    :)

    ps. when is the next one due?
     
  2. Maverick

    Maverick Well-Known Member

    Joined:
    23rd Sep, 2005
    Posts:
    51
    Location:
    Melbourne
    What Excel file do you use for modelling? I remember someone posting their version a while ago. Or do you have your own one? Is it a "generic" or "specific" model for your circumstances? Do you mind sharing it?

    Regards.
     
  3. jscott

    jscott Well-Known Member

    Joined:
    10th Jan, 2006
    Posts:
    143
    Location:
    Perth
    Hi Maverick,

    Its just my tweaks to the SS available on the Somersoft forum...
     
  4. Alan

    Alan Well-Known Member

    Joined:
    15th Aug, 2005
    Posts:
    603
    Location:
    Sydney
    If you only ever draw down a maximum of 2/3 of the previous years growth and invest the other 1/3 for interest payments/rainy day, how is it going 'pear shaped'?
     
  5. jscott

    jscott Well-Known Member

    Joined:
    10th Jan, 2006
    Posts:
    143
    Location:
    Perth
    I'll post my own SS when I get home tonight that compares the effects of compounding of interest and growth.