Stock Forum

Discuss value investing stock ideas

You must be logged in to post
Search Forums:


 






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

Questions about NetNet spreadsheet

No Tags
UserPost

2:26 pm
August 23, 2010


Jae Jun

Admin

posts 1336

2

1. It depends on what data source you are using in the net net sheet

2. shares oustanding used is the correct number of shares today. In the statements, it is the historical number.

3. NNWC = Cash & Equivalents + (Accounts Receivables x 0.75) + (Inventory x 0.5) – Total Liabilities

4. current assets – total liabilities

5. for data visualization purposes

5:46 pm
August 17, 2010


MrBook

Member

posts 30

1

Post edited 2:52 am – August 20, 2010 by MrBook


Jae; I am referring to (ABT) 8/16/2010. I am a premium user. I am referring to the NetNet spreadsheet.

 

1. Why is the Cash & Equivalents value = 4372.78in cell C10 different than the "Statements" Cash & Equivalent value = 4321.7 in cell S41?

 

2. Why is Shares Outstanding (cell C23) different than Shares Outstanding in "Statements" in cells S36 & S37?

 

3. Could you please give the formula for Discount to NNWC as mentioned in cell F29? 

 

4. Could you please give the formula for Discount to NCAV in cell F31?

 

5. Why do the values in cells F27:F31 also repeat at the top?

 

OK. Thanks.

No Tags


About the Stock Valuation Software forum

Most Users Ever Online: 147

Currently Online: Graeme
9 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 4
Forums: 40
Topics: 695
Posts: 3686

Membership:

There are 869 Members
There have been 8 Guests

There is 1 Admin
There are 3 Moderators

Top Posters:

somrh – 275
Graeme – 125
zehua – 96
valueinvestortoday – 75
nell – 67
krackerjack121 – 67

Recent New Members: kalidas, NathanB21, jademan10, romans122, vincentbston, mrpenguin

Administrators: Jae Jun (1336 Posts)

Moderators: Jae Jun (1336 Posts), VANYA (1 Post), djsun (0 Posts)