InvestorsHub Logo
Followers 3
Posts 20
Boards Moderated 0
Alias Born 04/07/2018

Re: madprophet post# 31643

Thursday, 04/12/2018 7:15:16 PM

Thursday, April 12, 2018 7:15:16 PM

Post# of 46490
Interpreting the Worlds' intrinsic value spreadsheet

The spreadsheet rows 42-1041 contain 1,000 sample scenarios or possible outcomes. Each columns' value is based on the assumptions (at the top of the sheet).

So take row 42 for example:

* The A-column (CAFC restores all claims) is either TRUE (25% of the time) or FALSE (75% of the time), because that assumption is currently set at 25%.
* The B-column (PTAB restores all claims) can only be TRUE if the CAFC fails to restore all claims, and when that happens, it is TRUE 85% of the time (according to the assumption).
* The C-column (SC restores all claims) is TRUE 10% of the time.
* The D-column (All claims restored) is TRUE whenever any of the first 3 columns are TRUE.
* The E-column is a little more complicated. It considers whether all claims are restored, odds of settlement, odds of triple damages, reasonable royalty rate, and subtracts out attorney fees.
* The F-column (Other settlers) guesses how many of the other infringers will decide to settle. It is 0 if the Activision lawsuit goes unfavorably.
* The G-column (Other awards) has example awards from the other lawsuits, minus attorney fees.
* The H-column (Awards) is the total totals from the Activision and other lawsuits.
* And finally, the I-column has example intrinsic values of the company per share, based on the awards, previous net losses, taxes, MediMed stake, and P/E ratio.

I've added some of these notes to the column headings of the sample scenarios to hopefully make things clearer.