How to Calculate Your Investment Portfolio Return?

Print This Post Print This Post

by KCLau

in Make Money Tips, investment

Investing in various asset classes and never bother to track and monitor its return, is like flirting with several girls at the same time and never bother whom will ultimately be your wife. Don’t blindly invest and forget. It is like flirting without knowing what you will get.

You just need an extra step to calculate the return of your investment portfolio.

Let’s say you invest in several asset classes. Your gold investment gives over 100% return last year. Your stock investment turned sour after the 8th of March Malaysian general election. The apartment you rented out gives you a consistent return month after month because of your loyal tenants. Many type of investment, all with different return. So how do you know your overall investment portfolio is doing? Is it on track?

This is a simple tutorial on how to compute your portfolio return.

Return of portfolio = (W1 x R1) + (W2 x R2) + (W3 x R3) + …..(Wn x Rn)

Where W1, W2, W3 and Wn stand for the weightings in % of assets, for asset 1 to n, in the portfolio. Whereas, R1, R2, R3 and Rn are returns for the respective assets, 1 to n, in the portfolio.

Example 1:

More than half is invested in real estates.

Weight of stocks = 50k/293k = 17.06%
Weighted return of stocks = 25% x 17.06% = 4.27%
Overall portfolio return = 4.27 + 0.44 + 1.01 + 4.10 = 9.82%

Example 2:
This is a very conservative asset allocation. about 73% invested in fixed deposit.

Example 3:

This is an “balance” portfolio, invested in four asset class with equal share.

Download the excel spreadsheet: investment-portfolio-return

By tracking your portfolio return, you will be able to construct a proper asset allocation to get the desired return.

{ 10 trackbacks }

investlah.com
July 15, 2008 at 7:35 pm
RockYourVote.net
July 15, 2008 at 7:38 pm
Finance Fiesta #7: Mamma Mia Edition | LivingAlmostLarge
July 17, 2008 at 9:55 pm
Rich Life Carnival #6 | Your Finish Rich Plan - A Personal Finance Blog
July 20, 2008 at 11:39 am
Carnival of Financial Planning #8 - Cute Kitten Edition | Financial Learn
July 20, 2008 at 12:52 pm
» Summertime Savings Kids Make Money
July 21, 2008 at 8:46 pm
Carnival of 20-Something Finances - July 28, 2008 | Weak Wallet
July 31, 2008 at 3:16 am
Carnival of Making REAL Money Issue #21 on August 1st, 2008 | InvestorBlogger
August 2, 2008 at 9:27 pm
Carnival of Making REAL Money Issue #21 on August 1st, 2008 | Blog Carnivals
August 16, 2008 at 7:54 pm
How can I get compounded 10% return per annum?[Q&A]
May 26, 2009 at 11:11 am

{ 7 comments… read them below or add one }

1 Bill July 18, 2008 at 3:18 pm

Nice summary of how to calculate investment returns.

Reply

2 gokou3 July 23, 2008 at 12:07 am

Perhaps I have read it wrong, but I think you should also list the beginning market values and calculate weightings based on those MV.

Reply

3 KCLau July 23, 2008 at 1:27 am

Hi Gokou3,
Of course you need to find out the return rate of the individual classes. About how to arrive on the return rate, it will depends on many other variables.
Say you invest in RM10k in stock markets on Jan 1, and then review its return on Dec 31, it will be a very straight forward calculation. But I bet that in the real world, it doesn't work that way. You might buy and sell (trading), or using dollar cost averaging (different entry point). You have to calculate separately for every investment classes to come up with the appropriate return to be used in this form.
How about real estate investment? It is not simply buy a house at RM100k, and think that it has appreciate 10% by year end. It involves rental yield, maintenance etc.
We will talk more about calculating return for every single asset classes in the future.

Reply

4 sherin September 24, 2008 at 9:19 am

Excellent work and very informative. Appreciated

Reply

5 sherin September 24, 2008 at 9:22 am

Can we have a link exchange?

My blog name: Investment Internals
URL: http://investinternals.blogspot.com

contact: investinternals@gmail.com

Reply

6 KCLau September 24, 2008 at 9:45 am

Sorry that I don't exhange link at this moment. I'll probably link to
your article when it is appropriate.

http://www.kclau.com
Via iphone (爱疯)

Reply

7 Link Robertson November 3, 2008 at 6:03 pm

Leave a Comment

You can use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Previous post:

Next post: