Let's Calculate Actual ASI Value

Genting wrote:I made an excel sheet to calculate actual ASI value which, reflects the actual companies value(performance) in CSE.

I started it using the current values and modified several share prices, which I think represents their actual value.
I would like you all to contribute it by updating company shares prices, which you think that may represent its fair value.
Once you change the shave price, it will automatically calculate the ASI reflecting your change.

The excel sheet can be found at-
https://spreadsheets.google.com/spreadsheet/ccc?key=0AoLBuHWorJAtdC13enU2Rk1SVjdRWFBIcV9UZnlpM1E&hl=en_US&pli=1#gid=0

SanjivFund wrote:..market is undervalued?

Genting wrote:I made an excel sheet to calculate actual ASI value which, reflects the actual companies value(performance) in CSE.

I started it using the current values and modified several share prices, which I think represents their actual value.
I would like you all to contribute it by updating company shares prices, which you think that may represent its fair value.
Once you change the shave price, it will automatically calculate the ASI reflecting your change.

The excel sheet can be found at-
https://spreadsheets.google.com/spreadsheet/ccc?key=0AoLBuHWorJAtdC13enU2Rk1SVjdRWFBIcV9UZnlpM1E&hl=en_US&pli=1#gid=0

Genting wrote:
"Base values are established with average market value on year 1985. Hence the base year becomes 1985."

Source : http://cse.lk/sectors/home.htm

Genting wrote:fair value is the fair market price of each company's share.
I used some values which I think fair : ex RICH 13.5
Several other members also has contributed to it by putting down values which they think fair.

If we can get fair values of all companies, we can get the true value for ASI. It can be up or down from the current value.

Let's Calculate Actual ASI Value

Post by Genting Yesterday at 4:57 pm
+
-
I made an excel sheet to calculate actual ASI value which, reflects the actual companies value(performance) in CSE.

I started it using the current values and modified several share prices, which I think represents their actual value.
I would like you all to contribute it by updating company shares prices, which you think that may represent its fair value.
Once you change the shave price, it will automatically calculate the ASI reflecting your change.

The excel sheet can be found at-
https://spreadsheets.google.com/spreadsheet/ccc?key=0AoLBuHWorJAtdC13enU2Rk1SVjdRWFBIcV9UZnlpM1E&hl=en_US&pli=1#gid=0

Ben Graham wrote:nice work genting. +rep from me too
did u take base value from CSE or u calculated it?

we have to enter a fairly precise value for the fair value of a particular stock considering global markets PE ratios. i said that since many global analysts say CSE's PE ratio is high. we have to consider that. if i am correct US markets PE is much smaller than CSE PE. US is something where evrybdy is taking as a base or a reference. since SL is a developing country, lil high PE is OK to me. nt smthn like 25 or 28. i am not an expert. its my view.
Btwn, base value of a new IPO must be the offering/issuing price. isnt it??