Insert Friend's Email Address Above to Inform Them

 

 

 

 

Search for:

 

 

Excel Financial Formulas

"Not only do these 10 functions help me evaluate the financial impact of my marketing programs, I can now talk to my CFO with confidence.  I can show him the profit impact, break even quantity, marketing ROI, and other metrics of proposed programs."

Function Computes
Expected Value Average of a series of possible outcomes weighted by the probability of the outcomes.
Profit Impact Contribution to profit from marketing
Break Even Quantity Quantity needed to achieve 0 profits in short-run.
Customer Acquisition Cost Generates the cost of acquiring a customer.
Customer Lifetime Average longevity of a customer
Total Lifetime Customer Value Customer's contribution to corporate value, including acquisition cost.  Assumes the customer contributes the same amount each period.
Post Acquisition CLV Customer's contribution to corporate value, once they've become a customer.  This excludes the acquisition cost.  Assumes the customer contributes the same amount each period.
Marketing ROI Return on a marketing investment.
Price Variance Revenue variance between actuals and planned due to differences in price.  Instead of variance to plan, you can also compute the variance to another period.
Volume Variance Revenue variance between actuals and planned due to differences in volume.  Instead of variance to plan, you can also compute the variance to another period.

Buy today for only $39.95 $29.95. That's less than $1.00 40 per solution.  Click here to start today. 

You can try Exel-lent Marketing Formulas for 30 days.  Click here for a fully functional trial version.

 

Formula Categories     Trial     Purchase     About     Support     Search     Email     InfoTech Marketing    Total Customer Analytics     The Sales and Marketing Source    Site Map

Copyright 1998-2014 InfoTech Marketing. All rights reserved.

InfoTech Marketing, 8601 W. Cross Dr. F5, Suite 139, Littleton, CO 80123  Phone:  720-732-4588
Revised: January 18, 2014