How would I solve for Churn using this?

As with any subscription business customers are lost, called 'churn', over time. In the green boxes in Column E above, calculate the change in Column C(the percent of customers retained that month) from the same value the previous month. We can synthesize the churn of the dog food business you have calculated in Column E as follows: Lose 30% of first month customers in the second month Lose an additional 10% of second month customers in the third month Lose 5% of all third month or longer customers in the fourth or subsequent months Although the churn of the fourth or subsequent months varies minimally month to month, it is unlikely that this variability is a pattern that will repeat. It is more realistic to assume that customers will be lost (churn) at a constant 5% per month. Churn Count of Average of Row Labels Month Value 1 100.0% 5 2 70.0% 100 3 63.0% 120 4 59.6% 140 5 56.4% 1401 6 53.7% 140 7 51.3% 140 8 48.9% 140 9 46.2% 140 10 43.2% 140 11 41.2% 140 12 39.7% 140 13 38.0% 140 14 35.8% 140 15 33.7% 140 16 32.0% 140 17 30.3% 140 18 29.1% 140 19 27.1% 140 20 26.2% 140 21 24.7% 140 22 100 22 o As with any subscription business customers are lost, called 'churn', over time. In the green boxes in Column E above, calculate the change in Column C(the percent of customers retained that month) from the same value the previous month. We can synthesize the churn of the dog food business you have calculated in Column E as follows: Lose 30% of first month customers in the second month Lose an additional 10% of second month customers in the third month Lose 5% of all third month or longer customers in the fourth or subsequent months Although the churn of the fourth or subsequent months varies minimally month to month, it is unlikely that this variability is a pattern that will repeat. It is more realistic to assume that customers will be lost (churn) at a constant 5% per month. Churn Count of Average of Row Labels Month Value 1 100.0% 5 2 70.0% 100 3 63.0% 120 4 59.6% 140 5 56.4% 1401 6 53.7% 140 7 51.3% 140 8 48.9% 140 9 46.2% 140 10 43.2% 140 11 41.2% 140 12 39.7% 140 13 38.0% 140 14 35.8% 140 15 33.7% 140 16 32.0% 140 17 30.3% 140 18 29.1% 140 19 27.1% 140 20 26.2% 140 21 24.7% 140 22 100 22 o