Value Investing 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

Interest Income

No Tags
UserPost

9:30 am
February 12, 2011


Jae Jun

Admin

posts 1463

2

Hi Hewitt,

 

1. Can you try refreshing the spreadsheet again? I believe it was a temp issue as I can see all 10 years of financial data.

 

2. Unfortunately smartmoney does not have a separate line for interest expense. It would definitely help. The previous version I had where I was getting data from either morningstar or advfn breaks down the data nicely, but smartmoney is lacking in this respect. It's not as detailed as the other sources.

But with all the customer support issues about advfn not working properly for people overseas, I've had to resort to smartmoney.

My next project is to start something where the spreadsheets are less dependent on the public sites. That way people can just access my server and pull the data from there.

Thanks for the vote of confidence in the product!

 

 

 

9:26 am
February 11, 2011


earningspower

New Member

posts 2

1

Jae -

 

I am looking at CSCO's financial statements on OSV and have two questions:

 

1. The income statement for 2001-2005 is missing, although the balance sheet and cash flow statement data is provided. Why is the IS incomplete?

2. Does the data provider (looks like Smart Money) have a separate line for interest income, since there is also a separate line for interest expense? For the fiscal year ending July 2010, CSCO's interest expense was $623M, as OSV shows. But CSCO also had $635M of interest income per the 10-K, due to almost $40 billion of cash, cash equivalents, and investments. Here's why a separate line for interest income matters: when we calculate EV/FCF, we need to know interest income/(expense), whose after-tax income/(expense) is subtracted from (added to) operating cash flow. If we do not subtract AT interest income, then CSCO's EV/FCF is understated; i.e., the business looks more profitable, and hence cheaper, than it what we will realize in the years ahead. After all, if you put CSCO's net cash into your personal checking account after you buy the business (which is the theory behind EV), then CSCO's income statement and operating cash flow lose the interest income that arises from this cash pile.

 

OSV is a great tool. I have told friends buying OSV will be the best money I spend in 2011. Thank you for for sharing, and for letting your customers help you make OSV even more robust.

 

Hewitt Heiserman

No Tags


About the Stock Valuation Software forum

Forum Timezone: America/Los_Angeles

Most Users Ever Online: 170

Currently Online: mt
19 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 4
Forums: 40
Topics: 766
Posts: 4120

Membership:

There are 958 Members
There have been 9 Guests

There is 1 Admin
There are 3 Moderators

Top Posters:

somrh – 336
Graeme – 183
nell – 100
zehua – 96
valueinvestortoday – 80
krackerjack121 – 69

Recent New Members: autocats, silverfox, jman, matias091, foundos, pberardi

Administrators: Jae Jun (1463 Posts)

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