| User | Post |
|
3:55 pm
January 21, 2010
|
Jae Jun
| | |
| Admin
| posts 1331 |
|
|
Sorry but I'm not quite sure what you mean.
In excel if a value is 373,444 even though it may only display 2 decimal places, the entire number is still used in the calculation and not 0.37m. So regardless of whether you multiply by 1m at the beginning or at the end of the formula is the same.
|
|
|
9:53 am
January 21, 2010
|
stocki711
| | |
| Member | posts 21 |
|
|
If you multiplied their numbers (such as .14 million) by 1 million in your formulas and let the larger numbers go through calculations you wont loss as much value on share calculation
|
|
|
1:05 am
January 20, 2010
|
Jae Jun
| | |
| Admin
| posts 1331 |
|
|
That's a good point but the numbers are from the internet. So if a site has 0.14m to represent 147,383 then it could be a problem as you suggest. Thanks for pointing that out. I didn't think about that but unfortunately it's not something that I can fix as well.
|
|
|
12:46 am
January 20, 2010
|
stocki711
| | |
| Member | posts 21 |
|
|
All of your numbers are in millions but if you multiplied all the numbers by a million and then carried out the DCF formula your share prices will be greater in price, sometimes as much as 10% greater for microcaps (such as EVI). Just a suggestion although I don't know if you did it for sake of speed of calculations…
|
|
Home
