Fosbuvir Project The company considers development of a new drug to treat Hepati
ID: 2789102 • Letter: F
Question
Fosbuvir Project
The company considers development of a new drug to treat Hepatitis C, code-named the Fosbuvir Project. Fosbeck has already spent $420 M on preliminary research for drug development and it will need another $600 M on development this year (tax deductible) and $2 B in CapEx next year (these cash outlays are not part of the cash flows that you have estimated earlier, because this project is not approved yet). Capital expenditures will be depreciated over 10 years using straight line depreciation.
The patent for the drug is pending and the company expects to receive an FDA approval and start selling the drug in two years. Its expected revenues in the first year of sales are $1 B with subsequent annual growth of 50% over the next three years, after which the sales will be stable for another 7 years. After that the drug will lose the patent protection and its manufacturing is expected to stop. The CoGS are estimated to be 15% of revenues and SG&A expenses are $2 B a year if the drug is produced and zero otherwise.
Expected revenues and expenses take into account the uncertainty of getting the patent and FDA approval. The company estimates the probability of getting the approval in two years is 10% (i.e., if the company gets the approval the revenue is $10 B, if it does not, the revenue is zero). Even if Fosbuvir gets approved by FDA, each year there is a 5 % probability of the patent becoming obsolete due to a new drug entering the market, in which case the revenues, as well as CoGS and SG&A expenses will drop to zero.
NPV and IRR
Please estimate the NPV and IRR of the Fosbuvir Project, using the company’s WACC of 12%. Please show excel formula and calculations.
CoGS ratio 15% growth 50% SGA $2.00 CapEx $2.00 Revenue1 $10.00 Project Life 10 years Tax rate 38% R&D $0.60 probability of approval 10% probability of obsolescence 5% WACC 12% Year 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Probability of Success 0.1 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 Revenue Cost SGA R&D Depreciation (unconditional) EBIT Taxes Net Income OCF CapEx FCF NPV IRRExplanation / Answer
CoGS Ratio
15%
Growth
50%
SGA
2.00
CapEx
2.00
Revenue 1
10.00
Project Life
10 Years
Tax Rate
38%
R&D
0.60
Probability of approval
10%
Probability of obsolescence
5%
WACC
12%
Time Period
0
1
2
3
4
5
6
7
8
9
10
11
12
Year
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
Probability of Success
0.10
0.95
0.95
0.95
0.95
0.95
0.95
0.95
0.95
0.95
Revenue
0.00
0.00
0.00
1.00
1.50
2.25
3.38
3.38
3.38
3.38
3.38
3.38
3.38
Less: Cost of goods sold
0.00
0.00
0.00
0.15
0.23
0.34
0.51
0.51
0.51
0.51
0.51
0.51
0.51
Gross margin
0.85
1.28
1.91
2.87
2.87
2.87
2.87
2.87
2.87
2.87
Less: SGA
0.00
0.00
0.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
Less: R&D
0.42
0.60
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Less: Depreciation
0.00
0.00
0.00
0.20
0.20
0.20
0.20
0.20
0.20
0.20
0.20
0.20
0.20
EBIT
-1.35
-0.93
-0.29
0.67
0.67
0.67
0.67
0.67
0.67
0.67
Less: Taxes
0.25
0.25
0.25
0.25
0.25
0.25
0.25
Net Income
-1.35
-0.93
-0.29
0.41
0.41
0.41
0.41
0.41
0.41
0.41
OCF (Gross Margin-SGA-R&D)
-0.42
-0.60
0.00
-1.15
-0.73
-0.09
0.87
0.87
0.87
0.87
0.87
0.87
0.87
CapEx
0.00
0.00
2.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
FCF (OCF - CapEx)
-0.42
-0.60
-2.00
-1.15
-0.73
-0.09
0.87
0.87
0.87
0.87
0.87
0.87
0.87
PV of FCF
-0.42
-0.54
-1.59
-0.82
-0.46
-0.05
0.44
0.39
0.35
0.31
0.28
0.25
0.22
NPV of Project
-1.63
IRR
3.03%
CoGS Ratio
15%
Growth
50%
SGA
2.00
CapEx
2.00
Revenue 1
10.00
Project Life
10 Years
Tax Rate
38%
R&D
0.60
Probability of approval
10%
Probability of obsolescence
5%
WACC
12%
Time Period
0
1
2
3
4
5
6
7
8
9
10
11
12
Year
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
Probability of Success
0.10
0.95
0.95
0.95
0.95
0.95
0.95
0.95
0.95
0.95
Revenue
0.00
0.00
0.00
1.00
1.50
2.25
3.38
3.38
3.38
3.38
3.38
3.38
3.38
Less: Cost of goods sold
0.00
0.00
0.00
0.15
0.23
0.34
0.51
0.51
0.51
0.51
0.51
0.51
0.51
Gross margin
0.85
1.28
1.91
2.87
2.87
2.87
2.87
2.87
2.87
2.87
Less: SGA
0.00
0.00
0.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
Less: R&D
0.42
0.60
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Less: Depreciation
0.00
0.00
0.00
0.20
0.20
0.20
0.20
0.20
0.20
0.20
0.20
0.20
0.20
EBIT
-1.35
-0.93
-0.29
0.67
0.67
0.67
0.67
0.67
0.67
0.67
Less: Taxes
0.25
0.25
0.25
0.25
0.25
0.25
0.25
Net Income
-1.35
-0.93
-0.29
0.41
0.41
0.41
0.41
0.41
0.41
0.41
OCF (Gross Margin-SGA-R&D)
-0.42
-0.60
0.00
-1.15
-0.73
-0.09
0.87
0.87
0.87
0.87
0.87
0.87
0.87
CapEx
0.00
0.00
2.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
FCF (OCF - CapEx)
-0.42
-0.60
-2.00
-1.15
-0.73
-0.09
0.87
0.87
0.87
0.87
0.87
0.87
0.87
PV of FCF
-0.42
-0.54
-1.59
-0.82
-0.46
-0.05
0.44
0.39
0.35
0.31
0.28
0.25
0.22
NPV of Project
-1.63
IRR
3.03%