Financial
Modeling
and
Business Case Development
Overview
The financial model is a multi-year cash flow model based on detailed assumptions
about the product, customers, marketing budgets, and marketing program
effectiveness collected from historical data, market research and experience.
The
model tracks a prospect from solicitation to sale to customer retention
It establishes a base case and enables you to test investment trade-offs,
identify high leverage opportunities, break-even points, performance against
plan and what-ifs.
Modeling
allows you to evaluate the big picture, with the ability to understand
differences in performance segmented by market and product.
The
model evolves over time, becoming increasingly accurate and relevant, as
it is continuously updated with future program results and further customized.
It
serves as an excellent custom reporting device (I.e. automated
scorecard).
A Couple of
Examples...
GM
Card:
Provided business analysis for the GM Card program in the U.S., as well as
subsequent models for launches in Canada, Mexico, England and Brazil. The
models provide a complete picture of the company, incorporating assumptions
about the product, economic factors, banking fees, marketing budgets and
the effectiveness of each marketing channel.
As a result of
these models, GM confidently expanded into Canada and England, cautiously
entered Brazil and avoided Mexico. Different product configurations were
offered in each country based on maximizing the results from each financial
model.
After the launch,
the U.S. model was updated to include actual data and drove decision making
for ten years, including the decisions to:
- Discontinue
the partner program
- Eliminate the
gold card product
- Shift to a new
tiered rewards program
Bristol-Myers
Squibb:
Our custom financial and marketing planning tool sized the market for
a new drug based on population demographics, mortality rates, and treated
and untreated universe by disease for which the drug can be marketed. It
incorporated details about media spending, DTC, professional spending, and
a compliance and persistency program. The user could then test various marketing
strategies and budgets, and learn the expected sales mix and financial
results.
|