ROI on Sales and Marketing Spend

Video Tutorial:

This template has been built so organizations can track the return on their sales and marketing spend. It will work as long as the future revenue can be directly attached to a given spend of a month.

This is a more complex calculation for businesses that have irregular and recurring revenues that result from a one-time spend on marketing. The logic in this template makes it as simple as it can be and will calculate the rate as revenues come in each month for a given previous months’ spend.

Two additional calculations have been added.

The first is a time-sensitive return (IRR). That means internal rate of return and it is used to take into account the length of time it takes for revenues to come in. It is not common to see this calculation used in such a way, but I think it gives more meaning to the returns you are getting and is a good comparison metric.

The second is the amount of months it takes to earn enough revenue back to pay for the initial spend. This is a really important metric. The lower the number of months to payback is, the better.

The model tracks for up to 10 years of time on a monthly basis.

Greenhouse Excel Model

Steps to Follow in Creating Excel Models
Steps to Follow in Creating Excel Models
Users who purchased ROI on Sales and Marketing Spend, also purchased:
Residual Land Value Calculation
Add to wish list
Purchase Excluding 7.7% tax
Manufacturing Company
Manufacturing_Company
Add to wish list
Purchase Excluding 7.7% tax
SaaS Financial Model
SaaS Financial Model
Add to wish list
Purchase Excluding 7.7% tax
Industry
Summary Find out what kind of on-going ROI (return on investment) you are getting on your sales and marketing spend.
Screenshots / Pictures
Use Cases , , , , , , , , , , , , , , , ,

Write a Review