DIY Investment with Excel

This is the June-2010 Sharpe optimization.
Current Portfolio: Return = 3.28%, STDEV = 4.21%, Sharpe = 0.7471
Optimized Portfolio: Return = 3.44%, STDEV = 2.68%, Sharpe = 1.210

Source: http://www.rhb.com.my/easy/easy_pinjaman_ekspres.html
Personal Loan business at Malaysia
Bring along your MyKad and head to the nearest Easy branch to apply for a personal loan and obtain instant approvals and loan disbursement.

Recently, I bought a new HTC phone. Previously I used Nokia N82.
After 2 weeks of using the new phone, you know, well, I always compare the new set with old during the transition period.
Several concerns are listed inside the table above. And, I notice that new phone not really new, I mean totally. Good function, not matter in hardware or software, it is still a big room for HTC to improve....

Scenario 1: Mr. J did invest single lump sum RM31,000 into an UT on 13-Dec-07. Today's value of this UT suffers loss of 9.81% for holding period (13-Dec-07 till 4-Jun-10), which its value is RM26,421.16, CAGR = -6.27% p.a.
Scenario 2: Mr. K started his first investment for the same UT for RM1,000 on 13-Dec-07. And, he practiced his monthly investment amounted RM1,000 into the UT on the 1st day of the month till 1-Jun-10. Today's value of this UT generates gain of 3.82...