<img height="1" width="1" style="display:none;" alt="" src="https://www.facebook.com/tr?id=880824774066981&amp;ev=PageView&amp;noscript=1">
Skip to Content
Main Content

Model Base, Best and Worst Case Scenarios

Model scenarios for Funding (source and amount released, loan repayments), Patient Population and Enrollment, Costs (site, patient, operational, compliance), Revenue (direct sales, royalties, one-off revenue) and Cash Balances.

View Variances Between Scenarios

Use the Variance summary sheet to get a side-by-side comparison of base, best and worst case scenarios for each trial phase.

View All Your KPIs in One Dashboard

Get a detailed breakdown of your costs, revenue and cash during each trial phase with a visual dashboard.

Frequently Asked Questions

A. Yes. This Clinical Trial Modelling template is totally free and yours to keep forever.
A. Use this Excel template to track all of your funding, costs, revenue and cash balances for each trial phase in one place. Plus, you can model base, best and worst case scenarios.
A. Since the Template was specifically designed for Excel, we don’t recommend that you open the Template in Google Sheets. The formulas and formatting may not work in Google Sheets.
A. Nope. All you need is Microsoft Excel.
A. We’re happy you asked. Vena is the #1 AI-Powered Complete FP&A Platform. Over 2000 organizations of all sizes power their Plan To Grow™ with Vena.

Download Your Free Template

Download your free Excel template and start getting more time back in your day so you can focus on planning for tomorrow.

More Templates

Rolling Forecast Template

Improve your operating expense forecasting. Choose from multiple planning methods, view trendlines and variances and more.

What-If Analysis Template

Try our Financial Modeling Template to model different monthly forecasting scenarios and view variances between forecasted inputs and scenario models.

Budget vs. Actual Report Template

Use this Budget vs. Actual Template to calculate and visualize variance across different timeframes and accounts.