Want FREE Templates on Digital Transformation? Download our FREE compilation of 50+ slides. This is an exclusive promotion being run on LinkedIn.

  Please register (it's free!) or login to view the remaining preview.
If you are logged in, your referral link [?] is automatically included below.
EMBED CODE (Copy and Paste)


  1. Analyzes a Biopharmaceutical Company using a Risk-Adjusted NPV Valuation Methodology.
  2. Supports a portfolio of 4 products (more can be added upon request)


Financial Model presenting a business scenario of a Biopharmaceutical Company with a portfolio of 4 different types of drugs, each representing a potential market opportunity.

The model analyzes the NPV of each product using a Risk-Adjusted DCF Valuation methodology after taking into consideration the different development risks and probability of success across 5 different development phases (Preclinical, Phase I, Phase II, Phase III, Approval).

The NPV of each drug is added together along with various Operating Expenses and Financing Assumptions to produce Company's Consolidated Financial Statements and come up with Business Unlevered and Levered Return Metrics (rNPV, IRR, MOIC, etc.)

Revenue is earned either through direct sale of the product or through product licensing and is forecasted using assumptions on drug's potential market penetration, expected peak sales, sale price, royalty rates, etc.

The model includes Development timing assumptions per drug from Preclinical to Market phases, Research & Development Costs per drug and development phase, Pre and Post Market Capital Expenditures, direct and indirect Operating Expenses.

Finally the model provides a Venture Capital Valuation and Fundraising Analysis including Discounted Equity Value, Pre/Post Money Valuation, Fundraising per Investor (Invested Amount, FD Shares Outstanding, Share Price) and Investors Returns (Dividends Payout, Profit, IRR, MOIC).

The structure of the template follows Financial Modeling Best Practices principles and is fully customizable.

Model Structure:

•  General Setup
The General Setup tab contains all the high-level assumptions necessary for the overall functionality of the model including General Business Info, Timing and Currency, Depreciation & Amortization, Income Tax Rate, Working Capital, Group Level Other Revenue & OpEx, Financing and Valuation Assumptions

•  Products
Products development and revenue assumptions including Market penetration data, Sale Price, Sale Method (Direct or License), Development phases timing and costs, COGS & OpEx, Pre/Post Market Capital Expenditures, Probability of Success (POS) rates and LOA (Likelihood of Approval) calculation.

•  Capex
Assumptions for Foundation's Capital Expenditures and calculation of depreciation using the straight-line method

•  WACC & Comps
Calculation of Weighted Average Cost of Capital using Comparable Companies Table to calculate Beta.

•  Vaccines Analysis (4 worksheets)
Analysis of each Vaccine including Risk-Adjusted Forecast, Adjusted FCFF, Terminal Value and Unlevered Return Metrics (rNPV, IRR, MOIC, etc) and Supporting Schedules for R&D Risk-Adjusted Costs and Working Capital.

•  Group Consolidation
Group Level Consolidated Financial Statements built using 3 Statement Model.
It also includes several Financial Ratios, Company's Valuation (DCF, Terminal Value, Unlevered and Levered Cash Flows and Return Metrics) and Supporting Schedules for R&D investments, Fixed Assets & Depreciation, Working Capital, Debt & Equity.

•  Venture Capital Valuation
VC Valuation analysis including Discounted Equity Value, Pre/Post Money Valuation, Fundraising Analysis per Investor (Invested Amount, FD Shares Outstanding, Share Price) and Investors Returns (Dividends Payout, Profit, IRR, MOIC)

•  Dashboard
Presentation of key business figures using highly-sophisticated Charts & Graphs

•  Executive Summary Report
Company's Performance Summary designed to be easy to read, print, and save to pdf.

Help & Support

Committed to high quality and customer satisfaction, all our templates follow best practice financial modeling principles and are thoughtfully and carefully designed, keeping the user's needs and comfort in mind.
No matter if you have no experience or you are well versed in finance, accounting, and the use of Microsoft Excel, our professional financial models are the right tools to boost your business operations!
If you however experience any difficulty while using this template and you are not able to find the appropriate guidance in the provided instructions, please feel free to contact us for assistance.
If you need a template customized for your business requirements, please e-mail us and provide a brief explanation of your specific needs.

Got a question about the product? Email us at [email protected] or ask the author directly by using the form to the right. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Pharma Biotech Risk-Adjusted Valuation Model Excel document

Top Flevy Author [?]

Pharma Biotech Risk-Adjusted Valuation Model

Sold by Profit Vision (this author has 105 documents)


Add to Cart

This business document is categorized under the function(s):

It applies to Healthcare & Life Sciences

File Type: Excel (xlsx)

File Size: 472.8 KB

Related Topic(s): Integrated Financial Model Healthcare

Purchase includes lifetime product updates. After your purchase, you will receive an email to download this document.

Initial upload date (first version): May 15, 2022
Most recent version published: May 16, 2022

Ask the Author a Question

Must be logged in Click here to log in



Since 2012, we have provided best practices to over 5,000 businesses and organizations of all sizes across the world—in over 130 countries. Below is just a very small sample of our customer base.

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.


Excel workbook
1-page PDF document
Excel workbook
57-slide PowerPoint deck
Excel workbook
180-slide PowerPoint deck and supporting ZIP
65-slide PowerPoint deck
Author: PPT Lab
Excel workbook
211-slide PowerPoint deck
277-slide PowerPoint deck
Excel workbook



Become your organization's resident expert on...

Digital Transformation
Strategy Development
Post-merger Integration (PMI)
Organizational Design (OD)
Performance Management
Business Transformation
Customer-centric Design (CCD)
Organizational Culture (OC)
Interested in something else? Browse our 500+ Business Toolkits of best practices, each focused on a specific management topic.