Exploring marketing ROI on deals - some excel analysis

searcher profile

October 28, 2024

by a searcher from Warsaw School of Economics in Toronto, ON, Canada

I have no idea if this will be useful to anyone. I needed to evaluate some deals in the past month and I tried to gauge how much better I can do marketing / sales than the current owner, to project business growth -> ROI on the deal.

Being new to the space, I'm sure there will be a few things I've messed up (let me know if you see anything) but as a simplified model of the evaluating current marketing of the deal, I don't think it will be too far off.

I created it in a flexible manner, and anyone who wants to tweak the scenarios to what makes sense to them, or that they're seeing in the market can do so and get something similar in terms of projected increase in sales / spending.

As a new member to a community, I thought I'd share. I hope it's helpful to some.

https://docs.google.com/spreadsheets/d/1C78N1MCcE12IenGG_IASEjU1PiwpWxTjs_dJZgUzgB8/edit?usp=sharing

1
1
41
Replies
1
commentor profile
Reply by an admin
from Massachusetts Institute of Technology in Portland, OR, USA
^redacted‌ have previously commented on Excel and Modeling and might be able to comment here.
Join the discussion