+11
Completed

ROIC Formula and Formulas in General

Richard 8 years ago updated by OSV Support 5 years ago 14

Hi Jae,

I've been using ROIC a lot in the spreadsheet but am unsure of what formula you are using. The problem is everybody has a different way of calculating the number so its sometimes difficult to do comparisons.


I think in general you might have a formula page that discloses all the formulas that you use so that people know exactly what is being measured.

+1
Under review

I'm thinking of how to best present the formulas I'm using.
Don't want to create a separate page that doesn't get visited. I want it to be right there for that specific point when you are looking at that data.

I think your little 'tool tip' fly outs work good, maybe include the '?' tool tip with the equation or general overview of the formula next to the item/formula you want to highlight

The only downside is that the tooltips don't support math equations.

And trying to read a potentially complex calculation in 1 line is going to be tough for users.

+3

I would love the exact formulas for everything. I wouldn't mind a seperate apreadsheet or pdf for reference. I often time spend a lot of time scouring the interenet to get the bare bones equations for valuatioms and metrics.

Excellent topic. I was just looking at GM. OSV has ROIC for FY2016 as 4.50% and Schwab has it as 7.16% -- a big difference. Schwab's formula is

Other 'Valuation' Ratios comparisons for GM are:


FYI, Schwab P/CF formula is:

Current Price divided by Cash Flow Per Share for the most recent fiscal year. Cash Flow is defined as Income After Taxes minus Preferred Dividends and General Partner Distributions plus Depreciation, Depletion and Amortization.

Share Price (as of last close)//Cash Flow Per Share (MRFY)

2.91

Started

Currently working being able to display the formulas used for calculations when you hover over the data point as opposed to having a single page or sheet. Having it right there when you need it will be more practical and useful.

Jae,

Could you provide an update on status of this?

The code is done. Just trying to find time to type in all the formulas.

Completed

Closing this, as we've entered most of the formulas as tooltips, but let us know if there's any particular that are missing/needed!

Many have generic descriptions. Please look at all under Key Stats/Key Ratios.

Look at my post from 2 years ago (same discrepancies apply).  For example, P/CF says "price per share divided by cash flow per share", which is a formula -- but begs the question: what is formula for 'cash flow'.  Same idea for ROIC -- what is the formula used?


Please provide more detailed formulas for everything listed in Key Stats/Key Ratios list.

Planned

Fair enough. We'll update these.

Thank you Mike.  Your presence now at OSV and responsiveness is a very welcomed improvement.

The status of this upgrade was changed to "Planned" 4 months ago.  Would you please provide an update on the progress?

Completed

Hi Jeff, thanks for the kick in the butt. We packaged these updates with another data update that has turned out to be a lot more complicated than we initially thought. So, I just separated them out and pushed them live. It may take 24 hours for the cache to refresh, but by tomorrow you should be seeing many more formulas in the key stats hover-overs.