Sorry ladies and gents, the google app was not doing all the calcs that I though it was so I have retuned the model yet again with the additional updates and fixes to the formulae:
Share Count 550M
Debt 500M
Partner taking 25% of the EBITA
So the new numbers on the output tab are as follows:
Post Approval Y10 Model 1 (NA) Model 2 (NA & Euro) Model 3 (World)
Share Count 550,000,000.00 550,000,000.00 550,000,000.00
Total Market Size 40,000,000 75,000,000 285,000,000
Market Share 20% 20% 8%
MNKD Market 8,000,000 15,000,000 22,800,000
Output Capacity 8,846,241 16,406,921 23,534,321
Dividend Rate 4% 4% 4%
P/E Ratio 16.00 16.00 16.00
Share Price using P/E $107.21 $230.12 $349.09
PEG Ratio n/a - too volitile
Dividend $4.29 $9.20 $13.96
The link to the New Editable workbook is:
https://docs.google.com/spreadsheet/ccc?key=0Ao_mxzpZueoYdEtOVUlndHphNkV3WF81a2ZOWUJkYnc#gid=0
The link to the New Baseline workbook is:
https://docs.google.com/spreadsheet/ccc?key=0Ao_mxzpZueoYdFlwWEtuUlVYNlFnR0x2OEZUclNPQ3c#gid=0
Both are also avail on the links page as well.
Always looking for additional input,
OOG
