Description
Product Viability – Consolidation Model Overview
Introduction
In the modern business landscape, understanding the financial prospects and viability of a product is paramount to successful market entry and sustainability. The Product Viability Model (PVM) is tailored to offer a thorough financial perspective, ensuring businesses have a well-rounded view of their product’s potential performance. The Product Viability – Consolidation Model extends this capability by consolidating up to six Product Viability Models (PVMs) into a single, comprehensive overview. This model facilitates in-depth hypotheses and strategic decisions through consolidated financial data and sensitivity analysis.
Model Architecture
Sales Channels
The model bifurcates sales into two channels: Direct Sales and Indirect Sales. Here, you’ll input the forecasted number of products to be sold against the market potential, culminating in the total projected revenue.
Manufacturing and Cost of Sales
This section addresses manufacturing costs, direct cost of sales, and indirect cost of sales. The resultant total revenue minus the variable cost of sales provides the Gross Margin (GM).
Fixed Costs
Fixed costs are segmented into development costs (inclusive of capital expenditure), direct SG&A costs, and indirect SG&A costs. The summation of these provides the Total SG&A Costs.
Working Capital Analysis
This includes an assessment of creditors, debtors, and inventory costs.
Project Summary
The model gives a clear snapshot of:
GM1: Revenue minus Manufacturing Costs
GM2: GM1 minus Cost of Sales (COGS)
Net Profit: GM2 minus Total SG&A
Financial Projections
A holistic summary sheet provides insights into Net Present Value (NPV) and projects discounted cash flows. Cumulative discounted cash flow, standalone cash flow, and profit are also graphed for visual understanding.
Consolidation and Sensitivity Analysis
The consolidation model allows up to six PVMs to be merged, providing a comprehensive view of a product portfolio over a defined timeframe block across six periods (years). The consolidated results are presented as a total summary where further sensitivities can be applied via variable sliders across eleven parameters. The generated sensitivities are then presented as Scenario 1 and Scenario 2.
Graphical Presentation
The model includes graphing capabilities to present the expected Revenue, Profit, Cashflow, and Discounted Cashflow. This visual representation aids in understanding the financial trajectory and viability of the products.
Sensitivity Analysis
Beyond foundational calculations, the PVM delves deep into sensitivity analysis. Twelve plan variables are tested under best and worst-case scenarios, pinpointing the most financially volatile components of the plan. Results are laid out for the Baseline Plan, Sensitivity Scenario 1, and Sensitivity Scenario 2.
Resultant Overview
The Product Viability Model, with its multifaceted and robust structure, offers businesses a granular view of their product’s financial potential. By examining both fixed and variable costs and revenue streams and performing an in-depth sensitivity analysis, businesses are well-equipped to make informed decisions about product launches, investments, and market strategies. This model serves as an indispensable tool for businesses aiming for strategic and financial acumen in the ever-evolving market landscape.
Overview Graphics / Screenshots:
PV Consolidation Architecture
PV Model Sensitivity Analysis – Best and Worst Case Scenario’s