This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
NPV from start year, $M
Project Name
Project Start Year
Sales Start Year
Number of Sales Years
Patient Population
Patient CAGR
Average Selling Price, $
Year 1 Market Share
Year 2 Market Share
Year 3 Market Share
Year 4 Market Share
Year 5+ Market Share
Cost of Capital
Cost of licensing, % revenue
Cost of Sales, % revenue
Product COGS, % ASP
Drugs & SW 1%
Device 1st 10%
Device 2nd 20%
Commodity 40%