$\backslash$table$[[$Estimate the Cost of Customer Acquisition $($COCA$)],[,$Time Period $($default is vear but can change$)],[,$Year $1,$Year $2,$Year $3,$Year $4,$Year $5],[$New Customers forecasted$],[$All Sales expenses for period$],[$All Marketing expenses for period$],[$Total Marketing & Sales expenses for period$],[$COCA for the period,,,,,$]]$

Convert Estimation into Short, Medium and Long fierm

Understanding these numbers are not precise, create a range you are comfortable with for the short, medium and long term $($as defined in I$($c$)$ above$)$ from the worksheet above.

Short Term COCA Range $q,$

Medium Term COCA Range

Long Term $($steady state$)$ COCA Range