Forum

You must be logged in to post
Search Forums:


 






Wildcard Usage:
*    matches any number of characters
%    matches exactly one character

Spreadsheet – possible rounding error

No Tags
UserPost

3:55 pm
January 21, 2010


Jae Jun

Admin

posts 762

4

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 11

3
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 762

2

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 11

1

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…

No Tags


About the Old School Value forum

Forum Timezone: Etc/GMT+7

Most Users Ever Online: 117

Currently Online:
7 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 4
Forums: 39
Topics: 385
Posts: 1766

Membership:

There are 408 Members
There has been 1 Guest

There is 1 Admin
There are 3 Moderators

Top Posters:

zehua – 89
DrSues02 – 45
krackerjack121 – 41
dmop12 – 34
Sid – 33
ankitgu – 30

Recent New Members: anil_san, juhanharm, shucmu, AdamGaglio, southie, MoNk

Administrators: Jae Jun (762 Posts)

Moderators: Jae Jun (762 Posts), VANYA (1 Post), sjmsoftech (0 Posts)



Optimized by SEO Ultimate

50 queries in 1.093 seconds.