You are an Associate at Breakaway Equity Partners who is tasked with performing a cohort analysis on a software company that breaks down its customers into cohorts based on the quarter in which they were onboarded and analyzes the Annual Recurring Revenue $($ARR$)$ by cohort.

NOTE: You are working only in the yellow shaded cells. The Excel file is already formatted and organized for you. To avoid calculation errors, do not change the formatting in the file or sort the data set.

Working on the $$ARR by Customer$$ tab:

Step $1$: In columns BD through BS$,$ rows $2$ and $3,$ bring in the correct Quarter End Date for each column based on the timeframe of the ARR by Customer dataset and form the correct Cohort Name based on that date.

Step $2$: In columns BU and BV$,$ bring in the first month of purchase date and form the correct Cohort Name for each customer, e$.$g$.$ for a customer onboarded in Q$1$ of $2017,$ the cohort name should be $$Q$12017.$

Step $3$: Complete the quarterly roll up of ARR by customer by bringing in the ARR balance for each customer at the end of each quarter.

Working on the $$Cohort Analysis$$ tab:

Step $4$: In column D$,$ rows $7-22$ and $24,$ calculate the number of customers in each cohort.

Step $5$: Complete the ARR Cohort Analysis by summing the total ARR at the end of each quarter for each cohort.

Step $6$: Complete the ARR Y$-$o$-$Y Growth Rate analysis by calculating the year$-$over$-$year quarterly ARR growth rate for each cohort in each period.

Step $7$: Answer the following questions.

Question $1$ of $8$: How many customers are in the Q$32017$ cohort?