I started serious Investing Journey in Jan 2000 to create wealth through long-term investing and short-term trading; but as from April 2013 my Journey in Investing has changed to create Retirement Income for Life till 85 years old in 2041 for two persons over market cycles of Bull and Bear.

Since 2017 after retiring from full-time job as employee; I am moving towards Investing Nirvana - Freehold Investment Income for Life investing strategy where 100% of investment income from portfolio investment is cashed out to support household expenses i.e. not a single cent of re-investing!

It is 57% (2017 to Aug 2022) to the Land of Investing Nirvana - Freehold Income for Life!


Click to email CW8888 or Email ID : jacobng1@gmail.com



Welcome to Ministry of Wealth!

This blog is authored by an old multi-bagger blue chips stock picker uncle from HDB heartland!

"The market is not your mother. It consists of tough men and women who look for ways to take money away from you instead of pouring milk into your mouth." - Dr. Alexander Elder

"For the things we have to learn before we can do them, we learn by doing them." - Aristotle

It is here where I share with you how I did it! FREE Education in stock market wisdom.

Think Investing as Tug of War - Read more? Click and scroll down



Important Notice and Attention: If you are looking for such ideas; here is the wrong blog to visit.

Value Investing
Dividend/Income Investing
Technical Analysis and Charting
Stock Tips

Saturday 21 January 2012

XIRR/CAGR: Investor's true performance indicator! (5)

Read? XIRR/CAGR: Investor's true performance indicator! (4)

Read? Two Bank Accounts? No, You may need Four! - (4)

How can I easily maintain and track investible and virgin cash?

It is lot easier if you have your investment bank account linked to your broker and CDP.

See the following examples. No sweat tracking.








When I add more spare cash e.g $20,000 into investment bank account for future investment opportunity in stocks






When I sell $20,000 stock, my bank account will be credited with 20,000 by my broker.






Still blur?

Then you have to buy Lasksa set at ToastBox for 1-to-1 coaching. LOL!


4 comments:

  1. why cant we create something transactional? isnt that a much recurring way of management - + cash.

    what i find is that if i do that alot of + - + - the calculation cannot throw out an XIRR. it becomes useless.

    ReplyDelete
  2. Hmm.. I like to simplify matters and break them up for easy maintenance.

    I measure XIRR is separately from stock transactions and dividends received.

    One excel worksheet containing only XIRR measurement

    Row 1: Date and initial capital

    Row 2: Date and new added capital

    Row N: Date and new added capital

    Last row: Current date and Portfolio Value


    ------------------

    Portfolio Value is maintained in another worksheet and seperate from XIRR and stock transctions

    Portfolio Value

    Left Column

    Row 1: Current stocks value at market closing prices
    Row 2: Investible Cash
    Row 3: Total

    Right Column

    Row 1: Total capital
    Row 2: Total Realized P/L (including stock dividends recieved)
    Row 3: Total Unrealized P/L
    Row 4: Total

    Total of LHS = Total of RHS

    Stock transactions and dividends

    Track in whatever method or ways. Free form tracking but must be able to produce two items:

    1. Realized P/L (including stock dividends received)
    2. Unrealized P/L

    ReplyDelete
  3. uncle let me try to see if i can incorporate it.

    ReplyDelete
  4. incorporate at where?

    ReplyDelete

Related Posts with Thumbnails