Internet Marketing Model - Calculator and Sensitivity Analysis in Excel
Video Tutorial:
This is a great sensitivity tool as well as a good way to plan out expected cash flow from operating an affiliate business that utilizes PPC (pay-per-click) marketing strategies or a direct advertising campaign. The nuances for all the math that is involved in the analysis of each type of internet marketing endeavor has been built in. The user simply needs to start playing with the figures to see what may be viable based on various total clicks / conversion rates / commission rates / sales prices.
More importantly, the user of this model is going to be able to see what potential conversion rates / volume of sales will provide a suitable break even point where profit starts to be made. In the 12-month cash flow forecast, there is a dropdown to select direct or affiliate operation as well as the expected clicks per month.
The sensitivity tables are great at showing ROI and profit per day at up to 17 different click volumes.
