Calculations and Valuation Modelling Platform

Idea Link

Database Engineer
UX Designer
Web Developer
Bubble

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

Bubble.io

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 loading times.

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 product with 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.

To schedule a free discovery call with our founder, please use the Calendly link:

Partner With Idea
View Services

More Projects by Idea