Monday, March 31, 2008

Uncle Kim Choong passed away

My uncle, Kim Choong had passed away on 18 March 2008.

May he has peace & God blessed.

My mentor passed away

Last Friday, got a news that my uncle has passed away. He was my mentor. He has encouraged me to come to Singapore to work while I was very young, still schooling. It was rather emotional as I attended his funeral on Sat and later the cremation at Mandai.

Memories of what he had told me flows into my mind vividly as I recall the past. He had brought me around S'pore and to Changi airport, introduce me around chinatown. Then I introduced my wife (girl friend then) to him too.

Do treasure for your loves ones when you can.

Monday, March 17, 2008

NPV and IRR

Net present value (NPV) and internal rate of return (IRR). Both NPV and IRR are referred to as discounted cash flow methods because they factor the time value of money into your capital investment project evaluation. Both NPV and IRR are based on a series of future payments (negative cash flow), income (positive cash flow), losses (negative cash flow), or "no-gainers" (zero cash flow).



Source: http://office.microsoft.com/en-us/excel/HA011136321033.aspx?pid=CL100570551033

Wednesday, March 12, 2008

Thursday, March 6, 2008

Finding rows between nth to mth in Oracle

select *
from
(select a.*, rownum rnum
from
(select id, data
from t
order by id) a
where rownum <= 151
)
where rnum >= 148
/

select * from (select t.*, rownum rnum from t where rownum <> 140
/

Stocks with high dividend

http://money.cnn.com/galleries/2008/news/0802/gallery.dividend_stocks/index.html

Wrigley
Emerson Electric's
Federated
Abbott's
Pepsi