A leading international biotech company wanted an adaptive platform which would provide a real-time depiction of the company’s financials based on the performance of 30+ product-indication combinations having a market worth of around $2B.
Viscadia was asked to design and build a scalable and dynamic long-range planning model which would aggregate the product and firm level financials from cross-functional stakeholders in order to create an all – encompassing portfolio dashboard.
Classified and segmented the assets on basis of their stage of development, deal structure and forecast availability, and mapped the segments to a forecast approach and appropriate financial template.
Incorporated asset specific profit-sharing deal structures to track revenue and expenses as a result of partnerships and support a clear depiction of the financial performance.
Built a base standard template to house asset level financials and facilitate data collation and representation across all asset types – to ensure consistency and scalability.
Created a one stop repository for all the financial inputs related to different assets to make the user experience more streamlined and hassle free.
Managed client’s complete portfolio through dynamic, individual asset level modelling and aggregation that caters to different cross functional needs
Provided frameworks to configure multiple scenarios across different financial elements + Calculated portfolio specific KPIs (such as NPV) to measure the health of the business.