This module is designed to help marketing professionals, and the financial departments that support them, consider all the revenue and cost implications of each new product so that they can integrate it into their offering. This is especially valuable in a world of products affected by fast moving technology.

Product Development and Introduction in today's fast-paced competitive environment requires a disciplined, consistent evaluation approach. Our tool brings focus to the revenue and cost drivers and makes it easy to quickly estimate how each new offering will impact your business. Results are displayed in summary form (including a Payback Chart) plus detailed period-by-period results for each financial element.

In this module you will see and practice construction and integration of the complex and versatile new product introduction tool described above. You will learn to use multiple Excel and VBA capabilities to ensure investments and estimated benefits will be entered accurately, calculated correctly, and displayed clearly, and that multiple parameters can be changed dynamically to provide engaging real-time analysis.

Included are:

• VBA setup of calendar parameters, currency, hurdle and tax rates, and labor format
• VBA entry of cost and asset ratios to revenue, to automate many recurring calculations
• VBA entry of benefit and investment data, including start and end dates and ramp up and ramp down periods
• VBA control of depreciation methods and periods
• VBA control of uncertainty (sensitivity drivers)
• Calculation of optimistic, expected, and pessimistic cases by financial element by month for the periods defined
• Engaging summary report of Payback, NPV, IRR, and period results

The Product Development model associated with this module is available for use as is, or can be modified or used as the structural basis for specialized models.

The features of this module are:

• A focused guide through new product introduction concepts
• A working example of a complex model
• Access to “Help” at all times: extensive help for working with Excel and VBA and dealing with financial and accounting concepts