drugsim - Drug Model Interest rate 0.15 initial r and d...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Drug Model Interest rate 0.15 initial r and d testing I stage succeed? Prob of success worst most likely best stage Cash flow Time DCF cost #ADDIN? cost #ADDIN? initial r and d #ADDIN? #ADDIN? 0.2 0.35 0.42r and d #ADDIN? #ADDIN? best 50 best 350 preclinical testing #ADDIN? #ADDIN? 0.3 0.5 0.6preclinical testing #ADDIN? #ADDIN? #ADDIN? worst 120 worst 600 testing I #ADDIN? #ADDIN? 0.4 0.5 0.6testing I #ADDIN? #ADDIN? #ADDIN? most likely 70 most likely 480 testing I #ADDIN? #ADDIN? 0.7 0.9 0.96testing I #ADDIN? #ADDIN? #ADDIN? time #ADDIN? time #ADDIN? Profit! #ADDIN? #ADDIN? #ADDIN? best 3 best 3 Total DCF #ADDIN? worst 7 worst 6 most likely 4 most likely 4 preclinical testing testing I cost initial r and initial r and preclinical tpreclinical t esting I / stesting I / Ptesting I / stesting I / Ptime time cost cost time time profit cost #ADDIN? cost #ADDIN? best 10 best 3500 worst 30 worst 6000 most likely 15 most likely 4200 time #ADDIN? time #ADDIN? best 0.5 best 3 worst 3 worst 6 most likely 1 most likely 4 profit #ADDIN? best 60000 worst 14000 most likely 18000 Maximum Mean Std Dev 6626.53 84.97 820.09 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 @RISK Output Data Reports Output Data Outputs Total DCF / DCF Simulation 1 Workbook drugsim4.xls Worksheet analysis Iteration / Cell $O$10 1 2352.02 2-68.96 3-98.18 4-61.85 5-315.56 6-76.96 7-64.89 8-52.72 9-66.3 10-68.32 11 926.13 12-339.41 13-79.18 14-98.25 15-97.26 16-88.63 17-86.8 18-71.56 19-75.88 20-60.87 21-60.37 22-95.8 23-90.46 24-56.08 25-69.51 26-76.01 27-269.52 28-101.95 29-68.57 30 6379.25 31-229.69 32-89.94 33-65.47 34-78.13 35-79.94 36-94.57 37-298.77 38-80.04 39-65.86 40-59.63 41-91.78 42-278.73 43-290.81 44-91.47 45-81.33 46-66.02 47-93.53 48-65.75 49-69.86 50-58.97 51-64.15 52-64.9 53-77.69 54-60.34 55-68.31 56-78.2 57-281.23 58-97.23 59-72.22 60-76.92 61-95.29 62-62.61 63-77.97 64-69.42 65-114.72 66-89.72 67-243.64 68-102.23 69-92.07 70-53.68 71 2521.05 72-76.34 73-75.33 74-93.41 75-82.57 76-282.92 77-67.72 78-113.56 79-57.68 80-70.19 81-73.41 82-80.47 83-57.76 84-73.57 85-70.88 86-76.75 87-87.71 88-87.47 89-78.69 90-93.95 91-87.29 92-91.55 93-64.76 94 1753.04 95-89.22 96-71.49 97 1805.06 98-95.09 99-87.12 100-71.81 101-97.71 102 3960.53 103-106.03 104-56.24 105-244.86 106-83.12 107-102.8 108-97.99 109-79.72 110-76.15 111-69.74 112-85.38 113-78.89 114-62.42 115 925.65 116 1046.66 117-109.39 118-62.27 119-335.47 120-68.25 121-62.85 122-80.81 123-99.56 124-86.37 125-82.08 126-112.92 127-273.35 128-326.31 129-85.47 130-256.74 131-69.6 132-67.85 133-70.68 134-80.42 135-71.85 136-90.97 137-105.84 138-77.16 139-73.7 140-97.45 141-96.1 142-103.68 143-81.34 144 3807.46 145-79.32 146-76.3 147-65.4 148-65.09 149-323.3 150-71.18 151-102.66 152-72.29 153-83.13-83....
View Full Document

This note was uploaded on 03/17/2010 for the course ACCT acct 4360 taught by Professor Robert during the Spring '10 term at DeVry Colorado Springs.

Page1 / 145

drugsim - Drug Model Interest rate 0.15 initial r and d...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online