Calculations and Valuation Modelling Platform for Life Science Companies
The advanced calculation system offers an extensive platform that simplifies the valuation process for life science companies. It provides precise calculations, user-friendly interfaces for data entry, extensive logic, and a function-rich toolset.
Key Features
- Quantifying and monitoring the pipeline's value over time
- Sensitivity analysis on key value drivers
- Valuing existing or future licensing contracts
- Valuation comparison to past metrics with highlighted differences
- Task management platform with progress tracking
- Super admin dashboard for client management
- Exportable PDFs with valuation results and graphical data
Building a User-Friendly Valuation Platform
A complex, consulting Excel document has been transformed into a full-fledged asset valuation and deal modeling tool. It tracks the value of each asset, calculates the full pipeline over time, and generates shareable result charts for stakeholders. Our primary design challenge was making the data inputs' structure understandable and user-friendly with a high level of dynamic content for the user. We achieved this by embedding a navigation bar that tracks the progress of each valuation or deal, moving users efficiently through the process and creating links to relevant sections.
TOOL USED
DELIVERABLES
UX/UI DESIGN
DATABASE DESIGN
CALCULATION CODEBASE
WEB APP DEVELOPMENT
PDF DOWNLOADS
EXTENSIVE COMPANY AND USER MANAGEMENT
Augmenting Calculations & Data Management
The complex, intricate calculations were a major challenge tackled with our custom-coded solution for accuracy and effectiveness. Our robust data modeling was iterated through several versions before we found the optimal format for storing dynamic data in the database. Critical actions were strategically divided between the client and the server side to prevent system collapse with increased user numbers, reducing the load on the platform. Many actions were migrated into Bubble plugins to speed up the loading speeds.
Elevating No Code with Customizations
The journey of developing the platform highlighted the importance and potential of augmenting no code solutions with custom coding. During development, we realized that no code tools alone could not handle some of the complex calculations. By supplementing the productwith custom plugins, we were able to optimize functions, speed up processes and enhance the overall user experience. It showed us the effectiveness of combining the best of both worlds—no-code and custom coding—to create advanced, high-performing solutions.
ASSET VALUATION
Users can track the value of each asset and the pipeline over time, visually represented and exportable as graphical data for stakeholders.
PIPELINE VALUATION
The platform allows managers to delegate different components of the valuation to their team and track task progress.
LICENSING SIMULATION
The value of existing or future licensing contracts can be calculated using this platform. This includes simulation and optimization of licensing deal terms, with clear visualizations for better insights.
TASK MANAGEMENT
The platform allows managers to delegate different components of the valuation to their team and track task progress.