Objective: determine maximum CPA (cost per acquisition) for marketing spend
Questions we want answered:
We want to determine how much marketing we have to spend annually in year 1 and 2.
How much can we spend to acquire a customer?
How much traffic do we need or can we get using the determined CPA?
What should be our CPC (cost per click)?
What is the CLV (customer lifetime value)?
What are the margin per customers lifespan?
repeat purchase rate
purchases per month
avg customer lifespan
I need an excel model to be created with a chart. The model should take into account operational costs, above KPIs and other factors to determine CLV (customer lifetime value), CPA, show breakeven point, show revenue annually and how much we need to spend on marketing.
There should be few charts showing breakeven point and scenarios.
the model should cover 3 scenarios; conservative, medium, aggressive
In terms of budget, Im open to recommendations.