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.